PostgreSQL - performance

This forum is an archive for the mailing list pgsql-performance@postgresql.org (more options) Messages posted here will be sent to this mailing list.
12345 ... 169
Topics (5888)
Replies Last Post Views
Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query by A Guy Named Ryan
3
by Tom Lane-2
Plan not skipping unnecessary inner join by Matthew Nelson
5
by Ranier Vilela-2
Please help! Query jumps from 1s -> 4m by James Thompson-2
10
by James Thompson-2
Inaccurate Rows estimate for "Bitmap And" causes Planner to choose wrong join by Steve Pritchard
3
by Steve Pritchard
600 million rows of data. Bad hardware or need partitioning? by xpro6000
8
by xpro6000
pg_attribute, pg_class, pg_depend grow huge in count and size with multiple tenants. by samhitha g
11
by Jeff Janes
Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) by Amarendra Konda
4
by David Rowley
Re: AutoVacuum and growing transaction XID's by Michael Lewis
0
by Michael Lewis
NUMA settings by Marc Rechté
6
by Laurenz Albe
good book or any other resources for Postgresql by Bhupendra Babu
3
by Bhupendra Babu
Duplicate WHERE condition changes performance and plan by singh400@gmail.com
6
by Michael Lewis
Recursive query slow on strange conditions by Jean-Christophe Bogg...
6
by Jean-Christophe Bogg...
Best partition type for billions of addresses by xpro6000
4
by Stephen Frost
The query plan get all columns but I'm using only one column. by Moises Lopez
6
by Moises Lopez
PostgreSQL does not choose my indexes well by Arcadio Ortega Reino...
20
by Arcadio Ortega Reino...
Postgres not using index on views by Rick Vincent
11
by Rick Vincent
Using unlogged tables for web sessions by Stephen Carboni
0
by Stephen Carboni
High kswapd by Don Seiler
4
by Don Seiler
PostgreSQL DBA consulting by daya airody
2
by Amol Tarte
High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version by Maxim Boguk-2
2
by Maxim Boguk-2
slow query by dangal
2
by Michael Christofides
Postgresql 12, 512 partition by hash. Slow select by xpro6000
4
by Neil
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good by Julien Rouhaud
5
by Julien Rouhaud
Increasing work_mem slows down query, why? by Silvio Moioli
11
by Silvio Moioli
Best way to delete big amount of records from big table by Ekaterina Amez
8
by Laurenz Albe
JOIN on partitions is very slow by daya airody
5
by daya airody
Slow planning time when public schema included (12 vs. 9.4) by Anders Steinlein-3
8
by Anders Steinlein-3
Random function by Luís Roberto Weck
2
by David G Johnston
Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 by Ronnie S
2
by Ronnie S
Partitions to improve write/update speed for tables with indexes? by xpro6000
1
by Justin Pryzby
Slow ext'd query via client native implementation vs. libpq & simple psql by Richard Michael
3
by Justin Pryzby
pg12 partitions show bad performance vs pg96 by Mariel Cherkassky
9
by David Rowley
Many DataFileRead - IO waits by Ben Snaidero
9
by legrand legrand
much slower query in production by Guillaume Cottenceau...
10
by Guillaume Cottenceau...
PostgreSQL 11 higher Planning time on Partitioned table by Ravi Garg
7
by Ravi Garg
12345 ... 169