pgsql-general - June 2020

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

June 1, 2020

Thread	Author	Time
Re: Suggestion to Monitoring Tool	Rene Romero Benavides	00:06
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Adrian Klaver	00:29
Re: Oracle vs. PostgreSQL - a comment	Stefan Knecht	05:36
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Andrus	05:50
RE: pg_ctl can't start db server	Tanja Savic	07:04
Re: Oracle vs. PostgreSQL - a comment	Paul Förster	07:11
Re: pg_ctl can't start db server	Paul Förster	07:19
Re: Oracle vs. PostgreSQL - a comment	Jayadevan M	07:44
Re: Oracle vs. PostgreSQL - a comment	Paul Förster	07:50
Re: Oracle vs. PostgreSQL - a comment	Thomas Kellerer	07:53
Vanishing unique constraint	Bernhard Beroun	08:02
Re: problem with self built postgres 9.0.9	Gabriele Bulfon	08:07
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Andrus	08:17
Re: pg_stat_sql_plans ALPHA released	legrand legrand	08:36
Re: Postgresql 9.6 -> AWS RDS Postgresql 12.2 with pg_logical	Peter Eisentraut	09:04
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Paul Förster	09:06
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Magnus Hagander	09:13
Re: Oracle vs. PostgreSQL - a comment	Peter J. Holzer	09:58
Re: Trigger not firing	Hans	10:09
Re: Trigger not firing	Pavel Stehule	10:14
Re: Trigger not firing	Hans	10:15
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Andrus	10:26
Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated	Paul Förster	10:44
Re: Vanishing unique constraint	Julien Rouhaud	10:56
Re: Vanishing unique constraint	Bernhard Beroun	11:23
Re: Oracle vs. PostgreSQL - a comment	Ravi Krishna	11:58
Re: pg_ctl can't start db server	Adrian Klaver	13:26
Re: Trigger not firing	Adrian Klaver	13:43
Re: Vanishing unique constraint	Julien Rouhaud	15:27
Re: Suggestion to Monitoring Tool	Keith Fiske	15:47
Re: psql12.3 + jdbc_fdw - return wrong query results by using OR	Ying Lu	16:01
Pglogical 2.3.0 in AWS RDS 12.2	Igor Polishchuk	16:39
Re: Oracle vs. PostgreSQL - a comment	Karsten Hilbert	18:08
Using JSONB with nested key-value structures, and skipping/wildcarding the key	Shaheed Haque	18:18
Re: Pglogical 2.3.0 in AWS RDS 12.2	Jeremy Schneider	22:33
Re: Pglogical 2.3.0 in AWS RDS 12.2	Jeremy Schneider	22:39
Re: Using JSONB with nested key-value structures, and skipping/wildcarding the key	Alban Hertroys	22:50

June 2, 2020

