Postgresql Performance
[Prev Page][Next Page]
- PG 9.1 performance loss due to query plan being changed depending on db data (4s vs 200ms),
Rodrigo Rosenfeld Rosas
- Re: How can i find out top high load sql queries in PostgreSQL.,
suhas.basavaraj12
- backend suddenly becomes slow, then remains slow,
Andrew Dunstan
- Why does the number of rows are different in actual and estimated.,
AI Rumman
- Slow queries after vacuum analyze,
Ghislain ROUVIGNAC
- How do I track stats on foreign table access through foreign data wrapper?,
David Crawford
- problem with large inserts,
Lutz Fischer
- Memory issue for inheritance tables.,
Hari Babu
- Limit & offset effect on query plans,
Amitabh Kant
- encouraging index-only scans,
Andrew Dunstan
- track_activity_query_size,
Andrew Dunstan
- Read rows deleted,
Alejandro Carrillo
- hash join vs nested loop join,
Huan Ruan
- Re: hash join vs nested loop join,
Jeff Janes
- <Possible follow-ups>
- Re: hash join vs nested loop join,
Kevin Grittner
- Re: hash join vs nested loop join,
Kevin Grittner
- Re: hash join vs nested loop join,
Kevin Grittner
- Re: hash join vs nested loop join,
Kevin Grittner
- Re: hash join vs nested loop join,
Kevin Grittner
- Re: hash join vs nested loop join,
Kevin Grittner
Occasional timeouts on TRUNCATE and simple INSERTs,
Osborn, Jeff
Do I have a hardware or a software problem?,
Niels Kristian Schjødt
Perform scan on Toast table,
classical_89
Why is PostgreSQL 9.2 slower than 9.1 in my tests?,
Patryk Sidzina
Any idea on how to improve the statistics estimates for this plan?,
Guillaume Smet
Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance,
Shaun Thomas
CREATING INDEX on column having null values,
suhas.basavaraj12
Slow query: bitmap scan troubles,
postgresql
deadlock under load,
Bob Jolliffe
9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL,
Guillaume Cottenceau
Comparative tps question,
John Lister
NEED REPLICATION SOLUTION -POSTGRES 9.1,
suhas.basavaraj12
Optimize update query,
Niels Kristian Schjødt
<Possible follow-ups>
Re: Optimize update query,
Kevin Grittner
Re: Optimize update query,
Kevin Grittner
Re: Optimize update query,
Kevin Grittner
Database design - best practice,
Niels Kristian Schjødt
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
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]