[go: up one dir, main page]

pgsql-general since 2023-01-11 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 23 24 25 26 27 28 29 30 31

Jan. 11, 2023

Thread Author Time
Re: Use case for enabling log_duration other than benchmarking Julien Rouhaud 05:02
Re: Best opensource Postgresql monitoring tool Vikas Sharma 08:43
Re: PITR and instance without any activity Adrien Nayrat 10:26
Re: Disallow execution of shell commands from psql hubert depesz lubaczewski 12:54
Autovacuum Hung Due to Bufferpin Fred Habash 13:59
Re: Autovacuum Hung Due to Bufferpin Tom Lane 15:32
Re: Autovacuum Hung Due to Bufferpin Fred Habash 17:46
Disabling triggers on tables dumped with pg_extension_config_dump() Michel Pelletier 19:40
Changing displayed time zone in RAISE NOTICE output? Ron 21:00
Re: Changing displayed time zone in RAISE NOTICE output? Adrian Klaver 21:06
Re: Autovacuum Hung Due to Bufferpin Tom Lane 21:07

Jan. 12, 2023

Thread Author Time
Re: Changing displayed time zone in RAISE NOTICE output? Ron 05:25
EXPLAIN and FK references? Ron 05:42
Re: EXPLAIN and FK references? Tom Lane 06:07
Re: EXPLAIN and FK references? Christophe Pettus 06:13
Re: EXPLAIN and FK references? Julien Rouhaud 06:42
Re: EXPLAIN and FK references? Ron 07:03
Re: EXPLAIN and FK references? Tom Lane 07:11
Re: EXPLAIN and FK references? Ron 07:33
Re: EXPLAIN and FK references? Julien Rouhaud 07:39
Intervals and ISO 8601 duration Sebastien Flaesch 13:40
default icu locale for new databases (PG15) Robert Sjöblom 14:56
Re: Intervals and ISO 8601 duration Tom Lane 15:08
Re: default icu locale for new databases (PG15) Laurenz Albe 15:38
Re: Changing displayed time zone in RAISE NOTICE output? Adrian Klaver 15:38
Re: Changing displayed time zone in RAISE NOTICE output? Pavel Stehule 16:22
Why is a hash join preferred when it does not fit in work_mem Dimitrios Apostolou 16:24
Re: Changing displayed time zone in RAISE NOTICE output? Adrian Klaver 16:27
Re: Changing displayed time zone in RAISE NOTICE output? Pavel Stehule 16:29
AW: [Extern] Re: postgres restore & needed history files Zwettler Markus (OIZ) 16:50
Re: AW: [Extern] Re: postgres restore & needed history files Ron 17:12
gexec from command prompt? Ron 17:25
Re: gexec from command prompt? Pavel Stehule 17:33
Re: gexec from command prompt? Alvaro Herrera 18:04
Re: gexec from command prompt? David G. Johnston 18:41

Jan. 13, 2023

Thread Author Time
Re: Why is a hash join preferred when it does not fit in work_mem David Rowley 01:38
Re: Support logical replication of DDLs 📎 vignesh C 06:33
Re: AW: [Extern] Re: postgres restore & needed history files Laurenz Albe 10:25
AW: AW: [Extern] Re: postgres restore & needed history files Zwettler Markus (OIZ) 11:23
Re: Why is a hash join preferred when it does not fit in work_mem Dimitrios Apostolou 12:49
row estimate for partial index Harmen 15:01
Directly embedding a psql SET variable inside another string? Ron 16:12
Re: Directly embedding a psql SET variable inside another string? Adam Scott 17:08
Re: Directly embedding a psql SET variable inside another string? David G. Johnston 17:13
Re: Directly embedding a psql SET variable inside another string? Adrian Klaver 17:13
Re: Directly embedding a psql SET variable inside another string? David G. Johnston 17:14
Re: Directly embedding a psql SET variable inside another string? Ron 18:07
Re: Intervals and ISO 8601 duration Ken Tanzer 22:17
Re: Intervals and ISO 8601 duration Adrian Klaver 22:41
Re: Intervals and ISO 8601 duration Ken Tanzer 22:47
Re: Intervals and ISO 8601 duration David G. Johnston 22:49
Re: Intervals and ISO 8601 duration Ken Tanzer 22:51
Re: Intervals and ISO 8601 duration Adrian Klaver 23:03
Re: Intervals and ISO 8601 duration Ken Tanzer 23:32
Re: Intervals and ISO 8601 duration Adrian Klaver 23:44
Re: Intervals and ISO 8601 duration Adrian Klaver 23:57

Jan. 14, 2023

