Messages by Thread
-
-
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
-
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
-
Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit
Achilleas Mantzios
-
Multixact wraparound monitoring
bruno da silva
-
Planning time is time-consuming
Mikhail Balayan
-
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
-
Re: Slow query, possibly not using index
Tom Lane
-
Re: Slow query, possibly not using index
Les
-
Re: Slow query, possibly not using index
Wael Khobalatte
-
Re: Slow query, possibly not using index
Tom Lane
-
Re: Slow query, possibly not using index
Les
-
Re: Slow query, possibly not using index
Les
-
Re: Slow query, possibly not using index
Les
-
Re: Slow query, possibly not using index
Pavel Stehule
-
Re: Slow query, possibly not using index
David Rowley
-
Re: Slow query, possibly not using index
Les
-
Question regarding writes when locking rows
Martin Querleu
-
slow delete
Les
-
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