dumping - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2025-04-03 09:32:44 | Re: partition table optimizer join cost misestimation (Andrei Lepikhov)
dump of pg_statistic on attributes cc.sss_id and aa.mmm_id? 4. Is there
Mailing lists >> pgsql-performance >> Thread >> Search in thread (5)
2025-03-19 21:46:58 | parallel pg_restore blocks on heavy random read I/O on all children processes (Dimitrios Apostolou)
DUMP_FILENAME And here is the pg_dump command which has created the dump file
Mailing lists >> pgsql-performance >> Thread
2025-02-26 17:27:53 | Efficient pagination using multi-column cursors (large.goose2829@salomvary.com)
knowing The Truth. I've dumped my experiments into a DB Fiddle: https:///f/kd8zaibZGKGH1HSStyxNkx/0 Cheers, Márton
Mailing lists >> pgsql-performance >> Thread >> Search in thread (3)
2024-07-10 18:41:01 | Re: Specific objects backup in PostgreSQL (David G. Johnston)
dump itself doesn't provide any command line options to give you this specific subset
Mailing lists >> pgsql-performance >> Thread
2023-10-26 13:47:03 | Re: Postgres 15 SELECT query doesn't use index under RLS (Alexander Okulovich)
dump, but no luck. The first query execution on Postgres 15 behaves like on the real
Mailing lists >> pgsql-performance >> Thread
2023-09-15 14:30:39 | pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit (Achilleas Mantzios - cloud)
dump from the linux system, I am puzzled why this huge difference in Buffers: shared
Mailing lists >> pgsql-performance >> Thread >> Search in thread (3)
2023-08-29 18:42:27 | Re: Queries containing ORDER BY and LIMIT started to work slowly (Jeff Janes)
dump of the database, but don't describe doing anything with it. Did you replace
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-08-27 17:39:40 | Re: Slow query, possibly not using index (Les)
dump the whole database and restore it on another machine. Would that eliminate dead rows
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-06-01 03:36:13 | thousands of CachedPlan entry per backend (James Pang (chaolpan))
dump "Grand total:", both mached. But from details, we found almost of entry belong to "CacheMemoryContext
Mailing lists >> pgsql-performance >> Thread
2023-05-04 17:31:45 | Fsync IO issue (ProfiVPS Support)
dump, the content is as expected. We are talking about some insane data overhead here
Mailing lists >> pgsql-performance >> Thread
2022-09-16 23:05:57 | Milions of views - performance, stability (Hubert Rutkowski)
dumping through pg_dump to tar took 13 minutes. Same table but without views: less
Mailing lists >> pgsql-performance >> Thread >> Search in thread (4)
2022-06-19 07:16:26 | RE: reindex option for tuning load large data (James Pang (chaolpan))
dump only used to dump metadata in Postgres to rebuild index and recreate constraints. The questions
Mailing lists >> pgsql-performance >> Thread
2022-03-03 08:59:03 | OOM killer while pg_restore (Marc Rechté)
dump contains over 200M rows for that table and is in custom format, which corresponds
Mailing lists >> pgsql-performance >> Thread
2022-02-24 16:10:51 | Re: Advice needed: query performance deteriorates by 2000% within 1 minute (Tom Lane)
dump will not propagate such hacks on system-defined objects, so you'll need a note
Mailing lists >> pgsql-performance >> Thread
2022-01-20 22:50:07 | Poor performance PostgreSQL 13/ PostGIS 3.x (Lugosi, Jim)
dump. Could this be causing issues? Should we load the data from scratch? We use ogr2ogr