Thread Author Time
Re: Intervals and ISO 8601 duration Adrian Klaver 00:02
Re: Intervals and ISO 8601 duration Bryn Llewellyn 00:03
Re: Intervals and ISO 8601 duration Martin L. Buchanan 00:07
Re: Intervals and ISO 8601 duration Adrian Klaver 00:08
Re: Intervals and ISO 8601 duration Ken Tanzer 00:28
Re: Intervals and ISO 8601 duration Tom Lane 00:57
Re: Intervals and ISO 8601 duration Ken Tanzer 01:24
Re: Intervals and ISO 8601 duration Tatsuo Ishii 02:16
synchronized standby: committed local and waiting for remote ack qihua wu 03:16
Re: Intervals and ISO 8601 duration Tom Lane 05:20
Re: Intervals and ISO 8601 duration Adrian Klaver 05:27
Re: synchronized standby: committed local and waiting for remote ack Tom Lane 05:31
Re: Intervals and ISO 8601 duration Peter J. Holzer 05:32
Dump (was: Intervals and ISO 8601 duration) Peter J. Holzer 05:50
Re: Intervals and ISO 8601 duration Pavel Stehule 06:01
does refreshing materialized view make the database bloat? jian he 06:04
Re: Intervals and ISO 8601 duration Ken Tanzer 06:17
Re: does refreshing materialized view make the database bloat? David G. Johnston 06:19
Re: does refreshing materialized view make the database bloat? Peter J. Holzer 08:51
Re: Why is a hash join preferred when it does not fit in work_mem Tom Lane 16:17
Re: row estimate for partial index Tom Lane 16:23
SQL question hamann.w 16:32

Jan. 15, 2023

Thread Author Time
Re: Support logical replication of DDLs Ajin Cherian 04:09
Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 15:47
pg_upgrade 13.6 to 15.1? pf 19:27
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Magnus Hagander 19:36
Re: pg_upgrade 13.6 to 15.1? Tom Lane 19:47
Re: pg_upgrade 13.6 to 15.1? Adrian Klaver 20:23
Re: pg_upgrade 13.6 to 15.1? pf 20:39
Re: pg_upgrade 13.6 to 15.1? pf 20:41
Re: pg_upgrade 13.6 to 15.1? Tom Lane 20:59
Re: pg_upgrade 13.6 to 15.1? Adrian Klaver 21:00
Re: pg_upgrade 13.6 to 15.1? Tom Lane 21:07
Re: pg_upgrade 13.6 to 15.1? pf 21:27
Re: pg_upgrade 13.6 to 15.1? pf 21:38
RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 21:57
Re: pg_upgrade 13.6 to 15.1? pf 21:59
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Magnus Hagander 22:07
Re: pg_upgrade 13.6 to 15.1? Alan Hodgson 22:15
Re: pg_upgrade 13.6 to 15.1? Gavan Schneider 22:16
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Ron 22:26
Re: pg_upgrade 13.6 to 15.1? Tom Lane 22:37
Re: pg_upgrade 13.6 to 15.1? [Solved: what can go wrong, will...] pf 22:56

Jan. 16, 2023

Thread Author Time
Re: Support logical replication of DDLs vignesh C 03:12
Re: does refreshing materialized view make the database bloat? jian he 04:52
Re: does refreshing materialized view make the database bloat? David G. Johnston 04:58
Re: does refreshing materialized view make the database bloat? jian he 05:29
Re: does refreshing materialized view make the database bloat? David G. Johnston 05:43
glibc initdb options vs icu compatibility questions (PG15) Robert Sjöblom 08:30
RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 08:41
Re: row estimate for partial index Harmen 08:55
Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Fred Habash 12:48
Re: Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Laurenz Albe 13:11
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? Laurenz Albe 13:21
Re: glibc initdb options vs icu compatibility questions (PG15) Laurenz Albe 13:26
Re: AW: AW: [Extern] Re: postgres restore & needed history files Laurenz Albe 13:30
Re: Support logical replication of DDLs 📎 Ajin Cherian 13:33
Re: Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Erik Wienhold 14:32
RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? HECTOR INGERTO 14:37
Re: row estimate for partial index Tom Lane 14:59
Re: glibc initdb options vs icu compatibility questions (PG15) Joe Conway 15:47
No function matches the given name and argument types. arons 16:04
Re: No function matches the given name and argument types. Adrian Klaver 16:17
Re: No function matches the given name and argument types. Adrian Klaver 16:21
Re: No function matches the given name and argument types. arons 17:41
Re: No function matches the given name and argument types. Pavel Stehule 17:49
Re: No function matches the given name and argument types. David G. Johnston 17:53
Re: No function matches the given name and argument types. Christophe Pettus 17:57
minor bug Torsten Förtsch 18:59
Re: Why is a hash join preferred when it does not fit in work_mem Dimitrios Apostolou 19:05
Re: Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Ron 21:18
Re: Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Rob Sargent 21:46
Re: Why is a Read-only Table Gets Autovacuumed "to prevent wraparound" Ron 23:13

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

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 23 24 25 26 27 28 29 30 31