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 ... 166
Topics (5806)
Replies Last Post Views
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
Specific query taking time to process by Fahiz Mohamed
9
by Jeff Janes
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
Postgresql planning time too high by Sterpu Victor
14
by Tomas Vondra-4
Hash Join over Nested Loop by Luís Roberto Weck
4
by Pavel Stehule
Wrong estimations and NL Anti join poor performance by Andrew Zakharov
0
by Andrew Zakharov
Out of memory error on automatic vacuum by Ekaterina Amez
5
by Tomas Vondra-4
Simple DELETE on modest-size table runs 100% CPU forever by Craig James-2
10
by Craig James-2
JSON path by Jesper Pedersen
2
by Jesper Pedersen
Parallel Query by Luís Roberto Weck
7
by Luís Roberto Weck
Slow "not in array" operation by Marco Colli
16
by Marco Colli
FPGA optimization ... by Gunter
6
by Tomas Vondra-4
Slow planning, fast execution for particular 3-table query by David Wheeler-2
12
by Justin Pryzby
Huge shared hit for small table by Scott Rankin
12
by Jeff Janes
GIN index on JSONB not used due to lack of nested statistics by Alessandro Baretta-3
1
by Jeff Janes
UNION causes horrible plan on JOIN by Craig James-2
4
by Kyotaro Horiguchi-4
1234 ... 166