pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedIs a VACUUM or ANALYZE necessary after logical replication?
2024-06-15 22:55 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Is a VACUUM or ANALYZE necessary after logical replication?
2024-06-15 23:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Is a VACUUM or ANALYZE necessary after logical replication?
2024-06-16 06:54 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: Is a VACUUM or ANALYZE necessary after logical replication?
2024-06-16 07:09 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
Design for dashboard query
2024-06-15 13:24 UTC sud <suds1434@gmail.com>
` Re: Design for dashboard query
2024-06-15 15:14 UTC Sushrut Shivaswamy <sushrut.shivaswamy@gmail.com>
` Re: Design for dashboard query
2024-06-15 20:09 UTC yudhi s <learnerdatabase99@gmail.com>
[3+ messages in thread]
pgstattuple - can it/does it provide stats by partition?
2024-06-15 12:40 UTC Dragam <dragam@protonmail.com>
` Re: pgstattuple - can it/does it provide stats by partition?
2024-06-15 17:04 UTC Ron Johnson <ronljohnsonjr@gmail.com>
[2+ messages in thread]
Reserving GUC prefixes from a non-preloaded DB extension is not always enforced
2024-06-13 19:26 UTC Narek Galstyan <narekg@berkeley.edu>
` Re: Reserving GUC prefixes from a non-preloaded DB extension is not always enforced
2024-06-13 19:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Reserving GUC prefixes from a non-preloaded DB extension is not always enforced
2024-06-14 07:44 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
Reset sequence to current maximum value of rows
2024-06-13 17:20 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 17:26 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 17:28 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 18:24 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 18:38 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 18:50 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 18:54 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 19:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 19:50 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 19:57 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 20:09 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 20:14 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Reset sequence to current maximum value of rows [RESOLVED]
2024-06-13 20:22 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 20:30 UTC Jeremy Smith <jeremy@musicsmith.net>
` Re: Reset sequence to current maximum value of rows
2024-06-13 21:13 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 22:01 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 22:13 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 22:24 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Reset sequence to current maximum value of rows
2024-06-13 22:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Reset sequence to current maximum value of rows
2024-06-14 07:08 UTC Alban Hertroys <haramrae@gmail.com>
[20+ messages in thread]
Question about UNIX socket connections and SSL
2024-06-12 15:34 UTC Casey & Gina <cg@osss.net>
` Re: Question about UNIX socket connections and SSL
2024-06-12 19:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about UNIX socket connections and SSL
2024-06-12 19:32 UTC Daniel Gustafsson <daniel@yesql.se>
` Re: Question about UNIX socket connections and SSL
2024-06-12 20:46 UTC Casey & Gina <cg@osss.net>
` Re: Question about UNIX socket connections and SSL
2024-06-13 11:47 UTC Daniel Gustafsson <daniel@yesql.se>
` Re: Question about UNIX socket connections and SSL
2024-06-13 20:18 UTC Casey & Gina <cg@osss.net>
[6+ messages in thread]
Questions on logical replication
2024-06-04 22:55 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-04 23:02 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-04 23:05 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Questions on logical replication
2024-06-05 21:54 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-05 22:19 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Questions on logical replication
2024-06-06 22:19 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-07 04:20 UTC Kashif Zeeshan <kashi.zeeshan@gmail.com>
` Re: Questions on logical replication
2024-06-07 15:15 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Questions on logical replication
2024-06-08 17:40 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-08 17:46 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Questions on logical replication
2024-06-08 20:33 UTC Justin <zzzzz.graf@gmail.com>
` Re: Questions on logical replication
2024-06-11 21:38 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-11 21:42 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-12 17:01 UTC Justin <zzzzz.graf@gmail.com>
` Re: Questions on logical replication
2024-06-13 10:01 UTC Koen De Groote <kdg.dev@gmail.com>
` Re: Questions on logical replication
2024-06-13 15:37 UTC Justin <zzzzz.graf@gmail.com>
[16+ messages in thread]
Oracle Linux 9 Detected RPMs with RSA/SHA1 signature
2024-06-12 09:54 UTC Hans Schou <hans.schou@gmail.com>
` Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature
2024-06-12 14:34 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature
2024-06-13 14:41 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[3+ messages in thread]
TOAST Table / Dead Tuples / Free Pages
2024-06-13 07:55 UTC Shenavai, Manuel <manuel.shenavai@sap.com>
` Re: TOAST Table / Dead Tuples / Free Pages
2024-06-13 08:08 UTC Kashif Zeeshan <kashi.zeeshan@gmail.com>
` Re: TOAST Table / Dead Tuples / Free Pages
2024-06-13 08:41 UTC Muhammad Ikram <mmikram@gmail.com>
` Re: TOAST Table / Dead Tuples / Free Pages
2024-06-13 14:38 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[4+ messages in thread]
Syntax on BEFORE Trigger - Cascade?
2024-06-13 14:11 UTC David Barbour <dbarbour@istation.com>
` Re: Syntax on BEFORE Trigger - Cascade?
2024-06-13 14:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Syntax on BEFORE Trigger - Cascade?
2024-06-13 14:25 UTC David G. Johnston <david.g.johnston@gmail.com>
[3+ messages in thread]
Definging columns for INSERT statements
2024-06-12 21:11 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Definging columns for INSERT statements
2024-06-12 22:12 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Definging columns for INSERT statements
2024-06-12 22:43 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Definging columns for INSERT statements
2024-06-12 23:05 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Definging columns for INSERT statements
2024-06-12 23:24 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Definging columns for INSERT statements
2024-06-12 23:38 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Definging columns for INSERT statements
2024-06-13 12:37 UTC Rich Shepard <rshepard@appl-ecosys.com>
[7+ messages in thread]
PG16.1 security breach?
2024-06-07 11:04 UTC Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
` Re: PG16.1 security breach?
2024-06-07 13:22 UTC Joe Conway <mail@joeconway.com>
` Re: PG16.1 security breach?
2024-06-07 14:16 UTC David G. Johnston <david.g.johnston@gmail.com>
` PG16.1 security breach?
2024-06-07 14:42 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: PG16.1 security breach?
2024-06-10 09:21 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: PG16.1 security breach?
2024-06-12 20:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: PG16.1 security breach?
2024-06-12 21:37 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: PG16.1 security breach?
2024-06-12 22:08 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: PG16.1 security breach?
2024-06-12 22:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PG16.1 security breach?
2024-06-12 23:07 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: PG16.1 security breach?
2024-06-13 11:59 UTC Joe Conway <mail@joeconway.com>
[11+ messages in thread]
UPDATE with multiple WHERE conditions
2024-06-12 21:28 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 21:31 UTC Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 21:34 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 21:48 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 22:05 UTC Rob Sargent <robjsargent@gmail.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 22:09 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 22:41 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 22:46 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-12 22:47 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: UPDATE with multiple WHERE conditions
2024-06-13 10:34 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
[10+ messages in thread]
Long running query causing XID limit breach
2024-05-22 21:16 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 03:29 UTC Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
` Re: Long running query causing XID limit breach
2024-05-23 04:48 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 05:12 UTC Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
` Re: Long running query causing XID limit breach
2024-05-23 06:11 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 06:25 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 06:51 UTC Muhammad Salahuddin Manzoor <salahuddin.m@bitnine.net>
` Re: Long running query causing XID limit breach
2024-05-23 07:19 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 07:52 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-05-23 08:11 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 08:15 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-05-23 12:45 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-23 14:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-05-24 05:04 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-25 20:54 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-25 20:59 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 05:56 UTC David HJ <chuxiongzhong@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 08:13 UTC Torsten Förtsch <tfoertsch123@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 09:15 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 15:00 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Long running query causing XID limit breach
2024-05-26 17:48 UTC Torsten Förtsch <tfoertsch123@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 18:46 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-26 19:25 UTC Torsten Förtsch <tfoertsch123@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-27 03:37 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-27 09:20 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-05-28 20:04 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Long running query causing XID limit breach
2024-05-29 08:08 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-06-05 06:25 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-06-05 07:08 UTC Simon Elbaz <elbazsimon9@gmail.com>
` Re: Long running query causing XID limit breach
2024-06-05 07:39 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-06-05 10:22 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Long running query causing XID limit breach
2024-06-05 19:21 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Long running query causing XID limit breach
2024-06-08 09:21 UTC sud <suds1434@gmail.com>
` Re: Long running query causing XID limit breach
2024-06-13 07:43 UTC yudhi s <learnerdatabase99@gmail.com>
[34+ messages in thread]
postgres table statistics
2024-06-12 07:47 UTC Chandy G <vgchandru@yahoo.com>
` Re: postgres table statistics
2024-06-12 08:27 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: postgres table statistics
2024-06-12 14:44 UTC Shammat <shammat@gmx.net>
` Re: postgres table statistics
2024-06-13 07:11 UTC Chandy G <vgchandru@yahoo.com>
[4+ messages in thread]
"permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
2024-06-13 01:31 UTC Chema <chema@interneta.org>
` Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
2024-06-13 01:44 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
2024-06-13 01:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program
2024-06-13 01:53 UTC Chema <chema@interneta.org>
[4+ messages in thread]
Is NVMe RAID useless (performance-wise) with PostgreSQL?
2024-06-13 00:54 UTC Dragan Milivojević <galileo@pkm-inc.com>
Re: Defining columns for INSERT statements
2024-06-12 21:36 UTC Rich Shepard <rshepard@appl-ecosys.com>
Does trigger only accept functions?
2024-06-10 19:17 UTC veem v <veema0000@gmail.com>
` Re: Does trigger only accept functions?
2024-06-10 20:20 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Does trigger only accept functions?
2024-06-11 01:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Does trigger only accept functions?
2024-06-11 11:33 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Does trigger only accept functions?
2024-06-11 18:49 UTC veem v <veema0000@gmail.com>
` Re: Does trigger only accept functions?
2024-06-11 18:56 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Does trigger only accept functions?
2024-06-11 19:20 UTC veem v <veema0000@gmail.com>
` Re: Does trigger only accept functions?
2024-06-11 19:46 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Does trigger only accept functions?
2024-06-11 19:58 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Does trigger only accept functions?
2024-06-11 22:25 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Does trigger only accept functions?
2024-06-12 16:40 UTC Isaac Morland <isaac.morland@gmail.com>
[11+ messages in thread]
Unexpected Backend PID reported by Notification
2024-06-11 15:05 UTC Dominique Devienne <ddevienne@gmail.com>
` Re: Unexpected Backend PID reported by Notification
2024-06-11 15:21 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Unexpected Backend PID reported by Notification
2024-06-11 15:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Unexpected Backend PID reported by Notification
2024-06-12 06:53 UTC Dominique Devienne <ddevienne@gmail.com>
[4+ messages in thread]
Oracle to Postgres - Transform Hash Partition
2024-06-06 16:28 UTC David Barbour <dbarbour@istation.com>
` Re: Oracle to Postgres - Transform Hash Partition
2024-06-06 18:41 UTC Christoph Moench-Tegeder <cmt@burggraben.net>
` Re: Oracle to Postgres - Transform Hash Partition
2024-06-07 05:40 UTC Muhammad Ikram <mmikram@gmail.com>
` Re: Oracle to Postgres - Transform Hash Partition
2024-06-07 08:31 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Oracle to Postgres - Transform Hash Partition - Thanks!
2024-06-11 22:11 UTC David Barbour <dbarbour@istation.com>
[5+ messages in thread]
Creating big indexes
2024-06-08 07:23 UTC Lok P <loknath.73@gmail.com>
` Re: Creating big indexes
2024-06-09 05:06 UTC sud <suds1434@gmail.com>
` Re: Creating big indexes
2024-06-09 05:09 UTC Lok P <loknath.73@gmail.com>
` Re: Creating big indexes
2024-06-09 08:09 UTC Lok P <loknath.73@gmail.com>
` Re: Creating big indexes
2024-06-11 18:22 UTC sud <suds1434@gmail.com>
[5+ messages in thread]
Re: Gaps in PK sequence numbers [RESOLVED]
2024-06-11 01:10 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: Gaps in PK sequence numbers [RESOLVED]
2024-06-11 01:21 UTC Christophe Pettus <xof@thebuild.com>
` Re: Gaps in PK sequence numbers [RESOLVED]
2024-06-11 01:23 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Gaps in PK sequence numbers [RESOLVED]
2024-06-11 12:28 UTC Rich Shepard <rshepard@appl-ecosys.com>
[4+ messages in thread]
libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 14:36 UTC Dominique Devienne <ddevienne@gmail.com>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 16:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 18:43 UTC Dominique Devienne <ddevienne@gmail.com>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 20:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 22:59 UTC Thomas Munro <thomas.munro@gmail.com>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-10 23:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: libpq v17 PQsocketPoll timeout is not granular enough
2024-06-11 07:19 UTC Francisco Olarte <folarte@peoplecall.com>
[7+ messages in thread]
autoanalyze / autovacuum vs manually executed "vacuum analyze"
2024-06-11 06:55 UTC Shenavai, Manuel <manuel.shenavai@sap.com>
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox