Mailing lists [pgsql-general]

1 April 2020

• 00:09   Re: Index selection issues with RLS using expressions Alastair McKinley
• 07:52   Database Cache Hit Ratio (Warning) Rajiv Ranjan
• 08:14   Re: Database Cache Hit Ratio (Warning) David G. Johnston
• 15:18   Re: Is PostgreSQL SQL Database Command Syntax Similar toMySQL/MariaDB? Turritopsis Dohrnii Teo En Ming
• 15:27   Re: Index selection issues with RLS using expressions Alastair McKinley
• 15:51    Nicola Contu
• 16:35   permission denied for schema AC Gomez
• 17:05   Re: Index selection issues with RLS using expressions Stephen Frost
• 18:59   Re: permission denied for schema Adrian Klaver
• 19:04   Re: pgAdmin4 installation on macOS installed a User: can I delete it? Adrian Klaver
• 19:17   dbeaver Roberto Della Pasqua
• 19:27   Re: dbeaver Adrian Klaver
• 19:33   R: dbeaver Roberto Della Pasqua
• 20:09   postgres: archiver process failed on 000000010000020A00000073 Silvio Fabi - NBS srl
• 20:36   Re: postgres: archiver process failed on 000000010000020A00000073 Alvaro Herrera
• 22:44   Re: dbeaver negora
• 22:53   Re: dbeaver Ravi Krishna
• 23:28   Re: dbeaver Thomas Kellerer

2 April 2020

• 00:53   Re: R: dbeaver Adrian Klaver
• 01:06   It is possible to force periodically switch xlog? Edson Richter
• 01:11   Re: It is possible to force periodically switch xlog? Abdul Sayeed
• 01:55   Re: It is possible to force periodically switch xlog? Alvaro Herrera
• 02:19   RE: It is possible to force periodically switch xlog? Edson Richter
• 02:39   using a common key value on both sides of a union ? David Gauthier
• 02:46   Re: using a common key value on both sides of a union ? David G. Johnston
• 04:09   Re: It is possible to force periodically switch xlog? David Steele
• 04:22   Re: It is possible to force periodically switch xlog? Kyotaro Horiguchi
• 05:29   RE: It is possible to force periodically switch xlog? Edson Richter
• 05:31   RE: It is possible to force periodically switch xlog? Edson Richter
• 05:38   Re: It is possible to force periodically switch xlog? Alvaro Herrera
• 06:16   RE: It is possible to force periodically switch xlog? Edson Richter
• 11:12   Re: postgres: archiver process failed on 000000010000020A00000073 Silvio Fabi - NBS srl
• 11:53   Re: using a common key value on both sides of a union ? Laurenz Albe
• 17:48   Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 Andrus
• 17:57   Re: Fixing set-returning functions are not allowed in UPDATE afterupgrade to Postgres 12 Laurenz Albe
• 18:06   too many clients already Abraham, Danny
• 18:09   Re: too many clients already Rob Sargent
• 18:20   Re: too many clients already Adrian Klaver
• 18:22   RE: Re: too many clients already Abraham, Danny
• 18:29   Re: too many clients already Adrian Klaver
• 18:35   RE: Re: too many clients already Abraham, Danny
• 18:37   Re: too many clients already Adrian Klaver
• 18:41   RE: Re: too many clients already Abraham, Danny
• 18:51   Re: too many clients already Tom Lane
• 19:20   RE: Re: too many clients already Abraham, Danny
• 19:40   Re: too many clients already Tom Lane
• 20:13   RE: Re: too many clients already Abraham, Danny
• 22:37   Could someone please help us share the procedure to troubleshoot thelocks on proc issues. postgann2020 s
• 22:37   Could someone please help us share the procedure to troubleshoot thelocks on proc issues. postgann2020 s
• 22:37   Could someone please help us share the procedure to troubleshoot thelocks on proc issues. postgann2020 s
• 23:40   Cstore_fdw issue. Moses Mafusire

3 April 2020

