Postgresql Performance
[Prev Page][Next Page]
- pgsql_tmp( Temporary tablespace),
suhas.basavaraj12
- Savepoints in transactions for speed?,
Mike Blackwell
- Postgres configuration for 8 CPUs, 6 GB RAM,
Syed Asif Tanveer
- SQL performance question,
Niklas Paulsson
- Hints (was Poor performance using CTE),
Craig James
- PostgreSQL strange query plan for my query,
David Popiashvili
- Re: help on slow query using postgres 8.4,
Kevin Grittner
- Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7,
Antti Jokipii
- PQconnectStart/PQconnectPoll,
Sergio Mayoral
- FW: slow query on postgres 8.4,
Russell Keane
- partitioning versus clustering,
Andrew W. Gibbs
- intercepting where clause on a view or other performance tweak,
Russell Keane
- SOLVED - RE: Poor performance using CTE,
David Greco
- Poor performance using CTE,
David Greco
- postgres 8.4, COPY, and high concurrency,
Jon Nelson
- performance regression with 9.2,
Dave Cramer
- PostreSQL v9.2 uses a lot of memory in Windows XP,
Wu Ming
fast read of binary data,
Eildert Groeneveld
Index is not using,
K P Manoj
Planner sometimes doesn't use a relevant index with IN (subquery) condition,
Rafał Rzepecki
parallel query evaluation,
Oliver Seidel
Thousands databases or schemas,
Denis
Unique values across a table of arrays - documents and tags,
Ivan Voras
HT on or off for E5-26xx ?,
David Boreham
Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2,
Rodrigo Rosenfeld Rosas
freebsd or linux,
list, mailing
help with too slow query,
Pedro Jiménez Pérez
DBT-1,
Samrat
- <Possible follow-ups>
- DBT-1,
Revagade, Samrat
Suggested test points for a performance tool?,
Christoffer Lernö
Constraint exclusion in views,
Claudio Freire
pg_buffercache,
pg noob
Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries,
Petr Praus
dbt2 performance regresses from 9.1.6 to 9.2.1,
Dong Ye
Seq scan on big table, episode 2,
Vincenzo Melandri
Invalid memory alloc request size,
Mahavir Trivedi
Re: set-returning calls and overhead,
Jon Nelson
High %SYS CPU usage,
Cesar Martin
Seq scan on 10million record table.. why?,
Vincenzo Melandri
PostgreSQL server failed to start,
vignesh
Slow query, where am I going wrong?,
Andy
How to keep queries low latency as concurrency increases,
Catalin Iacob
Request for help with slow query,
Woolcock, Sean
Replaying 48 WAL files takes 80 minutes,
Albe Laurenz
Prepared statements slow in 9.2 still (bad query plan),
Daniel Burbridge
Slower Performance on Postgres 9.1.6 vs 8.2.11,
robcron
PSA: New Kernels and intel_idle cpuidle Driver!,
Shaun Thomas
BAD performance with enable_bitmapscan = on with Postgresql 9.0.X (X = 3 and 10),
Alberto Marchesini
Setting Statistics on Functional Indexes,
Shaun Thomas
Query-Planer from 6seconds TO DAYS,
Böckler Andreas
<Possible follow-ups>
Re: Query-Planer from 6seconds TO DAYS,
Kevin Grittner
Re: Query-Planer from 6seconds TO DAYS,
Kevin Grittner
Re: Query-Planer from 6seconds TO DAYS,
Kevin Grittner
Re: Query-Planer from 6seconds TO DAYS,
Kevin Grittner
Tons of free RAM. Can't make it go away.,
Shaun Thomas
Connection Options -- SSL already uses compression?,
Karl Denninger
How to upgrade from 9.1 to 9.2 with replication?,
delongboy
Tablespace-derived stats?,
Shaun Thomas
Recursive query gets slower when adding an index,
Thomas Kellerer
Unused index influencing sequential scan plan,
Thom Brown
High cost estimates when n_distinct is set,
Niko Kiirala
Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6,
Maciek Sakrejda
have: seq scan - want: index scan,
Chris Ruprecht
pgbounce max_client_conn and default_pool_size,
Yetkin Öztürk
Have: Seq Scan - Want: Index Scan - what am I doing wrong?,
Chris Ruprecht
limit order by performance issue,
Pedro Jiménez
Support Create package,
Alejandro Carrillo
LIKE op with B-Tree Index?,
Sam Wong
Slow Delete : Seq scan instead of index scan,
Sylvain CAILLET
SELECT AND AGG huge tables,
houmanb
WebSphere Application Server support for postgres,
John Nash
Query with limit goes from few ms to hours,
henk de wit
Index over all partitions (aka global index)?,
Stefan Keller
Do cast affects index usage?,
Anibal David Acosta
Drawbacks of create index where is not null ?,
Franck Routier
hash aggregation,
Korisk
shared_buffers/effective_cache_size on 96GB server,
Strahinja Kustudić
Ways to speed up ts_rank,
Shane Hathaway
Why am I getting great/terrible estimates with these CTE queries?,
Tomas Vondra
Hyperthreading (was: Two identical systems, radically different performance),
Craig James
Two identical systems, radically different performance,
Craig James
- Re: Two identical systems, radically different performance,
Craig James
- Re: Two identical systems, radically different performance,
Craig James
- Re: Two identical systems, radically different performance,
Shaun Thomas
- Re: Two identical systems, radically different performance,
David Thomas
- Re: Two identical systems, radically different performance,
Gavin Flower
- Re: Two identical systems, radically different performance,
Ants Aasma
- Re: Two identical systems, radically different performance,
Andrea Suisani
Re: Two identical systems, radically different performance,
Imre Samu
Re: Two identical systems, radically different performance,
Steve Crawford
Re: Two identical systems, radically different performance,
Evgeny Shishkin
Re: Two identical systems, radically different performance,
Evgeny Shishkin
Re: Two identical systems, radically different performance,
Yeb Havinga
Scaling 10 million records in PostgreSQL table,
Navaneethan R
UPDATE execution time is increasing,
virag
Strange behavior after upgrade from 9.0 to 9.2,
Andrzej Zawadzki
hash aggregation speedup,
Korisk
how to avoid deadlock on masive update with multiples delete,
Anibal David Acosta
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]
