Postgresql Performance
[Prev Page][Next Page]
- Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries, (continued)
- 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
suboptimal query plan,
Nick Hofstede
deadlock_timeout affect on performance,
pg noob
A Tale of 2 algorithms,
Colin Taylor
wrong join result set estimate,
Evgeny Shishkin
NestedLoops over BitmapScan question,
Виктор Егоров
Query plan, nested EXISTS,
Matt Daw
Possible Performance Regression with Transitive Comparisons vs. Constants,
Shaun Thomas
"Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records,
antthelimey
exponential performance decrease, problem with version postgres + RHEL?,
John Nash
hardware advice,
M. D.
Re: hardware advice,
David Boreham
Re: [GENERAL] Memory issues,
Scott Marlowe
Inaccurate Explain Cost,
Robert Sosinski
Same query doing slow then quick,
FFW_Rude
Spurious failure to obtain row lock possible in PG 9.1?,
henk de wit
Postgres becoming slow, only full vacuum fixes it,
Kiriakos Tsourapas
- Re: Postgres becoming slow, only full vacuum fixes it,
Kiriakos Tsourapas
- Re: Postgres becoming slow, only full vacuum fixes it,
Ondrej Ivanič
- Re: Postgres becoming slow, only full vacuum fixes it,
Mark Kirkwood
- <Possible follow-ups>
- Re: Postgres becoming slow, only full vacuum fixes it,
Kevin Grittner
- Re: Postgres becoming slow, only full vacuum fixes it,
Kevin Grittner
- Re: Postgres becoming slow, only full vacuum fixes it,
Kiriakos Tsourapas
Memory issues,
Shiran Kleiderman
PostgreSQL performance on 64 bit as compared to 32 bit,
Umesh Kirdat
Cost of opening and closing an empty transaction,
Jon Leighton
Newbie performance problem - semop taking most of time ?,
mal.oracledba
Query Planner Optimization?,
Brandon
problems with large objects dump,
Sergio Gabriel Rodriguez
Remote access to Postgresql slow,
Manoj Agarwal
Setting autovacuum_vacuum_scale_factor to 0 a good idea ?,
Sébastien Lorion
wal_sync_method on FreeBSD 9.0 - ZFS,
Sébastien Lorion
Are there known performance issues with defining all Foreign Keys as deferrable initially immediate,
McKinzie, Alan (Alan)
20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets,
Nikolay Ulyanitsky
AppScale backend datastore (NoSQL again kind of),
Ross Reedstrom
Guide to Posting Slow Query Questions,
Jeff Janes
add column with default value is very slow,
AI Rumman
force defaults,
Willy-Bas Loos
Planner selects different execution plans depending on limit,
bill_martin
: PostgreSQL Index behavior,
Venkat Balaji
libpq or postgresql performance,
Aryan Ariel Rodriguez Chalas
HELP!!!-----Need to Sql commands to monitoring Postgresql,
charles_xie
query performance, where goes time?,
Anibal David Acosta
Inserts in 'big' table slowing down the database,
Stefan Keller
JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem,
Eileen
exponential performance decrease in ISD transaction,
John Nash
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]
