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 ... 171
Topics (5952)
Replies Last Post Views
LWLocks by LockManager slowing large DB by Paul Friedman
19
by Álvaro Herrera
INSERTS waiting with wait_event is "transactionid" by Nagaraj Raj
2
by Nagaraj Raj
procedure using CURSOR to insert is extremely slow by Szalontai Zoltán
7
by Szalontai Zoltán
str_aggr function not wokring by aditya desai
3
by aditya desai
select count(*) is slow by aditya desai
4
by aditya desai
SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS by aditya desai
4
by Andrew Dunstan
Substitute for synonym in Oracle after migration to postgres by aditya desai
3
by aditya desai
PosgtgreSQL hot standby reading WAL from muli-attached volume? by Gunter
0
by Gunter
SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. by aditya desai
24
by aditya desai
High availability management tool. by Rodriguez Pablo A
3
by Adalberto Caccia
High-volume writes - what is the max throughput possible by Geervan Hayatnagarka...
2
by Hannu Krosing-7
Fwd: different execution time for the same query (and same DB status) by Francesco De Angelis
13
by Nikhil Shetty
Odd (slow) plan choice with min/max by Paul McGarry-2
5
by Yoan SULTAN
SQL performance issue (postgresql chooses a bad plan when a better one is available) by Chris Stephens
5
by Hannu Krosing-7
Extremely inefficient merge-join by Marcin Gozdalik
2
by Marcin Gozdalik
wide table, many many partitions, poor query performance by S Bob
2
by Laurenz Albe
FreeBSD UFS & fsync by Luca Ferrari-2
8
by Luca Ferrari-2
Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? by Gunther Schadow
4
by Kamil Dziedzic
Users grants with setting options by Nagaraj Raj
2
by Nagaraj Raj
Slow query performance inside a transaction on a clean database by val.janeiko
1
by Laurenz Albe
Potential performance issues related to group by and covering index by Liu, Xinyu
5
by Hannu Krosing-7
tables meta data collection by Nagaraj Raj
1
by Justin Pryzby
Performance issues related to left join and order by by Liu, Xinyu
1
by David Rowley
Potential performance issues by Jung, Jinho
9
by Hannu Krosing-7
Postgres performance comparing GCP and AWS by Maurici Meneghetti
12
by Hannu Krosing-7
Disabling options lowers the estimated cost of a query by Arne Roland
1
by Tom Lane-2
RE: Autovacuum not functioning for large tables but it is working for few other small tables. by M Tarkeshwar Rao
5
by Laurenz Albe
Slow query and wrong row estimates for CTE by Dane Foster
9
by Yoan SULTAN
Query performance issue by Nagaraj Raj
3
by Michael Lewis
Understanding logical replication lag by Patrick Molgaard
0
by Patrick Molgaard
High COMMIT times by Don Seiler
17
by Don Seiler
RE: Need information on how MM frees up disk space (vaccum) after scheduled DB cleanup by BGwCronScript/BGwLogCleaner by M Tarkeshwar Rao
0
by M Tarkeshwar Rao
How to deal with analyze gathering irrelevant stats by Rémi Chatenay
5
by Michael Lewis
Slow recursive CTE query questions, with row estimate and n_distinct issues by Christopher Baines
4
by Christopher Baines
Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. by Gunter
2
by Bruce Momjian
1234 ... 171