[go: up one dir, main page]

pgsql-general - January 2023

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

Jan. 1, 2023

Thread Author Time
PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 20:51
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Adrian Klaver 21:00
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 21:11
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Adrian Klaver 21:48
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Rob Sargent 21:50

Jan. 2, 2023

Thread Author Time
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 06:08
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Tom Lane 06:19
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Ahmet Demir 06:29
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 06:34
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 06:53
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Matthias Apitz 07:46
Re: Support logical replication of DDLs vignesh C 08:06
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Antonis Christodoulou 08:37
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours 📎 Ebubekir Büyüktosun 08:54
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Matthias Apitz 09:35
Re: Exact same output - pg_stat_statements hubert depesz lubaczewski 13:34
what kind of hash algorithm is used by hash_bytes()? jacktby@gmail.com 16:30
Re: what kind of hash algorithm is used by hash_bytes()? Adrian Klaver 17:13

Jan. 3, 2023

Thread Author Time
Re: what kind of hash algorithm is used by hash_bytes()? Julien Rouhaud 01:41
Re: Exact same output - pg_stat_statements Julien Rouhaud 05:52
Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Julien Rouhaud 05:58
postgres restore & needed history files Zwettler Markus (OIZ) 16:03
Re: REINDEX vs VACUUM Hao Zhang 17:57

Jan. 4, 2023

Thread Author Time
Re: REINDEX vs VACUUM Rébeli-Szabó Tamás 13:25
What is the best setup for distributed and fault-tolerant PG database? Age Apache 13:26
Re: REINDEX vs VACUUM Ron 15:34
curious postgres (crash) recovery behavior Zwettler Markus (OIZ) 16:54
Re: REINDEX vs VACUUM Rébeli-Szabó Tamás 21:00
Corrupt WAL in replication slot Fontana Daniel (Desartec S.R.L.) 21:24
Re: Support logical replication of DDLs 📎 Zheng Li 21:35
Re: curious postgres (crash) recovery behavior Rébeli-Szabó Tamás 21:52
Re: What is the best setup for distributed and fault-tolerant PG database? Rob Sargent 23:54

Jan. 5, 2023

Thread Author Time
Re: What is the best setup for distributed and fault-tolerant PG database? Saul Perdomo 03:34
Re: What is the best setup for distributed and fault-tolerant PG database? Bryn Llewellyn 04:28
Re: REINDEX vs VACUUM Brad White 08:51
Re: REINDEX vs VACUUM Peter J. Holzer 10:26
Aw: Re: REINDEX vs VACUUM Karsten Hilbert 11:34
Re: REINDEX vs VACUUM Peter J. Holzer 12:15
PG replicas and transactions atomicity Louis Laborde 20:07
Re: PG replicas and transactions atomicity Christophe Pettus 20:09

Jan. 6, 2023

Thread Author Time
Re: PG replicas and transactions atomicity Ron 00:03
Re: PG replicas and transactions atomicity Christophe Pettus 00:04
Re: PG replicas and transactions atomicity Christophe Pettus 03:46
Re: postgres restore & needed history files Laurenz Albe 05:28
Re: postgres restore & needed history files Christophe Pettus 05:34
Re: best practice to patch a postgresql version? Laurenz Albe 05:43
Re: Purging few months old data and vacuuming in production Ranjith Paliyath 08:44
Re: best practice to patch a postgresql version? Ron 10:21
Re: Purging few months old data and vacuuming in production Ron 10:30
Re: Purging few months old data and vacuuming in production Ranjith Paliyath 14:27
Re: Purging few months old data and vacuuming in production Ron 14:57
Re: Updating column default values in code Brad White 23:31

Jan. 7, 2023

Thread Author Time
Re: Updating column default values in code Ken Tanzer 01:44
Re: Regd. the Implementation of Wallet (in Oracle) config equivalent in postgreSQL whilst the database migration Bruce Momjian 03:26
Re: Updating column default values in code Brad White 04:14
Re: Updating column default values in code Tom Lane 05:13
RE: Purging few months old data and vacuuming in production Ranjith Paliyath 05:33
Re: Purging few months old data and vacuuming in production Peter J. Holzer 11:29
Re: Purging few months old data and vacuuming in production Ron 13:40
Re: Support logical replication of DDLs 📎 Zheng Li 15:28
Re: Purging few months old data and vacuuming in production Peter J. Holzer 17:23
Re: Purging few months old data and vacuuming in production Николай Кобзарев 17:38
impact join syntax ?? and gist index ?? Marc Millas 19:46
Re: impact join syntax ?? and gist index ?? Marc Millas 19:55
Re: impact join syntax ?? and gist index ?? Marc Millas 20:38
Re: impact join syntax ?? and gist index ?? Erik Wienhold 20:40
Re: impact join syntax ?? and gist index ?? Marc Millas 20:57
Re: impact join syntax ?? and gist index ?? Tom Lane 21:32
Re: impact join syntax ?? and gist index ?? Marc Millas 21:47
Re: impact join syntax ?? and gist index ?? Tom Lane 22:07

Jan. 9, 2023

Thread Author Time
Re: PITR and instance without any activity Adrien Nayrat 09:58
Re: Exact same output - pg_stat_statements hubert depesz lubaczewski 10:15
Re: PITR and instance without any activity Torsten Förtsch 10:23
How do the Linux distributions create the Linux user/group "postgres"? Matthias Apitz 12:41
Re: How do the Linux distributions create the Linux user/group "postgres"? Thomas Guyot 13:11
Re: How do the Linux distributions create the Linux user/group "postgres"? Joe Conway 13:15
Re: How do the Linux distributions create the Linux user/group "postgres"? Erik Wienhold 13:18
Re: How do the Linux distributions create the Linux user/group "postgres"? Matthias Apitz 13:27
Re: How do the Linux distributions create the Linux user/group "postgres"? Ron 14:11
Re: How do the Linux distributions create the Linux user/group "postgres"? Joe Conway 15:57

Jan. 10, 2023

Thread Author Time
pg_multixact_member file limits Martin Ritchie 04:51
Re: Segmentation fault on RelationGetDescr in my first extension Kyotaro Horiguchi 06:01
Use case for enabling log_duration other than benchmarking Alicja Kucharczyk 13:14
Re: pg_multixact_member file limits Ron 13:53
Re: Use case for enabling log_duration other than benchmarking Ron 13:57
Best opensource Postgresql monitoring tool Vikas Sharma 14:29
Re: Use case for enabling log_duration other than benchmarking Alicja Kucharczyk 15:57
Re: Use case for enabling log_duration other than benchmarking Ron 16:28
Disallow execution of shell commands from psql Wiwwo Staff 18:01

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

Browse Archives

Prev | Next