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 ... 165
Topics (5769)
Replies Last Post Views
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
Change in CTE treatment in query plans? by David Conlin
1
by Tom Lane-2
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
Slow query on V12. by Luís Roberto Weck
5
by Luís Roberto Weck
pg12 partitions question by Mariel Cherkassky
1
by Mariel Cherkassky
comparing output of internal pg tables of referenced tables by Mariel Cherkassky
14
by Michaeldba@sqlexec.c...
Surprising benchmark count(1) vs. count(*) by Thomas Kellerer
5
by Tom Lane-2
pg12 - migrate tables to partitions structure by Mariel Cherkassky
5
by Michael Lewis
Question regarding fast-hashing in PGSQL by Steve-100
3
by Tom Lane-2
does max_connections affect the query planner by Bob Jolliffe
3
by Jeff Janes
Query execution time Vs Cost by Amarendra Konda
2
by Amarendra Konda
select distinct runs slow on pg 10.6 by yash mehta
13
by Dinesh Somani
Incorrect choice of Nested Loop for a skewed distribution by Oleg Kharin-2
2
by Oleg Kharin-2
Upsert performance considerations (~1 mil/hour) by Fredrik Blomqvist
2
by Fredrik Blomqvist
UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE by Mariel Cherkassky
2
by Merlin Moncure-2
Erratically behaving query needs optimization by Barbu Paul - Gheorgh...
14
by Barbu Paul - Gheorgh...
Extremely slow HashAggregate in simple UNION query by Felix Geisendörfer
11
by Andres Freund
1234 ... 165