pgsql-general since 2023-02-15 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 15, 2023

Thread Author Time
Re: Order of rows in simple "select r from table_fn()" David G. Johnston 00:08
Re: Query plan for "id IS NULL" on PK David Rowley 00:21
Re: Quoting issue from ODBC Adrian Klaver 01:35
RE: Support logical replication of DDLs 📎 [email protected] 03:01
Re: Support logical replication of DDLs Peter Smith 04:00
Re: Query plan for "id IS NULL" on PK Tom Lane 04:11
Re: Support logical replication of DDLs Peter Smith 04:32
Re: Order of rows in simple "select r from table_fn()" Pavel Stehule 04:34
Re: Order of rows in simple "select r from table_fn()" Bryn Llewellyn 05:01
Re: Support logical replication of DDLs Amit Kapila 05:57
Re: Support logical replication of DDLs Amit Kapila 06:50
Re: Support logical replication of DDLs Alvaro Herrera 08:32
Re: Multi-column index: Which column order Laurenz Albe 08:46
Re: Support logical replication of DDLs Amit Kapila 09:51
unresolved external symbol when building on Windows King of Hearts 10:00
Re: unresolved external symbol when building on Windows Andy Y 11:01
Re: Query plan for "id IS NULL" on PK Ron 16:17
Re: Multi-column index: Which column order Ron 16:20
Re: Support logical replication of DDLs 📎 Zheng Li 22:16

Feb. 16, 2023

Thread Author Time
Re: Multi-column index: Which column order Laurenz Albe 03:45
Re: Support logical replication of DDLs Amit Kapila 04:00
Re: Multi-column index: Which column order Ron 04:08
Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 06:57
Re: Support logical replication of DDLs 📎 Ajin Cherian 07:54
Aggressive vacuum frequency on a table Simon Elbaz 09:58
Re: Multi-column index: Which column order Laurenz Albe 10:22
RE: Support logical replication of DDLs [email protected] 13:15
Vacuum full issue Rama Krishnan 13:18
DELETE trigger, direct or indirect? Dominique Devienne 13:23
Re: Automatic aggressive vacuum on almost frozen table takes too long Adrian Klaver 15:44
Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 15:47
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? David G. Johnston 16:07
Re: DELETE trigger, direct or indirect? Erik Wienhold 16:09
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? Ron 16:15
Re: DELETE trigger, direct or indirect? Adrian Klaver 16:46
Re: Support logical replication of DDLs Jonathan S. Katz 16:48
Re: DELETE trigger, direct or indirect? David G. Johnston 16:55
Re: DELETE trigger, direct or indirect? Adrian Klaver 16:59
Re: DELETE trigger, direct or indirect? Dominique Devienne 17:17
How to avoid Trigger ping/pong / infinite loop Dominique Devienne 17:43
Re: DELETE trigger, direct or indirect? Adrian Klaver 17:51
Re: Support logical replication of DDLs Alvaro Herrera 17:53
Re: How to avoid Trigger ping/pong / infinite loop Adrian Klaver 17:58
Re: Support logical replication of DDLs Alvaro Herrera 18:02
Re: How to avoid Trigger ping/pong / infinite loop Dominique Devienne 18:21
Re: DELETE trigger, direct or indirect? Dominique Devienne 18:28
Re: DELETE trigger, direct or indirect? Brad White 18:46
Re: Support logical replication of DDLs Jonathan S. Katz 19:01
Re: How to avoid Trigger ping/pong / infinite loop David G. Johnston 19:22
Re: Vacuum full issue David G. Johnston 19:28
Re: Vacuum full issue Adrian Klaver 19:29
Re: Support logical replication of DDLs Alvaro Herrera 19:38
Re: Automatic aggressive vacuum on almost frozen table takes too long Peter Geoghegan 19:41
Re: How to avoid Trigger ping/pong / infinite loop David Wheeler 19:42
Re: Support logical replication of DDLs Jonathan S. Katz 19:43
Re: DELETE trigger, direct or indirect? Adrian Klaver 19:45
Re: How to avoid Trigger ping/pong / infinite loop Adrian Klaver 19:55
Re: Support logical replication of DDLs Jonathan S. Katz 21:08
Re: How to avoid Trigger ping/pong / infinite loop Ken Tanzer 22:47

Feb. 17, 2023

Thread Author Time
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 01:23
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 01:40
Re: Support logical replication of DDLs Zheng Li 04:13
PostgreSQL configuration in a VM Sebastien Flaesch 08:13
Re: Support logical replication of DDLs Amit Kapila 09:15
Sv: PostgreSQL configuration in a VM Andreas Joseph Krogh 09:48
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 10:30
Re: Support logical replication of DDLs vignesh C 11:04
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? Marc Millas 13:23
Re: Query plan for "id IS NULL" on PK Ben Chrobot 14:20
Sequential scan faster than index Arthur Ramsey 16:18
Re: Automatic aggressive vacuum on almost frozen table takes too long Peter Geoghegan 21:34

Feb. 18, 2023

Thread Author Time
Hi All, Ryan MYJ 00:00
can't get psql authentication against Active Directory working Tomas Pospisek 14:02
Does Postgres 14 have a query cache? Siddharth Jain 14:46
Re: Does Postgres 14 have a query cache? David G. Johnston 14:54
Re: Does Postgres 14 have a query cache? Peter J. Holzer 14:59
Re: Does Postgres 14 have a query cache? Christophe Pettus 16:08
Re: can't get psql authentication against Active Directory working Erik Wienhold 16:16
Re: can't get psql authentication against Active Directory working Tomas Pospisek 16:32
Re: Does Postgres 14 have a query cache? Ron 18:43
Re: Does Postgres 14 have a query cache? Steven Lembark 18:45
Re: Does Postgres 14 have a query cache? Siddharth Jain 18:48
Re: Does Postgres 14 have a query cache? Tatsuo Ishii 23:16
Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Bryn Llewellyn 23:49

Feb. 19, 2023

Thread Author Time
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Julien Rouhaud 00:35
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Christophe Pettus 00:43
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Christophe Pettus 00:51
Re: Support logical replication of DDLs Jonathan S. Katz 02:20
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? David G. Johnston 02:50
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Ian Lawrence Barwick 02:52
Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Christophe Pettus 02:54
RE: Support logical replication of DDLs 📎 [email protected] 14:54
RE: Support logical replication of DDLs [email protected] 14:55
A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Kirk Wolak 19:43
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Tom Lane 21:18
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 David Rowley 23:26

Feb. 20, 2023

Thread Author Time
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Tom Lane 00:17
Need Detailed to build real time CDC Data Pipeline Puja Anil AJMERA 04:12
Re: Support logical replication of DDLs Amit Kapila 04:14
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Pavel Stehule 04:54
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 05:29
Re: Support logical replication of DDLs Masahiko Sawada 08:22
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 David Rowley 09:09
Re: can't get psql authentication against Active Directory working Stephen Frost 14:17
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Tom Lane 14:58
Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 Kirk Wolak 15:49
pg_reload_conf() Marc Millas 16:57
Re: pg_reload_conf() Adrian Klaver 17:01
Re: pg_reload_conf() David G. Johnston 17:21
pg_dump'ed file contains "DROP DATABASE" pf 18:27
Re: pg_dump'ed file contains "DROP DATABASE" Tom Lane 18:35
Re: pg_dump'ed file contains "DROP DATABASE" Adrian Klaver 19:06
Re: pg_dump'ed file contains "DROP DATABASE" pf 19:36
Is Autovacuum running? Brad White 19:42
Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Bryn Llewellyn 19:57
Re: pg_dump'ed file contains "DROP DATABASE" Adrian Klaver 19:59
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Christophe Pettus 20:05
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? David G. Johnston 20:10
Re: pg_reload_conf() Marc Millas 20:36
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Bryn Llewellyn 20:50
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Daniel Verite 21:01
Re: pg_dump'ed file contains "DROP DATABASE" Adrian Klaver 23:24
Re: Support logical replication of DDLs Jonathan S. Katz 23:44

Feb. 21, 2023

Thread Author Time
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Bryn Llewellyn 01:54
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Christophe Pettus 02:00
Re: Support logical replication of DDLs Zheng Li 02:09
Please upload patroni 3.0.1 package to postgresql repo SUN YI 02:17
Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Bryn Llewellyn 02:18
Re: pg_dump'ed file contains "DROP DATABASE" pf 03:22
Re: pg_dump'ed file contains "DROP DATABASE" Adrian Klaver 05:29
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 05:43
Re: Automatic aggressive vacuum on almost frozen table takes too long Peter Geoghegan 05:50
Re: Sequential scan faster than index Luca Ferrari 10:41
Re: Sequential scan faster than index David Rowley 11:06
Aw: Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? Karsten Hilbert 11:26
[No subject] Alberto García Fumero 12:44
Re: Carsten Klein 12:57
Re: can't get psql authentication against Active Directory working Tomas Pospisek 14:38
Re: Hi All, Tom Lane 14:51
Re: can't get psql authentication against Active Directory working Stephen Frost 15:29
Re: Is Autovacuum running? Brad White 17:54
Re: Is Autovacuum running? Christophe Pettus 17:57
Re: Is Autovacuum running? Brad White 18:48
transaction_isolation vs. default_transaction_isolation Bryn Llewellyn 19:31
Re: Is Autovacuum running? Christophe Pettus 19:45
Re: transaction_isolation vs. default_transaction_isolation David G. Johnston 20:45
Re: Is Autovacuum running? David Rowley 20:56
Debugging postgres on Windows - could not open directory "/lib" Cathy Xie 22:12
Re: Is Autovacuum running? Brad White 22:28
Re: Debugging postgres on Windows - could not open directory "/lib" Adrian Klaver 22:54
Re: Is Autovacuum running? David Rowley 23:17

Feb. 22, 2023

Thread Author Time
Re: transaction_isolation vs. default_transaction_isolation Bryn Llewellyn 00:06
RLS without leakproof restrictions? Tom Dunstan 00:57
Re: Debugging postgres on Windows - could not open directory "/lib" Cathy Xie 01:18
Re: RLS without leakproof restrictions? Martin L. Buchanan 02:41
Re: RLS without leakproof restrictions? Tom Dunstan 03:45
Re: RLS without leakproof restrictions? Tom Lane 03:46
Re: RLS without leakproof restrictions? Tom Dunstan 04:12
Event Triggers unable to capture the DDL script executed Neethu P 07:57
PostgreSQL optimizations for CoW FS HECTOR INGERTO 09:41
Re: Event Triggers unable to capture the DDL script executed Laurenz Albe 09:51
RE: Event Triggers unable to capture the DDL script executed n.kobzarev 10:03
Memory leak using when using libpq PQExecParams() CRYPTO_zalloc() Michael Arnold 13:35
Re: Memory leak using when using libpq PQExecParams() CRYPTO_zalloc() Jeffrey Walton 15:13
Re: Debugging postgres on Windows - could not open directory "/lib" Adrian Klaver 17:21
Re: Support logical replication of DDLs 📎 Zheng Li 23:01

Feb. 23, 2023

Thread Author Time
Re: Event Triggers unable to capture the DDL script executed Neethu P 04:10
Re: Event Triggers unable to capture the DDL script executed Laurenz Albe 10:50
Re: Event Triggers unable to capture the DDL script executed Neethu P 11:33
Re: Support logical replication of DDLs 📎 Ajin Cherian 11:42
Re: RLS without leakproof restrictions? Stephen Frost 16:47

Feb. 24, 2023

Thread Author Time
Re: Debugging postgres on Windows - could not open directory "/lib" Cathy Xie 01:16
Re: Support logical replication of DDLs Masahiko Sawada 08:42
Re: can't get psql authentication against Active Directory working Tomas Pospisek 14:21
Re: PostgreSQL optimizations for CoW FS Peter Eisentraut 16:13
Re: Debugging postgres on Windows - could not open directory "/lib" Adrian Klaver 16:59
curiosity in default column header Rob Sargent 20:47
Re: curiosity in default column header David G. Johnston 21:11
Re: can't get psql authentication against Active Directory working Stephen Frost 23:52

Feb. 25, 2023

Thread Author Time
IS as a binary operator david wheeler 10:38
Re: IS as a binary operator Tom Lane 16:54

Feb. 26, 2023

Thread Author Time
Give me details of some attributes!! [email protected] 14:29
Comparing Postgres logical replication to MySQL Siddharth Jain 20:28
Re: Give me details of some attributes!! Laurenz Albe 20:45

Feb. 27, 2023

Thread Author Time
Re: Event Triggers unable to capture the DDL script executed Neethu P 03:52
ERROR: unsupported Unicode escape sequence - in JSON-type column Jan Bilek 06:28
Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 07:26
Re: Interval in hours but not in days Leap second not taken into account Laurenz Albe 08:23
Re: Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 08:50
Re: Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 10:28
Repear operations on 50 tables of the same schema? celati Laurent 11:53
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Laurenz Albe 12:13
Re: Event Triggers unable to capture the DDL script executed Laurenz Albe 12:14
Re: Repear operations on 50 tables of the same schema? Ron 14:31
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Erik Wienhold 15:17
pg_upgradecluster transfering only a portion of the data Dávid Suchan 15:44
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Tom Lane 16:12
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:14
Re: pg_upgradecluster transfering only a portion of the data Tom Lane 16:36
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:46

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28