Mailing lists [pgsql-performance]
- Mail Test F Brown
- Re: SQL performance problems Alberto Caso
- Re: How to force Nested Loop plan? Ron Johnson
- Re: How to force Nested Loop plan? Tom Lane
- Re: Hardware recommendations to scale to silly load Vivek Khera
- Re: Hardware recommendations to scale to silly load Vivek Khera
- Re: opinion on RAID choice Andrew Sullivan
- Re: opinion on RAID choice Larry Rosenman
- Re: opinion on RAID choice Ron Johnson
- Re: opinion on RAID choice Andrew Sullivan
- Re: opinion on RAID choice Greg Spiegelberg
- Re: Hardware recommendations to scale to silly load Greg Stark
- Re: opinion on RAID choice Ron Johnson
- Re: Hardware recommendations to scale to silly load Ron Johnson
- Use of to_timestamp causes full scan Zaremba, Don
- Re: Use of to_timestamp causes full scan Tom Lane
- PostgreSQL is slow...HELP Azlin Ghazali
- Re: PostgreSQL is slow...HELP Andrew Sullivan
- " ... though the pgsql version performance is not very great." Justin Clift
- Re: PostgreSQL is slow...HELP Nick Fankhauser
- Re: PostgreSQL is slow...HELP Tom Lane
- Re: PostgreSQL is slow...HELP Shridhar Daithankar
- FreeBSD page size (was Re: The results of my PostgreSQL/filesystem performance tests) Vivek Khera
- SQL slower when running for the second time Rhaoni Chiu Pereira
- Re: FreeBSD page size Vivek Khera
- Query on Postgresql performance Naveen Palavalli
- Re: FreeBSD page size Sean Chittenden
- Re: FreeBSD page size Vivek Khera
- Re: [ADMIN] SQL slower when running for the second time Peter Eisentraut
- Re: SQL slower when running for the second time Ron Johnson
- Re: [ADMIN] SQL slower when running for the second time Rhaoni Chiu Pereira
- Re: FreeBSD page size Marc G. Fournier
- Re: FreeBSD page size Bruce Momjian
- Re: FreeBSD page size Rod Taylor
- Re: FreeBSD page size Marc G. Fournier
- Re: Selecting random rows efficiently scott.marlowe
- Re: FreeBSD page size Bruce Momjian
- SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Rudi Starcevic
- Re: SELECT's take a long time compared to other DBMS Rod Taylor
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Rudi Starcevic
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Neil Conway
- Re: Query on Postgresql performance Neil Conway
- PostgreSQL Reliability when fsync = false on Linux-XFS Federico Sevilla III
- Re: SELECT's take a long time compared to other DBMS Christopher Browne
- Re: SELECT's take a long time compared to other DBMS Christopher Browne
- Re: PostgreSQL Reliability when fsync = false on Linux-XFS Rod Taylor
- Re: SELECT's take a long time compared to other DBMS Nick Fankhauser
- Re: SELECT's take a long time compared to other DBMS Tom Lane
- Re: PostgreSQL Reliability when fsync = false on Hannu Krosing
- Re: PostgreSQL Reliability when fsync = false on Linux-XFS Shridhar Daithankar
- Re: PostgreSQL Reliability when fsync = false on Linux-XFS Sean Chittenden
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Shridhar Daithankar
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: Query on Postgresql performance Andrew Sullivan
- Re: SELECT's take a long time compared to other DBMS Hannu Krosing
- Re: PostgreSQL Reliability when fsync = false on Linux-XFS Tom Lane
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Jean-Luc Lachance
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: FreeBSD page size Vivek Khera
- Re: SELECT's take a long time compared to other DBMS Hannu Krosing
- Re: SELECT's take a long time compared to other DBMS Relaxin
- [GENERAL] how to get accurate values in pg_statistic (continued) Mary Edie Meredith
- Re: SELECT's take a long time compared to other DBMS William Yu
- Re: [GENERAL] how to get accurate values in pg_statistic Rod Taylor
- Re: FreeBSD page size Bruce Momjian
- Re: FreeBSD page size Vivek Khera
- Re: FreeBSD page size (was Re: The results of my scott.marlowe
- Re: FreeBSD page size Bruce Momjian
- Re: FreeBSD page size Bruce Momjian
- Re: SELECT's take a long time compared to other DBMS scott.marlowe
- Re: PostgreSQL Reliability when fsync = false on Linux-XFS scott.marlowe
- Performance problems on a fairly big table with two key columns. Rasmus Aveskogh
- Re: SELECT's take a long time compared to other DBMS scott.marlowe
- Re: [GENERAL] how to get accurate values in pg_statistic (continued) Tom Lane
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: [GENERAL] how to get accurate values in pg_statistic Neil Conway
- Re: [GENERAL] how to get accurate values in pg_statistic Mary Edie Meredith
- Re: [GENERAL] how to get accurate values in pg_statistic Rod Taylor
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Christopher Browne
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Neil Conway
- Re: Query too slow Bruce Momjian
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: SELECT's take a long time compared to other DBMS Eirik Oeverby
- Re: Performance problems on a fairly big table with two key columns. Richard Huxton
- Re: [GENERAL] Seq scan of table? Bjorn T Johansen
- Re: [GENERAL] Seq scan of table? Richard Huxton
- Re: [GENERAL] Seq scan of table? Bjørn T Johansen
- Re: [GENERAL] Seq scan of table? Jonathan Bartlett
- Re: SELECT's take a long time compared to other DBMS Patrick Hatcher
- Re: Performance problems on a fairly big table with two Rasmus Aveskogh
- Re: [GENERAL] Seq scan of table? Ron Johnson
- Re: Performance problems on a fairly big table with two Richard Huxton
- Re: [GENERAL] how to get accurate values in pg_statistic (continued) Tom Lane
- Re: [GENERAL] how to get accurate values in pg_statistic Mary Edie Meredith
- Re: [GENERAL] Seq scan of table? Richard Huxton
- Re: [GENERAL] Seq scan of table? Neil Conway
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: [GENERAL] how to get accurate values in pg_statistic Bruce Momjian
- Re: [GENERAL] how to get accurate values in pg_statistic Bruce Momjian
- Re: [GENERAL] how to get accurate values in pg_statistic Tom Lane
- Re: SELECT's take a long time compared to other DBMS Neil Conway
- Re: [GENERAL] Seq scan of table? Tom Lane
- Serious issues with CPU usage
- Re: Serious issues with CPU usage Tom Lane
- Re: SELECT's take a long time compared to other DBMS Relaxin
- Re: Serious issues with CPU usage Hannu Krosing
- Poor pg_dump performance Jim C. Nasby
- Re: [GENERAL] how to get accurate values in pg_statistic Bruce Momjian
- slow plan for min/max Pailloncy Jean-Gérard
- Re: [GENERAL] how to get accurate values in pg_statistic Greg Stark
- Re: [GENERAL] how to get accurate values in pg_statistic Tom Lane
- Re: Serious issues with CPU usage Andri Saar
- Re: Serious issues with CPU usage Shridhar Daithankar
- Re: Serious issues with CPU usage Manfred Koizar
- Re: Serious issues with CPU usage Tom Lane
- Re: Serious issues with CPU usage Andri Saar
- Re: Serious issues with CPU usage Shridhar Daithankar
- Re: slow plan for min/max scott.marlowe
- Re: slow plan for min/max Neil Conway
- Re: slow plan for min/max Christopher Browne
- Re: slow plan for min/max scott.marlowe
- Re: slow plan for min/max Tom Lane
- Explain Doc Rhaoni Chiu Pereira
- Re: Explain Doc Alberto Caso
- Re: slow plan for min/max Christopher Browne
- Re: slow plan for min/max Greg Stark
- Re: slow plan for min/max Josh Berkus
- Re: slow plan for min/max Matt Clark
- Re: slow plan for min/max Matt Clark
- Re: slow plan for min/max Tom Lane
- Odiel León
- Re: slow plan for min/max Matt Clark
- Re: slow plan for min/max Tom Lane
- Quick question Josh Berkus
- Re: Quick question Tom Lane
- Slow query? Waruna Geekiyanage
- increase performancr with "noatime"? JM
- Re: increase performancr with "noatime"? Andrew Sullivan
- Need advice about triggers Mindaugas Riauba
- Re: increase performancr with "noatime"? Bill Moran
- Re: Need advice about triggers Richard Huxton
- Re: Need advice about triggers Rod Taylor
- Re: Need advice about triggers Mindaugas Riauba
- Re: slow plan for min/max Pailloncy Jean-Gérard
- Re: Need advice about triggers scott.marlowe
- Re: Need advice about triggers Tom Lane
- Re: Need advice about triggers Richard Huxton
- Re: Need advice about triggers Hannu Krosing
- Re: increase performancr with "noatime"? Vivek Khera
- Re: slow plan for min/max Greg Stark
- Re: slow plan for min/max Josh Berkus
- Re: slow plan for min/max Bruno Wolff III
- Re: slow plan for min/max Thomas Swan
- Re: slow plan for min/max Bruno Wolff III
- Reading data in bulk - help? Chris Huston
- Re: Reading data in bulk - help? Josh Berkus
- Re: slow plan for min/max Matt Clark
- Re: Hardware recommendations to scale to silly load Bruce Momjian
- Re: Reading data in bulk - help? Chris Huston
- Re: Hardware recommendations to scale to silly load Gregory S. Williamson
- Re: Reading data in bulk - help? Dennis Bjorklund
- Re: Need advice about triggers Mindaugas Riauba
- Re: Reading data in bulk - help? Magnus Naeslund(w)
- Re: Hardware recommendations to scale to silly load Bruce Momjian
- Re: Need advice about triggers Hannu Krosing
- Re: Reading data in bulk - help? Josh Berkus
- Upgrade Woes aturner@neteconomist.com
- Re: Upgrade Woes Richard Huxton
- Re: Upgrade Woes Christopher Browne
- Re: [GENERAL] how to get accurate values in pg_statistic (continued) Bruce Momjian
- Re: Query too slow Bruce Momjian
- Re: Reading data in bulk - help? Chris Huston
- Re: Reading data in bulk - help? William Yu
- Re: [GENERAL] how to get accurate values in pg_statistic (continued) Christopher Browne
- Re: [osdldbt-general] Re: [GENERAL] how to get accurate Mary Edie Meredith
- Attempt at work around of int4 query won't touch int8 index ... James Robinson
- Re: Attempt at work around of int4 query won't touch int8 index ... Tom Lane
- Re: Reading data in bulk - help? Josh Berkus
- Re: [osdldbt-general] Re: [GENERAL] how to get accurate Christopher Browne
- Re: [GENERAL] how to get accurate values in pg_statistic (continued) Tom Lane
- Re: Reading data in bulk - help? Christopher Kings-Lynne
- Re: Upgrade Woes aturner@neteconomist.com
- Re: Upgrade Woes Tom Lane
- Re: Upgrade Woes Jeff
- Re: [GENERAL] how to get accurate values in pg_statistic scott.marlowe
- Re: [GENERAL] how to get accurate values in pg_statistic Christopher Browne
- Re: Upgrade Woes aturner@neteconomist.com
- best arrangement of 3 disks for (insert) performance Richard Jones
- Re: best arrangement of 3 disks for (insert) performance Matt Clark
- software vs hw hard on linux Jeff
- Re: software vs hw hard on linux aturner@neteconomist.com
- Re: [GENERAL] how to get accurate values in pg_statistic scott.marlowe
- Re: software vs hw hard on linux Christopher Browne
- Re: best arrangement of 3 disks for (insert) performance Christopher Browne
- Re: best arrangement of 3 disks for (insert) performance Josh Berkus
- Re: best arrangement of 3 disks for (insert) performance Richard Jones
- Re: software vs hw hard on linux Josh Berkus
- Re: best arrangement of 3 disks for (insert) performance Richard Jones
- Re: best arrangement of 3 disks for (insert) performance - Dell Thom Dyson
- Re: best arrangement of 3 disks for (insert) performance Will LaShell
- Re: software vs hw hard on linux Vivek Khera
- Re: software vs hw hard on linux Vivek Khera
- Re: best arrangement of 3 disks for (insert) performance - Dell Vivek Khera
- Re: best arrangement of 3 disks for (insert) performance Vivek Khera
- Re: best arrangement of 3 disks for (insert) performance - Dell Christopher Browne
- Re: best arrangement of 3 disks for (insert) performance Rod Taylor
- Re: best arrangement of 3 disks for (insert) performance Cott Lang
- Re: software vs hw hard on linux Cott Lang
- Re: Attempt at work around of int4 query won't touch int8 index ... Shridhar Daithankar
- restore time: sort_mem vs. checkpoing_segments Vivek Khera
- L|p Treatment that makes your L|ps PLUMP Womens Breakthrough
- Inconsistent performance Joseph Bove
- Re: Inconsistent performance Stephan Szabo
- Re: Inconsistent performance Bruno Wolff III
- Re: restore time: sort_mem vs. checkpoing_segments Josh Berkus
- Re: Inconsistent performance Joseph Bove
- Re: Inconsistent performance Josh Berkus
- Re: Inconsistent performance Stephan Szabo
- Re: Inconsistent performance Joseph Bove
- Re: Inconsistent performance Christopher Browne
- Re: Inconsistent performance scott.marlowe
- Re: Inconsistent performance Brian Hirt
- Re: Inconsistent performance scott.marlowe
- Re: Inconsistent performance Christopher Browne
- Re: restore time: sort_mem vs. checkpoing_segments Tom Lane
- Re: Inconsistent performance Manfred Koizar
- Re: Attempt at work around of int4 query won't touch int8 index ... Paul Thomas
- Re: Inconsistent performance Matt Clark
- Re: restore time: sort_mem vs. checkpoing_segments Vivek Khera
- Re: Attempt at work around of int4 query won't touch int8 index ... Tom Lane
- Re: Inconsistent performance Joseph Bove
- Re: Inconsistent performance Jeff
- Re: [GENERAL] how to get accurate values in pg_statistic Mary Edie Meredith
- Re: [GENERAL] how to get accurate values in pg_statistic Tom Lane
- Effective Cache Size Nick Barr
- Re: Effective Cache Size Shridhar Daithankar
- inferior SCSI performance Michael Adler
- Re: inferior SCSI performance Tom Lane
- Is there a reason _not_ to vacuum continuously? Matt Clark
- Re: Is there a reason _not_ to vacuum continuously? scott.marlowe
- Re: Is there a reason _not_ to vacuum continuously? Josh Berkus
- Re: restore time: sort_mem vs. checkpoing_segments Robert Treat
- Re: Is there a reason _not_ to vacuum continuously? Matt Clark
- Re: restore time: sort_mem vs. checkpoing_segments Vivek Khera
- Re: Is there a reason _not_ to vacuum continuously? Matt Clark
- How to force an Index ? Rhaoni Chiu Pereira
- Re: Is there a reason _not_ to vacuum continuously? Josh Berkus
- Re: How to force an Index ? Josh Berkus
- Re: Is there a reason _not_ to vacuum continuously? Christopher Browne
- rewrite in to exists? LN Cisneros
- Re: rewrite in to exists? Christopher Kings-Lynne
- Many fields in one table or many tables? Alexander Priem
- Re: Is there a reason _not_ to vacuum continuously? Oliver Scheit
- Re: Is there a reason _not_ to vacuum continuously? Christopher Kings-Lynne
- Re: Is there a reason _not_ to vacuum continuously? Oliver Scheit
- Re: Is there a reason _not_ to vacuum continuously? Christopher Kings-Lynne
- Re: rewrite in to exists? Manfred Koizar
- Re: Is there a reason _not_ to vacuum continuously? Oliver Scheit
- Re: How to force an Index ? Rhaoni Chiu Pereira
- Re: Is there a reason _not_ to vacuum continuously? Christopher Kings-Lynne
- Re: rewrite in to exists? LN Cisneros
- Re: How to force an Index ? Tom Lane
- Re: Many fields in one table or many tables? Josh Berkus
- Re: Is there a reason _not_ to vacuum continuously? Josh Berkus
- Re: rewrite in to exists? Josh Berkus
- Find one record Joseph Bove
- Re: How to force an Index ? Josh Berkus
- Re: Find one record Josh Berkus
- Re: How to force an Index ? Josh Berkus
- Re: Many fields in one table or many tables? Tom Lane
- Re: rewrite in to exists? LN Cisneros
- osdl-dbt3 run results - puzzled by the execution plans Jenny Zhang
- Re: osdl-dbt3 run results - puzzled by the execution plans Matt Clark
- Re: osdl-dbt3 run results - puzzled by the execution Jenny Zhang
- Re: osdl-dbt3 run results - puzzled by the execution plans Tom Lane
- Re: rewrite in to exists? Manfred Koizar
- Re: osdl-dbt3 run results - puzzled by the execution Matt Clark
- Re: osdl-dbt3 run results - puzzled by the execution plans Greg Stark
- Re: osdl-dbt3 run results - puzzled by the execution plans Manfred Koizar
- Re: osdl-dbt3 run results - puzzled by the execution Jenny Zhang
- Re: osdl-dbt3 run results - puzzled by the execution Jenny Zhang
- Re: osdl-dbt3 run results - puzzled by the execution Jenny Zhang
- Sexier, Plumper L|ps can be yours only $24.76 Beauty Center
- How to make n_distinct more accurate. Nick Fankhauser
- LIKE query running slow Garrett Bladow
- Re: restore time: sort_mem vs. checkpoing_segments Vivek Khera
- Re: restore time: sort_mem vs. checkpoing_segments Bruce Momjian
- Re: restore time: sort_mem vs. checkpoing_segments Vivek Khera
- Re: LIKE query running slow Dennis Bjorklund
- Re: LIKE query running slow Shridhar Daithankar
- Re: LIKE query running slow Jeff
- Re: osdl-dbt3 run results - puzzled by the execution Manfred Koizar
- Re: How to make n_distinct more accurate. Nick Fankhauser
- Performance issue peter
- Index problem Rigmor Ukuhe
- Re: LIKE query running slow Rod Taylor
- Re: LIKE query running slow Josh Berkus
- Re: restore time: sort_mem vs. checkpoing_segments Dennis Bjorklund
- Re: [HACKERS] osdl-dbt3 run results - puzzled by the execution Tom Lane
- Re: LIKE query running slow Garrett Bladow
- Re: Performance issue Joseph Bove
- Re: Index problem Tomasz Myrta
- Re: Performance issue Richard Jones
- Re: Index problem Matt Clark
- Re: Performance issue Sean Chittenden
- Re: Performance issue Rod Taylor
- upping checkpoints on production server Robert Treat
- Re: upping checkpoints on production server Tom Lane
- Re: Index problem Rigmor Ukuhe
- Re: Index problem Matt Clark
- performance hit when joining with a view? Palle Girgensohn
- Re: Index problem Tom Lane
- Re: performance hit when joining with a view? Tom Lane
- Re: upping checkpoints on production server Robert Treat
- TPC-R benchmarks Oleg Lebedev
- Re: TPC-R benchmarks Jenny Zhang
- Re: TPC-R benchmarks Oleg Lebedev
- Re: TPC-R benchmarks Jenny Zhang
- Indices arent being used rantunes@student.dei.uc.pt
- Re: Indices arent being used Rod Taylor
- Re: TPC-R benchmarks Josh Berkus
- Re: TPC-R benchmarks Tom Lane
- Re: Indices arent being used Shridhar Daithankar
- Re: Indices arent being used rantunes@student.dei.uc.pt
- Re: Indices arent being used Tom Lane
- Re: TPC-R benchmarks Mary Edie Meredith
- Plan-Reading Rhaoni Chiu Pereira
- Re: Plan-Reading Josh Berkus
- Re: Indices arent being used rantunes@student.dei.uc.pt
- Re: Indices arent being used Tom Lane
- advice on raid controller Richard Jones
- Re: advice on raid controller allanwind@lifeintegrity.com (Allan Wind)
- Re: advice on raid controller Ron Johnson
- Re: advice on raid controller Josh Berkus
- Performance: BigInt vs Decimal(19,0) Yusuf W.
- Re: Performance: BigInt vs Decimal(19,0) Tom Lane
- Re: Performance: BigInt vs Decimal(19,0) Yusuf W.
- Re: Performance: BigInt vs Decimal(19,0) Josh Berkus
- Re: [GENERAL] Tuning/performance question. Shridhar Daithankar
- Re: advice on raid controller Matt Clark
- avoiding seqscan? Palle Girgensohn
- Re: avoiding seqscan? Josh Berkus
- Re: avoiding seqscan? Palle Girgensohn
- Re: avoiding seqscan? Josh Berkus
- Re: avoiding seqscan? Palle Girgensohn
- Re: avoiding seqscan? Palle Girgensohn
- Re: advice on raid controller scott.marlowe
- Re: avoiding seqscan? Gaetano Mendola
- Re: TPC-R benchmarks Oleg Lebedev
- Re: TPC-R benchmarks Shridhar Daithankar
- Re: Performance: BigInt vs Decimal(19,0) Franco Bruno Borghesi
- Re: Plan-Reading greg@turnstep.com
- Re: TPC-R benchmarks Mary Edie Meredith
- Re: TPC-R benchmarks Tom Lane
- Re: avoiding seqscan? Christopher Browne
- Re: avoiding seqscan? Gaetano Mendola
- Re: avoiding seqscan? Gaetano Mendola
- Re: Performance: BigInt vs Decimal(19,0) Andrew Rawnsley
- Re: TPC-R benchmarks Oleg Lebedev
- Re: TPC-R benchmarks Oleg Lebedev
- Re: TPC-R benchmarks Tom Lane
- Re: TPC-R benchmarks greg@turnstep.com
- Re: Performance: BigInt vs Decimal(19,0) Josh Berkus
- Re: advice on raid controller Will LaShell
- Re: TPC-R benchmarks Andrew Sullivan
- Re: TPC-R benchmarks Josh Berkus
- Re: TPC-R benchmarks Oleg Lebedev
- Re: advice on raid controller scott.marlowe
- Re: avoiding seqscan? Palle Girgensohn
- Re: advice on raid controller Palle Girgensohn
- Re: advice on raid controller Palle Girgensohn
- Re: advice on raid controller Matt Clark
- Re: advice on raid controller Bruce Momjian
- Test... David Griffiths
- Re: Test... Tom Lane