pgsql-general - October 2017

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)

Browse Archives

Prev | Next

Oct. 1, 2017

Thread Author Time
time series data Khalil Khamlichi 08:17
Revolut - postgres ? rakeshkumar464 13:10
Re: time series data Melvin Davidson 15:08
Re: time series data Clifford Snow 22:20

Oct. 2, 2017

Thread Author Time
Re: a JOIN to a VIEW seems slow Frank Millman 06:32
Setting search_path ignored Guyren Howe 14:00
Re: time series data Melvin Davidson 14:06
Re: Setting search_path ignored David G. Johnston 14:06
Re: Setting search_path ignored Guyren Howe 14:09
Re: Setting search_path ignored David G. Johnston 14:16
Re: Setting search_path ignored Charles Clavadetscher 14:21
Checkpoint write time - anything unusual? pinker 15:22
Re: time series data Scott Marlowe 16:08
Re: time series data Khalil Khamlichi 16:31
Re: time series data Khalil Khamlichi 17:27
Re: time series data Nico Williams 18:14
Re: pg_stat_tmp and pg_upgrade Bruce Momjian 22:36

Oct. 3, 2017

Thread Author Time
Re: Checkpoint write time - anything unusual? Laurenz Albe 07:38
BDR, wal sender, high system cpu, mutex_lock_common milist ujang 11:45
Re: BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer 13:49
Re: BDR, wal sender, high system cpu, mutex_lock_common milist ujang 16:21
Re: time series data Schneider 18:58

Oct. 4, 2017

Thread Author Time
error: initdb: could not look up effective user ID 21073: user does not exist Sandeep Gupta 13:25
Re: a JOIN to a VIEW seems slow Jan de Visser 16:07
Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici 19:15
Re: a JOIN to a VIEW seems slow Alban Hertroys 19:19
Trigger function problem Liglio Cavalcante 19:36

Oct. 5, 2017

Thread Author Time
Re: a JOIN to a VIEW seems slow Frank Millman 05:01
Re: a JOIN to a VIEW seems slow Frank Millman 06:20
Re: a JOIN to a VIEW seems slow Frank Millman 07:51
delete a file everytime pg server starts/crashes athinivas 14:04
Re: delete a file everytime pg server starts/crashes Melvin Davidson 14:32
Re: delete a file everytime pg server starts/crashes Ray Cote 14:51
Postgresql CDC tool recommendations ? avi Singh 17:28
Re: Postgresql CDC tool recommendations ? Steve Atkins 17:47
Re: Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici 19:58
Re: Strange checkpoint behavior - checkpoints take a long time Igor Polishchuk 23:56

Oct. 6, 2017

Thread Author Time
Re: Strange checkpoint behavior - checkpoints take a longtime Vladimir Nicolici 00:45
Re: Strange checkpoint behavior - checkpoints take a long time Andres Freund 01:51
Re: Strange checkpoint behavior - checkpoints take a longtime Vladimir Nicolici 02:53
Re: Strange checkpoint behavior - checkpoints take a longtime Andres Freund 03:03
Re: delete a file everytime pg server starts/crashes vinny 07:07
Regarding scram authentication libpq version 10 or more Durgamahesh Manne 08:44
Re: Regarding scram authentication libpq version 10 or more Michael Paquier 10:10
Re: Regarding scram authentication libpq version 10 or more Durgamahesh Manne 11:56
Re: Regarding scram authentication libpq version 10 or more Michael Paquier 12:26
Re: Regarding scram authentication libpq version 10 or more Durgamahesh Manne 12:39
compiling postgres_fdw fails for 9.6.5 Sandeep Gupta 13:22
Connection utilisation for pglogical Rory Campbell-Lange 13:50
Re: compiling postgres_fdw fails for 9.6.5 Tom Lane 14:03
Re: delete a file everytime pg server starts/crashes pinker 14:34
How to sort in pgAdmin 4 Thomasine Dade (tdade) 14:53
Re: Postgresql CDC tool recommendations ? Nico Williams 15:23
Re: delete a file everytime pg server starts/crashes pinker 15:27
Re: Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici 18:39
Functions and Parentheses Igal @ Lucee.org 21:18
Re: Functions and Parentheses David G. Johnston 21:33
Re: Functions and Parentheses Tom Lane 21:33
Re: Functions and Parentheses Joshua D. Drake 22:10
Re: Functions and Parentheses Igal @ Lucee.org 23:10

Oct. 7, 2017

Thread Author Time
phpPgAdmin 6 on a MAC (High Sierra) Jerry Levan 01:45
Re: a JOIN to a VIEW seems slow Frank Millman 09:34
Re: a JOIN to a VIEW seems slow David Rowley 12:49
table partition problem Hung Phan 16:57

Oct. 8, 2017

