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.
1234 ... 167
Topics (5829)
Replies Last Post Views
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
DB running out of memory issues after upgrade by Nagaraj Raj
4
by Merlin Moncure-2
RE: Can we have multiple tablespaces with in a database. by pafiti
1
by Daulat Ram-2
tablespace to benefit from ssd ? by Nicolas Paris-2
4
by Jeff Janes
SubtransControlLock and performance problems by Lars Aksel Opsahl-2
12
by Lars Aksel Opsahl-2
How to avoid UPDATE performance degradation in a transaction by Karl Düüna
5
by Andres Freund
Partial index creation always scans the entire table by MingJu Wu
9
by Tom Lane-2
Bad selectivity estimate when using a sub query to determine WHERE condition by Chris Borckholder
4
by Chris Borckholder
Writing 1100 rows per second by xpro6000
7
by Amol Tarte
TOAST table performance problem by Asya Nevra Buyuksoy
15
by Asya Nevra Buyuksoy
Slow performance with trivial self-joins by Benny Kramek
4
by David Rowley-3
Statistics on array values by Marco Colli
6
by Marco Colli
Specific query taking time to process by Fahiz Mohamed
13
by Duncan Whitham
Query optimization advice for beginners by Kemal Ortanca
4
by Laurenz Albe
Bad query plan decision when using multiple column index - postgresql uses only first column then filters by Cosmin Prund
11
by Cosmin Prund
Queries in plpgsql are 6 times slower on partitioned tables by Marcin Barczyński
0
by Marcin Barczyński
shared buffers and startup process by Joao Junior-2
1
by Michael Paquier-2
Bad query plan when you add many OR conditions by Marco Colli
10
by Thomas Kellerer
Seeking reason behind performance gain in 12 with HashAggregate by Shira Bezalel
8
by Shira Bezalel
distinguish index cost component from table component by Justin Pryzby
2
by Justin Pryzby
Merge join doesn't seem to break early when I (and planner) think it should - 10.4 by Timothy Garnett
1
by Jeff Janes
How to set parallel_tuple_cost by Jeff Janes
4
by Jeff Janes
Consecutive Query Executions with Increasing Execution Time by Shijia Wei
17
by Shijia Wei
weird long time query by Kaijiang Chen
7
by Osahon Oduware-2
shared memory size during upgrade pgsql with partitions by Piotr Włodarczyk
2
by Piotr Włodarczyk
1234 ... 167