Архив рассылок [pgsql-performance]
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 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
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" Zoltan Boszormenyi
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 Scott Marlowe
Re: Backup causing poor performance - suggestions Scott Marlowe
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: need to speed up query Gregory Williamson
Re: need to speed up query Justin
Re: need to speed up query Justin
plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt
Seqscan problem Vlad Arkhipov
Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt
Re: need to speed up query Justin
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: What constitutes a complex query Craig James
Re: What constitutes a complex query Scott Marlowe
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
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: 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 Heikki Linnakangas
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas
Re: Possible Redundancy/Performance Solution Dennis Muhlestein
Re: Possible Redundancy/Performance Solution Greg Smith
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
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 indexes Rauan Maemirov
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux
"append" takes a lot of time in a query Frank Dekervel
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 Jonah H. Harris
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
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 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
Problem with 11 M records table idc danny
Re: Problem with 11 M records table Bill Moran
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
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: 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 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
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
Re: I/O on select count(*) Greg Smith
Re: very slow left join Scott Marlowe
Re: I/O on select count(*) Simon Riggs
Re: very slow left join Scott Marlowe
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(*) 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
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
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? Albert Cervera Areny
Re: "append" takes a lot of time in a query Scott Marlowe
Re: Varchar pkey instead of integer Robins Tharakan
Index creation time and distribution Guillaume Smet
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 Guillaume Smet
Re: "Big O" notation for postgres? Gregory Stark
Re: I/O on select count(*) Luke Lonergan
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: 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: 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 hubert depesz lubaczewski
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
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: 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