Thread Author Time
Re: a JOIN to a VIEW seems slow Frank Millman 08:08
OR-clause support for indexes Andreas Joseph Krogh 08:30
Automatically check for anti-patterns in SQL queries Joy Arulraj 11:50
Re: delete a file everytime pg server starts/crashes athinivas 12:33
Re: delete a file everytime pg server starts/crashes Melvin Davidson 13:51
Re: delete a file everytime pg server starts/crashes athinivas 14:01
Re: delete a file everytime pg server starts/crashes Melvin Davidson 14:11
Equivalence Classes when using IN Kim Rose Carlsen 19:01
Re: Equivalence Classes when using IN David Rowley 20:49
Re: Equivalence Classes when using IN Tom Lane 21:07

Oct. 9, 2017

Thread Author Time
https://www.postgresql.org/ftp/source/v10.0/ distribution IS different than git tag REL_10_0 Andre Mikulec 03:18
Re: Automatically check for anti-patterns in SQL queries Thomas Kellerer 06:22
Re: OR-clause support for indexes David Rowley 06:39
Re: Equivalence Classes when using IN Kim Rose Carlsen 09:39
Re: Equivalence Classes when using IN David Rowley 10:47
Error: "cached plan must not change result type" Durumdara 11:12
Using cp to back up a database? Ron Johnson 13:40
Re: Equivalence Classes when using IN Tom Lane 13:51
Re: Using cp to back up a database? Larry Rosenman 13:51
Re: Using cp to back up a database? Melvin Davidson 14:01
Re: Using cp to back up a database? Achilleas Mantzios 14:09
Re: Using cp to back up a database? Michael Paquier 14:13
Re: Using cp to back up a database? Ron Johnson 14:15
Re: Using cp to back up a database? Achilleas Mantzios 14:20
Re: Using cp to back up a database? Jeff Janes 16:33
pg_start/stop_backup naming conventions mj0nes 16:33
Re: Using cp to back up a database? Ron Johnson 16:41
Permissions for Web App Igal @ Lucee.org 16:44
Re: Using cp to back up a database? Darren Douglas 16:49
Re: Using cp to back up a database? Jeff Janes 16:55
Re: Using cp to back up a database? Jeff Janes 17:06
Re: Using cp to back up a database? Darren Douglas 17:17
Re: Using cp to back up a database? Ron Johnson 17:19
Re: pg_start/stop_backup naming conventions David G. Johnston 17:33
Re: Permissions for Web App David G. Johnston 17:51
Re: Using cp to back up a database? Scott Mead 18:02
Re: Using cp to back up a database? Ron Johnson 18:13
Re: Permissions for Web App Igal @ Lucee.org 18:17
startup process stuck in recovery Christophe Pettus 19:08
Re: startup process stuck in recovery Tom Lane 19:10
Re: startup process stuck in recovery Christophe Pettus 19:18
Re: startup process stuck in recovery Christophe Pettus 19:21
Question about memory usage of pg_dump Condor 19:36
Re: startup process stuck in recovery Tom Lane 20:01
Re: startup process stuck in recovery Christophe Pettus 20:10
Re: startup process stuck in recovery Tom Lane 20:26
Re: startup process stuck in recovery Christophe Pettus 21:01
Re: startup process stuck in recovery Christophe Pettus 21:24
Re: startup process stuck in recovery Tom Lane 21:29
Can master and slave on different PG versions? rammohan ganapavarapu 23:06
Re: Equivalence Classes when using IN 📎 David Rowley 23:09
Re: startup process stuck in recovery Christophe Pettus 23:12
Re: Can master and slave on different PG versions? David G. Johnston 23:15
Re: startup process stuck in recovery Merlin Moncure 23:25
Re: Equivalence Classes when using IN Tom Lane 23:44
Re: Equivalence Classes when using IN David Rowley 23:52

Oct. 10, 2017

