RE: Slow query on a one-tuple table

With LIMIT 1, I get 3 shared buffers hit, pretty much always. Check if assessoria_pkey index is bloated. Regards, Igor Neyman

RE: Slow query on a one-tuple table

you repeat it with "LIMIT 1"? Notice huge difference in "buffers hit" while doing (the same) Index Scan in two plans. Regards, Igor Neyman

RE: Max_connections limit

umber of allowed connections in PG config to about 50, while allowing thousands client connection when configuring PgBouncer. Regards, Igor Neyman

RE: Planning performance problem (67626.278ms)

solves the problem only temporarily. Question is how can we debug what is going on? Best Regards, Krzysztof Płocharz ___ Why do you have to run Analyze? Did you turn off Autovacuum? Regards, Igor Neyman

RE: Slow query with aggregate and many LEFT JOINS

e this ? https://explain.depesz.com/s/6nf Regards Michaël Don’t know your hardware config, or Postgres settings, but I see external disk sort. So, try setting work_mem to ~48MB. Regards, Igor Neyman

RE: Slow query with aggregate and many LEFT JOINS

Try increasing both: join_collapse_limit and from_collapse_limit to 16 (or even 17). Regards, Igor Neyman

RE: PG 9.5 2 tables same DDL with diff size

need to lock the table, they could just prevent from cleaning "old" row versions. Regards, Igor Neyman

RE: PG 9.5 2 tables same DDL with diff size

diff size except the host ( same OS and PG version 9.5.3)? Thank you Table is still bloated because of some long running transactions, which don't allow full vacuum to do its job? Regards,

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se] Sent: Tuesday, November 21, 2017 11:48 AM To: pgsql-performance@lists.postgresql.org Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade I VACUUM every sunday so that is done already. =/ Not sure I have the proper pa

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

hen there is no other activity. Igor Neyman

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

hat back in. Still very curious about the 3x slowdown in 9.5 pg_dump though. -- Henrik Cednert cto | compositor Filmlance International Basically, you are dumping 40GB of data. I'd say even 212 minutes under 8.4 version was too slow. What kind of RAID is it? RAID1/RAID10/RAID5? Regards, Igor Neyman

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

ormat=custom These backups could only be restored using pg_restore (or something that wraps pg_restore). So, you can safely add parallel option. It should not affect your restore procedure. Regards, Igor Neyman