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 (5574)
Replies Last Post Views
Why could different data in a table be processed with different performance? by Vladimir Ryabtsev
34
by Sam R.
Import csv in PostgreSQL by dc12108
1
by Gabi D
Re: does work_mem is used on temp tables? by Andrew Gierth
0
by Andrew Gierth
Partial index plan/cardinality costing by jtc331
2
by Justin Pryzby
RE: Why the index is not used ? by Did16
4
by Tomas Vondra-4
dsa_allocate() faliure by Rick Otten-2
11
by Thomas Munro-3
psql: fe_sendauth: no password supplied by Daulat Ram-2
1
by Justin Pryzby
To keep indexes in memory, is large enough effective_cache_size enough? by Sam R.
16
by David Rowley-3
SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes by Arjun Ranade
10
by Justin Pryzby
reference regarding write load during different stages of checkpoint by Justin Pryzby
0
by Justin Pryzby
Re: link to Slow_Query_Questions from wiki/Main Page by Justin Pryzby
1
by Alvaro Herrera-9
Explain is slow with tables having many columns by legrand legrand
3
by Andres Freund
Multi-second pauses blocking even trivial activity by Patrick Molgaard
9
by Andreas Kretschmer-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
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
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...
1234 ... 160