Mailing lists [pgsql-performance]
- Re: Trigger or Function Robert Klemme
- How to Speed up Insert from Multiple Connections Adarsh Sharma
- Re: insert Vitalii Tymchyshyn
- Re: Performance die when COPYing to table with bigint PK Simon Riggs
- Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn
- Parameters for PostgreSQL Jayadevan M
- Re: How to Speed up Insert from Multiple Connections Kevin Grittner
- Re: insert Kevin Grittner
- synchronous_commit off Anibal David Acosta
- Re: synchronous_commit off Greg Smith
- Re: synchronous_commit off Anibal David Acosta
- Re: Parameters for PostgreSQL Merlin Moncure
- Re: synchronous_commit off Craig Ringer
- Re: Parameters for PostgreSQL Craig Ringer
- Which Join is better Adarsh Sharma
- Re: Which Join is better Szymon Guz
- Re: Which Join is better Maria Arias de Reyna
- Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn
- Tsearch2 - bad performance with concatenated ts-vectors Jan Wielgus
- Array access performance Andreas Brandl
- Re: Array access performance Andreas Brandl
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- Re: Trigger or Function Gavin Flower
- Re: Array access performance Tom Lane
- Re: Array access performance Andreas Brandl
- Re: Performance die when COPYing to table with bigint PK Kevin Grittner
- Re: Performance penalty when using WITH Merlin Moncure
- Re: synchronous_commit off lars hofhansl
- Re: Which Join is better lars hofhansl
- Re: Performance penalty when using WITH Robert Klemme
- Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Robert Haas
- Re: Performance penalty when using WITH Robert Klemme
- Re: Performance penalty when using WITH Merlin Moncure
- Postgres performance on Linux and Windows Dusan Misic
- Re: Postgres performance on Linux and Windows Andy Colson
- Re: Performance penalty when using WITH Robert Klemme
- Re: Postgres performance on Linux and Windows Dusan Misic
- Re: Postgres performance on Linux and Windows Kevin Grittner
- Re: Performance penalty when using WITH Robert Klemme
- Re: Parameters for PostgreSQL Jayadevan M
- Need to tune for Heavy Write Adarsh Sharma
- Re: Parameters for PostgreSQL Craig Ringer
- Re: Parameters for PostgreSQL Adarsh Sharma
- Re: Need to tune for Heavy Write Dusan Misic
- Re: Need to tune for Heavy Write Willy-Bas Loos
- Re: Need to tune for Heavy Write Dusan Misic
- Re: Need to tune for Heavy Write Scott Marlowe
- Re: Need to tune for Heavy Write Dusan Misic
- Re: Need to tune for Heavy Write Nicholson, Brad (Toronto, ON, CA)
- Seq Scan vs. Index Scan Nassib Nassar
- Re: Need to tune for Heavy Write Craig Ringer
- Re: Need to tune for Heavy Write Kevin Grittner
- Re: Parameters for PostgreSQL Andy Colson
- Re: Need to tune for Heavy Write Scott Marlowe
- Re: Seq Scan vs. Index Scan Kevin Grittner
- Re: Performance die when COPYing to table with bigint PK Kevin Grittner
- Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn
- Re: Need to tune for Heavy Write Scott Marlowe
- Re: Performance die when COPYing to table with bigint PK Kevin Grittner
- Re: Need to tune for Heavy Write Samuel Gendler
- table size is bigger than expected Jian Shi
- Postgres 8.4 memory related parameters Claire Chang
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- Re: Tsearch2 - bad performance with concatenated ts-vectors Gavin Flower
- Suspected Postgres Datacorruption Sumeet Jauhar
- Re: Performance penalty when using WITH Li Jin
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- Re: Parameters for PostgreSQL Craig Ringer
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- Re: table size is bigger than expected Justin Pitts
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time Clem Dickey
- Re: Postgres 8.4 memory related parameters Shaun Thomas
- Re: Postgres 8.4 memory related parameters Scott Marlowe
- Re: Tsearch2 - bad performance with concatenated ts-vectors Kevin Grittner
- Re: Suspected Postgres Datacorruption Scott Marlowe
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- Re: Postgres 8.4 memory related parameters Shaun Thomas
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- Re: Suspected Postgres Datacorruption Nicholson, Brad (Toronto, ON, CA)
- Re: Postgres 8.4 memory related parameters Shaun Thomas
- Re: Suspected Postgres Datacorruption Nicholson, Brad (Toronto, ON, CA)
- Re: Need to tune for Heavy Write Mark Kirkwood
- Re: table size is bigger than expected Steve Crawford
- Re: Suspected Postgres Datacorruption Scott Marlowe
- Re: Suspected Postgres Datacorruption Scott Marlowe
- Re: Suspected Postgres Datacorruption Tom Lane
- Re: Performance die when COPYing to table with bigint PK Віталій Тимчишин
- Re: UPDATEDs slowing SELECTs in a fully cached database Jeff Janes
- Re: Performance die when COPYing to table with bigint PK Vitalii Tymchyshyn
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- Re: Postgres 8.4 memory related parameters Shaun Thomas
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- Re: Postgres 8.4 memory related parameters Kevin Grittner
- PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh
- Re: Postgres 8.4 memory related parameters Shaun Thomas
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please Greg Williamson
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please tuanhoanganh
- Re: PostgreSQL 9.0.1 on Windows performance tunning help please Kevin Grittner
- benchmark woes and XFS options mark
- Re: benchmark woes and XFS options Greg Smith
- Re: Postgres performance on Linux and Windows Greg Smith
- Re: Postgres 8.4 memory related parameters Greg Smith
- Re: Suspected Postgres Datacorruption Greg Smith
- Re: benchmark woes and XFS options mark
- Re: Suspected Postgres Datacorruption Sumeet Jauhar
- Re: Suspected Postgres Datacorruption Sumeet Jauhar
- XFS options and benchmark woes mark
- Re: XFS options and benchmark woes mark
- Re: Performance die when COPYing to table with bigint PK Robert Ayrapetyan
- poor pefrormance with regexp searches on large tables Grzegorz Blinowski
- Re: poor pefrormance with regexp searches on large tables Tomas Vondra
- Re: poor pefrormance with regexp searches on large tables pasman pasmański
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Autovacuum running out of memory Alexis Lê-Quôc
- Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski
- Re: poor pefrormance with regexp searches on large tables Tomas Vondra
- Re: Autovacuum running out of memory Tom Lane
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Re: Autovacuum running out of memory Alexis Lê-Quôc
- Re: Autovacuum running out of memory Tom Lane
- Re: Autovacuum running out of memory Alexis Lê-Quôc
- Re: Autovacuum running out of memory Tom Lane
- Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Streaming replication performance Antonin Faltynek
- Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Re: Recommended optimisations slows down PostgreSQL 8.4 ktm@rice.edu
- Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Re: Recommended optimisations slows down PostgreSQL 8.4 Greg Smith
- Re: Recommended optimisations slows down PostgreSQL 8.4 Craig Ringer
- pgpool master or slave goes down java access error jenopob
- Re: poor pefrormance with regexp searches on large tables Grzegorz Blinowski
- Re: poor pefrormance with regexp searches on large tables Kevin Grittner
- Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Re: Recommended optimisations slows down PostgreSQL 8.4 Merlin Moncure
- Re: pgpool master or slave goes down java access error Waldo Nell
- Re: Streaming replication performance Merlin Moncure
- Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Re: Recommended optimisations slows down PostgreSQL 8.4 Kevin Grittner
- Re: Recommended optimisations slows down PostgreSQL 8.4 Greg Smith
- Re: Recommended optimisations slows down PostgreSQL 8.4 Waldo Nell
- Re: Recommended optimisations slows down PostgreSQL 8.4 Tom Lane
- Re: Recommended optimisations slows down PostgreSQL 8.4 Stephen Frost
- strange pgbench results (as if blocked at the end) Tomas Vondra
- How to see memory usage using explain analyze ? hyelluas
- Re: strange pgbench results (as if blocked at the end) Craig Ringer
- Re: strange pgbench results (as if blocked at the end) Greg Smith
- Re: strange pgbench results (as if blocked at the end)
- Re: strange pgbench results (as if blocked at the end) Scott Marlowe
- Re: strange pgbench results (as if blocked at the end)
- Re: strange pgbench results (as if blocked at the end) Tom Lane
- Re: strange pgbench results (as if blocked at the end) Greg Smith
- Re: How to see memory usage using explain analyze ? Igor Neyman
- Re: strange pgbench results (as if blocked at the end) Greg Smith
- Reports from SSD purgatory Greg Smith
- Re: Reports from SSD purgatory David Boreham
- Re: How to see memory usage using explain analyze ? hyelluas
- index not being used when variable is sent Eyal Wilde
- Re: index not being used when variable is sent Tom Lane
- Re: Streaming replication performance Pin007
- Tuning Tips for a new Server Ogden
- Re: index not being used when variable is sent Eyal Wilde
- Re: Tuning Tips for a new Server Andy Colson
- Re: Tuning Tips for a new Server Ogden
- Re: Tuning Tips for a new Server Tomas Vondra
- Re: Tuning Tips for a new Server Tomas Vondra
- Re: How to see memory usage using explain analyze ? Igor Neyman
- Re: DBT-5 & Postgres 9.0.3 bobbyw
- Re: Tuning Tips for a new Server Ogden
- Re: DBT-5 & Postgres 9.0.3 Andy Colson
- Re: DBT-5 & Postgres 9.0.3 bobbyw
- Re: DBT-5 & Postgres 9.0.3 ktm@rice.edu
- Calculating statistic via function rather than with query is slowing my query Anish Kejariwal
- Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Calculating statistic via function rather than with query is slowing my query Pavel Stehule
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ ktm@rice.edu
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ ktm@rice.edu
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Gary Doades
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Andy Colson
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Tuning Tips for a new Server Tomas Vondra
- Re: Calculating statistic via function rather than with query is slowing my query Anish Kejariwal
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Gary Doades
- Re: Calculating statistic via function rather than with query is slowing my query Pavel Stehule
- Re: Tuning Tips for a new Server Ogden
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Andy Colson
- Re: Tuning Tips for a new Server Scott Marlowe
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ J Sisson
- Re: Tuning Tips for a new Server Ogden
- Re: Tuning Tips for a new Server Tomas Vondra
- Re: DBT-5 & Postgres 9.0.3 Tom Lane
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: DBT-5 & Postgres 9.0.3 Aidan Van Dyk
- Re: index not being used when variable is sent Jim Nasby
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ ktm@rice.edu
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: DBT-5 & Postgres 9.0.3 Tom Lane
- Re: Need to tune for Heavy Write Jim Nasby
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Greg Smith
- Re: Calculating statistic via function rather than with query is slowing my query Craig Ringer
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ mark
- Re: Calculating statistic via function rather than with query is slowing my query Anish Kejariwal
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Greg Smith
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: heavy load-high cpu itilization Jim Nasby
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Craig Ringer
- Re: How to see memory usage using explain analyze ? hyelluas
- tunning strategy needed hyelluas
- Re: Calculating statistic via function rather than with query is slowing my query Craig Ringer
- Re: tunning strategy needed Craig Ringer
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Mark Kirkwood
- Re: tunning strategy needed Tomas Vondra
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Aidan Van Dyk
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Ogden
- Re: Calculating statistic via function rather than with query is slowing my query Anish Kejariwal
- settings input for upgrade Midge Brown
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Mark Kirkwood
- Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ Mark Kirkwood
- Variable versus constrant size tuples Krzysztof Chodak
- Re: Variable versus constrant size tuples Andy Colson
- Re: Variable versus constrant size tuples Merlin Moncure
- Re: Reports from SSD purgatory Greg Smith
- Re: settings input for upgrade Robert Klemme
- Re: settings input for upgrade Midge Brown
- Re: settings input for upgrade Scott Marlowe
- Re: settings input for upgrade Midge Brown
- Re: settings input for upgrade Robert Klemme
- Re: settings input for upgrade Greg Smith
- Re: settings input for upgrade Scott Marlowe
- Re: Variable versus constrant size tuples Krzysztof Chodak
- Re: tunning strategy needed hyelluas
- Re: settings input for upgrade Midge Brown
- Re: settings input for upgrade Midge Brown
- Re: settings input for upgrade Greg Smith
- RAID Controllers David Boreham
- 8.4 optimization regression? Mark Kirkwood
- Re: RAID Controllers Scott Marlowe
- Re: RAID Controllers Robert Schnabel
- Re: RAID Controllers David Boreham
- Re: RAID Controllers Alan Hodgson
- Re: RAID Controllers David Boreham
- Re: RAID Controllers Scott Marlowe
- Re: 8.4 optimization regression? Tom Lane
- Re: RAID Controllers Greg Smith
- Re: 8.4 optimization regression? Mark Kirkwood
- Re: 8.4 optimization regression? Mark Kirkwood
- How to track number of connections and hosts to Postgres cluster Venkat Balaji
- Re: How to track number of connections and hosts to Postgres cluster Guillaume Lelarge
- Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
- Re: How to track number of connections and hosts to Postgres cluster Adarsh Sharma
- Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
- Re: How to track number of connections and hosts to Postgres cluster Guillaume Lelarge
- Re: How to track number of connections and hosts to Postgres cluster Greg Smith
- Re: How to track number of connections and hosts to Postgres cluster Greg Spiegelberg
- Intel 320 SSD info David Boreham
- Re: How to track number of connections and hosts to Postgres cluster Maciek Sakrejda
- Re: Intel 320 SSD info Merlin Moncure
- Re: Intel 320 SSD info Andy
- Re: Intel 320 SSD info David Boreham
- Re: Intel 320 SSD info David Boreham
- Re: Intel 320 SSD info Greg Smith
- Re: Intel 320 SSD info David Boreham
- Re: Intel 320 SSD info
- Re: How to track number of connections and hosts to Postgres cluster Scott Marlowe
- Re: Intel 320 SSD info Merlin Moncure
- Re: Reports from SSD purgatory
- Re: Reports from SSD purgatory Merlin Moncure
- Re: Reports from SSD purgatory david@lang.hm
- Re: Reports from SSD purgatory Tomas Vondra
- Re: Reports from SSD purgatory Merlin Moncure
- Re: Reports from SSD purgatory
- Re: Reports from SSD purgatory David Boreham
- Re: Reports from SSD purgatory Tomas Vondra
- Re: Reports from SSD purgatory Tomas Vondra
- Re: Intel 320 SSD info Greg Smith
- Re: Reports from SSD purgatory david@lang.hm
- Re: Intel 320 SSD info David Rees
- reltuples value less than rows in the table. parul
- Re: How to track number of connections and hosts to Postgres cluster MirrorX
- Re: reltuples value less than rows in the table. Kevin Grittner
- Performance with many updates Tasdassa Asdasda
- Re: Performance with many updates Tomas Vondra
- Re: 8.4 optimization regression? Mark Kirkwood
- Query optimization help Szymon Kosok
- Query optimization help Szymon Kosok
- Re: Re: How to track number of connections and hosts to Postgres cluster Venkat Balaji
- Re: Query optimization help Ondrej Ivanič
- Re: Re: How to track number of connections and hosts to Postgres cluster Scott Marlowe
- Re: Query optimization help Szymon Kosok
- Re: Query optimization help Ondrej Ivanič
- Re: 8.4 optimization regression? Grzegorz Jaśkiewicz
- Summaries on SSD usage? Stefan Keller
- IN or EXISTS Andy Colson
- Re: 8.4 optimization regression? Mark Kirkwood
- Re: 8.4 optimization regression? Mark Kirkwood
- Re: IN or EXISTS Craig Ringer
- Query performance issue Jayadevan M
- Re: Query performance issue Heikki Linnakangas
- Re: Query performance issue Sushant Sinha
- Re: Query performance issue Jayadevan M
- Re: Query performance issue Jayadevan M
- Re: Query performance issue Jayadevan M
- Re: Query performance issue Venkat Balaji
- Re: Query performance issue Tomas Vondra
- Re: Query performance issue Jayadevan M
- Re: Query performance issue Kevin Grittner
- Re: IN or EXISTS Andy Colson
- Re: IN or EXISTS Tomas Vondra
- Slow performance Kai Otto
- Re: Slow performance Andy Colson
- Re: Slow performance Alan Hodgson
- Re: Slow performance Andy Colson
- Re: Slow performance Kevin Grittner
- Re: Slow performance Alan Hodgson
- Re: 8.4 optimization regression? Tom Lane