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 (5593)
Replies Last Post Views
Database size 1T but unclear why by Mariel Cherkassky
2
by Justin Pryzby
Fwd: amazon aroura config - seriously overcommited defaults? (May be Off Topic) by Square Bob
3
by Square Bob
Query with high planning time at version 11.1 compared versions 10.5 and 11.0 by Sanyo Moura
22
by Ashutosh Bapat-2
Slow Bitmap Index Scan by Scott Rankin
4
by Alan Hodgson-3
PostgreSQL VS MongoDB: a use case comparison by Fabio Pardi
12
by Oleg Bartunov-3
Re: dsa_allocate() faliure by Jakub Glapa
9
by Alvaro Herrera-9
autovacuum run but last_autovacuum is empty by Mariel Cherkassky
3
by Tom Lane-2
Optimizer choosing the wrong plan by Viswanath
1
by Jeff Janes
explain analyze faster then query by Mariel Cherkassky
3
by Justin Pryzby
Performance impact of updating target columns with unchanged values ON CONFLICT by Abi Noda
4
by Abi Noda
autovacuum is running but pg_stat_all_tables empty by Mariel Cherkassky
0
by Mariel Cherkassky
Re: checkpoint occurs very often when vacuum full running by Justin Pryzby
1
by Mariel Cherkassky
NOT IN vs. NOT EXISTS performance by Lincoln Swaine-Moore
3
by Lincoln Swaine-Moore
Fwd: Query with high planning time compared to execution time by swift1984
7
by swift1984
SCRAM question by Michaeldba@sqlexec.c...
2
by Michael Paquier-2
High CPU Usage of "SET ROLE" by Ulf Lohbr├╝gge
4
by Jeff Janes
Indexes on UUID - Fragmentation Issue by Uday Bhaskar V
4
by Michaeldba@sqlexec.c...
DELETE / UPDATE from partition not optimized (11.0) by Dave E Martin-2
2
by Justin Pryzby
Gained %20 performance after disabling bitmapscan by Yavuz Selim Sertoglu
8
by Jeff Janes
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 James Coleman
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
1234 ... 160