• 01:27   Re: Cstore_fdw issue. Adrian Klaver
• 02:00   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. Adrian Klaver
• 02:00   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. Adrian Klaver
• 02:00   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. Adrian Klaver
• 06:34   Backing out of privilege grants rabbit hole AC Gomez
• 06:37   Re: Backing out of privilege grants rabbit hole Guyren Howe
• 06:41   Re: Backing out of privilege grants rabbit hole Guyren Howe
• 06:42   Re: Backing out of privilege grants rabbit hole AC Gomez
• 07:42   Improve COPY performance into table with indexes. James Brauman
• 07:57   Re: Backing out of privilege grants rabbit hole raf
• 07:59   Re: Backing out of privilege grants rabbit hole AC Gomez
• 08:11   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. postgann2020 s
• 08:11   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. postgann2020 s
• 08:11   Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues. postgann2020 s
• 09:37   Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 Andrus
• 10:17   Re: Fixing set-returning functions are not allowed in UPDATE afterupgrade to Postgres 12 David G. Johnston
• 10:27   Re: Improve COPY performance into table with indexes. Tim Cross
• 10:42   Out of memory in big transactions after upgrade to 12.2 Jan Strube
• 11:47   Re: Improve COPY performance into table with indexes. Laurenz Albe
• 11:50   Re: Backing out of privilege grants rabbit hole Laurenz Albe
• 14:50   Re: Out of memory in big transactions after upgrade to 12.2 Pavel Stehule
• 15:16   Re: Database Cache Hit Ratio (Warning) Rajiv Ranjan
• 15:53   Re: Cstore_fdw issue. Moses Mafusire
• 16:29   Re: Out of memory in big transactions after upgrade to 12.2 David Day
• 16:55   Re: Backing out of privilege grants rabbit hole Rob Sargent
• 18:07   Re: Database Cache Hit Ratio (Warning) David G. Johnston
• 18:39   Re: Cstore_fdw issue. Adrian Klaver
• 18:52   Re: Improve COPY performance into table with indexes. Adrian Klaver
• 19:08   Re: Improve COPY performance into table with indexes. Rob Sargent
• 19:26   Re: Cstore_fdw issue. Moses Mafusire
• 19:30   Re: Out of memory in big transactions after upgrade to 12.2 Michael Lewis
• 19:39   Re: Cstore_fdw issue. Adrian Klaver
• 20:18   Re: Backing out of privilege grants rabbit hole Adrian Klaver
• 20:23   Re: Backing out of privilege grants rabbit hole Adrian Klaver
• 20:29   Re: Backing out of privilege grants rabbit hole AC Gomez
• 20:48   Re: Cstore_fdw issue. Moses Mafusire
• 20:56   Re: Cstore_fdw issue. Adrian Klaver
• 21:52   Re: Cstore_fdw issue. Moses Mafusire
• 22:10   Re: Cstore_fdw issue. Adrian Klaver
• 22:25   Re: Cstore_fdw issue. Adrian Klaver

4 April 2020

• 10:07   Why there is 30000 rows is sample Andrus
• 10:28   Re: Why there is 30000 rows is sample Julien Rouhaud
• 11:08   Re: Using compression on TCP transfer Andrus
• 17:05   Re: Why there is 30000 rows is sample Peter J. Holzer

5 April 2020

• 11:59   Re: Using compression on TCP transfer Olivier Gautherot
• 15:50   psql show me the : and ask user input, when running one sql file arden liu
• 16:46   Re: psql show me the : and ask user input, when running one sql file Tim Clarke
• 17:24   Re: psql show me the : and ask user input, when running one sql file David G. Johnston
• 17:36   Re: psql show me the : and ask user input, when running one sql file Rob Sargent
• 17:51   Re: psql show me the : and ask user input, when running one sql file David G. Johnston
• 18:57   Re: Using compression on TCP transfer Andrus
• 19:13   Re: psql show me the : and ask user input, when running one sql file Adrian Klaver
• 19:46   Re: psql show me the : and ask user input, when running one sql file Adrian Klaver
• 19:47   Re: psql show me the : and ask user input, when running one sql file Adrian Klaver
• 20:10   Re: psql show me the : and ask user input, when running one sql file Adrian Klaver
• 20:30   Re: psql show me the : and ask user input, when running one sql file arden liu
• 20:32   Re: psql show me the : and ask user input, when running one sql file arden liu
• 20:51   Re: psql show me the : and ask user input, when running one sql file arden liu
• 21:09   Re: psql show me the : and ask user input, when running one sql file Adrian Klaver
• 21:29   Re: psql show me the : and ask user input, when running one sql file arden liu
• 21:32   Re: psql show me the : and ask user input, when running one sql file Daniel Verite
• 21:46   Re: psql show me the : and ask user input, when running one sql file arden liu

6 April 2020

