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 (5795)
Replies Last Post Views
unexpected result for wastedbytes query after vacuum full by Mike Schanne
2
by Mike Schanne
autovacuum locking question by Mike Schanne
18
by Mike Schanne
Specific query taking time to process by Fahiz Mohamed
3
by Fahiz Mohamed
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
Re: performance degredation after upgrade from 9.6 to 12 by Andrew Zakharov
7
by Andres Freund
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
Notifications within triggers seem to compromise performance by Grégoire de Turckhei...
4
by Grégoire de Turckhei...
max_connections by Joao Junior-2
1
by Pavel Stehule
Change in CTE treatment in query plans? by David Conlin
2
by David Conlin
Can you please tell us how set this prefetch attribute in following lines. by M Tarkeshwar Rao
1
by Justin Pryzby
Re: pg_stat_bgwriter by Tomas Vondra-4
8
by dangal
Reading explain plans- row estimates/actuals on lower nodes vs next level up by Michael Lewis
1
by Tomas Vondra-4
Optimising a two column OR check by Ivan Voras
13
by Ivan Voras
Modification of data in base folder and very large tables by Ogden Brash
6
by Jeff Janes
Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query) by Behrang Saeedzadeh
2
by David Rowley-3
Would SSD improve Index Only Scan performance by a lot? by xpro6000
4
by Jeff Janes
Get the planner used by a query? by Behrang Saeedzadeh
1
by David Rowley-3
1234 ... 166