Thread	Author	Time
Re: Pglogical 2.3.0 in AWS RDS 12.2	Adrian Klaver	00:53
LOG: could not send data to client: Broken pipe	TALLURI Nareshkumar	03:41
Re: Using JSONB with nested key-value structures, and skipping/wildcarding the key	Shaheed Haque	07:30
Re: Using JSONB with nested key-value structures, and skipping/wildcarding the key	Thomas Kellerer	07:37
Re: Oracle vs. PostgreSQL - a comment	Ron	08:22
Re: Oracle vs. PostgreSQL - a comment	Tim Clarke	08:27
Re: Oracle vs. PostgreSQL - a comment	Grigory Smolkin	09:59
Fine grained permissions on User Mapping	Paul Bonaud	10:01
Re: pg_dump crashes	Nico De Ranter	11:23
Patroni	Sonam Sharma	11:36
Re: Patroni	Paul Förster	12:11
Re: Using JSONB with nested key-value structures, and skipping/wildcarding the key	Alban Hertroys	12:20
Re: Fine grained permissions on User Mapping	Tom Lane	14:08
Re: LOG: could not send data to client: Broken pipe	Adrian Klaver	14:14
Re: LOG: could not send data to client: Broken pipe	Adrian Klaver	14:19
Re: Oracle vs. PostgreSQL - a comment	Michael Nolan	15:32
When to use PARTITION BY HASH?	Oleksandr Shulgin	17:17
Re: When to use PARTITION BY HASH?	Justin Pryzby	17:33
Re: When to use PARTITION BY HASH?	MichaelDBA	17:39
Re: When to use PARTITION BY HASH?	David G. Johnston	17:43
Re: When to use PARTITION BY HASH?	Michel Pelletier	17:45
Re: When to use PARTITION BY HASH?	Stephen Frost	17:47
RE: LOG: could not send data to client: Broken pipe	TALLURI Nareshkumar	18:18
Re: Oracle vs. PostgreSQL - a comment	Ron	18:22
Re: Oracle vs. PostgreSQL - a comment	Ron	18:25
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	18:30
Re: Oracle vs. PostgreSQL - a comment	Ron	18:38
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	18:43
Re: Oracle vs. PostgreSQL - a comment	Tim Clarke	18:56
Re: LOG: could not send data to client: Broken pipe	Adrian Klaver	19:07
RE: LOG: could not send data to client: Broken pipe	TALLURI Nareshkumar	19:20
Re: Oracle vs. PostgreSQL - a comment	Ron	19:44
Re: Oracle vs. PostgreSQL - a comment	Ravi Krishna	19:45
Re: Oracle vs. PostgreSQL - a comment	Guyren Howe	20:01
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	20:30
Re: Vanishing unique constraint	Bernhard Beroun	20:37
Re: Oracle vs. PostgreSQL - a comment	Christophe Pettus	20:41
Re: Oracle vs. PostgreSQL - a comment	Ravi Krishna	20:49
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	21:16
Re: Oracle vs. PostgreSQL - a comment	Thomas Kellerer	21:18
Re: Oracle vs. PostgreSQL - a comment	Adam Brusselback	21:19
Re: Oracle vs. PostgreSQL - a comment	Guyren Howe	21:19
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	21:21
Re: Oracle vs. PostgreSQL - a comment	Stephen Frost	21:22
Re: Oracle vs. PostgreSQL - a comment	Kenneth Marshall	21:27
Re: Oracle vs. PostgreSQL - a comment	raf	23:52

June 3, 2020