• 09:39   Server with hot standby slave wont start after vacuum Andrus
• 11:03   How to prevent master server crash if hot standby stops Andrus
• 11:27   Re: How to prevent master server crash if hot standby stops Laurenz Albe
• 11:28   Re: How to prevent master server crash if hot standby stops Michael Paquier
• 11:33   Re: Server with hot standby slave wont start after vacuum Laurenz Albe
• 11:47   Re: How to prevent master server crash if hot standby stops Andrus
• 11:59   Re: How to prevent master server crash if hot standby stops Andrus
• 15:12   AW: Out of memory in big transactions after upgrade to 12.2 Jan Strube
• 16:02   Logical replication Konireddy Rajashekar
• 16:51   Re: How to prevent master server crash if hot standby stops Laurenz Albe
• 19:18   Re: Logical replication Michael Lewis

7 April 2020

• 00:50   Re: How to prevent master server crash if hot standby stops Andrus
• 02:41   Re: Cstore_fdw issue. Devrim Gündüz
• 02:43   Re: Cstore_fdw issue. Devrim Gündüz
• 04:11   How to unnest nested arrays Guyren Howe
• 05:21   extract property value from set of json arrays AC Gomez
• 05:44   Re: How to unnest nested arrays David G. Johnston
• 05:51   Re: extract property value from set of json arrays David G. Johnston
• 06:43   Re: extract property value from set of json arrays AC Gomez
• 07:08   what happens when you issue ALTER SERVER in a hot environment? AC Gomez
• 07:29   Re: what happens when you issue ALTER SERVER in a hot environment? David G. Johnston
• 07:53   Re: what happens when you issue ALTER SERVER in a hot environment? Tom Lane
• 08:03   Re: How to unnest nested arrays Pavel Stehule
• 08:24   Re: How to unnest nested arrays Guyren Howe
• 08:49   Re: How to unnest nested arrays Pavel Stehule
• 09:29   Re: Logical replication Konireddy Rajashekar
• 09:59   Re: what happens when you issue ALTER SERVER in a hot environment? Laurenz Albe
• 10:12   Re: How to prevent master server crash if hot standby stops Laurenz Albe
• 12:05   Re: How to prevent master server crash if hot standby stops Andrus
• 13:50   Re: How to prevent master server crash if hot standby stops Laurenz Albe
• 14:39   PostgreSQL native multi-master Vano Beridze
• 16:16   Re: what happens when you issue ALTER SERVER in a hot environment? AC Gomez
• 16:46   Re: PostgreSQL native multi-master Andreas Kretschmer
• 18:10   Using of --data-checksums BGoebel
• 19:24   Estimated resources for a 500 connections instance (VM) David Gauthier
• 19:28   Re: Estimated resources for a 500 connections instance (VM) Josef Šimánek
• 19:41   Re: Mixed Locales and Upgrading Don Seiler
• 19:47   Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus
• 19:57   Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12 Pavel Stehule
• 20:09   Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus
• 20:19   Re: Estimated resources for a 500 connections instance (VM) Laurenz Albe
• 20:26   Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12 Pavel Stehule
• 22:51   Re: Estimated resources for a 500 connections instance (VM) David Gauthier
• 23:23   Re: Estimated resources for a 500 connections instance (VM) Sándor Daku
• 23:31   Re: Estimated resources for a 500 connections instance (VM) Tim Cross
• 23:31   Re: Estimated resources for a 500 connections instance (VM) Rob Sargent
• 23:32   Re: Estimated resources for a 500 connections instance (VM) Adrian Klaver

8 April 2020

• 00:56   Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus
• 04:24   Announcing "common" YUM repository Devrim Gündüz
• 05:29   Re: Using of --data-checksums Michael Paquier
• 10:32   Re: Mixed Locales and Upgrading Peter Eisentraut
• 10:39   Re: Estimated resources for a 500 connections instance (VM) Laurenz Albe
• 14:47   Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12 Pavel Stehule
• 14:53   Re: Mixed Locales and Upgrading Peter J. Holzer
• 16:34   Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus
• 16:39   Best method to display table information in predefined formats Mark Bannister
• 17:03   Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12 Pavel Stehule
• 17:35   Unexpected behavior sorting strings Jimmy Thrasher
• 18:28   Re: Best method to display table information in predefined formats Adrian Klaver
• 18:39   Re: Best method to display table information in predefined formats Mark Bannister
• 18:41   Re: Best method to display table information in predefined formats Adrian Klaver
• 18:47   Re: Unexpected behavior sorting strings Tom Lane
• 18:49   Re: Unexpected behavior sorting strings Adrian Klaver
• 18:53   Re: Best method to display table information in predefined formats melvin6925
• 18:53   Re: PostgreSQL native multi-master Stephen Frost
• 18:54   Re: Using of --data-checksums Stephen Frost
• 19:08   Re: Unexpected behavior sorting strings Jimmy Thrasher
• 20:28   full text Roberto Della Pasqua

9 April 2020

• 00:27   Re: full text Joshua Drake
• 10:27   Re: PostgreSQL native multi-master Joshua Drake
• 13:08   Re: full text Martin Gainty
• 17:33   order by not working in view ? David Gauthier
• 17:41   Re: full text Stephen Frost
• 17:41   Re: order by not working in view ? Tom Lane
• 17:57   Re: order by not working in view ? David G. Johnston

10 April 2020

• 00:29   ext4 tuning parameters Casey Meijer
• 04:40   Different Lock Behavior With Create and Drop Foreign Key Virendra Kumar
• 08:27   Re: Different Lock Behavior With Create and Drop Foreign Key Laurenz Albe
• 19:13   Re: Different Lock Behavior With Create and Drop Foreign Key Tom Lane
• 19:32   Huge number of pg_temp and pg_toast_temp schemas Andrus
• 20:27   Re: Huge number of pg_temp and pg_toast_temp schemas Tom Lane
• 21:06   Re: Huge number of pg_temp and pg_toast_temp schemas Andrus
• 21:30   Re: Huge number of pg_temp and pg_toast_temp schemas Adrian Klaver
• 23:20   Forcibly disconnect users from one database Andrus
• 23:25   Re: Using of --data-checksums Bruce Momjian
• 23:37   Re: Using of --data-checksums Stephen Frost

11 April 2020

• 01:39   Re: Forcibly disconnect users from one database Adrian Klaver

12 April 2020

• 00:25   Which commands are guaranteed to drop role Andrus
• 00:44   Looping though schemas to grant access will work in PUBLIC loopiteration but fails on next iteration of user schema at: GRANT ALL PRIVILEGESON ALL TABLES IN SCHEMA AC Gomez
• 07:50   Log Unique Queries without Params? Chris Morris
• 07:55   Re: Log Unique Queries without Params? Julien Rouhaud
• 09:05   Re: Using of --data-checksums Michael Paquier
• 14:38   Re: Using of --data-checksums Magnus Hagander
• 17:23   Re: Using of --data-checksums Tom Lane
• 23:09   Re: Which commands are guaranteed to drop role Laurenz Albe

13 April 2020

• 01:30   Re: Using of --data-checksums Michael Paquier
• 03:02   Re: Which commands are guaranteed to drop role Andrus
• 03:23   Database lock on command: GRANT ALL PRIVILEGES ON ALL TABLES INSCHEMA, while looping though schemas AC Gomez
• 08:37   Re: Log Unique Queries without Params? Chris Morris
• 09:20   Re: Log Unique Queries without Params? Rene Romero Benavides
• 13:30   MPP feature in PG brajmohan saxena
• 22:48   Using Oracle SQL Client commands with PSQL 12.2 DB Fred Richard
• 22:48   Using Oracle SQL Client commands with PSQL 12.2 DB Fred Richard
• 23:15   Re: Using Oracle SQL Client commands with PSQL 12.2 DB Olivier Gautherot

14 April 2020

• 12:01   AW: Which commands are guaranteed to drop role Zwettler Markus (OIZ)
• 15:47   Invalid name syntax on to_regrole(session_user) Ц
• 17:04   Re: Invalid name syntax on to_regrole(session_user) Tom Lane
• 17:32   Re[2]: Invalid name syntax on to_regrole(session_user) Ц
• 18:00   pg_basebackup && long time storage of wal_archive/ content Matthias Apitz
• 18:28   Re: pg_basebackup && long time storage of wal_archive/ content Adrian Klaver

15 April 2020

