Postgresql Performance
[Prev Page][Next Page]
- Re: Tuning for warm standby, (continued)
- Difference in query plan when using = or > in where clause,
Radhika S
- Incorrect row estimates in plan?,
pgdba
- Attempting to disable count triggers on cleanup,
Dave Cramer
- Acceptable level of over-estimation?,
Carlo Stonebanks
- TEXT or LONGTEXT?,
Fabiola Fernández
- select count(*) performance (vacuum did not help),
Gábor Farkas
- zero value in statistics collector's result,
Yinan Li
- Possible explanations for catastrophic performace deterioration?,
Carlos Moreno
- Query planner unaware of possibly best plan,
Denes Daniel
- Searching for the cause of a bad plan,
Csaba Nagy
Linux mis-reporting memory,
Decibel!
query io stats and finding a slow query,
Kamen Stanev
Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!,
smiley2211
REPOST: Performance improves only after repeated VACUUM/ANALYZE,
Carlo Stonebanks
REPOST: Nested loops row estimates always too high,
Carlo Stonebanks
Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
Heikki Linnakangas
- Re: Low CPU Usage,
Mark Lewis
- <Possible follow-ups>
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
- Re: Low CPU Usage,
brauagustin-susc
Tablespaces and NFS,
Carlos Moreno
Query works when kludged, but would prefer "best practice" solution,
Carlo Stonebanks
DELETE queries slow down,
Galantucci Giovanni
Regarding COPY command from Postgres 8.2.0,
soni de
Index files,
Harsh Azad
Long Running Commits - Not Checkpoints,
Brad Nicholson
Clustered tables improves perfs ?,
Patrice Castet
Index usage when bitwise operator is used,
W.Alphonse HAROUNY
db performance/design question,
Matt Chambers
pg_dump blocking create database?,
Dan Harris
efficient pattern queries (using LIKE, ~),
Fernan Aguero
500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running,
El-Lotso
More Vacuum questions...,
Kevin Kempter
Barcelona vs Tigerton,
Mindaugas
[Again] Postgres performance problem,
Ruben Rubio
What to vacuum after deleting lots of tables,
Craig James
random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1,
Carlo Stonebanks
DRBD and Postgres: how to improve the perfomance?,
Maila Fatticcioni
postgres memory management issues?,
Richard Yen
How planner decides left-anchored LIKE can use index,
Carlo Stonebanks
Reasonable amount of indices,
Patric
Re: [ADMIN] ADO -PostgreSQL OLE DB Provider,
Richard Broersma Jr
Re: Hardware spec],
Jean-David Beyer
SAN vs Internal Disks,
Harsh Azad
Hardware spec,
Willo van der Merwe
utilising multi-cpu/core machines?,
Thomas Finneid
RESEND:Postgres with Sun Cluster HA/Solaris 10,
Subbiah Stalin-XCGF84
Re : optimize query with a maximum(date) extraction,
JS Ubei
optimize query with a maximum(date) extraction,
JS Ubei
Re: optimize query with a maximum(date) extraction,
Gregory Stark
Re: optimize query with a maximum(date) extraction,
Dimitri
Performance on 8CPU's and 32GB of RAM,
Carlo Stonebanks
join tables vs. denormalization by trigger,
Walter Mauritz
About autovacuum,
Jean-David Beyer
Vacum Analyze problem,
rafael
schemas to limit data access,
Brennan, Sean (IMS)
8.2 Autovacuum BUG ?,
Pallav Kalva
- Re: 8.2 Autovacuum BUG ?,
Tom Lane
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Sergei Kornilov
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Andreas Kretschmer
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Andreas Kretschmer
- Message not available
- Message not available
- Message not available
- Message not available
- Message not available
- Message not available
- Re: 8.2 Autovacuum BUG ?,
Pavan Teja
- Re: 8.2 Autovacuum BUG ?,
David G. Johnston
- Re: 8.2 Autovacuum BUG ?,
Andreas Kretschmer
- Re: 8.2 Autovacuum BUG ?,
Claudio Freire
- Re: 8.2 Autovacuum BUG ?,
Pavan Teja
- Re: 8.2 Autovacuum BUG ?,
Claudio Freire
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Claudio Freire
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Claudio Freire
- Re: 8.2 Autovacuum BUG ?,
Pavan Teja
- Re: 8.2 Autovacuum BUG ?,
David G. Johnston
- Re: 8.2 Autovacuum BUG ?,
Alvaro Herrera
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Alvaro Herrera
- Re: 8.2 Autovacuum BUG ?,
Pavan Teja
- Re: 8.2 Autovacuum BUG ?,
Pavan Teja
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
Claudio Freire
- Re: 8.2 Autovacuum BUG ?,
pavan95
- Re: 8.2 Autovacuum BUG ?,
pavan95
Transaction Log,
mbguy2000-1
LIKE query verses =,
Karthikeyan Mahadevan
Performance issue with nested loop,
Jens Reufsteck
Performance problem with table containing a lot of text (blog),
Kari Lavikka
8.2 Query 10 times slower than 8.1 (view-heavy),
Evan Carroll
Re: 8.2 Query 10 times slower than 8.1 (view-heavy),
Gregory Stark
Re: 8.2 Query 10 times slower than 8.1 (view-heavy),
Kevin Grittner
<Possible follow-ups>
Re: 8.2 Query 10 times slower than 8.1 (view-heavy),
Evan Carroll
8.2.4 Chooses Bad Query Plan,
Pallav Kalva
Bitmap Heap Scan before using index,
GOERGLER Paul
Performance across multiple schemas,
Robins
index & Bitmap Heap Scan,
Paul
server performance issues - suggestions for tuning,
Kevin Kempter
Performance issue,
Willo van der Merwe
Postgres performance problem,
Ruben Rubio
Shared memory usage,
Max Zorloff
Partioning tsearch2 a table into chunks and accessing via views,
Benjamin Arai
significant vacuum issues - looking for suggestions,
Kevin Kempter
partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Anton
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Mikko Partio
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Tomas Tamosaitis
- <Possible follow-ups>
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Luke Lonergan
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Simon Riggs
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Gregory Stark
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Luke Lonergan
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Mark Kirkwood
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Gregory Stark
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Luke Lonergan
- hardware and For PostgreSQL,
Ketema Harris
- Re: hardware and For PostgreSQL,
Scott Marlowe
- Re: hardware and For PostgreSQL,
Ben
- Re: hardware and For PostgreSQL,
Joe Uhl
- Re: hardware and For PostgreSQL,
Ron St-Pierre
- Re: hardware and For PostgreSQL,
Paul Lambert
- Re: hardware and For PostgreSQL,
Magnus Hagander
- Re: hardware and For PostgreSQL,
Joe Uhl
- libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Alvaro Herrera
- Re: libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Alvaro Herrera
- Re: libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Alvaro Herrera
- Re: libgcc double-free, backend won't die,
Craig James
- Message not available
- Re: libgcc double-free, backend won't die,
Alvaro Herrera
- Re: libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Magnus Hagander
- Re: libgcc double-free, backend won't die,
Tom Lane
- Re: libgcc double-free, backend won't die,
Joshua D. Drake
- Re: libgcc double-free, backend won't die,
Tom Lane
- Re: libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Gregory Stark
- Re: libgcc double-free, backend won't die,
James Mansion
- Re: libgcc double-free, backend won't die,
Tom Lane
- Re: libgcc double-free, backend won't die,
Gregory Stark
- Re: libgcc double-free, backend won't die,
Craig James
- Re: libgcc double-free, backend won't die,
Gregory Stark
- Re: libgcc double-free, backend won't die,
James Mansion
- Re: libgcc double-free, backend won't die,
Bruce Momjian
- Multi-threading friendliness (was: libgcc double-free, backend won't die),
Craig James
- Re: Multi-threading friendliness,
James Mansion
- Re: libgcc double-free, backend won't die,
Tom Lane
- Re: libgcc double-free, backend won't die,
Tom Lane
- Re: hardware and For PostgreSQL,
Joshua D. Drake
- Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Tom Lane
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1,
Luke Lonergan
deadlock_timeout parameter in Postgresql.cof,
Sachchida Ojha
long-running query - needs tuning,
Kevin Kempter
[Index of Archives]
[Postgresql Home]
[Postgresql General]
[PHP on Windows]
[Yosemite News]
