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 ... 158
Topics (5524)
Replies Last Post Views
Dissuade the use of exclusion constraint index by Adam Brusselback
5
by Adam Brusselback
Small query plan change, big performance difference by Michael Sacket
2
by Michael Sacket
Re: pg_upgrade 10.2 by Jerry Sievers-3
0
by Jerry Sievers-3
Client Server performance & UDS by Kevin.Hughes@uk.fuji...
6
by e-blokos
Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan by Fred Habash
4
by Fred Habash
Sort is generating rows by Nicolas Seinlet
2
by Nicolas Seinlet
Possible optimisation: push down SORT and LIMIT nodes by Christopher Wilson
2
by Justin Pryzby
propose web form for submission of performance problems by Justin Pryzby
3
by Thomas Kellerer
Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!! by pavan95
23
by Justin Pryzby
dsa_allocate() faliure by Rick Otten-2
6
by Sand Stone
Help with tuning slow query by Kotapati, Anil
1
by Justin Pryzby
Latest advice on SSD? by Craig James-2
18
by Mark Kirkwood-2
Time bucketing query performance by Julian Wilson
1
by Justin Pryzby
help in analysis of execution plans by Neto pr
2
by David Rowley-3
Why doesn't the second query use the index for sorting? by Alf Lervåg
0
by Alf Lervåg
Performance issues while running select sql query by Kaushal Shriyan
6
by Kaushal Shriyan
SeqScan vs. IndexScan by Vitaliy Garnashevich
1
by Tom Lane-2
Data migration from postgres 8.4 to 9.4 by akshay.ballarpure
3
by Ahmed, Nawaz
Installing PostgreSQL 9.5 in centos 6 using YUM by dc12108
1
by Ahmed, Nawaz
Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...) by Hackety Man
12
by Deepak Somaiya
Table order at FROM clause affects performance? by Eduard Català
2
by Eduard Català
citext performance by Deepak Somaiya
2
by Deepak Somaiya
functions: VOLATILE performs better than STABLE by Peter Much
3
by Merlin Moncure-2
Slow query on partitioned table. by Glenn Pierce
2
by Justin Pryzby
Should from_collapse be switched off? (queries 10 times faster) by Peter Much
9
by Laurenz Albe
Slow planning time for custom function by bk-2
3
by bk-2
DB corruption by akshay.ballarpure
2
by Tom Lane-2
badly scaling performance with appending to bytea by Gary Cowell-2
5
by Pavel Stehule
PG 9.6 Slow inserts with long-lasting LWLocks by Pavel Suderevsky
3
by Pavel Suderevsky
Slow performance after restoring a dump by David Osborne
4
by David Osborne
Irrelevant columns cause massive performance change by Craig James-2
2
by Craig James-2
Too many .history file in pg_xlog takes lots of space by 彭昱傑
6
by 彭昱傑
Memory size by dangal
10
by dangal
Updating large tables without dead tuples by ldhasson
5
by ldhasson
by mistake dropped physical file dropped for one table. by ram.wissen
2
by ram.wissen
1234 ... 158