Postgresql Performance
[Prev Page][Next Page]
- Separate 100 M spatial data in 100 tables VS one big table,
kimaidou
- Re: Is partition pruning impacted by data type,
sud
- Table Partitioning and Indexes Performance Questions,
David Kelly
- generic plan generate poor performance,
James Pang
- extend statistics help reduce index scan a lot of shared buffer hits.,
James Pang
- Optimizing count(), but Explain estimates wildly off,
Chema
- sql statement not using all primary key values and poor performance,
James Pang
- "not related" code blocks for removal of dead rows when using vacuum and this kills the performance,
Lars Aksel Opsahl
- PostgreSQL doesn't use index-only scan if there is an expression in index,
Pavel Kulakov
- Simple JOIN on heavy table not using expected index,
kimaidou
- Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards.,
Daniel Blanch Bataller
- huge SubtransSLRU and SubtransBuffer wait_event,
James Pang (chaolpan)
Slow query in table where many rows were deleted. VACUUM FULL fixes it,
Pavlos Kallis
I don't understand that EXPLAIN PLAN timings,
Jean-Christophe Boggio
Why is a sort required for this query? (IS NULL predicate on leading key column),
Jerry Brenner
Selection not "pushed down into" CTE,
Clemens Eisserer
Questions about "Output" in EXPLAIN ANALYZE VERBOSE,
Jerry Brenner
Slow GroupAggregate and Sort,
Darwin Correa
Need help with performance tuning pg12 on linux,
Wilson, Maria Louise (LARC-E301)[RSES]
Parallel hints in PostgreSQL with consistent perfromance,
mohini mane
Which side of a Merge Join gets executed first? Do both sides always get executed?,
Jerry Brenner
2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers?,
Jerry Brenner
Question about semantics of $ variables in json explain plans in 13,
Jerry Brenner
Include a timestamp in future versions of pg_stat_statements when when a query entered the cache?,
Jerry Brenner
Does Postgres have consistent identifiers (plan hash value) for explain plans?,
Jerry Brenner
Strange "actual time" in simple CTE,
Jean-Christophe Boggio
Performance degradation with CTEs, switching from PG 11 to PG 15,
Jean-Christophe Boggio
[no subject],
Gulp
simple query running long time within a long transaction.,
James Pang (chaolpan)
Awkward Join between generate_series and long table,
Lincoln Swaine-Moore
GIN JSONB path index is not always used,
Tomasz Szymański
Underestimated number of output rows with an aggregate function,
Philippe BEAUDOIN
Postgres 15 SELECT query doesn't use index under RLS,
Alexander Okulovich
Unexpected termination looping over table.,
Matt Gibbins
Dirty reads on index scan,,
Koen De Groote
pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Achilleas Mantzios - cloud
- Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Tom Lane
- Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Achilleas Mantzios
- Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Tom Lane
- Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Achilleas Mantzios
- Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit,
Thomas Munro
Multixact wraparound monitoring,
bruno da silva
Planning time is time-consuming,
Mikhail Balayan
Re: Planning time is time-consuming,
David Rowley
Re: Planning time is time-consuming,
Imre Samu
query pg_stat_ssl hang 100%cpu,
James Pang (chaolpan)
Join order optimization,
Christian Beikov
Queries containing ORDER BY and LIMIT started to work slowly,
Rondat Flyag
Range partitioning query performance with date_trunc (vs timescaledb),
Philippe Pepiot
Index bloat and REINDEX/VACUUM optimization for partial index,
jayaprabhakar k
Slow query, possibly not using index,
Les
Question regarding writes when locking rows,
Martin Querleu
Partitioning update-heavy queue with hash partitions vs partial indexes,
Dorian Hoxha
Function call very slow from JDBC/java but super fast from DBear,
An, Hongguo (CORP)
Plan weirdness. A sort produces more rows than the node beneath it,
Dane Foster
Table copy with SERIALIZABLE is incredibly slow,
peter plachta
Results of experiments with UUIDv7, UUIDv8,
peter plachta
TOAST Fields serialisation/deserialization performance,
Piyush Katariya
Entire index scanned, but only when in SQL function?,
Philip Semanchuk
Performance implications of 8K pread()s,
Dimitrios Apostolou
Why is query performance on RLS enabled Postgres worse?,
Akash Anand
Fwd: Helping planner to chose sequential scan when it improves performance,
Patrick O'Toole
Index on (fixed size) bytea value,
Les
Merge David and Goliath tables efficiently,
Nicolas Paris
extended statistics n-distinct on multiple columns not used when join two tables,
James Pang (chaolpan)
Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT,
benoit
Postgresql equal join on function with columns not use index,
James Pang (chaolpan)
wrong rows estimation by hash join,
James Pang (chaolpan)
Weird behavior of INSERT QUERY,
Satalabaha Postgres
Understand time taken by individual SQL statements in a procedure,
Satalabaha Postgres
thousands of CachedPlan entry per backend,
James Pang (chaolpan)
How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server,
Sergio Rus
Unaccounted regression from postgresql 11 in later versions,
Bob Jolliffe
PostgreSQL performance on ARM i.MX6,
Druckenmueller, Marc
Connection drops on postgres 11.16,
aditya desai
Fsync IO issue,
ProfiVPS Support
Performance issues in query with multiple joins,
Παρασκευη Πασσαρη
How do Monitoring tools capture explain plan of a query,
kunwar singh
What is equivalent of v$sesstat and v$sql_plan in postgres?,
kunwar singh
High QPS, random index writes and vacuum,
peter plachta
speeding up grafana sensor-data query on raspberry pi 3,
Clemens Eisserer
Postgres Metrics,
André Rodrigues
Is there any tool which will help me run and explain analyze about 150 queries?,
kunwar singh
Query unable to utilize index without typecast to fixed length character,
ahi
Why are commits consuming most of the database time?,
Tim Slechta
Explain plan shows fewer shared blocks when index+table compared to index alone?,
Amin Jaffer
multicolumn partitioning help,
James Robertson
Huge Tables,
André Rodrigues
Planner choosing nested loop in place of Hashjoin,
Praneel Devisetty
INSERT statement going in IPC Wait_event,
aditya desai
BRIN index worse than sequential scan for large search set,
Mickael van der Beek
Connection forcibly closed remote server error.,
aditya desai
Performance of UPDATE operation,
Mkrtchyan, Tigran
For loop execution times in PostgreSQL 12 vs 15,
Adithya Kumaranchath
max_wal_senders,
Rick Otten
Window Functions & Table Partitions,
Benjamin Tingle
Domain check taking place unnecessarily?,
Mark Hills
Routing & Concurrency with trigger functions,
chanukya SDS
Getting an index scan to be a parallel index scan,
Alex Kaiser
Database Stalls,
Mok
Re: Database Stalls,
Craig Jackson
LIKE CLAUSE on VIEWS,
aditya desai
ALTER STATEMENT getting blocked,
aditya desai
change the default value of enable_bitmapscan to off,
hehaochen@xxxxxxxxxxx
Advice on best way to store a large amount of data in postgresql,
spiral
Max write throughput for single COPY,
Joe Wildish
How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits),
Maxim Boguk
When you really want to force a certain join type?,
Gunther Schadow
temp_file_limit?,
Frits Jalvingh
Postgres12 looking for possible HashAggregate issue workarounds?,
João Paulo Luís
JSON down performacen when id:1,
Render Comunicacion S.L.
time sorted UUIDs,
Tim Jones
DML sql execution time slow down PGv14 compared with PGv13,
James Pang (chaolpan)
creating hash indexes,
Rick Otten
Increased iowait and blk_read_time with higher shared_buffers,
Jordan Hurwich
wrong rows and cost estimation when generic plan,
James Pang
Message not available
sort performance better with little memory than big memory,
yang zhao
Odd Choice of seq scan,
Paul McGarry
Geometric types row estimation,
Igor ALBUQUERQUE SILVA
Catching up with performance & PostgreSQL 15,
Josh Berkus
Need suggestion to set-up RDS alerts on GP3 volumes,
Sengottaiyan T
why choosing an hash index instead of the btree version even if the cost is lower?,
Luca Ferrari
When can joins be avoided?,
Stefan Fehrenbach
Help needed with perf tests on subtransaction overflow,
Simon Riggs
=ANY(ARRAY) vs =ANY(ARRAY(expr)) performance,
Ramdip Gill
ogr2ogr slow sql when checking system tables for column info and so on.,
Lars Aksel Opsahl
Explain returns different number of rows,
Vince McMahon
Identify root-cause for intermittent spikes,
Sengottaiyan T
Milions of views - performance, stability,
Hubert Rutkowski
Query is sometimes fast and sometimes slow: what could be the reason?,
tiaswin
Faster more low-level methods of having hot standby / secondary read-only servers?,
Gunther Schadow
Postgresql JDBC process consumes more memory than psql client,
James Pang (chaolpan)
Select on partitioned table is very slow,
Jose Osinde
pgbench: could not connect to server: Resource temporarily unavailable,
Kevin McKibbin
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]