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.
123456 ... 169
Topics (5889)
Replies Last Post Views
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
Re: performance degredation after upgrade from 9.6 to 12 by Andrew Zakharov
11
by Pavel Stehule
autovacuum locking question by Mike Schanne
20
by Moreno Andreo
unexpected result for wastedbytes query after vacuum full by Mike Schanne
5
by Guillaume Lelarge-3
Logical replication performance by Florian Philippon
2
by Jeff Janes
How to run in parallel in Postgres by Lars Aksel Opsahl-2
9
by Lars Aksel Opsahl-2
query that canceled isnt logged by Mariel Cherkassky
4
by Tom Lane-2
Postgres backup tool recommendations for multi-terabyte database in Google Cloud by Craig Jackson
3
by Nikolay Samokhvalov
Make recently inserted/updated records available in the buffer/cache by Sachin Divekar
6
by Michael Lewis
[External] Join queries slow with predicate, limit, and ordering by Aufar Gilbran
2
by Aufar Gilbran
Considerable performance downgrade of v11 and 12 on Windows by Eugene Podshivalov
7
by Eugene Podshivalov
123456 ... 169