public inbox for [email protected]
help / color / mirror / Atom feedKeeping some tables in cache
2025-08-26 08:21 UTC Ertan Küçükoglu <[email protected]>
` Re: Keeping some tables in cache
2025-08-26 09:04 UTC Achilleas Mantzios <[email protected]>
` Re: Keeping some tables in cache
2025-08-26 12:21 UTC Laurenz Albe <[email protected]>
[3+ messages in thread]
Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-05 17:01 UTC Priya V <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-05 18:52 UTC Joe Conway <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-06 08:47 UTC Frits Hoogland <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-06 15:51 UTC Priya V <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-06 16:33 UTC Joe Conway <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-06 21:14 UTC Frits Hoogland <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-07 01:12 UTC Joe Conway <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-08 08:21 UTC Frits Hoogland <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-12 17:49 UTC Bruce Momjian <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-15 15:14 UTC Jorge Rodriguez <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-18 16:17 UTC Frédéric Yhuel <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-19 15:37 UTC Frits Hoogland <[email protected]>
` Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet
2025-08-19 17:40 UTC Frédéric Yhuel <[email protected]>
[13+ messages in thread]
Making Postgres slower
2025-07-28 13:31 UTC Bruce Momjian <[email protected]>
Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-07-21 05:58 UTC Stepan Neretin <[email protected]>
` Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-07-23 21:23 UTC Dimitrios Apostolou <[email protected]>
[2+ messages in thread]
Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN?
2025-07-19 23:03 UTC =?utf-8?B?WHVhbiBDaGVu?= <[email protected]>
` Re: Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN?
2025-07-20 01:57 UTC Tom Lane <[email protected]>
[2+ messages in thread]
Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-07-18 21:54 UTC Tom Lane <[email protected]>
Is there a way to identify a plan generated by GECO?
2025-07-18 01:09 UTC Jerry Brenner <[email protected]>
` Re: Is there a way to identify a plan generated by GECO?
2025-07-18 01:43 UTC Nikolay Samokhvalov <[email protected]>
` Re: Is there a way to identify a plan generated by GECO?
2025-07-18 01:57 UTC Tom Lane <[email protected]>
` Re: Is there a way to identify a plan generated by GECO?
2025-07-18 02:30 UTC Jerry Brenner <[email protected]>
` Re: Is there a way to identify a plan generated by GECO?
2025-07-18 03:10 UTC Tom Lane <[email protected]>
` Re: Is there a way to identify a plan generated by GECO?
2025-07-18 13:20 UTC Jerry Brenner <[email protected]>
[6+ messages in thread]
Any way to get nested loop index joins on CTEs?
2025-07-15 13:29 UTC Clemens Eisserer <[email protected]>
` Re: Any way to get nested loop index joins on CTEs?
2025-07-16 11:24 UTC Jean-Christophe BOGGIO <[email protected]>
[2+ messages in thread]
WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas
2025-07-08 08:12 UTC Dharin Shah <[email protected]>
` Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas
2025-07-08 14:05 UTC Álvaro Herrera <[email protected]>
` Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas
2025-07-08 21:15 UTC Dharin Shah <[email protected]>
[3+ messages in thread]
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-07-04 13:45 UTC Greg Sabino Mullane <[email protected]>
Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-25 08:35 UTC Motog Plus <[email protected]>
` Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-25 08:48 UTC Motog Plus <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 05:11 UTC Motog Plus <[email protected]>
` Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 05:40 UTC David G. Johnston <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 06:34 UTC Motog Plus <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 12:49 UTC Ron Johnson <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 13:11 UTC Claus Koch <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 13:43 UTC Motog Plus <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 14:30 UTC Paul Smith* <[email protected]>
` Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation
2025-06-26 14:54 UTC Ron Johnson <[email protected]>
[10+ messages in thread]
many sessions waiting DataFileRead and extend
2025-06-25 03:15 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-25 05:59 UTC Laurenz Albe <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-25 09:10 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-25 14:27 UTC Frits Hoogland <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 02:32 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 03:03 UTC Laurenz Albe <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 03:25 UTC Tatsuo Ishii <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 03:48 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 06:40 UTC Frits Hoogland <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 06:47 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 07:22 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 08:07 UTC Frits Hoogland <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 08:58 UTC James Pang <[email protected]>
` Re: many sessions waiting DataFileRead and extend
2025-06-26 12:19 UTC Robert Haas <[email protected]>
[14+ messages in thread]
many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
2025-06-24 14:22 UTC James Pang <[email protected]>
` Re: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
2025-06-24 14:31 UTC David G. Johnston <[email protected]>
[2+ messages in thread]
ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-03 15:34 UTC Dimitrios Apostolou <[email protected]>
` Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-04 07:00 UTC Frédéric Yhuel <[email protected]>
` Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-04 14:12 UTC Dimitrios Apostolou <[email protected]>
` Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-05 14:13 UTC Frédéric Yhuel <[email protected]>
` Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-05 14:51 UTC Frédéric Yhuel <[email protected]>
` [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-10 00:51 UTC Dimitrios Apostolou <[email protected]>
` Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized
2025-06-17 16:23 UTC Dimitrios Apostolou <[email protected]>
[7+ messages in thread]
Re: Performance implications of 8K pread()s
2025-06-13 12:15 UTC Dimitrios Apostolou <[email protected]>
Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 15:42 UTC Mark Frost <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 17:09 UTC Frédéric Yhuel <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 18:57 UTC Tom Lane <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-05 21:52 UTC Tom Lane <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-06 08:07 UTC Frédéric Yhuel <[email protected]>
` RE: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-06 09:21 UTC Mark Frost <[email protected]>
` Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
2025-06-07 01:29 UTC Tom Lane <[email protected]>
[7+ messages in thread]
Re: Database creation performance drop going from pg 14 to pg 15+
2025-06-05 18:25 UTC Mahdi Bahrami <[email protected]>
Database creation performance drop going from pg 14 to pg 15+
2025-05-15 16:28 UTC Mahdi Bahrami <[email protected]>
` Re: Database creation performance drop going from pg 14 to pg 15+
2025-05-27 08:12 UTC Mahdi Bahrami <[email protected]>
` Re: Database creation performance drop going from pg 14 to pg 15+
2025-05-27 15:07 UTC Álvaro Herrera <[email protected]>
` Re: Database creation performance drop going from pg 14 to pg 15+
2025-05-28 11:09 UTC Mahdi Bahrami <[email protected]>
` Re: Database creation performance drop going from pg 14 to pg 15+
2025-05-28 11:29 UTC Thomas Munro <[email protected]>
` Re: Database creation performance drop going from pg 14 to pg 15+
2025-05-28 12:15 UTC Mahdi Bahrami <[email protected]>
[6+ messages in thread]
inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 11:49 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 12:08 UTC Andrei Lepikhov <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 13:08 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 13:48 UTC Andrei Lepikhov <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 14:04 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 14:21 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 15:01 UTC David Rowley <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 15:18 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 15:33 UTC Tom Lane <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 17:22 UTC Andrei Lepikhov <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 17:55 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-12 18:07 UTC Tom Lane <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-13 04:25 UTC Andrei Lepikhov <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-13 11:20 UTC David Rowley <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-14 00:47 UTC Maxim Boguk <[email protected]>
` Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17)
2025-05-18 16:54 UTC Andrei Lepikhov <[email protected]>
[16+ messages in thread]
a lot of session wait on lock relation
2025-05-15 08:27 UTC James Pang <[email protected]>
` Re: a lot of session wait on lock relation
2025-05-15 09:31 UTC Chetan <[email protected]>
` Re: a lot of session wait on lock relation
2025-05-15 12:08 UTC Laurenz Albe <[email protected]>
` Re: a lot of session wait on lock relation
2025-05-15 13:24 UTC Tom Lane <[email protected]>
` Re: a lot of session wait on lock relation
2025-05-15 13:32 UTC James Pang <[email protected]>
` Re: a lot of session wait on lock relation
2025-05-15 13:43 UTC James Pang <[email protected]>
[6+ messages in thread]
Vacuum Questions
2025-05-02 14:23 UTC Leo <[email protected]>
` Re: Vacuum Questions
2025-05-02 16:04 UTC Leo <[email protected]>
` Re: Vacuum Questions
2025-05-02 23:49 UTC John Naylor <[email protected]>
` RE: Vacuum Questions
2025-05-03 19:46 UTC [email protected]
` Re: Vacuum Questions
2025-05-05 14:33 UTC Craig Jackson <[email protected]>
` Re: Vacuum Questions
2025-05-05 14:35 UTC Craig Jackson <[email protected]>
[6+ messages in thread]
PostgreSQL Choosing Full Index Over Partial Index
2025-04-28 13:22 UTC Felipe López Montes <[email protected]>
` Re: PostgreSQL Choosing Full Index Over Partial Index
2025-04-28 13:35 UTC Laurenz Albe <[email protected]>
` Re: PostgreSQL Choosing Full Index Over Partial Index
2025-04-28 14:54 UTC Felipe López Montes <[email protected]>
` Re: PostgreSQL Choosing Full Index Over Partial Index
2025-04-28 15:07 UTC Tom Lane <[email protected]>
` Re: PostgreSQL Choosing Full Index Over Partial Index
2025-04-30 09:11 UTC Felipe López Montes <[email protected]>
` Re: PostgreSQL Choosing Full Index Over Partial Index
2025-04-30 14:14 UTC Tom Lane <[email protected]>
[6+ messages in thread]
Constraints elimination during runtime
2025-04-16 11:16 UTC Weck, Luis <[email protected]>
` Re: Constraints elimination during runtime
2025-04-16 12:38 UTC Laurenz Albe <[email protected]>
[2+ messages in thread]
many sessions wait on LWlock WALWrite suddenly
2025-04-11 14:36 UTC James Pang <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-11 19:59 UTC Laurenz Albe <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-11 22:43 UTC MichaelDBA <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-15 09:16 UTC Yura Sokolov <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-15 10:00 UTC Andres Freund <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-15 10:44 UTC Yura Sokolov <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-15 10:53 UTC Andres Freund <[email protected]>
` Re: many sessions wait on LWlock WALWrite suddenly
2025-04-15 10:58 UTC Yura Sokolov <[email protected]>
[8+ messages in thread]
session waiting IO while background writer writing data
2025-04-14 05:30 UTC James Pang <[email protected]>
[next (older)]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox