pgsql-general since 2021-04-29 00:00

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

Search the Archives

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

Browse Archives

Prev | Next

April 29, 2021

Thread Author Time
Re: postgres index usage count too high Laurenz Albe 06:41
RE: Open source licenses DAVID Nicolas 08:35
Re: Open source licenses Magnus Hagander 08:57
index only scan taking longer to run Ayub M 09:01
Re: Oracle vs. PostgreSQL - a comment Paul Förster 17:13
Re: Oracle vs. PostgreSQL - a comment ERR ORR 19:12
Re: index only scan taking longer to run Michael Lewis 19:52
Re: index only scan taking longer to run David Rowley 22:23
Re: Oracle vs. PostgreSQL - a comment Ludovico Caldara 22:25

April 30, 2021

Thread Author Time
"Skipping" BitmapHeapScan for simple counts Maarten Mortier 07:38
client backwards compatible with older servers Rajesh Madiwale 07:51
Re: client backwards compatible with older servers Vijaykumar Jain 08:08
Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Wolfgang Rißler 08:49
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Laurenz Albe 11:00
Re: Streaming replica failure Vijaykumar Jain 11:03
Re: -1/0 virtualtransaction Thomas Munro 11:11
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Wolfgang Rißler 11:26
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Wolfgang Rißler 11:55
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Tom Lane 14:16
Re: "Skipping" BitmapHeapScan for simple counts Tom Lane 14:29
Re: pg_upgrade and wraparound Bruce Momjian 19:32
Re: -1/0 virtualtransaction Mike Beachy 20:53

May 1, 2021

Thread Author Time
database sorting algorithms. Jian He 07:06
Re: database sorting algorithms. Francisco Olarte 09:15
Re: database sorting algorithms. Gavan Schneider 09:48
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Wolfgang Rißler 10:59
Re: database sorting algorithms. Jian He 13:25
Re: -1/0 virtualtransaction Mike Beachy 14:06
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Adrian Klaver 16:26

May 2, 2021

Thread Author Time
Extended stats - value not in MCV list Pedro Luis Guzmán Hernández 04:52
Re: Why is writing JSONB faster than just JSON? Dmitry Dolgov 12:50
PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Pól Ua Laoínecháin 13:46
Is this the future of I/O for the RDBMS? Pól Ua Laoínecháin 13:49
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Vijaykumar Jain 17:00
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Ron 18:31
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Peter J. Holzer 19:30
Re: Is this the future of I/O for the RDBMS? Peter J. Holzer 20:16
Re: "invalid contrecord" error on replica Adrien Nayrat 20:43

May 3, 2021

Thread Author Time
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Wolfgang Rißler 06:09
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) Laurenz Albe 08:41
Re: "invalid contrecord" error on replica Laurenz Albe 08:43
Re: "invalid contrecord" error on replica Adrien Nayrat 08:58
Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86) WR 09:15
Huge performance penalty with parallel queries in Windows x64 v. Linux x64 📎 Hans Buschmann 10:26
Re: "invalid contrecord" error on replica Adrien Nayrat 13:02
Re: pg_upgrade and wraparound Jan Wieck 15:10

May 4, 2021

Thread Author Time
Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Thomas Munro 01:38
Identified cause of potential pg_upgrade failure on Windows due to OS update adding partial block list of ports 50xxxx (could not connect to server) Andrew Armstrong 03:26
AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Hans Buschmann 07:40
Re: pg_upgrade can result in early wraparound on databases with high transaction load 📎 Drouvot, Bertrand 08:17
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Pól Ua Laoínecháin 08:25
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Pól Ua Laoínecháin 08:41
Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL? Pól Ua Laoínecháin 08:56
Re: Is this the future of I/O for the RDBMS? Pól Ua Laoínecháin 09:52
Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Thomas Munro 10:42
Re: pg_restore - generated column - not populating Peter Eisentraut 12:25
Re: pg_restore - generated column - not populating Santosh Udupi 15:08
AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Hans Buschmann 15:50
PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Arne Henrik Segtnan 16:29
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Bruce Momjian 16:38
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Magnus Hagander 16:40
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Tom Lane 16:43
Re: AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Tom Lane 16:46
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Bruce Momjian 16:52
Re: Extended stats - value not in MCV list Tomas Vondra 18:22
Postgres upgrade 12 - issues with OIDs Venkata B Nagothi 21:49
Re: Postgres upgrade 12 - issues with OIDs Bruce Momjian 23:22

