Архив рассылок [pgsql-performance]
Re: Using EXECUTE in a function Merlin Moncure
Re: TRUNCATE TABLE Adriaan van Os
Re: TRUNCATE TABLE Kevin Grittner
RES: Improving select peformance Carlos H. Reimer
Re: TRUNCATE TABLE Alvaro Herrera
Re: RES: Improving select peformance Alvaro Herrera
Re: select on 1milion register = 6s Jan Dittmer
Re: Postgres configuration for 64 CPUs, 128 GB RAM... Luke Lonergan
RES: RES: Improving select peformance Carlos H. Reimer
cpu throttling Bryan Murphy
Re: cpu throttling Alan Hodgson
Re: cpu throttling Bryan Murphy
RES: RES: Improving select peformance Carlos H. Reimer
Postgres optimizer Mouhamadou Dia
Re: Postgres optimizer Mark Lewis
CLOG Patch Jignesh K. Shah
Re: CLOG Patch Simon Riggs
Re: cpu throttling Decibel!
RES: RES: RES: Improving select peformance Carlos H. Reimer
Default Performance between 8.0 and 8.1 Ted Jordan
Re: TRUNCATE TABLE Adriaan van Os
Re: Performance problems with large telemetric datasets
on 7.4.2 Heikki Linnakangas
Re: Default Performance between 8.0 and 8.1 Merlin Moncure
Re: TRUNCATE TABLE Decibel!
Extreme slow select query 8.2.4 Henrik Zagerholm
Re: Performance problems with large telemetric datasets
on 7.4.2 Heikki Linnakangas
Planner making wrong decisions 8.2.4. Insane cost calculations. Henrik Zagerholm
Re: Planner making wrong decisions 8.2.4. Insane cost calculations. Henrik Zagerholm
Re: Extreme slow select query 8.2.4 Tom Lane
Re: Extreme slow select query 8.2.4 Henrik Zagerholm
Re: Default Performance between 8.0 and 8.1 Ted Jordan
Re: TRUNCATE TABLE Tom Lane
Re: Extreme slow select query 8.2.4 Heikki Linnakangas
Re: Extreme slow select query 8.2.4 Henrik Zagerholm
Update table performance Mark Makarowsky
Re: Update table performance Richard Huxton
Re: Update table performance Scott Marlowe
Re: Update table performance Alan Hodgson
Re: Update table performance Decibel!
Re: Update table performance Chris Browne
Re: Update table performance Scott Marlowe
Re: Update table performance Decibel!
Re: Update table performance Mark Makarowsky
Re: Update table performance Erik Jones
Re: Update table performance Heikki Linnakangas
Re: Update table performance Erik Jones
Re: Update table performance Decibel!
Re: When/if to Reindex Vivek Khera
Re: When/if to Reindex Steven Flatt
Re: When/if to Reindex Bill Moran
How to ENABLE SQL capturing??? smiley2211
Re: How to ENABLE SQL capturing??? Steinar H. Gunderson
Re: When/if to Reindex Decibel!
Re: How to ENABLE SQL capturing??? Bryan Murphy
Re: When/if to Reindex Tom Lane
Re: mid 2007 "best bang for the buck" hardware opinions Scott Marlowe
Re: Update table performance Merlin Moncure
Re: When/if to Reindex Bill Moran
Re: Update table performance Michael Stone
Re: Update table performance Trevor Talbot
Re: When/if to Reindex Steven Flatt
Re: Update table performance Decibel!
Dell Hardware Recommendations Joe Uhl
Re: Dell Hardware Recommendations Decibel!
Re: Dell Hardware Recommendations Merlin Moncure
Re: Dell Hardware Recommendations Decibel!
Re: Dell Hardware Recommendations Arjen van der Meijden
Re: Dell Hardware Recommendations Scott Marlowe
Re: Dell Hardware Recommendations Decibel!
Re: Dell Hardware Recommendations Greg Smith
Re: Update table performance Kenneth Marshall
Performance on writable views Enrico Weigelt
Re: select count(*) performance slawekj
Re: Update table performance Piotr Kołaczkowski
Implementing an regex filter Enrico Weigelt
Re: Dell Hardware Recommendations david@lang.hm
Re: Dell Hardware Recommendations Merlin Moncure
Re: Dell Hardware Recommendations Merlin Moncure
Re: select count(*) performance Merlin Moncure
Re: select count(*) performance Brian Hurt
Re: Dell Hardware Recommendations Merlin Moncure
Re: How to ENABLE SQL capturing??? smiley2211
Re: CLOG Patch Jignesh K. Shah
Re: Help optimize view Relyea, Mike
Bitmap Index Scan optimization opportunity Kevin Grittner
Re: Dell Hardware Recommendations Vivek Khera
Re: CLOG Patch Simon Riggs
Re: Bitmap Index Scan optimization opportunity Heikki Linnakangas
Re: Dell Hardware Recommendations Merlin Moncure
Re: Dell Hardware Recommendations Joel Fradkin
Re: How to ENABLE SQL capturing??? Jeff Frost
Re: Help optimize view Tom Lane
Re: How to ENABLE SQL capturing??? smiley2211
Re: How to ENABLE SQL capturing??? Joshua D. Drake
Re: Performance on writable views Heikki Linnakangas
Re: Performance on writable views Joshua D. Drake
Re: select count(*) performance Kevin Grittner
Re: Dell Hardware Recommendations Vivek Khera
Re: select count(*) performance Kevin Grittner
Re: How to ENABLE SQL capturing??? Jonathan Ellis
Re: Help optimize view Relyea, Mike
Re: How to ENABLE SQL capturing??? Joshua D. Drake
Re: How to ENABLE SQL capturing??? Gregory Stark
Re: How to ENABLE SQL capturing??? Joshua D. Drake
Re: Help optimize view Kevin Grittner
Re: Help optimize view Relyea, Mike
Proposal: Pluggable Optimizer Interface Julius Stroffek
Re: Help optimize view Kevin Grittner
Re: Help optimize view Tom Lane
Re: [HACKERS] Proposal: Pluggable Optimizer Interface Stefan Kaltenbrunner
Stable function optimisation Philipp Specht
Re: Help optimize view Relyea, Mike
Re: Stable function optimisation Tom Lane
Re: Help optimize view Kevin Grittner
Re: [HACKERS] Proposal: Pluggable Optimizer Interface Julius Stroffek
Re: Performance on writable views Jim Nasby
Re: Help optimize view Kevin Grittner
Re: Dell Hardware Recommendations Dave Cramer
Indexscan is only used if we use "limit n" Sebastián Baioni
Re: Indexscan is only used if we use "limit n" Alvaro Herrera
Re: Stable function optimisation Philipp Specht
Integrated perc 5/i Michael Ben-Nes
Re: Integrated perc 5/i Merlin Moncure
Bad planner decision - bitmap scan instead of index Frank Schoep
Re: Integrated perc 5/i Steinar H. Gunderson
Re: Integrated perc 5/i Michael Ben-Nes
Re: Integrated perc 5/i Luke Lonergan
Re: Integrated perc 5/i Steinar H. Gunderson
Re: Integrated perc 5/i Decibel!
Re: Integrated perc 5/i tyrrill_ed@emc.com
Re: Integrated perc 5/i Merlin Moncure
Re: Integrated perc 5/i Scott Marlowe
Re: Integrated perc 5/i Decibel!
Re: Indexscan is only used if we use "limit n" Josh Berkus
Re: Integrated perc 5/i Luke Lonergan
Re: Bad planner decision - bitmap scan instead of index hubert depesz lubaczewski
Re: Bad planner decision - bitmap scan instead of index Michael Stone
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
Stable function optimisation Philipp Specht
Help optimize view Relyea, Mike
Re: select count(*) performance Detlef Rudolph
Raid Configurations Robert D Oden
Performance Solaris vs Linux Fredrik Bertilsson
Fwd: Table Partitioning Nurlan Mukhanov
Re: Raid Configurations Merlin Moncure
Re: select count(*) performance Scott Marlowe
Re: Simple select hangs while CPU close to 100% - Analyze Alvaro Herrera
Re: Performance Solaris vs Linux Alvaro Herrera
Re: Performance Solaris vs Linux Chris Mair
Re: Fwd: Table Partitioning Henrik
Re: Help optimize view Kevin Grittner
Re: Help optimize view Kevin Grittner
schema design question mark overmeer
Re: schema design question Adam Tauno Williams
Re: schema design question mark overmeer
Re: schema design question David Fetter
Re: schema design question Steinar H. Gunderson
Re: schema design question David Fetter
Re: [pgsql-jobs] Looking for database hosting Andrew Hammond
Re: schema design question mark overmeer
Re: [pgsql-jobs] Looking for database hosting Luke Lonergan
Re: schema design question David Fetter
Re: schema design question Steinar H. Gunderson
Re: Looking for database hosting: FIX CC LIST!! Josh Berkus
Re: [pgsql-jobs] Looking for database hosting Leon Mergen
Re: schema design question Adam Tauno Williams
Re: [pgsql-jobs] Looking for database hosting Andrew Hammond
Re: Help optimize view Relyea, Mike
Terminology Question Campbell, Lance
Re: Terminology Question Scott Marlowe
Re: Terminology Question Joshua D. Drake
Re: Performance Solaris vs Linux Julius Stroffek
Autovacuum is running forever Sachchida Ojha
Re: Autovacuum running forever Sachchida Ojha
Re: Autovacuum is running forever Michael Glaesemann
Re: Autovacuum is running forever Sachchida Ojha
Re: Autovacuum running forever Scott Marlowe
Re: Autovacuum is running forever Sachchida Ojha
Re: Autovacuum is running forever Alvaro Herrera
Re: Autovacuum is running forever Sachchida Ojha
Re: Autovacuum is running forever Scott Marlowe
Re: Autovacuum is running forever Scott Marlowe
Re: Autovacuum is running forever Scott Marlowe
Re: Autovacuum is running forever Sachchida Ojha
Re: Autovacuum is running forever Scott Marlowe
Re: Autovacuum is running forever Scott Marlowe
Optimising "in" queries Stephen Davies
Poor Performance after Upgrade Ben Perrault
Re: Optimising "in" queries Scott Marlowe
Re: Poor Performance after Upgrade Steinar H. Gunderson
Re: Poor Performance after Upgrade Russell Smith
Re: Optimising "in" queries Russell Smith
Re: Optimising "in" queries Michael Glaesemann
io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
Re: io storm on checkpoints, postgresql 8.2.4, linux Joshua D. Drake
Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
Re: Fast tsearch2, trigram matching on short phrases Steinar H. Gunderson
Re: When/if to Reindex Steven Flatt
Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov
Re: Optimising "in" queries Kevin Grittner
Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov
Long running transaction in pg_activity_log Sachchida Ojha
Re: Long running transaction in pg_activity_log Sachchida Ojha
Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
Re: Long running transaction in pg_activity_log Tobias Brox
Re: Long running transaction in pg_activity_log Farhan Mughal
Re: When/if to Reindex Gregory Stark
Re: Optimising "in" queries Michael Glaesemann
Re: Optimising "in" queries Russell Smith
Re: Optimising "in" queries Russell Smith
asynchronous commit feature Merlin Moncure
Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
Installing PostgreSQL Campbell, Lance
Re: Installing PostgreSQL Richard Huxton
long-running query - needs tuning Kevin Kempter
Re: Installing PostgreSQL Campbell, Lance
Re: Installing PostgreSQL Greg Smith
Re: Installing PostgreSQL Richard Huxton
Re: Installing PostgreSQL Campbell, Lance
Re: Optimising "in" queries Stephen Davies
deadlock_timeout parameter in Postgresql.cof Sachchida Ojha
deadlock_timeout parameter in Postgresql.cof Sachchida Ojha
Re: Optimising "in" queries Alvaro Herrera
Re: Raid Configurations Decibel!
Re: When/if to Reindex Steven Flatt
Re: Optimising "in" queries Tom Lane
Re: When/if to Reindex Tom Lane
Re: When/if to Reindex Mark Kirkwood
Re: When/if to Reindex Gregory Stark
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
Re: When/if to Reindex Steven Flatt
Re: When/if to Reindex Tom Lane
Re: When/if to Reindex Steven Flatt
Re: When/if to Reindex Tom Lane
Re: When/if to Reindex Steven Flatt
significant vacuum issues - looking for suggestions Kevin Kempter
Re: When/if to Reindex Gregory Stark
Re: significant vacuum issues - looking for
suggestions Kevin Grittner
Re: When/if to Reindex Tom Lane
Re: significant vacuum issues - looking for suggestions Kevin Kempter
Shared memory usage Max Zorloff
Re: [GENERAL] Shared memory usage Martijn van Oosterhout
Re: [GENERAL] Shared memory usage Max Zorloff
Re: [GENERAL] Shared memory usage Max Zorloff
Re: Shared memory usage Adam Tauno Williams
Postgres performance problem Ruben Rubio
Re: Shared memory usage Max Zorloff
Re: Postgres performance problem Chris Mair
Re: Postgres performance problem ruben@rentalia.com
Re: partitioned table and ORDER BY indexed_field DESC
LIMIT 1 Tomas Tamosaitis
Re: Postgres performance problem Bill Moran
Performance issue Willo van der Merwe
Re: Performance issue Bill Moran
Re: Performance issue Tom Lane
Re: asynchronous commit feature Decibel!
Re: asynchronous commit feature Merlin Moncure
Re: significant vacuum issues - looking for
suggestions Kevin Grittner
Re: significant vacuum issues - looking for suggestions Kevin Kempter
Re: significant vacuum issues - looking for suggestions Kevin Kempter
Re: significant vacuum issues - looking for suggestions Kevin Kempter
server performance issues - suggestions for tuning Kevin Kempter
Re: server performance issues - suggestions for tuning Richard Huxton
Re: Performance issue Willo van der Merwe
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
Re: server performance issues - suggestions for
tuning Kevin Grittner
Re: server performance issues - suggestions for tuning Andrew Sullivan
Re: server performance issues - suggestions for tuning Scott Marlowe
Re: Autovacuum is running forever Sachchida Ojha
Re: Optimising "in" queries Stephen Davies
Re: io storm on checkpoints, postgresql 8.2.4, linux Kenneth Marshall
Re: Optimising "in" queries Stephen Davies
Performance issue Willo van der Merwe
Bitmap Heap Scan before using index GOERGLER Paul
8.2.4 Chooses Bad Query Plan Pallav Kalva
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) Scott Marlowe
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) Joshua D. Drake
Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Kevin Grittner
Fwd: 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) Evan Carroll
Re: index & Bitmap Heap Scan Tom Lane
Re: Postgres performance problem Anton Melser
Re: 8.2.4 Chooses Bad Query Plan Tom Lane
Re: 8.2.4 Chooses Bad Query Plan Pallav Kalva
Re: 8.2.4 Chooses Bad Query Plan Tom Lane
Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas
Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas
Performance issue with nested loop Jens Reufsteck
Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll
Performance issue with nested loop Jens Reufsteck
LIKE query verses = Karthikeyan Mahadevan
Re: Performance across multiple schemas Robins Tharakan
Re: LIKE query verses = Mark Lewis
Re: LIKE query verses = Tom Lane
Re: Shared memory usage Greg Smith
Transaction Log mbguy2000-1@yahoo.com
Transaction Log Markus Benne
Re: Transaction Log Mark Mielke
Re: Transaction Log Steve Atkins
Re: Transaction Log Steinar H. Gunderson
Re: Transaction Log Bill Moran
Re: Transaction Log Alan Hodgson
Re: Shared memory usage Max Zorloff
Re: Postgres performance problem ruben@rentalia.com
Re: [Solved] Postgres performance problem Ruben Rubio
Re: [Solved] Postgres performance problem Mark Lewis
Re: [Solved] Postgres performance problem Richard Huxton
8.2 Autovacuum BUG ? Pallav Kalva
Re: 8.2 Autovacuum BUG ? Tom Lane
Re: 8.2 Autovacuum BUG ? Pallav Kalva
Re: 8.2 Autovacuum BUG ? Alvaro Herrera
Re: 8.2 Autovacuum BUG ? Pallav Kalva
Re: 8.2 Autovacuum BUG ? Mark Lewis
Re: 8.2 Autovacuum BUG ? Chris Browne
Re: 8.2 Autovacuum BUG ? Mikko Partio
Re: 8.2 Autovacuum BUG ? Pallav Kalva
Re: 8.2 Autovacuum BUG ? Alvaro Herrera
Re: 8.2 Autovacuum BUG ? Alvaro Herrera
Re: 8.2 Autovacuum BUG ? Tom Lane
Re: 8.2 Autovacuum BUG ? Erik Jones
Re: [Solved] Postgres performance problem Vivek Khera
Re: 8.2 Autovacuum BUG ? Tom Lane
Re: 8.2 Autovacuum BUG ? Chris Browne
Re: 8.2 Autovacuum BUG ? Greg Smith
Re: 8.2 Autovacuum BUG ? Tom Lane
