[go: up one dir, main page]

pgsql-general since 2023-01-20 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. 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
Re: Best Open Source OS for Postgresql Marc Millas 15:54
Re: A Small psql Suggestion hubert depesz lubaczewski 16:04
Re: Best Open Source OS for Postgresql Jeffrey Walton 16:05
Re: Best Open Source OS for Postgresql Adrian Klaver 16:25
New to PostgreSQL - looking for query writing tools Troy Sherven 16:43
Re: New to PostgreSQL - looking for query writing tools Robin Tang 17:00
Re: Best Open Source OS for Postgresql Bob Jolliffe 17:22
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 18:15
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 18:26
VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Dimitrios Apostolou 18:27
Re: Sequence vs UUID veem v 18:34
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) David G. Johnston 18:45
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Christophe Pettus 18:47
Re: Sequence vs UUID Kirk Wolak 18:47
Re: Best Open Source OS for Postgresql Adrian Klaver 18:53
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Tom Lane 18:56
"SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Ron 20:00
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Rodrigo Luna 20:06
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? David G. Johnston 20:06
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Tom Lane 20:10
Re: FATAL: database "xxx" does not exist when it does Siddharth Jain 20:13
Re: FATAL: database "xxx" does not exist when it does Rodrigo Luna 20:15
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? David G. Johnston 20:18
Re: FATAL: database "xxx" does not exist when it does Rodrigo Luna 20:19
Re: FATAL: database "xxx" does not exist when it does Tom Lane 20:45

Feb. 2, 2023

Thread Author Time
Re: pgBackrest Error : authentication method 10 not supported Daulat 06:45
How to write a new tuple into page? jacktby@gmail.com 06:57
Re: New to PostgreSQL - looking for query writing tools Giovanni Biscontini 07:34
Re-2: New to PostgreSQL - looking for query writing tools Sacha Kerres 07:51
Re: Re-2: New to PostgreSQL - looking for query writing tools Brent Wood 08:08
Re: Re-2: New to PostgreSQL - looking for query writing tools Jiten Kumar Shah 08:50
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 09:27
Re: Re-2: New to PostgreSQL - looking for query writing tools AR 11:27
Re: pgBackrest Error : authentication method 10 not supported Daulat 11:37
From Clause Conditional Zahir Lalani 12:54
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 14:59
Re: Sequence vs UUID Miles Elam 15:16
Re: Sequence vs UUID Benedict Holland 15:22
Re: From Clause Conditional Erik Wienhold 15:28
Re: From Clause Conditional Tom Lane 15:29
Re: Sequence vs UUID veem v 19:47
Re: Logical Replication - "invalid ordering of speculative insertion changes" Joe Wildish 20:11
Re: Sequence vs UUID Peter J. Holzer 23:11
Re: Sequence vs UUID Ron 23:17
Re: Sequence vs UUID Benedict Holland 23:26

Feb. 3, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 00:41
Re: Sequence vs UUID Rob Sargent 02:07
Re: Support logical replication of DDLs Alvaro Herrera 10:21
Re: Support logical replication of DDLs 📎 Ajin Cherian 13:27
Re: Sequence vs UUID Miles Elam 15:35
Fwd: Sequence vs UUID Dominique Devienne 15:58
Re: Sequence vs UUID veem v 16:47
Re: Sequence vs UUID Dominique Devienne 17:36

Feb. 4, 2023

Thread Author Time
Switching identity column to serial Erik Wienhold 00:54
Re: Switching identity column to serial Erik Wienhold 01:05
Re: Switching identity column to serial Ron 04:41
Re: Switching identity column to serial Ron 04:42
Re: Switching identity column to serial Erik Wienhold 20:55

Feb. 5, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 20:49

Browse Archives

Prev | Next