pgsql-general since 2013-11-14 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Nov. 14, 2013

Thread	Author	Time
Re: freeze cannot be finished 📎	Jeff Janes	00:26
Re: expression index not used within function	Tom Lane	00:36
Re: what checksum algo?	Michael Paquier	00:39
Re: what checksum algo?	Peter Geoghegan	01:12
Re: what checksum algo?	Tatsuo Ishii	01:53
Re: what checksum algo?	Peter Geoghegan	02:22
Re: Theory question	Jayadevan	02:28
Re: Theory question	Jayadevan M	02:30
commit fest 2013-11 wants reviewers	Peter Eisentraut	02:33
Re: what checksum algo?	Tatsuo Ishii	03:05
Re: pg_trgm module: no convertion into Trigrams on one side when comparing	Amit Langote	06:01
Re: How to print out a mass of text messages from a Samsung smart phone easily?	walerina	09:46
Re: [GENERAL] Clang 3.3 Analyzer Results	Magnus Hagander	10:45
Re: expression index not used within function	LPlateAndy	10:59
Re: expression index not used within function	LPlateAndy	11:13
Re: pg_trgm module: no convertion into Trigrams on one side when comparing	Janek Sendrowski	12:05
Tuning 9.3 for 32 GB RAM	Alexander Farber	13:44
Re: [GENERAL] Clang 3.3 Analyzer Results	Tom Lane	14:35
Re: Tuning 9.3 for 32 GB RAM	Jayadevan M	14:48
Re: Tuning 9.3 for 32 GB RAM	Alexander Farber	15:02
Re: Tuning 9.3 for 32 GB RAM	Alexander Farber	15:04
Re: Tuning 9.3 for 32 GB RAM	Alexander Farber	15:09
Equivalent syntax of PL/SQL using array in PL/pgSQL	Dang Minh Huong	15:13
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Elliot	15:20
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Dang Minh Huong	15:32
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Elliot	15:38
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	David Johnston	15:43
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Dang Minh Huong	15:56
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Dang Minh Huong	15:59
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Elliot	16:04
Mixed locales and date formatting	Vincent Veyron	16:19
Re: Tuning 9.3 for 32 GB RAM	Zev Benjamin	16:30
Re: Mixed locales and date formatting	Adrian Klaver	16:40
Re: Tuning 9.3 for 32 GB RAM	Sergey Konoplev	18:11
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Sergey Konoplev	18:40
PostgreSQL now on Amazon RDS	Helio Campos Mello de Andrade	18:42
Re: Clone database using rsync?	Laurentius Purba	19:53
Re: Tuning 9.3 for 32 GB RAM	Tomas Vondra	21:05
Push predicate down in view containing window function	Philippe Girolami	21:50
Re: Equivalent syntax of PL/SQL using array in PL/pgSQL	Dang Minh Huong	22:14
Re: Push predicate down in view containing window function	Tom Lane	22:43

Nov. 15, 2013

Thread	Author	Time
Re: Tuning 9.3 for 32 GB RAM	Michael Paquier	01:24
Re: pg_trgm module: no convertion into Trigrams on one side when comparing	Amit Langote	04:08
Re: Push predicate down in view containing window function	Philippe Girolami	06:43
Composite types or composite keys?	Tony Theodore	08:01
Postgres Server backend process	Jayadevan M	09:38
Re: pg_trgm module: no convertion into Trigrams on one side when comparing	Janek Sendrowski	10:10
Re: Postgres Server backend process	Albe Laurenz	11:08
counterpart to LOAD	Andreas Kretschmer	11:18
Install pg_trgm from source 📎	Janek Sendrowski	13:00
Re: counterpart to LOAD	Albe Laurenz	13:38
Re: Install pg_trgm from source	Devrim GÜNDÜZ	14:04
Re: Install pg_trgm from source	Michael Paquier	14:06
Re: Install pg_trgm from source	Janek Sendrowski	15:35
Re: Composite types or composite keys?	Merlin Moncure	16:01
Re: Push predicate down in view containing window function	Merlin Moncure	16:21

Nov. 16, 2013

Thread	Author	Time
PGSQL: listing db/role and user/role relationships	Felipe Gasper	00:19
Re: Add COPY statement inside sql function AND/OR call function within function	Adrian Klaver	01:12
log_line_prefix	Jayadevan M	03:14
Re: Add COPY statement inside sql function AND/OR call function within function	David Johnston	06:28
Re: log_line_prefix	hubert depesz lubaczewski	11:46
Visibility of table aliases in CTEs	Raymond O'Donnell	13:05
Re: log_line_prefix	Jayadevan	14:21
Re: Visibility of table aliases in CTEs	David Johnston	15:48
Re: Visibility of table aliases in CTEs	Raymond O'Donnell	16:39

Nov. 17, 2013