• 08:32   Help needed with XMLTABLE Dilip Kumar
• 09:16   Re: pg_basebackup && long time storage of wal_archive/ content Matthias Apitz
• 09:30   Re: pg_basebackup && long time storage of wal_archive/ content Laurenz Albe
• 10:11   Re: Help needed with XMLTABLE Pavel Stehule
• 10:25   Re: Help needed with XMLTABLE Pavel Stehule
• 10:40   Re: Help needed with XMLTABLE Dilip Kumar
• 13:01   pg_restore: could not close data file: Success Peter J. Holzer
• 13:14   Re: pg_restore: could not close data file: Success Peter J. Holzer
• 17:22   Re: pg_basebackup && long time storage of wal_archive/ content Adrian Klaver
• 20:25   GENERATED STORED columns and table rewrites? Maciek Sakrejda
• 20:50   timestamp and timestamptz  Niels Jespersen
• 21:04   Re: timestamp and timestamptz Magnus Hagander
• 21:06   Re: timestamp and timestamptz Steve Crawford
• 21:06   Re: timestamp and timestamptz Steve Crawford
• 23:44   Re: GENERATED STORED columns and table rewrites? Michael Lewis

16 April 2020

• 01:08   Re: timestamp and timestamptz Tim Cross
• 02:53   Re: timestamp and timestamptz raf
• 03:15   Re: timestamp and timestamptz David G. Johnston
• 06:08   Re: pg_restore: could not close data file: Success Kyotaro Horiguchi
• 06:08   Re: pg_restore: could not close data file: Success Kyotaro Horiguchi
• 07:12   SV: timestamp and timestamptz Niels Jespersen
• 08:40   Re: pg_restore: could not close data file: Success Michael Paquier
• 08:40   Re: pg_restore: could not close data file: Success Michael Paquier
• 10:19   Re: timestamp and timestamptz raf
• 10:27   Re: timestamp and timestamptz Steve Baldwin
• 10:28   Re: timestamp and timestamptz Pavel Stehule
• 11:23   Re: timestamp and timestamptz raf
• 11:27   Re: timestamp and timestamptz Magnus Hagander
• 11:35   Recursive Queries Alex Magnum
• 11:37   SV: timestamp and timestamptz Niels Jespersen
• 12:19   Re: pg_restore: could not close data file: Success Kyotaro Horiguchi
• 12:19   Re: pg_restore: could not close data file: Success Kyotaro Horiguchi
• 15:48   RE: Recursive Queries Rob Northcott
• 16:24   Re: Recursive Queries Julien Rouhaud
• 16:25   Re: Recursive Queries Michael Lewis
• 16:36   Re: Recursive Queries Edward Macnaghten
• 16:42   Re: Recursive Queries Olivier Gautherot
• 16:45   Re: Recursive Queries Edward Macnaghten
• 17:08   possibilities for SQL optimization Chris Stephens
• 17:22   Re: possibilities for SQL optimization Pavel Stehule
• 17:57   Re: possibilities for SQL optimization Chris Stephens
• 18:20   Re: possibilities for SQL optimization Olivier Gautherot
• 18:46   Re: possibilities for SQL optimization Michael Lewis
• 20:36   Re: timestamp and timestamptz Adrian Klaver
• 21:06   Re: Recursive Queries Alex Magnum
• 21:28   Re: possibilities for SQL optimization Chris Stephens
• 21:39   Using unlogged tables for web sessions Stephen Carboni
• 22:57   Need for box type with 1/4 precision and gist indexes Anzor Apshev

17 April 2020

