Архив рассылок [pgsql-performance]
SSD Drives Greg Stark
Page Miss Hits Ioannis Theoharis
No index usage with "left join" mailing@impactmedia.de
Re: No index usage with "left join" Leeuw van der, Tim
What kind of performace can I expect and how to measure? Joost Kraaijeveld
Re: What kind of performace can I expect and how to measure? Merlin Moncure
Re: No index usage with G u i d o B a r o s i o
Re: No index usage with "left join" Rod Taylor
Re: What kind of performace can I expect and how to measure? Joost Kraaijeveld
Re: No index usage with Bruce Momjian
Re: No index usage with "left join" Tom Lane
Re: What kind of performace can I expect and how to measure? Merlin Moncure
Re: No index usage with "left join" Scott Marlowe
Re: What kind of performace can I expect and how to Scott Marlowe
Re: Page Miss Hits Scott Marlowe
Re: Page Miss Hits Gaetano Mendola
Re: Page Miss Hits Gaetano Mendola
Re: my boss want to migrate to ORACLE Stephane Tessier
Re: Page Miss Hits Rod Taylor
Re: my boss want to migrate to ORACLE James Thornton
Re: my boss want to migrate to ORACLE Stephane Tessier
Re: Page Miss Hits Gaetano Mendola
Re: my boss want to migrate to ORACLE markir@coretech.co.nz
Re: my boss want to migrate to ORACLE Scott Marlowe
NOT IN query takes forever Marius Andreiana
pg_autovacuum parameters Lending, Rune
Re: NOT IN query takes forever Merlin Moncure
Re: NOT IN query takes forever Stephan Szabo
Re: pg_autovacuum parameters Matthew T. O'Connor
Re: NOT IN query takes forever Tom Lane
Re: NOT IN query takes forever Marius Andreiana
Re: NOT IN query takes forever Merlin Moncure
Re: pg_autovacuum parameters Gaetano Mendola
Performance Bottleneck Martin Foster
Re: NOT IN query takes forever Scott Marlowe
Re: Performance Bottleneck Dennis Bjorklund
Re: Performance Bottleneck Joshua D. Drake
Re: NOT IN query takes forever Gaetano Mendola
Re: Performance Bottleneck Gaetano Mendola
Re: NOT IN query takes forever Christopher Kings-Lynne
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Pierre-Frédéric Caillaud
Tuning queries on large database Valerie Schneider DSI/DEV
The black art of postgresql.conf tweaking Paul Serby
Re: The black art of postgresql.conf tweaking Michal Taborsky
Re: Tuning queries on large database Christopher Kings-Lynne
Re: Tuning queries on large database Rod Taylor
Re: The black art of postgresql.conf tweaking Janning Vygen
Re: The black art of postgresql.conf tweaking Paul Thomas
Re: Tuning queries on large database Valerie Schneider DSI/DEV
Re: The black art of postgresql.conf tweaking Thomas Swan
Re: Performance Bottleneck Michael Adler
Re: Tuning queries on large database Pierre-Frédéric Caillaud
Re: Tuning queries on large database Pierre-Frédéric Caillaud
FW: Tuning queries on large database Merlin Moncure
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Pierre-Frédéric Caillaud
Re: [GENERAL] Tuning queries on large database Valerie Schneider DSI/DEV
Re: [GENERAL] Tuning queries on large database Mark Kirkwood
Re: [GENERAL] Tuning queries on large database Gaetano Mendola
Re: [GENERAL] Tuning queries on large database Merlin Moncure
Re: [GENERAL] Tuning queries on large database Merlin Moncure
Temporary tables G u i d o B a r o s i o
Re: Performance Bottleneck Steinar H. Gunderson
Re: Temporary tables Gaetano Mendola
Re: my boss want to migrate to ORACLE Mischa Sandberg
pg_dump performance? Jesper Krogh
Re: pg_dump performance? Christopher Kings-Lynne
Re: pg_dump performance? Jesper Krogh
Re: Tuning queries on large database Gaetano Mendola
Re: [GENERAL] Tuning queries on large database Gaetano Mendola
Re: Temporary tables Gaetano Mendola
Re: Performance Bottleneck Gaetano Mendola
Re: The black art of postgresql.conf tweaking Gaetano Mendola
Re: The black art of postgresql.conf tweaking Josh Berkus
Re: Performance Bottleneck Mike Benoit
Re: The black art of postgresql.conf tweaking Gaetano Mendola
Re: Performance Bottleneck Martin Foster
Re: The black art of postgresql.conf tweaking Josh Berkus
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Gaetano Mendola
Re: The black art of postgresql.conf tweaking Gaetano Mendola
Re: Performance Bottleneck Tom Lane
Re: Performance Bottleneck Scott Marlowe
Re: Question about Generating Possible Plans by the planner/optimizer Steinar H. Gunderson
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Scott Marlowe
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Gaetano Mendola
Re: Performance Bottleneck Gaetano Mendola
Re: Performance Bottleneck Christopher Kings-Lynne
Re: Performance Bottleneck Jan Wieck
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Mike Benoit
Re: Performance Bottleneck Jan Wieck
Re: Performance Bottleneck Matt Clark
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Arjen van der Meijden
Re: Performance Bottleneck Martin Foster
Re: Performance Bottleneck Tatsuo Ishii
Re: Performance Bottleneck Tatsuo Ishii
performance with column orders Jim Thomason
Re: The black art of postgresql.conf tweaking Shridhar Daithankar
tablespaces and ramdisks Merlin Moncure
Re: tablespaces and ramdisks Tom Lane
Help specifying new machine Rory Campbell-Lange
Re: Help specifying new machine Bill Montgomery
insert waits for delete with trigger Litao Wu
Column order performance Bill Montgomery
Re: Performance Bottleneck Alex Hayward
Re: [HACKERS] fsync vs open_sync Merlin Moncure
Slow select, insert, update Paul Langard
Re: [HACKERS] fsync vs open_sync pgsql@mohawksoft.com
Re: Slow select, insert, update Doug McNaught
Re: Performance Bottleneck matt@ymogen.net
Hardware upgrade for a high-traffic database Jason Coene
Re: Slow select, insert, update Bill Montgomery
Re: Column order performance Bill Montgomery
Re: Slow select, insert, update Tom Lane
Re: Column order performance Josh Berkus
Re: [HACKERS] fsync vs open_sync Josh Berkus
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: Hardware upgrade for a high-traffic database Scott Marlowe
Bulk Insert and Index use Rudi Starcevic
Re: Slow select, insert, update Litao Wu
Re: Bulk Insert and Index use Gregory S. Williamson
Re: Bulk Insert and Index use Rudi Starcevic
Re: Bulk Insert and Index use Christopher Browne
Re: Bulk Insert and Index use Gregory S. Williamson
Re: Bulk Insert and Index use Rudi Starcevic
NUMERIC x VARCHAR Er Galvão Abbott
Re: NUMERIC x VARCHAR Scott Marlowe
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud
Re: NUMERIC x VARCHAR Pierre-Frédéric Caillaud
Re: NUMERIC x VARCHAR Er Galvão Abbott
Re: NUMERIC x VARCHAR Michael Glaesemann
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Storing binary data. Jesper Krogh
Re: Storing binary data. Shridhar Daithankar
Re: Hardware upgrade for a high-traffic database Sanjay Arora
Re: [GENERAL] How to know which queries are to be optimised? Bruno Wolff III
Re: Storing binary data. Tom Lane
Re: NUMERIC x VARCHAR Er Galvão Abbott
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: Storing binary data. Jesper Krogh
Re: fsync vs open_sync Merlin Moncure
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: NUMERIC x VARCHAR Jan Wieck
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: [HACKERS] fsync vs open_sync Steve Bergman
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: Hardware upgrade for a high-traffic database Russell Smith
Re: Storing binary data. Russell Smith
Buld Insert and Index use. Rudi Starcevic
Re: [HACKERS] fsync vs open_sync Gaetano Mendola
Re: Buld Insert and Index use. Josh Berkus
Re: Hardware upgrade for a high-traffic database Jason Coene
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud
Re: [GENERAL] How to know which queries are to be optimised? Richard Huxton
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: Hardware upgrade for a high-traffic database Merlin Moncure
Re: Help specifying new machine William Yu
Re: [GENERAL] How to know which queries are to be optimised? Rudi Starcevic
insert Ulrich Wisser
Re: insert G u i d o B a r o s i o
Re: insert gnari
Re: insert G u i d o B a r o s i o
Re: insert gnari
Re: insert Ulrich Wisser
Re: insert Paul Thomas
Re: insert Rod Taylor
Weird Database Performance problem! Arash Zaryoun
Re: insert Bruno Wolff III
Re: Help specifying new machine Raoul Buzziol
Re: [HACKERS] fsync vs open_sync pgsql@mohawksoft.com
Re: fsync vs open_sync pgsql@mohawksoft.com
Performance Problem With Postgresql! Arash Zaryoun
Re: Weird Database Performance problem! Richard Huxton
Re: insert Bruno Wolff III
Re: insert Matt Clark
Reiser4 Pierre-Frédéric Caillaud
Re: fsync vs open_sync Pierre-Frédéric Caillaud
Re: insert Tom Lane
Re: Reiser4 Josh Berkus
Re: Performance Problem With Postgresql! Josh Berkus
Re: fsync vs open_sync Merlin Moncure
Re: Weird Database Performance problem! Richard Huxton
Replication: Slony-I vs. Mammoth Replicator vs. ? Chris Cheston
Re: Reiser4 Bruce Momjian
Re: Reiser4 Bruce Momjian
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
Re: insert Gaetano Mendola
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
Re: [HACKERS] Reiser4 Peter Eisentraut
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Christopher Browne
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
Faster with a sub-query then without Martin Foster
Slow joins against set-returning functions Michael Fuhr
Re: Faster with a sub-query then without Martin Foster
Help interpreting explain analyze output Ole Tange
Re: Help interpreting explain analyze output Richard Poole
Re: Help specifying new machine William Yu
Re: Timestamp-based indexing Josh Berkus
Re: Index type Josh Berkus
Re: Timestamp-based indexing Tom Lane
Re: Strange problems with more memory. Mark Kirkwood
General performance problem! olivier HARO
Re: General performance problem! Leeuw van der, Tim
Re: General performance problem! Gaetano Mendola
Re: General performance problem! Richard Huxton
Postgres does not utilize indexes. Why? Artimenko Igor
Re: General performance problem! olivier HARO
Re: Postgres does not utilize indexes. Why? Michal Taborsky
Re: General performance problem! Duane Lee - EGOVX
Re: Postgres does not utilize indexes. Why? Pierre-Frédéric Caillaud
Re: shared_buffers Question Joe Lester
Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)? Frank van Vugt
Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)? Frank van Vugt
postgresql performance with multimedia my thi ho
Re: high load caused by I/O - a hint Grega Bremec
Re: Why is the number of dead tuples causing the performance of deferred triggers to degrade so rapidly (exponentionally)? Frank van Vugt
Re: high load caused by I/O - a hint Gaetano Mendola
I could not get postgres to utilizy indexes Igor Artimenko
Re: Help specifying new machine Raoul Buzziol
Re: Help specifying new machine Rod Taylor
Re: I could not get postgres to utilizy indexes Thomas Swan
Array types and loading Aaron Birkland
Re: Array types and loading Tom Lane
Re: Array types and loading Aaron Birkland
Re: Why is the number of dead tuples causing the performance DeJuan Jackson
Re: Postgres does not utilyze indexes Artimenko Igor
Re: Help specifying new machine William Yu
Re: Help specifying new machine Tom Lane
Re: I could not get postgres to utilizy indexes Leeuw van der, Tim
help with query Dave Cramer
Re: help with query Brad Bulger
Re: help with query Dave Cramer
Re: help with query Dave Cramer
Re: help with query Jean-Luc Lachance
Re: Help specifying new machine Josh Berkus
using an index worst performances Gaetano Mendola
Re: using an index worst performances Richard Huxton
Re: using an index worst performances Gaetano Mendola
Re: using an index worst performances Christopher Kings-Lynne
Re: using an index worst performances Gaetano Mendola
Re: using an index worst performances Rod Taylor
pg_restore very slow in 8.0.0beta1 Bonnin S.
Re: I could not get postgres to utilizy indexes Manfred Koizar
Re: I could not get postgres to utilizy indexes Leeuw van der, Tim
Re: using an index worst performances Gaetano Mendola
Query performance problem Danilo Mota
Re: Query performance problem Tom Lane
Re: Query performance problem Bruno Wolff III
Re: Query performance problem Tom Lane
Re: using an index worst performances Gaetano Mendola
Query Performance Danilo Mota
Re: Query Performance Brad Bulger
Re: using an index worst performances Gaetano Mendola
Re: postgresql 8.0 beta - fail to collect statsistic Steve Bergman
How do I see what triggers are called on cascade? andrew@pillette.com
Query kills machine. Stef
Re: Query kills machine. Christopher Kings-Lynne
Re: Query kills machine. Magnus Naeslund(pg)
Re: Query kills machine. Tom Lane
[FUN] Performance increase? Gaetano Mendola
Re: Query kills machine. Magnus Naeslund(t)
What is the best way to do attribute/values? Daniel Ceregatti
Re: What is the best way to do attribute/values? Josh Berkus
Re: What is the best way to do attribute/values? Richard Huxton
Re: postgresql performance with multimedia Gregory S. Williamson
Re: What is the best way to do attribute/values? Mark Kirkwood
OT: Network config (WAS: RE: postgresql performance with multimedia) Leeuw van der, Tim
Re: What is the best way to do attribute/values? Leeuw van der, Tim
Optimizer Selecting Incorrect Index David Price
Re: Optimizer Selecting Incorrect Index Richard Huxton
Re: What is the best way to do attribute/values? Josh Berkus
Anyone familiar with Apple Xserve RAID Robert Treat
Re: Anyone familiar with Apple Xserve RAID Josh Berkus
TSearch2 and optimisation ... Hervé Piedvache
Re: Anyone familiar with Apple Xserve RAID Doug McNaught
Re: Anyone familiar with Apple Xserve RAID Josh Berkus
Re: TSearch2 and optimisation ... Josh Berkus
Re: What is the best way to do attribute/values? Simon Riggs
Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Re: Anyone familiar with Apple Xserve RAID Ralf Schramm
Re: Anyone familiar with Apple Xserve RAID Ralf Schramm
Re: Equivalent praxis to CLUSTERED INDEX? Christopher Kings-Lynne
Re: What is the best way to do attribute/values? Mark Kirkwood
Re: Optimizer Selecting Incorrect Index Dennis Bjorklund
Re: TSearch2 and optimisation ... Hervé Piedvache
Re: Optimizer Selecting Incorrect Index Richard Huxton
Re: Optimizer Selecting Incorrect Index David Price
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
Re: Anyone familiar with Apple Xserve RAID Tore Halset
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
Re: TSearch2 and optimisation ... Josh Berkus
Re: TSearch2 and optimisation ... George Essig
Disabling transaction/outdated-tuple behaviour Neil Cooper
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
Re: Anyone familiar with Apple Xserve RAID Kevin Barnard
Re: Equivalent praxis to CLUSTERED INDEX? Magnus Hagander
Re: TSearch2 and optimisation ... Hervé Piedvache
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
Re: Anyone familiar with Apple Xserve RAID Doug McNaught
Re: Anyone familiar with Apple Xserve RAID Alan Stange
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
Re: Equivalent praxis to CLUSTERED INDEX? Gregory S. Williamson
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Query performance issue with 8.0.0beta1 Stefano Bonnin
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
Re: Query performance issue with 8.0.0beta1 Russell Smith
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
Re: Query performance issue with 8.0.0beta1 andrew@pillette.com
Re: Query performance issue with 8.0.0beta1 Josh Berkus
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Jeremy Dunn
Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Why those queries do not utilize indexes? Artimenko Igor
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Why those queries do not utilize indexes? Dennis Bjorklund
Re: Anyone familiar with Apple Xserve RAID Vivek Khera
Re: Why those queries do not utilize indexes? Artimenko Igor
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
Re: Why those queries do not utilize indexes? Christopher Kings-Lynne
ill-planned queries inside a stored procedure Gaetano Mendola
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
Re: ill-planned queries inside a stored procedure andrew@pillette.com
Re: ill-planned queries inside a stored procedure Gaetano Mendola
Performance hit on loading from HD Vitaly Belman
Re: Performance hit on loading from HD Josh Berkus
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Why does a simple query not use an obvious index? Jack Kerkhof
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
Query performance problem in 8.0.0beta1 Stefano Bonnin
Re: Why does a simple query not use an obvious index? Scott Marlowe
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
Re: Why does a simple query not use an obvious index? Scott Marlowe
Re: Why does a simple query not use an obvious index? Scott Marlowe
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
Re: Query performance problem in 8.0.0beta1 Russell Smith
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
seqscan instead of index scan Martin Sarsale
Re: seqscan instead of index scan Bruno Wolff III
Re: seqscan instead of index scan Merlin Moncure
Re: seqscan instead of index scan Martin Sarsale
Re: seqscan instead of index scan Martin Sarsale
Re: seqscan instead of index scan Merlin Moncure
Re: seqscan instead of index scan Bruno Wolff III
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
Re: Why does a simple query not use an obvious index? Bruno Wolff III
Re: seqscan instead of index scan Pierre-Frédéric Caillaud
Re: seqscan instead of index scan Stephan Szabo
Re: seqscan instead of index scan Greg Stark
Re: seqscan instead of index scan Tom Lane
Re: seqscan instead of index scan Martin Sarsale
Performance with Intel Compiler Jean-Max Reymond
odbc/ado problems Kroh István
Re: odbc/ado problems Merlin Moncure
Table UPDATE is too slow Ron St-Pierre
Re: Table UPDATE is too slow Thomas F.O'Connell
Re: Table UPDATE is too slow Steinar H. Gunderson
Re: Table UPDATE is too slow Ron St-Pierre
Re: Table UPDATE is too slow Ron St-Pierre
Re: Table UPDATE is too slow Frank Wiles
Re: Table UPDATE is too slow Steinar H. Gunderson
Optimizing a request Jean-Max Reymond
Re: Table UPDATE is too slow Matt Clark
Re: odbc/ado problems Merlin Moncure
Re: Optimizing a request Josh Berkus
Re: Optimizing a request Jean-Max Reymond
Re: Optimizing a request Gary Doades
Re: Table UPDATE is too slow William Yu
Re: Optimizing a request Jean-Max Reymond
Re: Optimizing a request Tom Lane
Re: Optimizing a request Gary Doades
Re: Optimizing a request Jean-Max Reymond
Re: Optimizing a request Jean-Max Reymond
Re: Optimizing a request Gary Doades
Re: Optimizing a request Hervé Piedvache
Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby
Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby
Re: Table UPDATE is too slow Ron St-Pierre