Thread	Author	Time
Re: PGSQL: listing db/role and user/role relationships	Luca Ferrari	08:56
N prefix and ::bpchar	oka	10:53
Postgres as In-Memory Database?	Stefan Keller	11:25
Re: Postgres as In-Memory Database?	Michael Paquier	12:00
Re: Postgres as In-Memory Database?	Edson Richter	13:42
Re: Postgres as In-Memory Database?	rob stone	14:15
Re: Postgres as In-Memory Database?	Edson Richter	14:30
Partitioning and triggers	Edson Richter	16:46
Re: simple query with radically different plan after 9.0 -> 9.2 upgrade	Kevin Goess	17:53
Re: Partitioning and triggers	Jeff Janes	20:45
Re: Partitioning and triggers	Edson Richter	20:57
Re: Postgres as In-Memory Database?	Stefan Keller	21:26
Re: Postgres as In-Memory Database?	Stefan Keller	21:33
Re: Postgres as In-Memory Database?	Edson Richter	22:09
Re: Postgres as In-Memory Database?	Martijn van Oosterhout	22:31
Re: Postgres as In-Memory Database?	Andreas Brandl	22:46
Re: Postgres as In-Memory Database?	Edson Richter	22:57
Re: Postgres as In-Memory Database?	Andreas Brandl	23:14
Re: Postgres as In-Memory Database?	Stefan Keller	23:53

Nov. 18, 2013

Thread	Author	Time
Re: Postgres as In-Memory Database?	Stefan Keller	00:02
Re: Postgres as In-Memory Database?	Gavin Flower	00:02
What does this error message mean? 📎	Ken Tanzer	00:40
Re: Postgres as In-Memory Database?	Edson Richter	00:46
Re: Postgres as In-Memory Database?	John R Pierce	01:03
Help : Sum 2 tables based on key from other table	Hengky Liwandouw	02:16
Re: What does this error message mean?	Tom Lane	02:20
Re: Composite types or composite keys?	Tony Theodore	02:57
Re: PGSQL: listing db/role and user/role relationships	Felipe Gasper	03:00
Re: What does this error message mean?	Ken Tanzer	03:03
Re: Composite types or composite keys?	Chris Travers	03:24
Sum 2 tables based on key from other table	Hengky Liwandouw	03:29
Re: Composite types or composite keys?	Tony Theodore	03:33
Re: What does this error message mean?	Tom Lane	03:38
Re: What does this error message mean?	Ken Tanzer	03:50
Re: Sum 2 tables based on key from other table	David Johnston	03:52
Re: What does this error message mean?	Tom Lane	03:59
Re: Composite types or composite keys?	Tony Theodore	04:07
Re: What does this error message mean?	Ken Tanzer	04:10
Re: Sum 2 tables based on key from other table	Hengky Liwandouw	05:21
Re: Sum 2 tables based on key from other table	David Johnston	05:56
Primary Key Index Bloat?	David Johnston	06:48
Suggestion: pg_dump self-cleanup if out-of-disk	David Johnston	07:12
Re: PGSQL: listing db/role and user/role relationships	Luca Ferrari	07:36
Re: freeze cannot be finished	Heikki Linnakangas	08:31
Re: Help : Sum 2 tables based on key from other table	Robin St.Clair	08:42
Re: Help : Sum 2 tables based on key from other table	Raymond O'Donnell	08:47
Re: Help : Sum 2 tables based on key from other table	Ken Tanzer	09:37
Re: Help : Sum 2 tables based on key from other table	Hengky Liwandouw	09:42
Re: Help : Sum 2 tables based on key from other table	Hengky Liwandouw	10:04
Re: Help : Sum 2 tables based on key from other table	Robin St.Clair	10:47
Re: N prefix and ::bpchar	Albe Laurenz	11:01
Could not truncate directory "pg_subtrans": apparent wraparound	Rafael Martinez	11:12
Re: Primary Key Index Bloat?	Chris Ernst	13:38
Regex files are missing	Janek Sendrowski	15:34
Re: Regex files are missing	Adrian Klaver	15:53
Re: Regex files are missing	Tom Lane	16:10
Re: expression index not used within function	LPlateAndy	16:23
Re: Regex files are missing 📎	Janek Sendrowski	16:32
Re: Postgres as In-Memory Database?	Jeff Janes	16:44
Re: Help : Sum 2 tables based on key from other table	Elliot	17:02
Re: Suggestion: pg_dump self-cleanup if out-of-disk	Jeff Janes	17:31
Re: Postgres as In-Memory Database?	Jeff Janes	18:20
Re: Regex files are missing	Adrian Klaver	18:58
Re: Regex files are missing	Kevin Grittner	19:51
ERROR: out of memory DETAIL: Failed on request of size ???	Brian Wong	20:40

Nov. 19, 2013

