Mailing lists [pgsql-performance]
- Re: Understanding histograms Gregory Stark
- Please ignore ... Marc G. Fournier
- Re: Understanding histograms Tom Lane
- Re: Please ignore ... D'Arcy J.M. Cain
- Re: Please ignore ... Justin
- Re: Please ignore ... Greg Smith
- Re: Please ignore ... Tino Wildenhain
- Re: Postgres replication Fujii Masao
- Re: Please ignore ... D'Arcy J.M. Cain
- Re: Benchmarks WAS: Sun Talks about MySQL Jignesh K. Shah
- Pros and Cons of 8.3.1 Gauri Kanekar
- Re: Pros and Cons of 8.3.1 Claus Guttesen
- Re: Vacuum statistics chirag.dave@gmail.com
- Re: Please ignore ... Alvaro Herrera
- Re: Pros and Cons of 8.3.1 Justin
- Re: Pros and Cons of 8.3.1 Joshua D. Drake
- Re: Pros and Cons of 8.3.1 Kevin Grittner
- Re: Pros and Cons of 8.3.1 Kevin Grittner
- Re: Pros and Cons of 8.3.1 Kevin Grittner
- two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Scott Marlowe
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Scott Marlowe
- Re: two memory-consuming postgres processes Tom Lane
- Re: two memory-consuming postgres processes Greg Smith
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Scott Marlowe
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Craig James
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Greg Smith
- Re: two memory-consuming postgres processes PFC
- Very slow INFORMATION_SCHEMA Ernesto
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Kevin Grittner
- Re: Very slow INFORMATION_SCHEMA Tom Lane
- Re: two memory-consuming postgres processes Kevin Grittner
- Re: two memory-consuming postgres processes Alexy Khrabrov
- Re: two memory-consuming postgres processes Matthew Wakeling
- Re: two memory-consuming postgres processes Merlin Moncure
- Re: Vacuum statistics Francisco Reyes
- Re: Vacuum statistics Mark Kirkwood
- Re: pgPool query cache Hannes Dorbath
- Fastest way / best practice to calculate "next birthdays" Hannes Dorbath
- Re: Fastest way / best practice to calculate "next birthdays" Joshua D. Drake
- Re: Fastest way / best practice to calculate "next birthdays" Hannes Dorbath
- Re: Fastest way / best practice to calculate "next birthdays" Zoltan Boszormenyi
- Re: Fastest way / best practice to calculate "next birthdays" Shane Ambler
- Re: Very slow INFORMATION_SCHEMA Mario Weilguni
- Backup causing poor performance - suggestions Campbell, Lance
- Re: Backup causing poor performance - suggestions Scott Marlowe
- Re: Backup causing poor performance - suggestions Campbell, Lance
- Re: Backup causing poor performance - suggestions Scott Marlowe
- Re: Backup causing poor performance - suggestions Craig James
- Re: Backup causing poor performance - suggestions Scott Marlowe
- Re: Backup causing poor performance - suggestions Simon Riggs
- Re: Backup causing poor performance - suggestions Scott Marlowe
- Re: Backup causing poor performance - suggestions Greg Smith
- Re: Backup causing poor performance - suggestions Greg Smith
- Re: Backup causing poor performance - suggestions Scott Marlowe
- RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Craig James
- Re: Very slow INFORMATION_SCHEMA Tom Lane
- need to speed up query Justin
- Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Scott Marlowe
- Re: need to speed up query Scott Marlowe
- Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Greg Smith
- Re: need to speed up query Gregory Williamson
- Re: need to speed up query Justin
- Re: need to speed up query Justin
- Re: need to speed up query PFC
- plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt
- Re: plan difference between set-returning function with ROWS within IN() and a plain join PFC
- Seqscan problem Vlad Arkhipov
- Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt
- Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Jeff
- Re: need to speed up query Justin
- Re: plan difference between set-returning function with ROWS within IN() and a plain join Tom Lane
- Re: Seqscan problem Tom Lane
- Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt
- multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
- Re: multiple joins + Order by + LIMIT query performance issue Guillaume Smet
- What constitutes a complex query Justin
- Re: What constitutes a complex query Craig James
- Re: need to speed up query PFC
- Re: What constitutes a complex query Scott Marlowe
- Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
- Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas
- Re: need to speed up query Shaun Thomas
- Re: What constitutes a complex query Steve Atkins
- Re: What constitutes a complex query Richard Broersma
- Possible Redundancy/Performance Solution Dennis Muhlestein
- Re: need to speed up query Justin
- Re: What constitutes a complex query Justin
- Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
- Re: What constitutes a complex query Scott Marlowe
- Re: Possible Redundancy/Performance Solution Greg Smith
- Re: need to speed up query Justin
- Re: multiple joins + Order by + LIMIT query performance issue Tom Lane
- Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas
- Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas
- Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas
- Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas
- Re: RAID 10 Benchmark with different I/O schedulers Craig James
- Re: Possible Redundancy/Performance Solution Dennis Muhlestein
- Re: RAID 10 Benchmark with different I/O schedulers Greg Smith
- Re: Possible Redundancy/Performance Solution Greg Smith
- Re: RAID 10 Benchmark with different I/O schedulers Craig James
- pgfouine - commit details? Josh Cole
- Re: Possible Redundancy/Performance Solution Dennis Muhlestein
- Re: pgfouine - commit details? Guillaume Smet
- Re: Seqscan problem Vlad Arkhipov
- Re: Possible Redundancy/Performance Solution Scott Marlowe
- Re: Possible Redundancy/Performance Solution Greg Smith
- Re: pgfouine - commit details? Josh Cole
- Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
- Re: RAID 10 Benchmark with different I/O schedulers Albe Laurenz *EXTERN*
- Re: multiple joins + Order by + LIMIT query performance issue Matthew Wakeling
- Re: RAID 10 Benchmark with different I/O schedulers Matthew Wakeling
- Re: Possible Redundancy/Performance Solution Dennis Muhlestein
- Query Optimization with Kruskal’s Algorithm Tarcizio Bini
- Re: Query Optimization with Kruskal’s Algorithm Alexander Staubo
- Re: [GENERAL] Ubuntu question Justin
- Re: [GENERAL] Ubuntu question Justin
- Creating a foreign key Campbell, Lance
- Re: Creating a foreign key Joshua D. Drake
- Re: Creating a foreign key Shaun Thomas
- Re: Creating a foreign key Campbell, Lance
- Creating indexes Rauan Maemirov
- Re: Creating indexes Alan Hodgson
- Re: Creating indexes Asche
- Re: Creating a foreign key PFC
- Re: Creating indexes PFC
- Re: Creating indexes Rauan Maemirov
- Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
- Re: multiple joins + Order by + LIMIT query performance issue Scott Marlowe
- "append" takes a lot of time in a query Frank Dekervel
- Re: "append" takes a lot of time in a query Tom Lane
- Re: plan difference between set-returning function with ROWS within IN() and a plain join Merlin Moncure
- Re: Query Optimization with Kruskal’s Algorithm Rauan Maemirov
- Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris
- Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane
- Re: Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris
- Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane
- Re: Re: Query Optimization with Kruskal’s Algorithm Michael Glaesemann
- Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett
- Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Neil Peter Braggio
- RAID controllers for Postgresql on large setups Francisco Reyes
- Re: RAID controllers for Postgresql on large setups Joshua D. Drake
- Re: RAID controllers for Postgresql on large setups Francisco Reyes
- Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett
- Re: RAID controllers for Postgresql on large setups Chris Ruprecht
- Re: RAID controllers for Postgresql on large setups Joshua D. Drake
- Re: RAID controllers for Postgresql on large setups Joshua D. Drake
- Re: RAID controllers for Postgresql on large setups Greg Smith
- Installation Steps to migrate to Postgres 8.3.1 Gauri Kanekar
- Re: Installation Steps to migrate to Postgres 8.3.1 Claus Guttesen
- Re: RAID controllers for Postgresql on large setups Scott Marlowe
- Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe
- Re: RAID controllers for Postgresql on large setups PFC
- Re: RAID controllers for Postgresql on large setups Francisco Reyes
- Re: RAID controllers for Postgresql on large setups Merlin Moncure
- Re: Installation Steps to migrate to Postgres 8.3.1 Knight, Doug
- Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe
- Re: RAID controllers for Postgresql on large setups Vivek Khera
- Re: RAID controllers for Postgresql on large setups Vivek Khera
- Problem with 11 M records table idc danny
- Re: Problem with 11 M records table Bill Moran
- Re: Problem with 11 M records table salman
- Re: Problem with 11 M records table Craig James
- Re: Problem with 11 M records table Craig James
- Re: Problem with 11 M records table Scott Marlowe
- Re: RAID controllers for Postgresql on large setups James Mansion
- Re: RAID controllers for Postgresql on large setups PFC
- can I move sort to first outer join ? fernando castano
- Re: Problem with 11 M records table Ramasubramanian G
- Regexps - never completing join. Rusty Conover
- Re: Regexps - never completing join. Rusty Conover
- Re: can I move sort to first outer join ? PFC
- postgres overall performance seems to degrade when large SELECT are requested Valentin Bogdanov
- Re: postgres overall performance seems to degrade when large SELECT are requested PFC
- Re: Regexps - never completing join. Rusty Conover
- I/O on select count(*) Doug Eck
- Re: I/O on select count(*) Merlin Moncure
- Re: I/O on select count(*) Doug Eck
- Re: I/O on select count(*) Kevin Grittner
- poor row estimates with multi-column joins Robert Treat
- Update performance degrades over time Subbiah Stalin-XCGF84
- Re: I/O on select count(*) Greg Smith
- Re: I/O on select count(*) Alvaro Herrera
- Re: I/O on select count(*) Greg Smith
- Re: I/O on select count(*) Jan de Visser
- Re: I/O on select count(*) Pavan Deolasee
- Re: I/O on select count(*) Luke Lonergan
- Re: I/O on select count(*) Greg Smith
- Re: I/O on select count(*) Joshua D. Drake
- Re: I/O on select count(*) Tino Wildenhain
- Re: I/O on select count(*) Tom Lane
- Re: I/O on select count(*) Tom Lane
- which ext3 fs type should I use for postgresql Philippe Amelant
- Re: which ext3 fs type should I use for postgresql Matthew Wakeling
- Re: which ext3 fs type should I use for postgresql david@lang.hm
- Re: which ext3 fs type should I use for postgresql Matthew Wakeling
- Re: I/O on select count(*) Matthew Wakeling
- Re: I/O on select count(*) Heikki Linnakangas
- Re: I/O on select count(*) Matthew Wakeling
- Re: I/O on select count(*) Jan de Visser
- Re: I/O on select count(*) Matthew Wakeling
- Re: I/O on select count(*) Ron Mayer
- Re: Update performance degrades over time Jeffrey Baker
- Re: I/O on select count(*) Alvaro Herrera
- Re: I/O on select count(*) Tom Lane
- Re: which ext3 fs type should I use for postgresql Craig James
- Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau
- Re: I/O on select count(*) Heikki Linnakangas
- Re: I/O on select count(*) Heikki Linnakangas
- Re: I/O on select count(*) Matthew Wakeling
- Re: which ext3 fs type should I use for postgresql Matthew Wakeling
- Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau
- Re: which ext3 fs type should I use for postgresql Joshua D. Drake
- Re: I/O on select count(*) Alvaro Herrera
- Re: I/O on select count(*) Alvaro Herrera
- Re: which ext3 fs type should I use for postgresql Guillaume Cottenceau
- Re: I/O on select count(*) Tom Lane
- Re: Update performance degrades over time Subbiah Stalin-XCGF84
- Re: I/O on select count(*) Robert Lor
- Re: I/O on select count(*) Tom Lane
- Re: Update performance degrades over time Subbiah Stalin-XCGF84
- Re: I/O on select count(*) Robert Lor
- Re: I/O on select count(*) James Mansion
- Re: I/O on select count(*) Gregory Stark
- Re: I/O on select count(*) Kevin Grittner
- Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Claus Guttesen
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Simon Riggs
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Richard Huxton
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space Luke Lonergan
- Re: Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter
- Re: which ext3 fs type should I use for postgresql david@lang.hm
- Re: which ext3 fs type should I use for postgresql Scott Marlowe
- Re: which ext3 fs type should I use for postgresql Joshua D. Drake
- very slow left join Ben
- Re: I/O on select count(*) Greg Smith
- Re: very slow left join Scott Marlowe
- Re: very slow left join Ben
- Re: I/O on select count(*) Simon Riggs
- Re: very slow left join Scott Marlowe
- Re: very slow left join Ben
- Re: very slow left join Craig Ringer
- Re: I/O on select count(*) Alvaro Herrera
- Re: Regexps - never completing join. Scott Marlowe
- Re: I/O on select count(*) Alvaro Herrera
- Re: Please ignore ... Alvaro Herrera
- Re: Regexps - never completing join. Rusty Conover
- Re: Regexps - never completing join. Scott Marlowe
- Re: I/O on select count(*) Tom Lane
- Re: I/O on select count(*) Jeremy Harris
- Re: I/O on select count(*) Greg Smith
- Re: Strange behavior: pgbench and new Linux kernels Greg Smith
- Re: I/O on select count(*) Matthew Wakeling
- Re: I/O on select count(*) Bruce Momjian
- Re: I/O on select count(*) Tom Lane
- Re: I/O on select count(*) Greg Smith
- Re: I/O on select count(*) Tom Lane
- Re: I/O on select count(*) PFC
- slow update kevin kempter
- Re: slow update A. Kretschmer
- Author Wanted Markus Feilner
- Re: Author Wanted Bill Moran
- Re: slow update Scott Marlowe
- improving performance for a delete kevin kempter
- Re: improving performance for a delete kevin kempter
- Re: improving performance for a delete PFC
- Varchar pkey instead of integer Robins Tharakan
- Re: Varchar pkey instead of integer Joshua D. Drake
- Re: Varchar pkey instead of integer Craig Ringer
- Re: Varchar pkey instead of integer Shane Ambler
- Re: Varchar pkey instead of integer Craig Ringer
- Re: Varchar pkey instead of integer J. Andrew Rogers
- Posible planner improvement? Albert Cervera Areny
- Re: "append" takes a lot of time in a query Frank Dekervel
- Re: Posible planner improvement? Richard Huxton
- Re: Posible planner improvement? Albert Cervera Areny
- Re: Posible planner improvement? Mark Mielke
- Re: Posible planner improvement? Albert Cervera Areny
- Re: Posible planner improvement? Albert Cervera Areny
- Re: Posible planner improvement? Luke Lonergan
- Re: Posible planner improvement? Richard Huxton
- "Big O" notation for postgres? H. Hall
- Re: "Big O" notation for postgres? Jonah H. Harris
- Re: "Big O" notation for postgres? Richard Huxton
- Re: Posible planner improvement? PFC
- Re: "Big O" notation for postgres? PFC
- Re: Posible planner improvement? Albert Cervera Areny
- Re: "append" takes a lot of time in a query Scott Marlowe
- Re: "Big O" notation for postgres? H. Hall
- Re: Varchar pkey instead of integer Robins Tharakan
- Index creation time and distribution Guillaume Smet
- Re: Index creation time and distribution Tom Lane
- Re: Index creation time and distribution Guillaume Smet
- Re: Index creation time and distribution Matthew Wakeling
- Re: Index creation time and distribution Scott Marlowe
- Re: Index creation time and distribution Guillaume Smet
- Re: Index creation time and distribution Tom Lane
- Re: Index creation time and distribution Guillaume Smet
- Re: "Big O" notation for postgres? Gregory Stark
- Re: I/O on select count(*) Luke Lonergan
- join/from_collapse_limit and geqo_threshold default values Vlad Arkhipov
- Quad Xeon or Quad Opteron? Andrzej Zawadzki
- Re: Quad Xeon or Quad Opteron? Craig Ringer
- Re: Quad Xeon or Quad Opteron? Adam Tauno Williams
- Re: Quad Xeon or Quad Opteron? Knight, Doug
- Re: Quad Xeon or Quad Opteron? Reid Thompson
- index performance on large tables with update and insert Jessica Richard
- IBM ServRAID-MR10M / LSI1078ROC advice Kevin Grittner
- Re: index performance on large tables with update and insert Magnus Hagander
- Re: Quad Xeon or Quad Opteron? Andrzej Zawadzki
- Re: Quad Xeon or Quad Opteron? Andrzej Zawadzki
- Re: Creating large database of MD5 hash values Decibel!
- Re: shared_buffers performance Decibel!
- Re: Posible planner improvement? Decibel!
- Re: I/O on select count(*) Decibel!
- Re: I/O on select count(*) Decibel!
- Re: Quad Xeon or Quad Opteron? Jeffrey Baker
- Re: Posible planner improvement? ITAGAKI Takahiro
- Re: I/O on select count(*) Heikki Linnakangas
- Symbolic Links to Tablespaces Campbell, Lance
- Re: "Big O" notation for postgres? H. Hall
- Re: Symbolic Links to Tablespaces Tom Lane
- Re: I/O on select count(*) Tom Lane
- Re: Symbolic Links to Tablespaces Campbell, Lance
- Re: Symbolic Links to Tablespaces A. Kretschmer
- Re: Symbolic Links to Tablespaces Heikki Linnakangas
- Re: Symbolic Links to Tablespaces Tino Wildenhain
- Re: Symbolic Links to Tablespaces Heikki Linnakangas
- Re: RAID controllers for Postgresql on large setups Marinos Yannikos
- Re: [GENERAL] select query takes 13 seconds to run with index mark
- Re: [GENERAL] select query takes 13 seconds to run with index mark
- Re: [GENERAL] select query takes 13 seconds to run with index PFC
- Re: [GENERAL] select query takes 13 seconds to run with index hubert depesz lubaczewski
- Re: [GENERAL] select query takes 13 seconds to run with index mark
- Re: [GENERAL] select query takes 13 seconds to run with index hubert depesz lubaczewski
- Outer joins and equivalence Simon Riggs
- Re: I/O on select count(*) Simon Riggs
- Re: Outer joins and equivalence Tom Lane
- Re: Outer joins and equivalence Matthew Wakeling
- Re: Outer joins and equivalence Simon Riggs
- GEQO Benchmark tarcizioab@c3sl.ufpr.br
- Re: GEQO Benchmark Tom Lane
- Re: GEQO Benchmark Tarcizio Bini
- Re: GEQO Benchmark Simon Riggs
- Re: GEQO Benchmark Tarcizio Bini
- Re: Creating large database of MD5 hash values Bruce Momjian
- Re: Creating large database of MD5 hash values Tom Lane
- 2GB or not 2GB Josh Berkus
- Re: 2GB or not 2GB Steve Crawford
- Re: 2GB or not 2GB Gregory Stark
- Re: 2GB or not 2GB Greg Smith
- Re: 2GB or not 2GB Jignesh K. Shah
- Re: 2GB or not 2GB Jignesh K. Shah
- IN() statement values order makes 2x performance hit Alexey Kupershtokh
- Re: IN() statement values order makes 2x performance hit Oleg Bartunov
- Re: IN() statement values order makes 2x performance hit Alexey Kupershtokh
- Re: 2GB or not 2GB Joshua D. Drake
- Adding "LIMIT 1" kills performance. Chris Shoemaker
- Re: Adding "LIMIT 1" kills performance. Shane Ambler
- OVERLAPS is slow Chris Browne
- Re: Adding "LIMIT 1" kills performance. Chris Shoemaker
- Re: Adding "LIMIT 1" kills performance. Tom Lane
- Re: 2GB or not 2GB Magnus Hagander
- ProcArrayLock (The Saga continues) Jignesh K. Shah
- Re: ProcArrayLock (The Saga continues) Gregory Stark
- Statistics issue Vlad Arkhipov
- Re: 2GB or not 2GB Simon Riggs
- Re: Statistics issue Tom Lane
- Re: 2GB or not 2GB Josh Berkus
- Re: 2GB or not 2GB Gregory Stark