[go: up one dir, main page]

pgsql-general since 2023-01-17 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)
Advanced Search

Browse Archives

Prev | Next

Jan. 17, 2023

Thread Author Time
Re: synchronized standby: committed local and waiting for remote ack qihua wu 03:06
pg_stat_all_tables: n_live_tup column value not persisting pran d 06:15
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Alban Hertroys 08:05
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Magnus Hagander 08:19
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Laurenz Albe 08:26
Re: minor bug 📎 Laurenz Albe 09:42
Re: minor bug Michael Paquier 10:12
Tablespace OID, database OID, relfilenode Wiwwo Staff 14:48
Re: Tablespace OID, database OID, relfilenode Laurenz Albe 15:01
RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 15:22
Re: minor bug Tom Lane 15:32
Re: Tablespace OID, database OID, relfilenode Wiwwo Staff 15:35
Re: Tablespace OID, database OID, relfilenode David G. Johnston 15:43
Re: Tablespace OID, database OID, relfilenode Adrian Klaver 15:44
Re: https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated. Alvaro Herrera 18:05
Re: Tablespace OID, database OID, relfilenode Wiwwo Staff 19:49
Maintaining blank lines in psql output? Ron 20:48
Re: Maintaining blank lines in psql output? David G. Johnston 21:22
Re: Use case for enabling log_duration other than benchmarking Bruce Momjian 21:26
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Bruce Momjian 21:38
Re: pg_upgrade 13.6 to 15.1? Bruce Momjian 21:41
Re: Maintaining blank lines in psql output? raf 23:06
Re: Maintaining blank lines in psql output? David G. Johnston 23:10
Re: Maintaining blank lines in psql output? raf 23:21

Jan. 18, 2023

Thread Author Time
Re: Maintaining blank lines in psql output? Ron 00:22
Re: Tablespace OID, database OID, relfilenode Adrian Klaver 05:27
Re: minor bug 📎 Laurenz Albe 08:27
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Laurenz Albe 10:02
Re: Support logical replication of DDLs Amit Kapila 11:26
RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 16:38
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Rob Sargent 16:54
Interpreting postgres execution plan along with AND/OR precedence Dirschel, Steve 17:03
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Ron 17:26
Re: Interpreting postgres execution plan along with AND/OR precedence Tom Lane 17:56
Re: Interpreting postgres execution plan along with AND/OR precedence Erik Wienhold 18:14
Re: Interpreting postgres execution plan along with AND/OR precedence Erik Wienhold 18:21
Tools for moving normalized data around Peter 19:47
Re: Tools for moving normalized data around Jeremy Smith 20:02
Re: minor bug 📎 Tom Lane 20:03
Re: Tools for moving normalized data around Gavan Schneider 20:15
Re: Tools for moving normalized data around Dominique Devienne 20:19
Re: Tools for moving normalized data around Rob Sargent 20:45
Database size different on Primary and Standby? Hilbert, Karin 23:09
Re: Database size different on Primary and Standby? Erik Wienhold 23:50

Jan. 19, 2023

Thread Author Time
Re: Database size different on Primary and Standby? Ian Lawrence Barwick 00:23
Re: Database size different on Primary and Standby? Erik Wienhold 00:47
Re: Database size different on Primary and Standby? Tom Lane 01:09
Re: Database size different on Primary and Standby? Ron 02:13
Re: Support logical replication of DDLs Zheng Li 03:09
Re: Support logical replication of DDLs Amit Kapila 07:05
Re: Support logical replication of DDLs 📎 vignesh C 08:51
Re: row estimate for partial index Harmen 09:04
Re: minor bug Laurenz Albe 12:57
Re: minor bug Torsten Förtsch 17:18
Re: minor bug Tom Lane 17:25
Re: minor bug Tom Lane 17:29
Re: Support logical replication of DDLs Zheng Li 17:54
Documentation discrepancy UNIQUE NULLS NOT DISTINCT Adrian Klaver 22:41
Re: Documentation discrepancy UNIQUE NULLS NOT DISTINCT David G. Johnston 22:51

Jan. 20, 2023

Thread Author Time
***Conflict with recovery error*** Abhishek Prakash 08:56
Re: ***Conflict with recovery error*** Laurenz Albe 09:55
RE: ***Conflict with recovery error*** Abhishek Prakash 09:59
Re: ***Conflict with recovery error*** Laurenz Albe 10:08
Re: Why is a hash join preferred when it does not fit in work_mem Dimitrios Apostolou 20:01