Thread	Author	Time
Re: Postgres as In-Memory Database?	Stefan Keller	01:39
Re: Postgres as In-Memory Database?	Andrew Sullivan	01:56
Re: Primary Key Index Bloat?	Sergey Konoplev	02:09
Re: ERROR: out of memory DETAIL: Failed on request of size ???	bricklen	03:25
Re: Suggestion: pg_dump self-cleanup if out-of-disk	David Johnston	03:59
Re: Suggestion: pg_dump self-cleanup if out-of-disk	David Johnston	04:08
Re: ERROR: out of memory DETAIL: Failed on request of size ???	Brian Wong	04:30
Re: ERROR: out of memory DETAIL: Failed on request of size ???	bricklen	05:15
org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml	gajendra s v	06:27
Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml	David Johnston	06:42
Re: Postgres as In-Memory Database?	Stefan Keller	07:16
pg_upgrade ?deficiency	Karsten Hilbert	10:22
Re: expression index not used within function	Albe Laurenz	10:42
Re: ERROR: out of memory DETAIL: Failed on request of size ???	Pavel Stehule	12:55
Re: Postgres as In-Memory Database?	Andrew Dunstan	14:30
Re: Postgres as In-Memory Database?	bricklen	14:32
Re: Postgres as In-Memory Database?	Stefan Keller	17:52
Re: Regex files are missing	Janek Sendrowski	20:22
Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml	Kevin Grittner	22:11
Re: org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml	David Johnston	22:19

Nov. 20, 2013

Thread	Author	Time
Re: Postgres as In-Memory Database?	Jeff Janes	00:29
Re: Postgres as In-Memory Database?	Edson Richter	00:56
Scrolling/Updating Cursors	Kevin Wooten	01:33
Re: Clang 3.3 Analyzer Results 📎	Peter Eisentraut	03:03
Re: Postgres as In-Memory Database?	Jeff Janes	03:30
Re: Clang 3.3 Analyzer Results	Tom Lane	03:38
Re: Postgres as In-Memory Database?	Edson Richter	03:41
Re: pg_xlog is getting bigger	Pankaj	05:58
Re: Postgres as In-Memory Database?	Bruce Momjian	12:59
Re: pg_upgrade ?deficiency	Bruce Momjian	13:04
Re: pg_upgrade ?deficiency	Karsten Hilbert	13:21
Re: pg_upgrade ?deficiency	Albe Laurenz	13:32
Re: pg_upgrade ?deficiency	Karsten Hilbert	13:36
Debugging extension with gdb?	Paul Jones	14:02
Re: pg_upgrade ?deficiency	Bruce Momjian	14:07
Re: pg_upgrade ?deficiency	Karsten Hilbert	15:07
Re: Debugging extension with gdb?	Tom Lane	15:13
Re: Postgres as In-Memory Database?	Jeff Janes	16:36
Re: Postgres as In-Memory Database?	Stefan Keller	17:02
How to change content of xml datatype	gajendra s v	17:21
Re: How to change content of xml datatype	Rob Sargent	17:31
Re: Postgres as In-Memory Database?	Jeff Janes	19:33
Does LC_CTYPE affect performance, index use?	Steven Dodd	19:57
hstore	Joey Quinn	21:12
Re: pg_upgrade ?deficiency	Bruce Momjian	21:44
Re: hstore	Venkatesulu Jumbo	21:51
Re: hstore	John R Pierce	21:59
Re: Debugging extension with gdb?	Paul Jones	22:11
Re: hstore	Joey Quinn	23:20
Changing primary key of large table, with foreign keys, without locking	Martijn van Oosterhout	23:28

Nov. 21, 2013

Thread	Author	Time
Re: pg_upgrade ?deficiency	Kevin Grittner	14:22
Re: pg_upgrade ?deficiency	Karsten Hilbert	14:39
corruption issue after server crash - ERROR: unexpected chunk number 0	Mike Broers	20:10
Primary Key	Joey Quinn	20:40
Re: Primary Key	Elliot	20:48
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Mike Broers	21:07
Getting non_NULL right-side values on a non-matching join? 📎	Ken Tanzer	21:25
Re: Primary Key	Joey Quinn	21:38
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Kevin Grittner	21:56
Re: Getting non_NULL right-side values on a non-matching join?	Kevin Grittner	22:22
Re: Primary Key	Joey Quinn	22:24
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Mike Broers	22:30
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Kevin Grittner	22:51
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Mike Broers	23:01
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	Kevin Grittner	23:09
Re: corruption issue after server crash - ERROR: unexpected chunk number 0	John R Pierce	23:14

Nov. 22, 2013

Thread	Author	Time
Re: Getting non_NULL right-side values on a non-matching join?	Ken Tanzer	00:29
Re: Getting non_NULL right-side values on a non-matching join?	Tom Lane	01:12
Re: Primary Key	Joshua D. Drake	01:15
Changing function from SECURITY DEFINER to SECURITY INVOKER changes query plan?	Joe Van Dyk	02:08

Browse Archives

Prev | Next