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 ... 159
Topics (5546)
Replies Last Post Views
Fwd: increase insert into local table from remote oracle table preformance by Mariel Cherkassky
4
by Mariel Cherkassky
Calculating how much redo log space has been used by Reza Taheri
1
by Andres Freund
Bi-modal streaming replication throughput by Alexis Lê-Quôc
3
by Andres Freund
Performance difference in accessing differrent columns in a Postgres Table by Dinesh Kumar-4
12
by Jeff Janes
Query with "ILIKE ALL" does not use the index by Nicolas Even
4
by Nicolas Even
Profile what the production server is doing by Thomas Güttler
10
by Michaeldba@sqlexec.c...
Why HDD performance is better than SSD in this case by Neto pr
31
by Mark Kirkwood-2
Improving Performance of Query ~ Filter by A, Sort by B by Lincoln Swaine-Moore
6
by Jeff Janes
Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation by Takao Magoori
1
by Tomas Vondra-4
HDD vs SSD without explanation by Neto pr
21
by Neto pr
performance statistics monitoring without spamming logs by Patrick Hemmer
5
by Julien Rouhaud
High concurrency but simple updating causes deadlock by 枫
1
by Roman Konoval
Suggestion to optimize performance of the PLSQL procedure. by dc12108
0
by dc12108
Need help with optimising simple query by Nandakumar M
2
by Nandakumar M
where can I download the binaries of plpython extension by Mariel Cherkassky
11
by Mariel Cherkassky
Problems with installing pgwatch2 without docker by Mariel Cherkassky-2
1
by Andrew Dunstan-8
Trigger overhead/performance and alternatives? by AJG
1
by Peter Eisentraut-6
tcp_keepalives by José Mello Júnior
1
by Justin Pryzby
Bug in PostgreSQL by ram.wissen
4
by Andres Freund
Queue table that quickly grows causes query planner to choose poor plan by David Wheeler-2
3
by David Wheeler-2
Slow join by Roman Kushnir
4
by Roman Kushnir
"set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench by Elvir Kurić
2
by Elvir Kurić
Slow query when pg_trgm is in inner lopp by Sasa Vilic
4
by Sasa Vilic
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
1234 ... 159