Home > mailing lists

Mailing lists [pgsql-general]

1 October 2017

00:03 Re: [GENERAL] Plan changes from index scan to seq scan after 5 executions David G. Johnston
00:15 Re: [GENERAL] Plan changes from index scan to seq scan after 5 executions Alexander Kukushkin
00:43 Re: [GENERAL] Plan changes from index scan to seq scan after 5 executions Tom Lane
14:17 [GENERAL] time series data Khalil Khamlichi
19:10 [GENERAL] Revolut - postgres ? rakeshkumar464
21:08 Re: [GENERAL] time series data Melvin Davidson

2 October 2017

04:20 Re: [GENERAL] time series data Clifford Snow
12:32 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
20:00 [GENERAL] Setting search_path ignored Guyren Howe
20:06 Re: [GENERAL] time series data Melvin Davidson
20:06 Re: [GENERAL] Setting search_path ignored David G. Johnston
20:09 Re: [GENERAL] Setting search_path ignored Guyren Howe
20:16 Re: [GENERAL] Setting search_path ignored David G. Johnston
20:21 Re: [GENERAL] Setting search_path ignored Charles Clavadetscher
21:22 [GENERAL] Checkpoint write time - anything unusual? pinker
22:08 Re: [GENERAL] time series data Scott Marlowe
22:31 Re: [GENERAL] time series data Khalil Khamlichi
23:27 Re: [GENERAL] time series data Khalil Khamlichi

3 October 2017