Thread	Author	Time
Re: LOG: could not send data to client: Broken pipe	Adrian Klaver	01:04
canceling statement due to conflict with recovery after pg_basebackup	Andrus	07:07
Re: When to use PARTITION BY HASH?	Oleksandr Shulgin	07:38
Re: When to use PARTITION BY HASH?	Oleksandr Shulgin	07:45
Re: canceling statement due to conflict with recovery after pg_basebackup	Kyotaro Horiguchi	09:00
Unable to find the details of bug fix in 9.6.x minor version.	Sameer Malve	09:32
select count(id) on RDS replica causing high CPU load on RDS master	Azul	11:04
Replication conflicts despite hot_standby_feedback = on?	Laurenz Albe	11:07
Re: Fine grained permissions on User Mapping	Paul Bonaud	11:11
Re: Replication conflicts despite hot_standby_feedback = on?	Julien Rouhaud	11:41
Re: When to use PARTITION BY HASH?	Oleksandr Shulgin	11:55
Re: Replication conflicts despite hot_standby_feedback = on?	Laurenz Albe	12:05
Re: Replication conflicts despite hot_standby_feedback = on?	Julien Rouhaud	12:42
Re: Unable to find the details of bug fix in 9.6.x minor version.	Adrian Klaver	13:47
Re: select count(id) on RDS replica causing high CPU load on RDS master	Jeremy Schneider	13:59
Re: Unable to find the details of bug fix in 9.6.x minor version.	Tom Lane	14:12
Shared memory error	Sonam Sharma	14:58
Re: When to use PARTITION BY HASH?	Justin Pryzby	15:09
Re: Oracle vs. PostgreSQL - a comment	Jeremy Schneider	16:50
Re: Oracle vs. PostgreSQL - a comment	Andreas Joseph Krogh	17:45
Re: Shared memory error	Sonam Sharma	17:57
Re: Shared memory error	Adrian Klaver	17:59
Re: Oracle vs. PostgreSQL - a comment	Chris Travers	18:07
Re: Shared memory error	Sonam Sharma	18:16
Re: Shared memory error	Sonam Sharma	18:18
Re: Oracle vs. PostgreSQL - a comment	Andreas Joseph Krogh	18:53
RE: Oracle vs. PostgreSQL - a comment	Basques, Bob (CI-StPaul)	19:19
Can we get SQL Server-like cross database queries	Guyren Howe	19:31
Re: Can we get SQL Server-like cross database queries	Tom Lane	19:46
Re: Can we get SQL Server-like cross database queries	Rob Sargent	19:57
Re: pg_dump of database with numerous objects	Alvaro Herrera	20:10
Re: Fine grained permissions on User Mapping	Adrian Klaver	20:22
Re: GPG signing	Bruce Momjian	20:46
Re: Oracle vs. PostgreSQL - a comment on Mysql	Martin Mueller	22:21
Re: Oracle vs. PostgreSQL - a comment on Mysql	Adrian Klaver	22:31
Re: Oracle vs. PostgreSQL - a comment on Mysql	Alvaro Herrera	22:32
A parsing question	Michael Nolan	22:41
Re: Oracle vs. PostgreSQL - a comment	Bruce Momjian	22:47
Re: Oracle vs. PostgreSQL - a comment on Mysql	Michael Nolan	22:48
Re: A parsing question	David G. Johnston	22:54
Re: A parsing question	Tom Lane	22:55

June 4, 2020

Thread	Author	Time
Re: Can we get SQL Server-like cross database queries	Ron	04:26
Re: Can we get SQL Server-like cross database queries	Thomas Munro	04:41
Potential optimisation for the creation of a partial index condition over a newly created nullable, non-default-valued column?	Tim Dawborn	05:46
Re: Can we get SQL Server-like cross database queries	Laurenz Albe	05:56
Re: Shared memory error	Sonam Sharma	07:09
Re: Fine grained permissions on User Mapping	Paul Bonaud	07:41
Re: Shared memory error	Naresh g	07:54
Re: Shared memory error	Thomas Munro	08:44
Re: select count(id) on RDS replica causing high CPU load on RDS master	Azul	09:22
Calculate hardware requirements	Praveen Kumar K S	09:36
Re: Calculate hardware requirements	Fabio Pardi	10:32
Re: Calculate hardware requirements	Praveen Kumar K S	10:44
Re: Shared memory error	Thomas Munro	11:42
Re: Shared memory error	Sonam Sharma	13:00
Re: Can we get SQL Server-like cross database queries	Matt Zagrabelny	14:21
Re: When to use PARTITION BY HASH?	Jeff Janes	14:32
PostgreSQL 11 with SSL on Linux	Susan Joseph	15:00
Re: Can we get SQL Server-like cross database queries	David G. Johnston	15:01
Re: PostgreSQL 11 with SSL on Linux	Magnus Hagander	15:14
Index no longer being used, destroying and recreating it restores use.	Koen De Groote	15:37
Multitenent architecture	Vasu Madhineni	15:52
Re: Index no longer being used, destroying and recreating it restores use.	Adrian Klaver	16:29
Re: Index no longer being used, destroying and recreating it restores use.	Tom Lane	16:43
Re: Index no longer being used, destroying and recreating it restores use.	Adrian Klaver	16:48
Re: PostgreSQL 11 with SSL on Linux	Susan Joseph	16:50
Monitoring for long running transactions	Samuel Smith	17:00
Possible improvement	Paul van der Linden	17:04
Re: Index no longer being used, destroying and recreating it restores use.	Tom Lane	17:08
Re: PostgreSQL 11 with SSL on Linux	Tom Lane	17:11
Re: PostgreSQL 11 with SSL on Linux	Susan Joseph	17:32
Re: PostgreSQL 11 with SSL on Linux	Alan Hodgson	17:36
Re: PostgreSQL 11 with SSL on Linux	Tom Lane	17:39
Re: PostgreSQL 11 with SSL on Linux	Susan Joseph	17:49
Re: PostgreSQL 11 with SSL on Linux	Tom Lane	18:07
Re: PostgreSQL 11 with SSL on Linux	Mohammed Bhatti	18:14
Re: PostgreSQL 11 with SSL on Linux	Susan Joseph	18:23
Re: Monitoring for long running transactions	Adrian Klaver	19:29
Move configuration files with pg_upgrade	Tanja Savic	19:52
Re: Monitoring for long running transactions	Samuel Smith	19:59
Re: Shared memory error	Thomas Munro	20:16
Re: Monitoring for long running transactions	Adrian Klaver	20:24
Re: Monitoring for long running transactions	Christoph Moench-Tegeder	20:29
Re: Monitoring for long running transactions	Thomas Kellerer	20:36
Re: Move configuration files with pg_upgrade	Peter J. Holzer	22:05
Re: Move configuration files with pg_upgrade	Adrian Klaver	22:26