• 00:24   Re: Using of --data-checksums Magnus Hagander
• 01:39   File Foreign Table Doesn't Exist when in Exception Virendra Kumar
• 01:47   Re: File Foreign Table Doesn't Exist when in Exception Adrian Klaver
• 01:47   Re: Using of --data-checksums Jeremy Schneider
• 02:07   Re: File Foreign Table Doesn't Exist when in Exception Adrian Klaver
• 02:21   Re: Using unlogged tables for web sessions Tim Cross
• 02:29   performance of first exec of prepared statement Ted Toth
• 02:59   Re: performance of first exec of prepared statement Ted Toth
• 03:15   Re: performance of first exec of prepared statement Adrian Klaver
• 03:32   Re: Using of --data-checksums Michael Paquier
• 03:38   Could not resolve host name error in psycopg2 derwin theduck
• 03:44   Re: timestamp and timestamptz raf
• 04:00   Re: Could not resolve host name error in psycopg2 Adrian Klaver
• 04:09   Re: performance of first exec of prepared statement Rob Sargent
• 04:11   Re: Could not resolve host name error in psycopg2 derwin theduck
• 07:22   Detecting renamed columns via pgouput in logical replication ? Andreas Andreakis
• 09:38   Pgbackrest restore options Konireddy Rajashekar
• 10:02   Re: Could not resolve host name error in psycopg2 Paul Förster
• 11:13   Re: Using unlogged tables for web sessions Steve Atkins
• 11:13   Is there a script and sample data to test the performance ofpostgresql? Kiwoong Choi
• 11:43   Re: Is there a script and sample data to test the performance of postgresql? David Rowley
• 15:37   easy way to acquire height / width from images (PNG, JPEG) stored asbytea? Achilleas Mantzios
• 16:09   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Adam Brusselback
• 16:28   Re: performance of first exec of prepared statement Ted Toth
• 16:31   Replication issue Sonam Sharma
• 16:34   Re: performance of first exec of prepared statement Ted Toth
• 16:48   Re: performance of first exec of prepared statement Rob Sargent
• 17:02   Re: Replication issue Adrian Klaver
• 17:10   Re: Could not resolve host name error in psycopg2 Adrian Klaver
• 17:39   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Achilleas Mantzios
• 17:45   Re: Replication issue Julien Rouhaud
• 17:46   Re: Could not resolve host name error in psycopg2 Paul Förster
• 17:47   Re: Replication issue Sonam Sharma
• 17:47   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Steve Atkins
• 18:05   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Achilleas Mantzios
• 18:14   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Imre Samu
• 18:18   Re: easy way to acquire height / width from images (PNG, JPEG) storedas bytea? Achilleas Mantzios
• 23:18   Re: Using unlogged tables for web sessions John DeSoi

18 April 2020

• 10:18   serie of serie Olivier Leprêtre
• 12:00   Re: serie of serie Rory Campbell-Lange
• 16:25   Re: serie of serie Achilleas Mantzios
• 19:24   Re: Replication issue Adrian Klaver

19 April 2020

• 17:47   Anzacathon, PostgreSQL and IPFS Daniel Pocock

20 April 2020

• 17:52   Usage reporting of Cloud provided PostgreSQL service Saurav Sarkar
• 20:50   Unable to connect to the database: TypeError: net.Socket is not a constructor Marco Ippolito
• 21:11   Re: Unable to connect to the database: TypeError: net.Socket is not aconstructor Adrian Klaver
• 21:29   Re: Unable to connect to the database: TypeError: net.Socket is not a constructor Marco Ippolito
• 22:21   Re: Unable to connect to the database: TypeError: net.Socket is not aconstructor Adrian Klaver

21 April 2020

• 01:47   Re: Unable to connect to the database: TypeError: net.Socket is nota constructor Tim Cross
• 10:34   Re: Unable to connect to the database: TypeError: net.Socket is not a constructor Marco Ippolito
• 11:58   a prefix searching Олег Самойлов
• 13:09   1GB of maintenance work mem pinker
• 20:24   Triggers and Full Text Search * Malik Rumi
• 20:32   Sv: Triggers and Full Text Search * Andreas Joseph Krogh
• 21:04   Re: Triggers and Full Text Search * Ericson Smith
• 21:12   Re: Triggers and Full Text Search * Adrian Klaver
• 21:21   Re: Triggers and Full Text Search * Malik Rumi
• 21:25   Re: Triggers and Full Text Search * Ericson Smith
• 21:25   Re: DB Link returning Partial data rows Adrian Klaver
• 21:28   Re: Triggers and Full Text Search * Adrian Klaver
• 22:45   Re: Triggers and Full Text Search * Laurenz Albe
• 23:30   how to slow down parts of Pg Kevin Brannen
• 23:38   Re: how to slow down parts of Pg Michael Lewis
• 23:52   Re: how to slow down parts of Pg Michael Loftis

22 April 2020

