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.
1234567 ... 169
Topics (5888)
Replies Last Post Views
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
Query slows when used with view by Yavuz Selim Sertoğlu...
6
by Tom Lane-2
Out of Memory errors are frustrating as heck! by Gunter
95
by Merlin Moncure-2
distinct on extract returns composite type by Mariel Cherkassky
5
by Michael Lewis
Slow PostgreSQL 10.6 query by Behrang Saeedzadeh
4
by Behrang Saeedzadeh
Delete huge Table under XFS by Joao Junior-2
4
by Tomas Vondra-4
Query went slow all of sudden. ON V 11.3 by nikhil raj
4
by Tomas Vondra-4
Some observations on very slow pg_restore operations by Ogden Brash
3
by Justin Pryzby
pg12 - partition by column that might have null values by Mariel Cherkassky
7
by Michael Lewis
sequence depends on many tables by Mariel Cherkassky
5
by Tom Lane-2
Slow pg_publication_tables with many schemas and tables by Edilmar Alves
2
by Edilmar Alves
Analyze on slave promoted. by Joao Junior-2
2
by Vik Fearing-4
Autovacuum is cleaning very less dead tuples by Amarendra Konda
1
by Laurenz Albe
1234567 ... 169