Jan. 21, 2023

Thread Author Time
Re: Autovacuum on sys tables Marc 15:58
Re: Autovacuum on sys tables Adrian Klaver 16:15

Jan. 23, 2023

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 08:46

Jan. 24, 2023

Thread Author Time
Re: Support logical replication of DDLs Zheng Li 03:27
Is a logical replication crash recovery safe? Zwettler Markus (OIZ) 15:37
Re: Is a logical replication crash recovery safe? Christophe Pettus 15:47
AW: [Extern] Re: Is a logical replication crash recovery safe? Zwettler Markus (OIZ) 16:07
Link WAL record to session Sergey Burladyan 18:35
Re: Link WAL record to session kaido vaikla 19:30
Re: Link WAL record to session David G. Johnston 19:36
re: Link WAL record to session kaido vaikla 20:29

Jan. 25, 2023

Thread Author Time
pg_rewind and user / passfile Wiwwo Staff 09:37
Re: pg_rewind and user / passfile Wiwwo Staff 09:57
dynamic partition table inserts Ted Toth 13:38
Re: dynamic partition table inserts Николай Кобзарев 16:49
DBeaver session populating pg_stat_activity.backend_xmin Dirschel, Steve 19:36
Re: DBeaver session populating pg_stat_activity.backend_xmin Thomas Kellerer 19:56
RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin Dirschel, Steve 22:21
Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin Ron 22:34
Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin Christophe Pettus 22:49

Jan. 26, 2023

Thread Author Time
Sequence vs UUID veem v 19:17
Re: Sequence vs UUID Christophe Pettus 19:39
Re: Sequence vs UUID Merlin Moncure 21:36
Re: Sequence vs UUID Rob Sargent 21:50
Re: Sequence vs UUID Erik Wienhold 21:55
Re: Sequence vs UUID Benedict Holland 22:00
Re: Sequence vs UUID Merlin Moncure 22:42

Jan. 27, 2023

Thread Author Time
Re: Sequence vs UUID Ron 00:48
Re: Sequence vs UUID G Hasse 01:54
timestamptz, local time in the future, and Don't do it wiki Max Nikulin 12:12
PostgreSQL DBA training Matthias Apitz 12:44
Re: Sequence vs UUID Rob Sargent 14:55
Re: timestamptz, local time in the future, and Don't do it wiki Peter J. Holzer 18:03
Indexes mysteriously change to LOG Rumpi Gravenstein 20:23
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 20:24
Re: Indexes mysteriously change to LOG Adrian Klaver 20:34
Re: Indexes mysteriously change to LOG Rumpi Gravenstein 20:51
Re: Indexes mysteriously change to ON ONLY Tom Lane 20:53
nextval per counted Rob Sargent 20:59
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 21:01
Re: Indexes mysteriously change to ON ONLY Christophe Pettus 21:07
Re: Indexes mysteriously change to ON ONLY Tom Lane 21:16
Re: nextval per counted David G. Johnston 21:20
Re: nextval per counted Rob Sargent 21:25
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 21:30
Re: nextval per counted David G. Johnston 21:31
Re: nextval per counted Rob Sargent 21:41

Jan. 28, 2023

Thread Author Time
Re: Indexes mysteriously change to ON ONLY Ron 02:26
Why is this SELECT evaluated? Miles Elam 19:29
Re: Why is this SELECT evaluated? Erik Wienhold 20:34
Re: Sequence vs UUID Erik Wienhold 20:39
Re: Why is this SELECT evaluated? Christophe Pettus 20:55

Jan. 29, 2023

Thread Author Time
Re: Sequence vs UUID Benedict Holland 01:44
Re: Sequence vs UUID Ron 02:01
Re: Sequence vs UUID Miles Elam 03:28
Re: Sequence vs UUID Ron 04:02
Re: Sequence vs UUID Miles Elam 05:02

Jan. 30, 2023