• 00:05   RE: how to slow down parts of Pg Kevin Brannen
• 00:14   Re: how to slow down parts of Pg Michael Loftis
• 00:16   RE: how to slow down parts of Pg Kevin Brannen
• 00:25   RE: how to slow down parts of Pg Kevin Brannen
• 00:32   Re: how to slow down parts of Pg Virendra Kumar
• 00:35   Re: how to slow down parts of Pg David G. Johnston
• 00:44   RE: how to slow down parts of Pg Kevin Brannen
• 01:17   Re: how to slow down parts of Pg Michael Lewis
• 01:54   Re: how to slow down parts of Pg Adrian Klaver
• 02:59   Re: Connection Refused Adrian Klaver
• 05:43   Re: how to slow down parts of Pg Virendra Kumar
• 07:17   Using GIN index to retrieve distinct values Alexander Hill
• 10:19   Re: how to slow down parts of Pg Laurenz Albe
• 11:00   How do work tercile, percentile & funcion percentile_cont() ? PALAYRET Jacques
• 11:15   Re: How do work tercile, percentile & funcion percentile_cont() ? PALAYRET Jacques
• 16:18   Re: How do work tercile, percentile & funcion percentile_cont() ? PALAYRET Jacques
• 17:36   Re: How do work tercile, percentile & funcion percentile_cont() ? Tom Lane
• 18:19   RE: how to slow down parts of Pg Kevin Brannen
• 18:49   Re: how to slow down parts of Pg Adrian Klaver
• 21:22   PG based ETL tools brajmohan saxena
• 22:10   Can I tell libpq to connect to the primary? Christian Ramseyer
• 22:10   Re: how to slow down parts of Pg Ron

23 April 2020

• 01:43   Re: how to slow down parts of Pg Peter J. Holzer
• 02:03   Re: How do work tercile, percentile & funcion percentile_cont() ? Peter J. Holzer
• 09:54   Re: Can I tell libpq to connect to the primary? Christian Ramseyer
• 11:13   pg11: Query using index, but only for half the partitions Stefan Knecht
• 13:01   Re: pg11: Query using index, but only for half the partitions Andreas Kretschmer
• 13:30   Re: pg11: Query using index, but only for half the partitions Stefan Knecht
• 13:47   Re: pg11: Query using index, but only for half the partitions Andreas Kretschmer
• 16:16   Re: pg11: Query using index, but only for half the partitions Michael Lewis
• 17:33   parameter limit Scott Ribe
• 17:48   Re: parameter limit Adrian Klaver
• 17:54   Re: parameter limit David G. Johnston
• 18:04   Re: parameter limit Scott Ribe
• 18:44   Reg: Help to understand the source code Preethi S
• 18:49   Re: Reg: Help to understand the source code Adrian Klaver
• 19:28   Re: Reg: Help to understand the source code Preethi S
• 19:30   Re: Reg: Help to understand the source code Rob Sargent
• 19:37   relationship of backend_start, query_start, state_change Si Chen
• 19:43   Re: Reg: Help to understand the source code Preethi S
• 19:46   Re: relationship of backend_start, query_start, state_change Michael Lewis
• 19:54   Re: relationship of backend_start, query_start, state_change Olivier Gautherot
• 19:55   Re: relationship of backend_start, query_start, state_change David G. Johnston
• 19:58   Re: relationship of backend_start, query_start, state_change Olivier Gautherot
• 20:00   Re: relationship of backend_start, query_start, state_change David G. Johnston
• 20:07   walreceiver termination Justin King
• 20:08   Re: relationship of backend_start, query_start, state_change David G. Johnston
• 20:26   Re: Reg: Help to understand the source code Paul Jungwirth
• 20:47   Re: walreceiver termination Tom Lane
• 21:26   Re: Could Not Connect To Server David G. Johnston
• 21:33   Ned to understand why all the idle connections David Gauthier
• 21:41   Re: Ned to understand why all the idle connections David G. Johnston
• 21:51   Re: Ned to understand why all the idle connections David Gauthier
• 21:55   Re: Could Not Connect To Server David G. Johnston
• 21:57   Re: Ned to understand why all the idle connections David G. Johnston
• 22:23   Re: Could Not Connect To Server Rob Sargent
• 22:25   Re: Could Not Connect To Server Adrian Klaver
• 22:27   Question on banner display after PG initial connection Lu, Dan
• 22:36   Re: Could Not Connect To Server Rob Sargent
• 22:40   Re: Could Not Connect To Server Adrian Klaver
• 22:46   Re: walreceiver termination Justin King
• 22:51   Re: walreceiver termination Justin King
• 23:06   Re: walreceiver termination Tom Lane
• 23:27   Re: Fw: Re: Could Not Connect To Server Adrian Klaver

24 April 2020