June 5, 2020

Thread	Author	Time
Binary encoding of TIMESTAMP WITH TIME ZONE	Joe Abbate	00:24
Re: Binary encoding of TIMESTAMP WITH TIME ZONE	Tom Lane	00:32
Re: PostgreSQL 11 with SSL on Linux	Paul Förster	06:21
Re: Multitenent architecture	Paul Förster	06:37
Re: Multitenent architecture	Laurenz Albe	06:57
Re: Multitenent architecture	Vasu Madhineni	07:48
Re: Possible improvement	David Rowley	08:13
Re: Multitenent architecture	Rob Sargent	10:09
Re: When to use PARTITION BY HASH?	Oleksandr Shulgin	10:11
Re: Multitenent architecture	Ravi Krishna	10:14
Re: Potential optimisation for the creation of a partial index condition over a newly created nullable, non-default-valued column?	David Rowley	10:15
Re: When to use PARTITION BY HASH?	Imre Samu	11:48
Re: Oracle vs. PostgreSQL - a comment	Achilleas Mantzios	12:05
Re: Oracle vs. PostgreSQL - a comment	Ravi Krishna	12:33
Re: Oracle vs. PostgreSQL - a comment	Achilleas Mantzios	12:48
Re: When to use PARTITION BY HASH?	Jeff Janes	13:51
Re: Index no longer being used, destroying and recreating it restores use.	Koen De Groote	14:05
Re: Index no longer being used, destroying and recreating it restores use.	Adrian Klaver	14:15
Re: Oracle vs. PostgreSQL - a comment	Thomas Kellerer	14:19
Re: Possible improvement	Tom Lane	14:31
Re: Oracle vs. PostgreSQL - a comment	Achilleas Mantzios	15:02
Re: Binary encoding of TIMESTAMP WITH TIME ZONE	Peter J. Holzer	15:30
Re: Index no longer being used, destroying and recreating it restores use.	Koen De Groote	15:34
Postgres12 - Confusion with pg_restore	Laura Smith	18:20
Re: Postgres12 - Confusion with pg_restore	Christophe Pettus	18:23
Re: Postgres12 - Confusion with pg_restore	Laura Smith	18:27
Re: Postgres12 - Confusion with pg_restore	Tom Lane	18:35
Re: Possible improvement	Paul van der Linden	18:39
Re: Possible improvement	Tom Lane	19:02
Re: Index no longer being used, destroying and recreating it restores use.	Michael Lewis	19:10
Re: Possible improvement	Paul van der Linden	19:46

Browse Archives

Prev | Next