May 5, 2021

Thread Author Time
Error creating postgres extensions Tiffany Thang 01:42
Re: Error creating postgres extensions Ian Lawrence Barwick 02:04
Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Thomas Munro 02:12
Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64 Thomas Munro 02:27
Re: Error creating postgres extensions Tiffany Thang 04:11
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Arne Henrik Segtnan 11:26
Strange behavior of function date_trunc Pavel Luzanov 13:23
Re: Strange behavior of function date_trunc Tomas Vondra 13:55
Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616" Bruce Momjian 14:02
Postgresql post_parse_analyze_hook not getting triggered for COMMIT command Soumya Prasad Ukil 14:04
Re: Strange behavior of function date_trunc Tom Lane 14:11
Re: Strange behavior of function date_trunc Pavel Luzanov 14:19
Re: Strange behavior of function date_trunc Pavel Luzanov 14:48
Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ? Ashwin Kini 18:42
Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ? Adrian Klaver 21:25
Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ? Ashwin Kini 22:20
Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ? Adrian Klaver 22:27
Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ? Ashwin Kini 22:28

May 6, 2021

Thread Author Time
Re: "invalid contrecord" error on replica Kyotaro Horiguchi 05:37
trigger impacting insertion of records Atul Kumar 07:45
Chain Hashing Jian He 09:48
Re: trigger impacting insertion of records Vijaykumar Jain 11:38
Re: Strange behavior of function date_trunc Pavel Luzanov 13:12
Re: Chain Hashing Thomas Munro 13:19
Re: Strange behavior of function date_trunc Tom Lane 13:44
Re: Strange behavior of function date_trunc David G. Johnston 14:28
[RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Thomas Boussekey 14:29
Compiling a ossp-uuid module for Win32 Wolfgang Rißler 14:57
Re: trigger impacting insertion of records Adrian Klaver 15:56
Re: Strange behavior of function date_trunc Pavel Luzanov 16:26
Re: Strange behavior of function date_trunc Tom Lane 19:14
Re: "invalid contrecord" error on replica Adrien Nayrat 19:21

May 7, 2021

Thread Author Time
Optimizing search query with sorting by creation field Droid Tools 00:42
idle_in_transaction_session_timeout Atul Kumar 06:34
Re: trigger impacting insertion of records Atul Kumar 06:37
SV: idle_in_transaction_session_timeout Gustavsson Mikael 06:42
Re: idle_in_transaction_session_timeout luis.roberto 11:10
Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Devrim Gündüz 11:55
Re: Optimizing search query with sorting by creation field Vijaykumar Jain 12:12
Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Thomas Boussekey 13:52
Re: Strange behavior of function date_trunc Pavel Luzanov 13:53
Re: Strange behavior of function date_trunc Pavel Luzanov 14:02
Re: trigger impacting insertion of records Adrian Klaver 14:57
Re: Metric to calculate WAL size left to transfer to Standby Viral Shah 20:07

May 8, 2021

Thread Author Time
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 02:23
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:23
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:39
Re: Have I found an interval arithmetic bug? Bruce Momjian 02:42
Re: Postgres upgrade 12 - issues with OIDs Venkata B Nagothi 03:37
Re: Postgres upgrade 12 - issues with OIDs Laurenz Albe 03:47
Re: Issue in PG start [email protected] 05:14
Re: Issue in PG start David G. Johnston 05:31
Re: Issue in PG start [email protected] 07:54
Re: pg_upgrade and wraparound Michael Paquier 08:48
Re: idle_in_transaction_session_timeout Atul Kumar 10:28
Re: idle_in_transaction_session_timeout Vijaykumar Jain 10:54
Re: Issue in PG start [email protected] 11:33
Re: idle_in_transaction_session_timeout Avinash Kumar 12:28
Re: Issue in PG start Adrian Klaver 15:53
Re: Issue in PG start Ron 16:23
Re: Issue in PG start Adrian Klaver 16:32
Re: Issue in PG start Tom Lane 16:53
Re: idle_in_transaction_session_timeout Peter J. Holzer 19:07

May 9, 2021

Thread Author Time
Re: Issue in PG start [email protected] 02:19
Re: Issue in PG start [email protected] 02:32
Re: Issue in PG start Ron 03:35
Re: Issue in PG start Adrian Klaver 16:43
Setting wal_keep_segments parameter rob stan 21:20
Re: Setting wal_keep_segments parameter Tom Lane 22:23
Re: Postgres upgrade 12 - issues with OIDs Venkata B Nagothi 23:26

May 10, 2021

Thread Author Time
Re: Issue in PG start Laurenz Albe 05:51
Copyright vs Licence Vijaykumar Jain 09:34
Re: Copyright vs Licence Ron 10:08
force partition pruning Niels Jespersen 11:39
Re: Copyright vs Licence cen 11:44
Re: force partition pruning Vijaykumar Jain 12:47
Re: Copyright vs Licence Michael Nolan 16:08
Re: trigger impacting insertion of records Michael Lewis 19:16
Postgresql 13 query engine regression Jonathan Chen 21:13
Re: Postgresql 13 query engine regression Adrian Klaver 21:47
Re: Postgresql 13 query engine regression Marc Millas 22:25
Re: Postgresql 13 query engine regression Tom Lane 22:34
Re: Postgresql 13 query engine regression Jonathan Chen 22:55
Re: Postgresql 13 query engine regression Jonathan Chen 23:21
Re: Postgresql 13 query engine regression Jonathan Chen 23:33

May 11, 2021

Thread Author Time
Re: Postgresql 13 query engine regression David Rowley 00:49
Re: Postgresql 13 query engine regression Jonathan Chen 01:22
Re: force partition pruning Vijaykumar Jain 11:51
SV: force partition pruning Niels Jespersen 12:14
Sequence gaps after restart Christopher Sumner 15:54
Re: Sequence gaps after restart Magnus Hagander 16:01
Re: Sequence gaps after restart Rob Sargent 16:07
Re: Sequence gaps after restart Tom Lane 16:15
Re: force partition pruning Vijaykumar Jain 17:12
Re: force partition pruning Vijaykumar Jain 17:29
Re: force partition pruning Vijaykumar Jain 18:33
ERROR: no known snapshots reg_pg_stefanz 21:01
Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Dhanisha 22:42

May 12, 2021

Thread Author Time
Re: force partition pruning David Rowley 00:34
SV: force partition pruning Niels Jespersen 02:46
Re: ERROR: no known snapshots Tom Lane 03:42
Re: force partition pruning Vijaykumar Jain 05:19
Re: ERROR: no known snapshots reg_pg_stefanz 11:25
Re: ERROR: no known snapshots Tom Lane 13:39
Postgresql fdw tracing Vijaykumar Jain 20:44

May 13, 2021

Thread Author Time
Query on postgres_fdw extension Swathi P 10:46
Re: Query on postgres_fdw extension Bharath Rupireddy 12:04
Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Devrim Gündüz 15:49
Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1 Dhanisha 18:25

May 14, 2021

Thread Author Time
Question about integer out of range in function Condor 06:38
Re: Query on postgres_fdw extension Swathi P 07:07