• 00:16   Re: Question on banner display after PG initial connection David G. Johnston
• 00:18   Re: Ned to understand why all the idle connections Si Chen
• 00:21   RE: how to slow down parts of Pg Kevin Brannen
• 00:26   Re: Fw: Re: Could Not Connect To Server Adrian Klaver
• 00:31   Re: Ned to understand why all the idle connections David G. Johnston
• 00:34   RE: how to slow down parts of Pg Kevin Brannen
• 00:36   Re: Fw: Re: Could Not Connect To Server Rob Sargent
• 00:40   Re: walreceiver termination Justin King
• 01:05   Re: Fw: Re: Could Not Connect To Server Adrian Klaver
• 01:06   Re: Fw: Re: Could Not Connect To Server David G. Johnston
• 01:22   Re: Fw: Re: Could Not Connect To Server Rob Sargent
• 01:36   Re: Ned to understand why all the idle connections Si Chen
• 01:55   Re: Fw: Re: Re: Could Not Connect To Server Rob Sargent
• 04:12   Re: Reg: Help to understand the source code Preethi S
• 10:12   Re: Can I tell libpq to connect to the primary? Michael Paquier
• 15:53   Weird behaviour of C extension function Amaury Bouchard
• 16:27   Re: Weird behaviour of C extension function Laurenz Albe
• 17:32   create index insist on 2 workers only Radoslav Nedyalkov
• 18:55   psql \copy Steve Clark
• 18:59   Re: psql \copy Adrian Klaver
• 18:59   Re: psql \copy David G. Johnston
• 18:59   Re: psql \copy Steve Crawford
• 19:12   Re: psql \copy Steve Clark
• 19:15   Re: psql \copy Adrian Klaver
• 19:16   Re: psql \copy Rob Sargent
• 19:19   Re: psql \copy Steve Clark
• 19:36   Re: psql \copy Ron

25 April 2020

• 05:03   Re: create index insist on 2 workers only Peter Geoghegan
• 18:04   Binary downloads and upgrading the host OS Tom Browder
• 18:23   Re: Binary downloads and upgrading the host OS Adrian Klaver
• 18:38   Re: Binary downloads and upgrading the host OS Tom Browder
• 21:12   Re: Triggers and Full Text Search * Malik Rumi

26 April 2020

• 01:06   Re: Binary downloads and upgrading the host OS Magnus Hagander
• 04:36   Re: Binary downloads and upgrading the host OS Tom Browder

27 April 2020

• 09:07   Re: Detecting renamed columns via pgouput in logical replication ? David G. Johnston
• 10:06   Re: Detecting renamed columns via pgouput in logical replication ? Andreas Andreakis
• 10:32   Re: Detecting renamed columns via pgouput in logical replication ? David G. Johnston
• 10:37   Re: Detecting renamed columns via pgouput in logical replication ? David G. Johnston
• 11:03   HOST variable in psql Paul Förster
• 11:45   How to debug "background worker "parallel worker" (PID 32152) wasterminated by signal 11: Segmentation fault" Radu Radutiu
• 12:37   Re: PostgreSQL Server version compatibility check with Window 2016 Magnus Hagander
• 15:20   Re: HOST variable in psql Tom Lane
• 15:21   PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Matthias Apitz
• 15:22   Re: How to debug "background worker "parallel worker" (PID 32152) was terminated by signal 11: Segmentation fault" Tom Lane
• 15:40   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Tom Lane
• 15:44   Re: HOST variable in psql Paul Förster
• 16:06   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;' Matthias Apitz
• 16:13   Re: HOST variable in psql Tom Lane
• 16:19   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;' Matthias Apitz
• 16:38   Re: HOST variable in psql Paul Förster
• 16:40   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Tom Lane
• 16:58   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Tom Lane
• 17:27   Re: How to debug "background worker "parallel worker" (PID 32152) wasterminated by signal 11: Segmentation fault" Mahendra Singh Thalor

28 April 2020

• 11:10   Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;' Matthias Apitz
• 23:58   GIN Expression Indexes Taylor Sarrafian

29 April 2020

• 03:29   Re: GIN Expression Indexes Adrian Klaver
• 14:26   Regarding db performance improvement Durgamahesh Manne
• 18:17   Why is a check constraint not working ? David Gauthier
• 18:19   Re: Why is a check constraint not working ? David G. Johnston
• 23:10   Re: Mixed Locales and Upgrading Don Seiler

30 April 2020

• 01:10   Re: Mixed Locales and Upgrading Adrian Klaver
• 02:39   Re: Mixed Locales and Upgrading Tom Lane
• 16:54   script libraries? Chris Stephens
• 17:06   Re: script libraries? Pavel Stehule
• 17:09   Re: script libraries? Thomas Kellerer
• 22:30   Re: Detecting renamed columns via pgouput in logical replication ? Alvaro Herrera