Thread Author Time
How to control pg_catalog results for each users? hirose shigeo (廣瀬 繁雄 □SWC○ACT) 05:00
Re: How to control pg_catalog results for each users? David G. Johnston 05:23
Re: How to control pg_catalog results for each users? Tom Lane 05:48
Re: How to control pg_catalog results for each users? Laurenz Albe 08:41
Question on Logical Replication Venkata B Nagothi 08:53
Re: Postgres upgrade 12 - issues with OIDs Venkata B Nagothi 08:54
Does statement_timeout apply to commit? qihua wu 09:10
Re: Sequence vs UUID veem v 11:29
alter table impact on view Marc Millas 12:13
Re: alter table impact on view David Rowley 12:52
Re: How to control pg_catalog results for each users? Ron 13:18
Re: Does statement_timeout apply to commit? Laurenz Albe 13:19
Re: alter table impact on view Marc Millas 14:15
How could I elog the tupleTableSlot to the fronted terminal? jacktby@gmail.com 15:23
Re: Sequence vs UUID veem v 16:11
Re: Sequence vs UUID Dominique Devienne 16:37
Re: Sequence vs UUID Tom Lane 16:48
Re: How could I elog the tupleTableSlot to the fronted terminal? Alvaro Herrera 17:44
Re: Sequence vs UUID veem v 19:43
Re: Sequence vs UUID Adrian Klaver 19:46
Re: Sequence vs UUID Ron 21:58

Jan. 31, 2023

Thread Author Time
How is timeout implemented in postgresql? qihua wu 01:35
Re: How is timeout implemented in postgresql? David G. Johnston 01:50
any wait event for a commit in sync replication? qihua wu 07:35
Best Open Source OS for Postgresql Giovanni Biscontini 08:02
Re: any wait event for a commit in sync replication? qihua wu 08:22
Re: How to control pg_catalog results for each users? hirose shigeo (廣瀬 繁雄 □SWC○ACT) 09:31
Re: timestamptz, local time in the future, and Don't do it wiki Max Nikulin 11:32
Re: Best Open Source OS for Postgresql Surya Widyanto 11:59
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 12:06
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 12:23
Re: toast useless Marcos Pegoraro 12:34
Download file from COPY ... TO with pgadmin Marco Lechner 13:02
Re: Best Open Source OS for Postgresql Marc Millas 13:09
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 13:21
pgBackrest Error : authentication method 10 not supported Daulat 13:57
Re: Download file from COPY ... TO with pgadmin Erik Wienhold 13:58
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 14:02
AW: Download file from COPY ... TO with pgadmin Marco Lechner 14:17
Re: toast useless Laurenz Albe 15:03
SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:07
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:16
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 15:20
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Tom Lane 15:28
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:40
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Christophe Pettus 15:42
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 15:43
Re: Re: How could I elog the tupleTableSlot to the fronted terminal? jacktby@gmail.com 16:12
A Small psql Suggestion Raymond Brinzer 16:17
RE: [EXT] DBeaver session populating pg_stat_activity.backend_xmin Dirschel, Steve 16:29
Re: Download file from COPY ... TO with pgadmin Adrian Klaver 16:30
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 16:32
Re: Best Open Source OS for Postgresql Adrian Klaver 16:38
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Tom Lane 17:15
Logical Replication - "invalid ordering of speculative insertion changes" Joe Wildish 18:10

Feb. 1, 2023

Thread Author Time
How to create a new operator inpg for spec data type? jacktby@gmail.com 05:40
Re: Best Open Source OS for Postgresql Tony Shelver 06:19
Re: How to create a new operator inpg for spec data type? Erik Wienhold 06:37
Re: Best Open Source OS for Postgresql Brad White 06:39
Re: Best Open Source OS for Postgresql Brent Wood 06:45
invisible commit question for sync replication qihua wu 06:52
Re: invisible commit question for sync replication Julien Rouhaud 07:11
Re: invisible commit question for sync replication David G. Johnston 07:21
Re: invisible commit question for sync replication qihua wu 08:05
Re: How could I elog the tupleTableSlot to the fronted terminal? Kyotaro Horiguchi 08:20
Re: invisible commit question for sync replication Laurenz Albe 08:38
Re: invisible commit question for sync replication qihua wu 09:25
database postgres not found Matthias Apitz 10:33
38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric. jian he 10:36
Re: database postgres not found Erik Wienhold 11:54
moving a database to a new 15.1 server Matthias Apitz 12:24
Re: moving a database to a new 15.1 server Thomas Kellerer 12:35
Re: moving a database to a new 15.1 server Erik Wienhold 12:38
pg_rewind and replication user Wiwwo Staff 14:09
Re: pg_rewind and replication user Mateusz Henicz 14:37
Re: 38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric. Tom Lane 15:05
Re: Best Open Source OS for Postgresql Wim Bertels 15:21
Re: A Small psql Suggestion Matt Zagrabelny 15:25
Re: Best Open Source OS for Postgresql Marc Millas 15:39

Browse Archives

Prev | Next