00:14 Re: [GENERAL] time series data Nico Williams
04:36 Re: [GENERAL] pg_stat_tmp and pg_upgrade Bruce Momjian
13:38 Re: [GENERAL] Checkpoint write time - anything unusual? Laurenz Albe
17:45 [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common milist ujang
19:49 Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer
22:21 Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common milist ujang

4 October 2017

00:58 Re: [GENERAL] time series data Schneider
19:25 [GENERAL] error: initdb: could not look up effective user ID 21073: user doesnot exist Sandeep Gupta
22:07 Re: [GENERAL] a JOIN to a VIEW seems slow Jan de Visser

5 October 2017

01:15 [GENERAL] Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici
01:19 Re: [GENERAL] a JOIN to a VIEW seems slow Alban Hertroys
01:36 [GENERAL] Trigger function problem Liglio Cavalcante
11:01 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
12:20 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
13:51 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
20:04 [GENERAL] delete a file everytime pg server starts/crashes athinivas
20:32 Re: [GENERAL] delete a file everytime pg server starts/crashes Melvin Davidson
20:51 Re: [GENERAL] delete a file everytime pg server starts/crashes Ray Cote
23:28 [GENERAL] Postgresql CDC tool recommendations ? avi Singh
23:47 Re: [GENERAL] Postgresql CDC tool recommendations ? Steve Atkins

6 October 2017

01:58 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici
05:56 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time Igor Polishchuk
06:45 Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime Vladimir Nicolici
07:51 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a longtime Andres Freund
08:53 Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime Vladimir Nicolici
09:03 Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime Andres Freund
13:07 Re: [GENERAL] delete a file everytime pg server starts/crashes vinny
14:44 [GENERAL] Regarding scram authentication libpq version 10 or more Durgamahesh Manne
16:10 Re: [GENERAL] Regarding scram authentication libpq version 10 or more Michael Paquier
17:56 Re: [GENERAL] Regarding scram authentication libpq version 10 or more Durgamahesh Manne
18:26 Re: [GENERAL] Regarding scram authentication libpq version 10 or more Michael Paquier
18:39 Re: [GENERAL] Regarding scram authentication libpq version 10 or more Durgamahesh Manne
19:22 [GENERAL] compiling postgres_fdw fails for 9.6.5 Sandeep Gupta
19:50 [GENERAL] Connection utilisation for pglogical Rory Campbell-Lange
20:03 Re: [GENERAL] compiling postgres_fdw fails for 9.6.5 Tom Lane
20:34 Re: [GENERAL] delete a file everytime pg server starts/crashes pinker
20:53 [GENERAL] How to sort in pgAdmin 4 Thomasine Dade (tdade)
21:23 Re: [GENERAL] Postgresql CDC tool recommendations ? Nico Williams
21:27 Re: [GENERAL] delete a file everytime pg server starts/crashes pinker

7 October 2017

00:39 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici
03:18 [GENERAL] Functions and Parentheses Igal @ Lucee.org
03:33 Re: [GENERAL] Functions and Parentheses David G. Johnston
03:33 Re: [GENERAL] Functions and Parentheses Tom Lane
04:10 Re: [GENERAL] Functions and Parentheses Joshua D. Drake
05:10 Re: [GENERAL] Functions and Parentheses Igal @ Lucee.org
07:45 [GENERAL] phpPgAdmin 6 on a MAC (High Sierra) Jerry Levan
15:34 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
18:49 Re: [GENERAL] a JOIN to a VIEW seems slow David Rowley
22:57 [GENERAL] table partition problem Hung Phan

8 October 2017

14:08 Re: [GENERAL] a JOIN to a VIEW seems slow Frank Millman
14:30 [GENERAL] OR-clause support for indexes Andreas Joseph Krogh
17:50 [GENERAL] Automatically check for anti-patterns in SQL queries Joy Arulraj
18:33 Re: [GENERAL] delete a file everytime pg server starts/crashes athinivas
19:51 Re: [GENERAL] delete a file everytime pg server starts/crashes Melvin Davidson
20:01 Re: [GENERAL] delete a file everytime pg server starts/crashes athinivas
20:11 Re: [GENERAL] delete a file everytime pg server starts/crashes Melvin Davidson

9 October 2017

01:01 [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
02:49 Re: [GENERAL] Equivalence Classes when using IN David Rowley
03:07 Re: [GENERAL] Equivalence Classes when using IN Tom Lane
09:18 [GENERAL] https://www.postgresql.org/ftp/source/v10.0/ distribution ISdifferent than git tag REL_10_0 Andre Mikulec
12:22 Re: [GENERAL] Automatically check for anti-patterns in SQL queries Thomas Kellerer
12:39 Re: [GENERAL] OR-clause support for indexes David Rowley
15:39 Re: [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
16:47 Re: [GENERAL] Equivalence Classes when using IN David Rowley
17:12 [GENERAL] Error: "cached plan must not change result type" Durumdara
19:40 [GENERAL] Using cp to back up a database? Ron Johnson
19:51 Re: [GENERAL] Equivalence Classes when using IN Tom Lane
19:51 Re: [GENERAL] Using cp to back up a database? Larry Rosenman
20:01 Re: [GENERAL] Using cp to back up a database? Melvin Davidson
20:09 Re: [GENERAL] Using cp to back up a database? Achilleas Mantzios
20:13 Re: [GENERAL] Using cp to back up a database? Michael Paquier
20:15 Re: [GENERAL] Using cp to back up a database? Ron Johnson
20:20 Re: [GENERAL] Using cp to back up a database? Achilleas Mantzios
22:33 Re: [GENERAL] Using cp to back up a database? Jeff Janes
22:33 [GENERAL] pg_start/stop_backup naming conventions mj0nes
22:41 Re: [GENERAL] Using cp to back up a database? Ron Johnson
22:44 [GENERAL] Permissions for Web App Igal @ Lucee.org
22:49 Re: [GENERAL] Using cp to back up a database? Darren Douglas
22:55 Re: [GENERAL] Using cp to back up a database? Jeff Janes
23:06 Re: [GENERAL] Using cp to back up a database? Jeff Janes
23:17 Re: [GENERAL] Using cp to back up a database? Darren Douglas
23:19 Re: [GENERAL] Using cp to back up a database? Ron Johnson
23:33 Re: [GENERAL] pg_start/stop_backup naming conventions David G. Johnston
23:51 Re: [GENERAL] Permissions for Web App David G. Johnston

10 October 2017

00:02 Re: [GENERAL] Using cp to back up a database? Scott Mead
00:13 Re: [GENERAL] Using cp to back up a database? Ron Johnson
00:17 Re: [GENERAL] Permissions for Web App Igal @ Lucee.org
01:08 [GENERAL] startup process stuck in recovery Christophe Pettus
01:10 Re: [GENERAL] startup process stuck in recovery Tom Lane
01:18 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
01:21 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
01:36 [GENERAL] Question about memory usage of pg_dump Condor
02:01 Re: [GENERAL] startup process stuck in recovery Tom Lane
02:10 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
02:26 Re: [GENERAL] startup process stuck in recovery Tom Lane
03:01 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
03:24 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
03:29 Re: [GENERAL] startup process stuck in recovery Tom Lane
05:09 Re: [GENERAL] Equivalence Classes when using IN David Rowley
05:12 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
05:25 Re: [GENERAL] startup process stuck in recovery Merlin Moncure
05:44 Re: [GENERAL] Equivalence Classes when using IN Tom Lane
05:52 Re: [GENERAL] Equivalence Classes when using IN David Rowley
06:30 Re: [GENERAL] startup process stuck in recovery Tom Lane
07:02 Re: [GENERAL] startup process stuck in recovery Peter Geoghegan
07:05 Re: [GENERAL] startup process stuck in recovery Tom Lane
07:21 Re: [GENERAL] startup process stuck in recovery Peter Geoghegan
08:25 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
08:27 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
12:48 Re: [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
12:52 Re: [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
17:25 [GENERAL] [asking about how to upgrade docker postgresql without losing the data] Olivani Prisila
19:08 Re: [GENERAL] Using cp to back up a database? Stephen Frost
19:12 Re: [GENERAL] pg_start/stop_backup naming conventions Stephen Frost
19:14 Re: [GENERAL] Permissions for Web App Stephen Frost
19:56 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici
20:17 Re: [GENERAL] Strange checkpoint behavior - checkpoints take a longtime Achilleas Mantzios
20:30 Re: [GENERAL] Strange checkpoint behavior - checkpoints take alongtime Vladimir Nicolici
20:32 Re: [GENERAL] startup process stuck in recovery Alvaro Herrera
20:34 Re: [GENERAL] Strange checkpoint behavior - checkpoints takealongtime Vladimir Nicolici
20:52 Re: [GENERAL] [asking about how to upgrade docker postgresql withoutlosing the data] David G. Johnston
21:05 Re: [GENERAL] startup process stuck in recovery Tom Lane

11 October 2017

00:37 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
01:41 Re: [GENERAL] Equivalence Classes when using IN Nico Williams
02:23 Re: [GENERAL] startup process stuck in recovery Tom Lane
02:40 [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
02:49 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Scott Marlowe
02:51 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
03:01 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Victor Yegorov
03:12 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Tomas Vondra
03:43 Re: [GENERAL] Error: "cached plan must not change result type" Dmitry Dolgov
03:53 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
04:00 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Scott Marlowe
04:06 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
04:20 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Victor Yegorov
04:28 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
04:41 Re: [GENERAL] core system is getting unresponsive because over 300cpu load John R Pierce
05:00 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
05:23 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Tomas Vondra
06:18 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Andres Freund
06:26 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
06:38 Re: [GENERAL] core system is getting unresponsive because over 300 cpu load pinker
07:30 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Justin Pryzby
07:42 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Tomas Vondra
12:54 Re: [GENERAL] startup process stuck in recovery Simon Riggs
13:09 Re: [GENERAL] startup process stuck in recovery Christophe Pettus
13:41 [GENERAL] Why does increasing the precision of a numeric column rewrites thetable? Thomas Kellerer
14:27 Re: [GENERAL] startup process stuck in recovery Simon Riggs
19:43 [GENERAL] Determine size of table before it's committed? Seamus Abshere
19:53 Re: [GENERAL] Determine size of table before it's committed? Justin Pryzby
19:54 Re: [GENERAL] Determine size of table before it's committed? Melvin Davidson
20:00 Re: [GENERAL] startup process stuck in recovery Tom Lane
20:30 Re: [GENERAL] Why does increasing the precision of a numeric column rewrites the table? Tom Lane

12 October 2017

00:18 [GENERAL] Making subscribers read only in Postgres 10 logical replication rverghese
00:26 Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication Joshua D. Drake
00:38 Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication rverghese
01:37 Re: [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
01:46 Re: [GENERAL] Equivalence Classes when using IN David Rowley
03:15 Re: [GENERAL] Equivalence Classes when using IN Kim Rose Carlsen
04:12 Re: [GENERAL] Equivalence Classes when using IN David Rowley
08:25 Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer
09:03 Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common Andres Freund
09:10 Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer
14:00 [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function KES
15:35 [GENERAL] Restore LargeObjects on different server Durumdara
16:41 Re: [GENERAL] Restore LargeObjects on different server Durumdara
18:15 Re: [GENERAL] Restore LargeObjects on different server Laurenz Albe
19:25 Re: [GENERAL] core system is getting unresponsive because over 300cpu load Scott Marlowe
20:37 Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinalparameter for 'justify' date/time function Brian Dunavant
20:48 [GENERAL] EAV Designs for Multi-Tenant Applications Nic Pottier
22:30 [GENERAL] Index corruption & broken clog Benoit Lobréau

13 October 2017

07:09 [GENERAL] REASSIGN OWNED simply doesn't work Sam Gendler
09:44 Re: [GENERAL] REASSIGN OWNED simply doesn't work Stephen Cook
13:55 Re: [GENERAL] Index corruption & broken clog Laurenz Albe
14:13 Re: [GENERAL] Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function KES
14:25 Re: [GENERAL] Index corruption & broken clog Benoit Lobréau
14:55 Re: [GENERAL] Index corruption & broken clog Benoit Lobréau
18:17 [GENERAL] Is pgbouncer still maintained? Steven Winfield
19:04 Re: [GENERAL] REASSIGN OWNED simply doesn't work Alvaro Herrera
19:36 Re: [GENERAL] Restore LargeObjects on different server Daniel Verite
21:49 [GENERAL] "Shared strings"-style table Seamus Abshere
22:09 Re: [GENERAL] "Shared strings"-style table Rob Sargent
22:12 Re: [GENERAL] "Shared strings"-style table David G. Johnston
22:29 Re: [GENERAL] "Shared strings"-style table Seamus Abshere
22:29 Re: [GENERAL] "Shared strings"-style table Melvin Davidson
22:39 [GENERAL] Merge - Insert Select Susan Hurst
22:43 Re: [GENERAL] Merge - Insert Select Peter Geoghegan
22:43 Re: [GENERAL] "Shared strings"-style table Seamus Abshere
22:52 Re: [GENERAL] "Shared strings"-style table Melvin Davidson
23:22 Re: [GENERAL] "Shared strings"-style table Melvin Davidson
23:59 Re: [GENERAL] "Shared strings"-style table Peter J. Holzer

14 October 2017

00:03 Re: [GENERAL] Permissions for Web App Igal @ Lucee.org
00:16 Re: [GENERAL] "Shared strings"-style table David G. Johnston
00:21 Re: [GENERAL] Permissions for Web App David G. Johnston
01:03 Re: [GENERAL] "Shared strings"-style table Thomas Kellerer
01:08 Re: [GENERAL] "Shared strings"-style table Seamus Abshere
01:09 Re: [GENERAL] Permissions for Web App Igal @ Lucee.org
01:29 [GENERAL] Multiple Schemas vs. Multiple Databases Igal @ Lucee.org
01:39 Re: [GENERAL] REASSIGN OWNED simply doesn't work David G. Johnston
01:42 Re: [GENERAL] Multiple Schemas vs. Multiple Databases Melvin Davidson
01:47 Re: [GENERAL] Multiple Schemas vs. Multiple Databases John R Pierce
02:24 Re: [GENERAL] Multiple Schemas vs. Multiple Databases Igal @ Lucee.org
03:36 Re: [GENERAL] Multiple Schemas vs. Multiple Databases Thomas Kellerer
12:20 [GENERAL] Delete Duplicates with Using Igal @ Lucee.org
13:18 [GENERAL] Where to find development builds of pg for windows legrand legrand
13:32 Re: [GENERAL] Delete Duplicates with Using legrand legrand
20:23 Re: [GENERAL] time series data Joshua D. Drake
20:25 Re: [GENERAL] time series data Khalil Khamlichi
20:30 [GENERAL] Non-overlapping updates blocking each other Seamus Abshere
21:32 Re: [GENERAL] Non-overlapping updates blocking each other Melvin Davidson
22:01 Re: [GENERAL] Non-overlapping updates blocking each other Thomas Kellerer
22:07 Re: [GENERAL] Non-overlapping updates blocking each other Melvin Davidson
22:32 Re: [GENERAL] Non-overlapping updates blocking each other Tom Lane

15 October 2017

18:01 Re: [GENERAL] Non-overlapping updates blocking each other Seamus Abshere
18:02 Re: [GENERAL] EAV Designs for Multi-Tenant Applications Alban Hertroys
19:26 Re: [GENERAL] Is pgbouncer still maintained? Greg Sabino Mullane
20:59 Re: [GENERAL] Non-overlapping updates blocking each other Melvin Davidson

16 October 2017

01:28 Re: [GENERAL] Delete Duplicates with Using Igal @ Lucee.org
05:01 [GENERAL] Adding identity column to a non-empty table Igal @ Lucee.org
06:24 Re: [GENERAL] Adding identity column to a non-empty table Igal @ Lucee.org
06:56 Re: [GENERAL] Adding identity column to a non-empty table Melvin Davidson
07:09 Re: [GENERAL] Adding identity column to a non-empty table Igal @ Lucee.org
07:42 Re: [GENERAL] Adding identity column to a non-empty table Melvin Davidson
09:10 Re: [GENERAL] Adding identity column to a non-empty table Igal @ Lucee.org
12:53 Re: [GENERAL] Delete Duplicates with Using Andreas Kretschmer
13:19 [GENERAL] Postgres 10 manual breaks links with anchors Thomas Kellerer
18:20 Re: [GENERAL] Non-overlapping updates blocking each other Seamus Abshere
19:24 Re: [GENERAL] Non-overlapping updates blocking each other Alvaro Herrera
19:55 Re: [GENERAL] Non-overlapping updates blocking each other Tom Lane
20:05 [GENERAL] Force SSL connection rakeshkumar464
20:08 [GENERAL] Using Substitution Variables In PostgreSQL Osahon Oduware
20:19 Re: [GENERAL] Force SSL connection Tom Lane
20:23 Re: [GENERAL] Using Substitution Variables In PostgreSQL Achilleas Mantzios
20:27 Re: [GENERAL] Using Substitution Variables In PostgreSQL David G. Johnston
20:43 [GENERAL] could not fdatasync log file: Input/output error said assemlal
20:47 Re: [GENERAL] could not fdatasync log file: Input/output error said assemlal
20:54 Re: [GENERAL] Using Substitution Variables In PostgreSQL Osahon Oduware
21:34 Re: [GENERAL] Non-overlapping updates blocking each other Seamus Abshere
21:39 [GENERAL] ORDER with CASE and Random for each case Alex Magnum
21:58 Re: [GENERAL] Delete Duplicates with Using Igal @ Lucee.org
23:08 Re: [GENERAL] Non-overlapping updates blocking each other Seamus Abshere
23:28 Re: [GENERAL] Delete Duplicates with Using Igal @ Lucee.org
23:47 Re: [GENERAL] time series data Khalil Khamlichi
23:57 Re: [GENERAL] REASSIGN OWNED simply doesn't work Sam Gendler

17 October 2017

04:02 Re: [GENERAL] REASSIGN OWNED simply doesn't work Alvaro Herrera
07:17 [GENERAL] PGConf.ASIA and VISA Tatsuo Ishii
07:18 Re: [GENERAL] could not fdatasync log file: Input/output error Michael Paquier
10:54 Re: [GENERAL] wal_retrieve_retry_interval Michael Paquier
12:01 Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication Feike Steenbergen
12:06 [GENERAL] Preventing psql from attempting to access ~/.pgpass file. Allan Kamau
12:11 Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication Thomas Kellerer
12:19 Re: [GENERAL] Preventing psql from attempting to access ~/.pgpassfile. Justin Pryzby
12:23 Re: [GENERAL] Preventing psql from attempting to access ~/.pgpass file. Murtuza Zabuawala
16:59 [GENERAL] pgcon2015, what happened to SMR disk technolgy ? Laurent Laborde
17:38 Re: [GENERAL] pgcon2015, what happened to SMR disk technolgy ? Geoff Winkless
19:54 [GENERAL] COPY log row count feauture request david.turon@linuxbox.cz
20:55 [GENERAL] Finally upgrading to 9.6! Ron Johnson
22:17 Re: [GENERAL] Finally upgrading to 9.6! Tom Lane
23:39 [GENERAL] Postgres Architect Dillon Tang

18 October 2017

00:09 Re: [GENERAL] Postgres Architect Joshua D. Drake
03:29 [GENERAL] Simple query fail Glenn Pierce
04:04 Re: [GENERAL] Simple query fail David G. Johnston
04:05 Re: [GENERAL] Simple query fail Glenn Pierce
05:02 Re: [GENERAL] could not fdatasync log file: Input/output error said assemlal
06:34 [GENERAL] Divert triggers on materialized views Ewen McNeill
08:13 Re: [GENERAL] could not fdatasync log file: Input/output error Michael Paquier
08:56 Re: [GENERAL] could not fdatasync log file: Input/output error Peter Geoghegan
10:50 Re: [GENERAL] pgcon2015, what happened to SMR disk technolgy ? Laurent Laborde
11:21 Re: [GENERAL] pgcon2015, what happened to SMR disk technolgy ? Andres Freund
12:18 [GENERAL] Log storage Ivan Sagalaev
14:24 [GENERAL] Table partionning : INSERT with inconsistent return ligne inserted. STERBECQ Didier
15:30 Re: [GENERAL] Log storage legrand legrand
15:34 Re: [GENERAL] Log storage Ivan Sagalaev
18:25 Re: [GENERAL] Log storage legrand legrand
18:43 Re: [GENERAL] Log storage Laurent Laborde
19:24 Re: [GENERAL] Finally upgrading to 9.6! Ron Johnson
20:34 Re: [GENERAL] Finally upgrading to 9.6! Igal @ Lucee.org
20:45 Re: [GENERAL] Finally upgrading to 9.6! Achilleas Mantzios
20:45 Re: [GENERAL] Finally upgrading to 9.6! Ron Johnson
21:02 [GENERAL] Problems with the time in data type timestamp without time zone Root2
21:05 [GENERAL] pg_dump throws too many command-line arguments in Postgres 10 Andrus
21:11 Re: [GENERAL] pg_dump throws too many command-line arguments inPostgres 10 Paul A Jungwirth
21:16 Re: [GENERAL] Finally upgrading to 9.6! Igal @ Lucee.org
21:21 [GENERAL] Problems with the time in data type timestamp without time zone américo bravo astroña
21:33 Re: [GENERAL] Problems with the time in data type timestamp withouttime zone David G. Johnston
21:38 Re: [GENERAL] Problems with the time in data type timestamp withouttime zone Basques, Bob (CI-StPaul)
21:46 Re: [GENERAL] Finally upgrading to 9.6! David G. Johnston
21:49 Re: [GENERAL] Finally upgrading to 9.6! Ron Johnson
21:57 Re: [GENERAL] Finally upgrading to 9.6! Melvin Davidson
23:26 Re: [GENERAL] Finally upgrading to 9.6! Joshua D. Drake
23:30 Re: [GENERAL] Table partionning : INSERT with inconsistent returnligne inserted. Vik Fearing
23:32 Re: [GENERAL] Finally upgrading to 9.6! Scott Marlowe
23:37 [GENERAL] Monitoring Tool for PostgreSQL Fabricio Pedroso Jorge
23:40 Re: [GENERAL] Monitoring Tool for PostgreSQL Scott Marlowe
23:46 Re: [GENERAL] Monitoring Tool for PostgreSQL Basques, Bob (CI-StPaul)

19 October 2017

00:08 Re: [GENERAL] Finally upgrading to 9.6! Vik Fearing
00:09 Re: [GENERAL] Monitoring Tool for PostgreSQL Thomas Kellerer
00:17 Re: [GENERAL] Finally upgrading to 9.6! Don Seiler
00:46 Re: [GENERAL] Finally upgrading to 9.6! David G. Johnston
02:00 Re: [GENERAL] Finally upgrading to 9.6! Joshua D. Drake
03:17 Re: [GENERAL] Finally upgrading to 9.6! Vik Fearing
03:24 Re: [GENERAL] Monitoring Tool for PostgreSQL Martin Goodson
03:34 Re: [GENERAL] Finally upgrading to 9.6! Don Seiler
03:56 Re: [GENERAL] Finally upgrading to 9.6! David G. Johnston
03:59 Re: [GENERAL] Finally upgrading to 9.6! Christopher Browne
04:52 Re: [GENERAL] Finally upgrading to 9.6! Gavin Flower
05:04 Re: [GENERAL] Divert triggers on materialized views Brent Wood
08:45 [GENERAL] pgpass file type restrictions Desidero
12:12 Re: [GENERAL] pgpass file type restrictions Tom Lane
17:33 Re: [GENERAL] Log storage Condor
17:45 Re: [GENERAL] Problems with the time in data type timestamp withouttime zone Achilleas Mantzios
18:22 Re: [GENERAL] pgpass file type restrictions Andrew Dunstan
19:20 Re: [GENERAL] pgpass file type restrictions Desidero
19:44 Re: [GENERAL] pgpass file type restrictions Andrew Dunstan
19:56 Re: [GENERAL] pgpass file type restrictions Daniel Verite
20:20 Re: [GENERAL] pgpass file type restrictions Tom Lane
20:28 Re: [GENERAL] Problems with the time in data type timestamp withouttime zone américo bravo astroña
20:57 Re: [GENERAL] Table partionning : INSERT with inconsistent returnligne inserted. STERBECQ Didier
21:21 [GENERAL] Using Variables in Queries Igal @ Lucee.org
21:25 Re: [GENERAL] Using Variables in Queries Scott Mead
21:37 Re: [GENERAL] Using Variables in Queries Alban Hertroys
21:40 Re: [GENERAL] Using Variables in Queries Pavel Stehule
21:44 Re: [GENERAL] Using Variables in Queries David G. Johnston
23:11 Re: [GENERAL] Problems with the time in data type timestamp withouttime zone rob stone
23:40 Re: [GENERAL] pgpass file type restrictions Daniel Verite

20 October 2017

00:11 Re: [GENERAL] Using Variables in Queries Igal @ Lucee.org
00:29 Re: [GENERAL] Using Variables in Queries Pavel Stehule
01:14 Re: [GENERAL] Using Variables in Queries Tom Lane
01:20 Re: [GENERAL] Using Variables in Queries David G. Johnston
01:35 Re: [GENERAL] Using Variables in Queries Tom Lane
01:54 Re: [GENERAL] Using Variables in Queries Igal @ Lucee.org
01:58 [GENERAL] Is it OK to create a directory in PGDATA dir rakeshkumar464
02:25 Re: [GENERAL] Is it OK to create a directory in PGDATA dir Tomas Vondra
03:49 Re: [GENERAL] Is it OK to create a directory in PGDATA dir Igal @ Lucee.org
04:15 [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs) Juliano
04:34 Re: [GENERAL] pgpass file type restrictions Stephen Frost
05:50 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs) John R Pierce
05:54 [GENERAL] tgrm index for word_similarity Igal @ Lucee.org
06:03 Re: [GENERAL] Is it OK to create a directory in PGDATA dir rakeshkumar464
06:32 Re: [GENERAL] Is it OK to create a directory in PGDATA dir John R Pierce
06:42 Re: [GENERAL] Is it OK to create a directory in PGDATA dir David G. Johnston
09:14 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs) Adam Brusselback
11:36 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs) John R Pierce
15:02 [GENERAL] A question on pg_stat_subscription view Önder Kalacı
20:11 [GENERAL] How do you decide what aggregates to add? Seamus Abshere
20:38 Re: [GENERAL] How do you decide what aggregates to add? Tom Lane
23:34 [GENERAL] Issues shutting down PostgreSQL 10 cleanly Stephen Froehlich
23:39 [GENERAL] Replication stops under certain circumstances Kim Rose Carlsen

21 October 2017

00:22 Re: [GENERAL] tgrm index for word_similarity Igal @ Lucee.org
02:12 [GENERAL] How to find out extension directory rakeshkumar464
02:56 Re: [GENERAL] How to find out extension directory Melvin Davidson
02:57 Re: [GENERAL] How to find out extension directory David G. Johnston
02:58 [GENERAL] Logical replication - behavior of REFRESH PUBLICATION's copy_data option Adam LaMore
03:10 Re: [GENERAL] How to find out extension directory Tom Lane
03:16 Re: [GENERAL] How to find out extension directory Joe Conway
05:08 [GENERAL] Weird performance difference Israel Brewster
05:31 Re: [GENERAL] Weird performance difference Justin Pryzby
05:52 Re: [GENERAL] Weird performance difference Israel Brewster
06:38 Re: [GENERAL] Weird performance difference Tom Lane
09:15 [GENERAL] Restoring tables with circular references dumped to separate files doganmeh
12:09 Re: [GENERAL] Restoring tables with circular references dumped to separate files Uwe
18:01 Re: [GENERAL] tgrm index for word_similarity Arthur Zakirov
18:24 [GENERAL] Re: Restoring tables with circular references dumped to separatefiles doganmeh
21:06 Re: [GENERAL] Re: Restoring tables with circular references dumped toseparate files Melvin Davidson
21:36 Re: [GENERAL] Weird performance difference israel

22 October 2017

01:17 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs) Juliano
02:18 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that supportpgagent (jobs) Adam Brusselback
02:48 [GENERAL] Re: Restoring tables with circular references dumped to separatefiles doganmeh
03:14 Re: [GENERAL] Re: Restoring tables with circular references dumped toseparate files Melvin Davidson
11:01 Re: [GENERAL] tgrm index for word_similarity Igal @ Lucee.org
15:03 Re: [GENERAL] A question on pg_stat_subscription view Günce Kaya
15:45 Re: [GENERAL] Weird performance difference Michael Paquier
18:32 [GENERAL] How to get login user name and host name in pgaudit rakeshkumar464
20:13 [GENERAL] Postgres 9.6 fails to start on VMWare Martin Moore
23:09 Re: [GENERAL] Re: Restoring tables with circular references dumped toseparate files Francisco Olarte

23 October 2017

00:15 [GENERAL] parray_gin and \d errors in PG10 Justin Pryzby
00:36 Re: [GENERAL] parray_gin and \d errors in PG10 Tom Lane
00:41 Re: [GENERAL] parray_gin and \d errors in PG10 Justin Pryzby
01:13 Re: [GENERAL] parray_gin and \d errors in PG10 Tom Lane
01:15 Re: [GENERAL] How to get login user name and host name in pgaudit Arthur Zakirov
01:58 Re: [GENERAL] tgrm index for word_similarity Arthur Zakirov
02:48 Re: [GENERAL] parray_gin and \d errors in PG10 Tom Lane
02:57 [GENERAL] Backup strategy using 'wal_keep_segments' Rhhh Lin
04:17 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Michael Paquier
04:19 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Michael Paquier
05:51 Re: [GENERAL] Postgres 9.6 fails to start on VMWare rob stone
10:00 [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols Ben Madin
13:45 Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs) Juliano
14:14 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Martin Moore
19:06 [GENERAL] Matching statement and duration log lines Popov Aleksey
19:19 Re: [GENERAL] A question on pg_stat_subscription view Önder Kalacı
19:28 [GENERAL] Is it safe to create foreign keys beforehand when logical replicationis used? Önder Kalacı
20:08 [GENERAL] multiple sql results to shell Mark Lybarger
20:19 Re: [GENERAL] multiple sql results to shell David G. Johnston
20:24 Re: [GENERAL] multiple sql results to shell Geoff Winkless
20:44 [GENERAL] table corruption Peter Hunčár
20:52 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Michael Nolan
21:26 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Martin Moore
21:35 Re: [GENERAL] table corruption Peter Geoghegan
21:35 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Scott Mead
21:37 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Martin Moore
22:17 Re: [GENERAL] Postgres 9.6 fails to start on VMWare George Neuner
23:19 Re: [GENERAL] table corruption Scott Marlowe
23:23 Re: [GENERAL] table corruption Peter Geoghegan

24 October 2017

00:43 Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols Tom Lane
03:05 [GENERAL] using conda environment for plpython3u? Celia McInnis
03:42 Re: [GENERAL] using conda environment for plpython3u? John R Pierce
04:14 Re: [GENERAL] multiple sql results to shell Randy Strauss
04:17 [GENERAL] Two versions of an extension in the same cluster? Paul Jungwirth
04:43 Re: [GENERAL] Two versions of an extension in the same cluster? Tom Lane
06:08 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Rhhh Lin
19:12 [GENERAL] Allow only certain query on replication slave basti
21:37 Re: [GENERAL] Allow only certain query on replication slave Michael Paquier
21:43 Re: [GENERAL] using conda environment for plpython3u? Celia McInnis
21:44 Re: [GENERAL] Postgres 9.6 fails to start on VMWare Martin Moore

25 October 2017

00:34 [GENERAL] Create database from template and include comment Peter Devoy
03:18 Re: [GENERAL] Allow only certain query on replication slave Don Seiler
18:24 [GENERAL] libpq: PQreset not reconnecting connection, even though server is running Geoff Winkless
18:29 Re: [GENERAL] libpq: PQreset not reconnecting connection, even though server is running Geoff Winkless
20:21 Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols Ben Madin
20:22 Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols Ben Madin

26 October 2017

01:34 [GENERAL] How do I insert and update into a table of arrays of composite typesvia a select command? Celia McInnis
01:47 Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command? Tom Lane
02:59 [GENERAL] query not scaling Rob Sargent
02:59 Re: [GENERAL] How do I insert and update into a table of arrays ofcomposite types via a select command? Celia McInnis
03:16 Re: [GENERAL] How do I insert and update into a table of arrays ofcomposite types via a select command? Celia McInnis
03:21 Re: [GENERAL] How do I insert and update into a table of arrays ofcomposite types via a select command? David G. Johnston
03:25 Re: [GENERAL] How do I insert and update into a table of arrays of composite types via a select command? Tom Lane
03:33 Re: [GENERAL] How do I insert and update into a table of arrays ofcomposite types via a select command? Celia McInnis
13:02 Re: [GENERAL] query not scaling Laurenz Albe
18:41 Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication Peter Eisentraut
19:11 Re: [GENERAL] query not scaling Rob Sargent
20:00 [GENERAL] Function Marcio Farah
21:01 Re: [GENERAL] query not scaling Tom Lane
21:17 Re: [GENERAL] query not scaling Rob Sargent
23:15 [GENERAL] BDR question on dboid conflicts Zhu, Joshua

27 October 2017

00:05 [GENERAL] Bucardo syncrun Emanuel Araújo
01:07 [GENERAL] Question regarding logical replication Weiping Qu
01:42 Re: [GENERAL] Question regarding logical replication Alvaro Aguayo Garcia-Rada
02:20 Re: [GENERAL] Question regarding logical replication Weiping Qu
04:09 [GENERAL] Announcing PostgreSQL SLES RPM Repository Devrim Gündüz
04:43 Re: [GENERAL] Bucardo syncrun Greg Sabino Mullane
06:29 [GENERAL] Combing row returning functions using "ROWS FROM"? Guyren Howe
07:07 Re: [GENERAL] query not scaling Rob Sargent
08:24 Re: [GENERAL] BDR question on dboid conflicts Craig Ringer
12:40 [GENERAL] Can't build ODBC -- odbc_config not found Chris Albertson
13:38 Re: [GENERAL] Can't build ODBC -- odbc_config not found Michael Paquier
13:39 Re: [GENERAL] Can't build ODBC -- odbc_config not found Devrim Gündüz
13:51 Re: [GENERAL] Can't build ODBC -- odbc_config not found John R Pierce
15:53 Re: [GENERAL] Question regarding logical replication Francisco Olarte
16:04 Re: [GENERAL] Question regarding logical replication Weiping Qu
18:03 Re: [GENERAL] Question regarding logical replication Francisco Olarte
19:50 Re: [GENERAL] Function Raymond O'Donnell
20:25 Re: [GENERAL] Question regarding logical replication Weiping Qu
20:56 Re: [GENERAL] query not scaling Merlin Moncure
21:28 Re: [GENERAL] Announcing PostgreSQL SLES RPM Repository Scott Marlowe
22:06 [GENERAL] controlling users to audit in pgaudit rakeshkumar464
22:11 Re: [GENERAL] BDR question on dboid conflicts Zhu, Joshua

28 October 2017

01:24 [GENERAL] Why does a SELECT query cause "dirtied" buffers? Thomas Kellerer
01:30 Re: [GENERAL] Why does a SELECT query cause "dirtied" buffers? Justin Pryzby
04:15 [GENERAL] gin index trouble Rob Sargent
05:05 Re: [GENERAL] Where to find development builds of pg for windows Jeff Janes
15:18 Re: [GENERAL] Where to find development builds of pg for windows legrand legrand
16:58 Re: [GENERAL] Where to find development builds of pg for windows Karsten Hilbert

30 October 2017

00:40 [GENERAL] Fwd: SPI_palloc problem Aron Widforss
00:45 [GENERAL] Old pg_clog files Ron Johnson
02:37 Re: [GENERAL] Old pg_clog files David G. Johnston
03:55 Re: [GENERAL] Old pg_clog files Ron Johnson
16:08 [GENERAL] Comparing epoch to timestamp Alexander Farber
17:29 Re: [GENERAL] Fwd: SPI_palloc problem Aron Widforss
17:33 Re: [GENERAL] Comparing epoch to timestamp Alexander Farber
19:48 [GENERAL] starting PG command line options vs postgresql.con rakeshkumar464
19:59 Re: [GENERAL] starting PG command line options vs postgresql.con Tom Lane
20:08 Re: [GENERAL] starting PG command line options vs postgresql.con David G. Johnston
20:21 Re: [GENERAL] Comparing epoch to timestamp Alexander Farber
20:35 Re: [GENERAL] gin index trouble Tom Lane
20:35 Re: [GENERAL] starting PG command line options vs postgresql.con Michael Paquier
21:56 Re: [GENERAL] gin index trouble Rob Sargent
22:15 Re: [GENERAL] gin index trouble Peter Geoghegan
22:23 Re: [GENERAL] gin index trouble Tom Lane
22:29 [GENERAL] UPDATE syntax change Adam Brusselback
22:32 Re: [GENERAL] gin index trouble Peter Geoghegan
22:34 Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column) Justin Pryzby
22:41 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Stephen Frost
22:42 Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column) Adam Brusselback
22:42 Re: [GENERAL] UPDATE syntax change Tom Lane
22:45 Re: [GENERAL] gin index trouble Rob Sargent
22:56 Re: [GENERAL] gin index trouble Peter Geoghegan
23:13 Re: [GENERAL] gin index trouble Rob Sargent
23:31 [GENERAL] the database system is shutting down - terminating walsender processdue to replication timeout Zarko Aleksic
23:35 [GENERAL] the database system is shutting down - terminating walsender processdue to replication timeout Zarko Aleksic
23:36 [GENERAL] the database system is shutting down - terminating walsender processdue to replication timeout Zarko Aleksic
23:55 [GENERAL] pg_audit to mask literal sql rakeshkumar464

31 October 2017

01:25 [GENERAL] Roles inherited from a role which is the owner of a database can drop it? Ivan Voras
02:58 Re: [GENERAL] pg_audit to mask literal sql Arthur Zakirov
03:10 Re: [GENERAL] Roles inherited from a role which is the owner of adatabase can drop it? David G. Johnston
03:35 Re: [GENERAL] pg_audit to mask literal sql John R Pierce
03:46 Re: [GENERAL] pg_audit to mask literal sql Rob Sargent
04:42 Re: [GENERAL] pg_audit to mask literal sql rakeshkumar464
04:43 Re: [GENERAL] pg_audit to mask literal sql rakeshkumar464
04:44 Re: [GENERAL] pg_audit to mask literal sql rakeshkumar464
04:48 [GENERAL] Make "(composite).function_name" syntax work without search_path changes? David G. Johnston
04:48 [GENERAL] pgaduit - is there a way to audit a role rakeshkumar464
04:57 Re: [GENERAL] query not scaling Laurenz Albe
05:21 Re: [GENERAL] Make "(composite).function_name" syntax work without search_path changes? Tom Lane
05:56 [GENERAL] From the "SQL is verbose" department, WINDOW RANGE specifications David G. Johnston
12:50 Re: [GENERAL] Roles inherited from a role which is the owner of adatabase can drop it? Ivan Voras
13:15 [GENERAL] How to access a second database Sherman Willden
13:40 Re: [GENERAL] How to access a second database Stanislav Ganin
13:41 Re: [GENERAL] How to access a second database John R Pierce
13:57 Re: [GENERAL] How to access a second database John R Pierce
15:53 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Rhhh Lin
16:27 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Michael Paquier
18:04 Re: [GENERAL] Backup strategy using 'wal_keep_segments' Stephen Frost
18:08 Re: [GENERAL] pg_audit to mask literal sql Stephen Frost
18:12 Re: [GENERAL] Roles inherited from a role which is the owner of adatabase can drop it? Stephen Frost
22:16 Re: [GENERAL] query not scaling Rob Sargent