Thread Author Time
Re: startup process stuck in recovery Tom Lane 00:30
Re: startup process stuck in recovery Peter Geoghegan 01:02
Re: startup process stuck in recovery Tom Lane 01:05
Re: startup process stuck in recovery Peter Geoghegan 01:21
Re: startup process stuck in recovery Christophe Pettus 02:25
Re: startup process stuck in recovery Christophe Pettus 02:27
Re: Equivalence Classes when using IN Kim Rose Carlsen 06:48
Re: Equivalence Classes when using IN Kim Rose Carlsen 06:52
Re: Can master and slave on different PG versions? Ramesh 08:49
[asking about how to upgrade docker postgresql without losing the data] Olivani Prisila 11:25
Re: Using cp to back up a database? Stephen Frost 13:08
Re: pg_start/stop_backup naming conventions Stephen Frost 13:12
Re: Permissions for Web App Stephen Frost 13:14
Re: Strange checkpoint behavior - checkpoints take a long time Vladimir Nicolici 13:56
Fwd: [GENERAL] How to sort in pgAdmin 4 Melvin Davidson 14:03
Re: Strange checkpoint behavior - checkpoints take a long time Achilleas Mantzios 14:17
Re: Strange checkpoint behavior - checkpoints take a longtime Vladimir Nicolici 14:30
Re: startup process stuck in recovery Alvaro Herrera 14:32
Re: Strange checkpoint behavior - checkpoints take alongtime Vladimir Nicolici 14:34
Re: [asking about how to upgrade docker postgresql without losing the data] David G. Johnston 14:52
Re: startup process stuck in recovery Tom Lane 15:05
Re: Can master and slave on different PG versions? Scott Marlowe 15:26
Re: Can master and slave on different PG versions? rammohan ganapavarapu 15:49
Re: Can master and slave on different PG versions? Scott Marlowe 16:05
Re: startup process stuck in recovery Christophe Pettus 18:37
Re: Equivalence Classes when using IN Nico Williams 19:41
Re: startup process stuck in recovery Tom Lane 20:23
core system is getting unresponsive because over 300 cpu load pinker 20:40
Re: core system is getting unresponsive because over 300 cpu load Scott Marlowe 20:49
Re: core system is getting unresponsive because over 300 cpu load pinker 20:51
Re: core system is getting unresponsive because over 300 cpu load Victor Yegorov 21:01
Re: core system is getting unresponsive because over 300 cpu load Tomas Vondra 21:12
Re: Error: "cached plan must not change result type" Dmitry Dolgov 21:43
Re: core system is getting unresponsive because over 300 cpu load pinker 21:53
Re: core system is getting unresponsive because over 300 cpu load Scott Marlowe 22:00
Re: core system is getting unresponsive because over 300 cpu load pinker 22:06
Re: core system is getting unresponsive because over 300 cpu load Victor Yegorov 22:20
Re: core system is getting unresponsive because over 300 cpu load pinker 22:28
Re: core system is getting unresponsive because over 300 cpu load John R Pierce 22:41
Re: core system is getting unresponsive because over 300 cpu load pinker 23:00
Re: core system is getting unresponsive because over 300 cpu load Tomas Vondra 23:23

Oct. 11, 2017

Thread Author Time
Re: core system is getting unresponsive because over 300 cpu load Andres Freund 00:18
Re: core system is getting unresponsive because over 300 cpu load pinker 00:26
Re: core system is getting unresponsive because over 300 cpu load pinker 00:38
Re: core system is getting unresponsive because over 300 cpu load Justin Pryzby 01:30
Re: core system is getting unresponsive because over 300 cpu load Tomas Vondra 01:42
Re: Can master and slave on different PG versions? Scott Mead 02:10
Re: startup process stuck in recovery Simon Riggs 06:54
Re: startup process stuck in recovery Christophe Pettus 07:09
Why does increasing the precision of a numeric column rewrites the table? Thomas Kellerer 07:41
Re: startup process stuck in recovery Simon Riggs 08:27
BUG #14850: Implement optinal additinal parameter for 'justify' date/time function kes-kes 10:35
Determine size of table before it's committed? Seamus Abshere 13:43
Re: Determine size of table before it's committed? Justin Pryzby 13:53
Re: Determine size of table before it's committed? Melvin Davidson 13:54
Re: startup process stuck in recovery Tom Lane 14:00
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Pavel Stehule 14:11
Re: Why does increasing the precision of a numeric column rewrites the table? Tom Lane 14:30
Making subscribers read only in Postgres 10 logical replication rverghese 18:18
Re: Making subscribers read only in Postgres 10 logical replication Joshua D. Drake 18:26
Re: Making subscribers read only in Postgres 10 logical replication rverghese 18:38
Re: Equivalence Classes when using IN Kim Rose Carlsen 19:37
Re: Equivalence Classes when using IN David Rowley 19:46
Re: Equivalence Classes when using IN Kim Rose Carlsen 21:15
Re: Equivalence Classes when using IN David Rowley 22:12

Oct. 12, 2017

Thread Author Time
Re: BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer 02:25
Re: BDR, wal sender, high system cpu, mutex_lock_common Andres Freund 03:03
Re: BDR, wal sender, high system cpu, mutex_lock_common Craig Ringer 03:10
Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function 📎 KES 08:00
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Arthur Zakirov 09:15
Restore LargeObjects on different server Durumdara 09:35
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function KES 10:01
Re: Restore LargeObjects on different server Durumdara 10:41
Re: Restore LargeObjects on different server Laurenz Albe 12:15
Re: core system is getting unresponsive because over 300 cpu load Scott Marlowe 13:25
Re: Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Brian Dunavant 14:37
EAV Designs for Multi-Tenant Applications Nic Pottier 14:48
Index corruption & broken clog Benoit Lobréau 16:30

Oct. 13, 2017

Thread Author Time
REASSIGN OWNED simply doesn't work Sam Gendler 01:09
Re: REASSIGN OWNED simply doesn't work Stephen Cook 03:44

Browse Archives

Prev | Next