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 ... 160
Topics (5566)
Replies Last Post Views
Why could different data in a table be processed with different performance? by Vladimir Ryabtsev
10
by didier
Multi-second pauses blocking even trivial activity by Patrick Molgaard
9
by Andreas Kretschmer-3
To keep indexes in memory, is large enough effective_cache_size enough? by Sam R.
12
by David Rowley-3
How to see/calculate size of index in memory? by Sam R.
1
by Sergei Kornilov
Re: Why the sql is not executed in parallel mode by Thomas Munro-3
0
by Thomas Munro-3
Select count(*) on a 2B Rows Tables Takes ~20 Hours by Fd Habash
7
by Jeremy Schneider-2
LEFT JOIN LATERAL optimisation at plan time by Nicolas Paris-2
1
by Tom Lane-2
pg_pub_decrypt: 10x performance hit with gpg v2 by Felix A. Kater
0
by Felix A. Kater
Performance problems with Thai language by Andrey Zhidenkov-2
0
by Andrey Zhidenkov-2
How Do You Associate a Query With its Invoking Procedure? by Fd Habash
6
by Fd Habash
Advice on machine specs for growth by Rory Campbell-Lange
0
by Rory Campbell-Lange
Performance of INSERT into temporary tables using psqlODBC driver by padusuma
11
by padusuma
Partial index plan/cardinality costing by jtc331
0
by jtc331
GIN Index has O(N^2) complexity for array overlap operator? by Felix Geisendörfer
0
by Felix Geisendörfer
Performance difference in accessing differrent columns in a Postgres Table by Dinesh Kumar-4
16
by Dinesh Kumar-4
query gets very slow when :jsonb ?& operator is used by davidjesse091
1
by Jeff Janes
Guideline To Resolve LWLock:SubtransControlLock by Fd Habash
9
by Jeremy Schneider-2
RE: Query is slow when run for first time; subsequent execution is fast by jimmy
1
by Jeff Janes
Inconsistent query times and spiky CPU with GIN tsvector search by Scott Rankin
1
by Laurenz Albe
Re: trying to delete most of the table by range of date col by Justin Pryzby
9
by Mariel Cherkassky
Extremely slow when query uses GIST exclusion index by David-5
4
by Andreas Kretschmer-3
dsa_allocate() faliure by Rick Otten-2
10
by Sand Stone
Bi-modal streaming replication throughput by Alexis Lê-Quôc
5
by Andres Freund
Fwd: increase insert into local table from remote oracle table preformance by Mariel Cherkassky
6
by legrand legrand
Calculating how much redo log space has been used by Reza Taheri
2
by Reza Taheri
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
1234 ... 160