Postgresql Performance

Date Index

[Prev Page][Next Page]

Re: Major Linux performance regression; shouldn't we be worried about RHEL6?, (continued)
Running PostgreSQL as fast as possible no matter the consequences, A B
- Re: Running PostgreSQL as fast as possible no matter the consequences, Thom Brown
  - Re: Running PostgreSQL as fast as possible no matter the consequences, Thom Brown
  - Re: Running PostgreSQL as fast as possible no matter the consequences, A B
- Re: Running PostgreSQL as fast as possible no matter the consequences, Guillaume Cottenceau
  - Re: Running PostgreSQL as fast as possible no matter the consequences, Marti Raudsepp
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Guillaume Cottenceau
- Re: Running PostgreSQL as fast as possible no matter the consequences, Szymon Guz
  - Re: Running PostgreSQL as fast as possible no matter the consequences, A B
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Marti Raudsepp
      - Re: Running PostgreSQL as fast as possible no matter the consequences, Thom Brown
      - Re: Running PostgreSQL as fast as possible no matter the consequences, Guillaume Cottenceau
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Jon Nelson
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Robert Haas
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Andy Colson
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Robert Haas
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Craig Ringer
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Lello, Nick
      - Re: Running PostgreSQL as fast as possible no matter the consequences, Dimitri Fontaine
      - Re: Running PostgreSQL as fast as possible no matter the consequences, Klaus Ita
- Re: Running PostgreSQL as fast as possible no matter the consequences, Craig Ringer
  - Re: Running PostgreSQL as fast as possible no matter the consequences, A B
- Re: Running PostgreSQL as fast as possible no matter the consequences, Devrim GÜNDÜZ
  - Re: Running PostgreSQL as fast as possible no matter the consequences, Mladen Gogala
- Re: Running PostgreSQL as fast as possible no matter the consequences, Chris Browne
  - Re: Running PostgreSQL as fast as possible no matter the consequences, Bruce Momjian
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Fabrízio de Royes Mello
    - Re: Running PostgreSQL as fast as possible no matter the consequences, Robert Haas
      - Re: Running PostgreSQL as fast as possible no matter the consequences, Bruce Momjian
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Jeff Janes
        
        Re: Running PostgreSQL as fast as possible no matter the consequences, Bruce Momjian
Simple (hopefully) throughput question?, Nick Matheson
- Re: Simple (hopefully) throughput question?, Heikki Linnakangas
  - Re: Simple (hopefully) throughput question?, Nick Matheson
    - Re: Simple (hopefully) throughput question?, Vitalii Tymchyshyn
      - Re: Simple (hopefully) throughput question?, Maciek Sakrejda
      - Re: Simple (hopefully) throughput question?, Samuel Gendler
        
        Re: Simple (hopefully) throughput question?, Samuel Gendler
- Re: Simple (hopefully) throughput question?, Marti Raudsepp
  - Re: Simple (hopefully) throughput question?, Nick Matheson
- Re: Simple (hopefully) throughput question?, Andy Colson
  - Re: Simple (hopefully) throughput question?, Nick Matheson
  - Re: Simple (hopefully) throughput question?, Nick Matheson
    - Re: Simple (hopefully) throughput question?, Pierre C
- Re: Simple (hopefully) throughput question?, Pierre C
- Message not available
  - Re: Simple (hopefully) throughput question?, Nick Matheson
- Re: Simple (hopefully) throughput question?, Robert Klemme
- <Possible follow-ups>
- Re: Simple (hopefully) throughput question?, Nick Matheson
Bufer cache replacement LRU algorithm?, Mladen Gogala
- Re: Bufer cache replacement LRU algorithm?, Kenneth Marshall
  - Re: Bufer cache replacement LRU algorithm?, Kevin Grittner
- Re: Bufer cache replacement LRU algorithm?, Greg Smith
Array interface, Mladen Gogala
- Re: Array interface, Conor Walsh
  - Re: Array interface, Mladen Gogala
- <Possible follow-ups>
- Array interface, Mladen Gogala
  - Re: Array interface, Mark Kirkwood
    - Re: Array interface, Mark Kirkwood
- Array interface, Mladen Gogala
A query become very slow after upgrade from 8.1.10 to 8.4.5, Yaocl
- Re: A query become very slow after upgrade from 8.1.10 to 8.4.5, Tom Lane
  - Re: A query become very slow after upgrade from 8.1.10 to 8.4.5, Yaocl
Insert performance with composite index, Divakar Singh
- Re: Insert performance with composite index, Marti Raudsepp
  - Re: Insert performance with composite index, Divakar Singh
    - Re: Insert performance with composite index, Marti Raudsepp
- Re: Insert performance with composite index, Cédric Villemain
  - Re: Insert performance with composite index, hubert depesz lubaczewski
    - Re: Insert performance with composite index, Cédric Villemain
      - Re: Insert performance with composite index, hubert depesz lubaczewski
        
        Re: Insert performance with composite index, Cédric Villemain
      - Re: Insert performance with composite index, Divakar Singh
- Re: Insert performance with composite index, Andres Freund
  - Message not available
    - Re: Insert performance with composite index, Andres Freund
      - Re: Insert performance with composite index, Divakar Singh
        
        Re: Insert performance with composite index, Andres Freund
        
        Re: Insert performance with composite index, Divakar Singh
        
        Re: Insert performance with composite index, Andres Freund
Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
- Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
  - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
    - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
      - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Scott Carey
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Robert Haas
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Josh Berkus
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Josh Berkus
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Tom Lane
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Jignesh Shah
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Mladen Gogala
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Scott Carey
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Robert Haas
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Scott Carey
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Jon Nelson
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Greg Smith
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Scott Carey
      - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Andres Freund
      - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Josh Berkus
        
        Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Pierre C
  - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Marti Raudsepp
  - Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?, Mark Kirkwood
MVCC and Implications for (Near) Real-Time Application, Steve Wong
- Re: MVCC and Implications for (Near) Real-Time Application, A.M.
- Re: MVCC and Implications for (Near) Real-Time Application, Kevin Grittner
- Re: MVCC and Implications for (Near) Real-Time Application, Pierre C
typoed column name, but postgres didn't grump, Jon Nelson
- Re: typoed column name, but postgres didn't grump, Tom Lane
  - Re: typoed column name, but postgres didn't grump, Kevin Grittner
    - Re: typoed column name, but postgres didn't grump, Tom Lane
partitioning question 1, Ben
- Re: partitioning question 1, Joshua D. Drake
  - Re: partitioning question 1, Ben
    - Re: partitioning question 1, Joshua D. Drake
      - Re: partitioning question 1, Ben
        
        Re: partitioning question 1, Joshua D. Drake
        
        Re: partitioning question 1, Ben
        
        Re: partitioning question 1, Reid Thompson
        
        Re: partitioning question 1, Joshua D. Drake
        
        Re: partitioning question 1, Ben
- Re: partitioning question 1, Igor Neyman
  - Re: partitioning question 1, Ben
    - Re: partitioning question 1, Igor Neyman
Massive update, memory usage, Trenta sis
- Re: Massive update, memory usage, Andreas Kretschmer
- Re: Massive update, memory usage, Craig Ringer
  - Message not available
    - Massive update, memory usage, Trenta sis
      - Re: Massive update, memory usage, Cédric Villemain
        
        Re: Massive update, memory usage, Trenta sis
        
        Re: Massive update, memory usage, Emanuele Bracci Poste
temporary tables, indexes, and query plans, Jon Nelson
- Re: temporary tables, indexes, and query plans, Mladen Gogala
  - Re: temporary tables, indexes, and query plans, Jon Nelson
    - Re: temporary tables, indexes, and query plans, Jon Nelson
      - Re: temporary tables, indexes, and query plans, Reid Thompson
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Justin Pitts
        
        Re: temporary tables, indexes, and query plans, Robert Haas
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Jon Nelson
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Robert Haas
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Robert Haas
        
        Re: temporary tables, indexes, and query plans, Tom Lane
        
        Re: temporary tables, indexes, and query plans, Justin Pitts
Regression: 8.3 2 seconds -> 8.4 100+ seconds, Francisco Reyes
- Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Pavel Stehule
  - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Francisco Reyes
    - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Marcin Mirosław
      - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Francisco Reyes
- Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Tom Lane
  - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Francisco Reyes
- Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Robert Haas
  - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Francisco Reyes
  - Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds, Greg Smith
Slow Query- Bad Row Estimate, Ozer, Pam
- <Possible follow-ups>
- Slow Query- Bad Row Estimate, Ozer, Pam
  - Re: Slow Query- Bad Row Estimate, Josh Berkus
    - Re: Slow Query- Bad Row Estimate, Ozer, Pam
      - Re: Slow Query- Bad Row Estimate, Josh Berkus
        
        Re: Slow Query- Bad Row Estimate, Ozer, Pam
        
        Re: Slow Query- Bad Row Estimate, Tom Lane
        
        Re: Slow Query- Bad Row Estimate, Ozer, Pam
  - Re: Slow Query- Bad Row Estimate, Tom Lane
    - Re: Slow Query- Bad Row Estimate, Ozer, Pam
      - Re: Slow Query- Bad Row Estimate, Tom Lane
  - Re: Slow Query- Bad Row Estimate, Kevin Grittner
CPUs for new databases, Christian Elmerot
- Re: CPUs for new databases, Kevin Grittner
  - Re: CPUs for new databases, Christian Elmerot
- Re: CPUs for new databases, Scott Marlowe
  - Re: CPUs for new databases, Josh Berkus
    - Re: CPUs for new databases, James Cloos
      - Re: CPUs for new databases, Ivan Voras
        
        Re: CPUs for new databases, Scott Marlowe
        
        Re: CPUs for new databases, Yeb Havinga
        
        Re: CPUs for new databases, Scott Marlowe
        
        Re: CPUs for new databases, Scott Marlowe
        
        Re: CPUs for new databases, Josh Berkus
        
        Re: CPUs for new databases, Scott Marlowe
        
        Re: CPUs for new databases, Scott Marlowe
        
        Re: CPUs for new databases, Greg Smith
        
        Re: CPUs for new databases, Christian Elmerot @ One.com
        
        Re: CPUs for new databases, Greg Smith
        
        Re: CPUs for new databases, Scott Carey
- <Possible follow-ups>
- CPUs for new databases, Christian Elmerot @ One.com
- Re: CPUs for new databases, Kevin Grittner
which one is faster, AI Rumman
- Re: which one is faster, Szymon Guz
  - Re: which one is faster, Marcin Mirosław
    - Re: which one is faster, Szymon Guz
      - Re: which one is faster, Grzegorz Jaśkiewicz
        
        Re: which one is faster, Szymon Guz
        
        Re: which one is faster, Grzegorz Jaśkiewicz
        
        Re: which one is faster, Szymon Guz
- Re: which one is faster, Mladen Gogala
interpret statement log duration information, Mark Rostron
- Re: interpret statement log duration information, Tom Lane
AIX slow buffer reads, André Volpato
- Re: AIX slow buffer reads, Merlin Moncure
  - Re: AIX slow buffer reads, André Volpato
    - Re: AIX slow buffer reads, Brad Nicholson
      - Re: AIX slow buffer reads, André Volpato
        
        Re: AIX slow buffer reads, Brad Nicholson
        
        Re: AIX slow buffer reads, André Volpato
        
        Re: AIX slow buffer reads, Greg Smith
        
        Re: AIX slow buffer reads, Tom Lane
        
        Re: AIX slow buffer reads, Brad Nicholson
        
        Re: AIX slow buffer reads, Tom Lane
        
        Re: AIX slow buffer reads, André Volpato
        
        Re: AIX slow buffer reads, André Volpato
Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
- Re: Postgres insert performance and storage requirement compared to Oracle, Joshua D. Drake
  - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
    - Re: Postgres insert performance and storage requirement compared to Oracle, Steve Singer
      - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
- Re: Postgres insert performance and storage requirement compared to Oracle, Scott Marlowe
  - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
    - Re: Postgres insert performance and storage requirement compared to Oracle, Joshua D. Drake
      - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
    - Re: Postgres insert performance and storage requirement compared to Oracle, Mladen Gogala
    - Re: Postgres insert performance and storage requirement compared to Oracle, Scott Marlowe
    - Re: Postgres insert performance and storage requirement compared to Oracle, Alan Hodgson
- Re: Postgres insert performance and storage requirement compared to Oracle, Josh Kupershmidt
- Message not available
  - Message not available
    - Re: Postgres insert performance and storage requirement compared to Oracle, Ray Stell
- Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
  - Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
    - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
      - Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Leonardo Francalanci
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Mladen Gogala
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Jon Nelson
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Mladen Gogala
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Robert Haas
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Jesper Krogh
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Jesper Krogh
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Jesper Krogh
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Steve Singer
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Scott Carey
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Mladen Gogala
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Postgres insert performance and storage requirement compared to Oracle, Ivan Voras
        
        Re: Re: Postgres insert performance and storage requirement compared to Oracle, Merlin Moncure
        
        Re: Re: Postgres insert performance and storage requirement compared to Oracle, Robert Haas
        
        Re: Re: Postgres insert performance and storage requirement compared to Oracle, Tom Lane
- <Possible follow-ups>
- Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
  - Re: Postgres insert performance and storage requirement compared to Oracle, Steve Singer
    - Re: Postgres insert performance and storage requirement compared to Oracle, Reid Thompson
  - Re: Postgres insert performance and storage requirement compared to Oracle, David Wilson
    - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
  - Re: Postgres insert performance and storage requirement compared to Oracle, Alex Hunsaker
    - Re: Postgres insert performance and storage requirement compared to Oracle, Divakar Singh
      - Re: Postgres insert performance and storage requirement compared to Oracle, Alex Hunsaker
      - Re: Postgres insert performance and storage requirement compared to Oracle, Pavel Stehule
Experiences with running PostgreSQL on Blue Arc Network Storage, Tim Goodaire
New wiki page on write reliability, Greg Smith
- Re: New wiki page on write reliability, Brad Nicholson
  - Re: New wiki page on write reliability, Greg Smith
- Re: New wiki page on write reliability, Bruce Momjian
Periodically slow inserts, Gael Le Mignot
- Re: Periodically slow inserts, Kenneth Marshall
- Re: Periodically slow inserts, Leonardo Francalanci
  - Re: Periodically slow inserts, Gael Le Mignot
    - Re: Periodically slow inserts, Leonardo Francalanci
    - Re: Periodically slow inserts, Leonardo Francalanci
      - Re: Periodically slow inserts, Cédric Villemain
    - Re: Periodically slow inserts, Greg Smith
- Re: Periodically slow inserts, Tom Lane
  - Re: Periodically slow inserts, Gael Le Mignot
    - Re: Periodically slow inserts, Tom Lane
      - Re: Periodically slow inserts, Leonardo Francalanci
- Re: Periodically slow inserts, Mladen Gogala
- Re: Periodically slow inserts, Gael Le Mignot
Index scan is not working, why??, AI Rumman
- Re: Index scan is not working, why??, Samuel Gendler
  - Re: Index scan is not working, why??, Scott Marlowe
- Re: Index scan is not working, why??, Mladen Gogala
- Re: Index scan is not working, why??, Igor Neyman
What is postmaster doing?, Dimi Paun
- Re: What is postmaster doing?, Reid Thompson
  - Re: What is postmaster doing?, Dimi Paun
- Re: What is postmaster doing?, Jeff Davis
  - Re: What is postmaster doing?, Tom Lane
    - Re: What is postmaster doing?, Dimi Paun
      - Re: What is postmaster doing?, Tom Lane
        
        Re: What is postmaster doing?, Dimi Paun
        
        Re: What is postmaster doing?, Tom Lane
        
        Re: What is postmaster doing?, Scott Marlowe
        
        Re: What is postmaster doing?, Scott Marlowe
        
        Re: What is postmaster doing?, Greg Smith
- Re: What is postmaster doing?, Mladen Gogala
Slow Query- Simple taking, Ozer, Pam
- Re: Slow Query- Simple taking, Kevin Grittner
  - Re: Slow Query- Simple taking, Ozer, Pam
    - Re: Slow Query- Simple taking, Robert Haas
      - Re: Slow Query- Simple taking, Mladen Gogala
        
        Re: Slow Query- Simple taking, Richard Broersma
        
        Re: Slow Query- Simple taking, Mladen Gogala
        
        Re: Slow Query- Simple taking, Robert Haas
- Re: Slow Query- Simple taking, Mathieu De Zutter
- Re: Slow Query- Simple taking, Robert Haas
  - Re: Slow Query- Simple taking, Robert Haas
HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Scott Carey
- Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Tom Lane
  - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Scott Carey
    - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Mladen Gogala
      - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Kevin Grittner
- Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Robert Haas
  - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Tom Lane
    - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Scott Carey
      - Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?, Tom Lane
unexpected query failure: ERROR: GIN indexes do not support whole-index scans, Jon Nelson
- Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans, Tom Lane
  - Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans, Jon Nelson
Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Eric Comeau
- Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Tom Lane
  - Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Mladen Gogala
    - Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Tom Lane
      - Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Eric Comeau
        
        Re: Help with duration of statement: EXECUTE <unnamed> [PREPARE: COMMIT], Tom Lane
how to get the total number of records in report, AI Rumman
- Re: how to get the total number of records in report, Josh Kupershmidt
  - Re: how to get the total number of records in report, AI Rumman
    - Re: how to get the total number of records in report, Greg Spiegelberg
- Re: how to get the total number of records in report, Merlin Moncure
  - Re: how to get the total number of records in report, Robert Haas
    - Re: how to get the total number of records in report, Merlin Moncure
    - Re: how to get the total number of records in report, AI Rumman
      - Re: how to get the total number of records in report, Merlin Moncure
Select count(*), the sequel, Mladen Gogala
- Re: Select count(*), the sequel, Kenneth Marshall
  - Re: Select count(*), the sequel, Robert Haas
    - Re: Select count(*), the sequel, Tom Lane
      - Re: Select count(*), the sequel, Robert Haas
      - Re: Select count(*), the sequel, Pierre C
        
        Re: Select count(*), the sequel, Kevin Grittner
        
        Re: Select count(*), the sequel, Pierre C
        
        Re: Select count(*), the sequel, Kenneth Marshall
        
        Re: Select count(*), the sequel, Thomas Kellerer
        
        Re: Select count(*), the sequel, Tom Lane
        
        Re: Select count(*), the sequel, Kenneth Marshall
- <Possible follow-ups>
- Select count(*), the sequel, Mladen Gogala
  - Re: Select count(*), the sequel, Vitalii Tymchyshyn
    - Re: Select count(*), the sequel, Mladen Gogala
UUID performance as primary key, Navkirat Singh
- Re: UUID performance as primary key, Craig Ringer
  - Re: UUID performance as primary key, Andy
  - Re: UUID performance as primary key, Merlin Moncure
- Re: UUID performance as primary key, Craig James
Re: Stored procedure declared as VOLATILE => no good optimization is done, Kevin Grittner
help with understanding EXPLAIN, Brandon Casci
Index scan / Index cond limitation or ?, Nikolai Zhubr
- Re: Index scan / Index cond limitation or ?, Tom Lane
  - Re: Index scan / Index cond limitation or ?, Nikolai Zhubr
help with understanding EXPLAIN and boosting performance, Brandon Casci
- Re: help with understanding EXPLAIN and boosting performance, Tom Lane
Stored procedure declared as VOLATILE => no good optimization is done, Damon Snyder
- Re: Stored procedure declared as VOLATILE => no good optimization is done, Merlin Moncure
  - Re: Stored procedure declared as VOLATILE => no good optimization is done, Tatsuo Ishii
    - Re: Stored procedure declared as VOLATILE => no good optimization is done, Tom Lane
      - Re: Stored procedure declared as VOLATILE => no good optimization is done, Merlin Moncure
        
        Re: Stored procedure declared as VOLATILE => no good optimization is done, Damon Snyder
odd postgresql performance (excessive lseek), Jon Nelson
- Re: odd postgresql performance (excessive lseek), Jon Nelson
  - Re: odd postgresql performance (excessive lseek), Merlin Moncure
    - Re: odd postgresql performance (excessive lseek), Jon Nelson
  - Re: odd postgresql performance (excessive lseek), Tom Lane
    - Re: odd postgresql performance (excessive lseek), Jon Nelson
      - Re: odd postgresql performance (excessive lseek), Greg Smith
        
        Re: odd postgresql performance (excessive lseek), Merlin Moncure
    - Re: odd postgresql performance (excessive lseek), Robert Haas
      - Re: odd postgresql performance (excessive lseek), Tom Lane
oracle to psql migration - slow query in postgres, Tony Capobianco
- Re: oracle to psql migration - slow query in postgres, bricklen
- Re: oracle to psql migration - slow query in postgres, Ivan Voras
- Re: oracle to psql migration - slow query in postgres, Cédric Villemain
  - Re: oracle to psql migration - slow query in postgres, Maciek Sakrejda
- Re: oracle to psql migration - slow query in postgres, Pierre C
- Re: oracle to psql migration - slow query in postgres, Jon Nelson
  - Re: oracle to psql migration - slow query in postgres, Mladen Gogala
    - Re: oracle to psql migration - slow query in postgres, Samuel Gendler
      - Re: oracle to psql migration - slow query in postgres, Mladen Gogala
    - Re: oracle to psql migration - slow query in postgres, Tony Capobianco
- Re: oracle to psql migration - slow query in postgres, Merlin Moncure
- Re: oracle to psql migration - slow query in postgres, Igor Neyman
  - Re: oracle to psql migration - slow query in postgres, Tony Capobianco
    - Re: oracle to psql migration - slow query in postgres, Igor Neyman
      - Re: oracle to psql migration - slow query in postgres, Tony Capobianco
Bogus startup cost for WindowAgg, Ants Aasma
- Re: Bogus startup cost for WindowAgg, Mladen Gogala
  - Re: Bogus startup cost for WindowAgg, Ants Aasma
- Re: Bogus startup cost for WindowAgg, Tom Lane
- Re: Bogus startup cost for WindowAgg, Mladen Gogala
SQL functions vs. PL/PgSQL functions, Reuven M. Lerner
- Re: SQL functions vs. PL/PgSQL functions, Craig Ringer
- Re: SQL functions vs. PL/PgSQL functions, Merlin Moncure
- Re: SQL functions vs. PL/PgSQL functions, Tom Lane
  - Re: SQL functions vs. PL/PgSQL functions, Reuven M. Lerner
  - Re: SQL functions vs. PL/PgSQL functions, Merlin Moncure
    - Re: SQL functions vs. PL/PgSQL functions, Tom Lane
bulk load performance question, Samuel Gendler
- Re: bulk load performance question, Tom Lane
read only transactions, Jon Nelson
- Re: read only transactions, Kevin Grittner
- Re: read only transactions, Tom Lane
- Re: read only transactions, Chris Browne
  - Re: read only transactions, Tom Lane
join order, AI Rumman
- Re: join order, Scott Marlowe
Db slow down after table partition, AI Rumman
- <Possible follow-ups>
- DB slow down after table partition, AI Rumman
  - Re: DB slow down after table partition, Thom Brown
Slow count(*) again..., Neil Whelchel
- Re: Slow count(*) again..., Scott Marlowe
  - Re: Slow count(*) again..., Neil Whelchel
    - Re: Slow count(*) again..., Craig Ringer
      - Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., Reid Thompson
        
        Re: Slow count(*) again..., Reid Thompson
    - Re: Slow count(*) again..., Віталій Тимчишин
      - Re: Slow count(*) again..., Neil Whelchel
  - Re: Slow count(*) again..., Craig James
    - Re: Slow count(*) again..., Neil Whelchel
      - Re: Slow count(*) again..., Samuel Gendler
      - Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Kevin Grittner
        
        Re: Slow count(*) again..., Joe Uhl
        
        Re: Slow count(*) again..., david
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Pierre C
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Pierre C
      - Re: Slow count(*) again..., Mladen Gogala
    - Re: Slow count(*) again..., Vitalii Tymchyshyn
      - Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., david
        
        Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., david
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Vitalii Tymchyshyn
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Jon Nelson
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Jon Nelson
        
        Re: Slow count(*) again..., Kevin Grittner
        
        Re: Slow count(*) again..., Luca Tettamanti
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Tom Lane
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Tom Lane
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Tom Lane
        
        Re: Slow count(*) again..., Vitalii Tymchyshyn
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Robert Haas
        
        Re: Slow count(*) again..., david
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Vitalii Tymchyshyn
        
        Re: Slow count(*) again..., Scott Carey
- Re: Slow count(*) again..., Mladen Gogala
  - Re: Slow count(*) again..., Joe Conway
    - Re: Slow count(*) again..., Mladen Gogala
      - Re: Slow count(*) again..., Samuel Gendler
  - Re: Slow count(*) again..., Craig Ringer
    - Re: Slow count(*) again..., Mladen Gogala
      - Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., Joshua Tolley
        
        Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Joshua Tolley
        
        Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Samuel Gendler
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Samuel Gendler
        
        Re: Slow count(*) again..., david
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Samuel Gendler
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Craig Ringer
        
        Re: Slow count(*) again..., Chris Browne
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Mark Kirkwood
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Mark Kirkwood
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Robert Haas
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Robert Haas
        
        Re: Slow count(*) again..., mark
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Robert Haas
        
        Re: Slow count(*) again..., Jesper Krogh
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Mark Kirkwood
        
        Re: Slow count(*) again..., Robert Haas
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Alex Hunsaker
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Mark Kirkwood
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Kevin Grittner
        
        Re: Slow count(*) again..., Tom Lane
        
        Re: Slow count(*) again..., Alex Hunsaker
        
        Re: Slow count(*) again..., david
      - Re: Slow count(*) again..., Jon Nelson
      - Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Dan Harris
        
        Re: Slow count(*) again..., Scott Carey
        
        Re: Slow count(*) again..., Dan Harris
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Mladen Gogala
        
        Re: Slow count(*) again..., Greg Smith
        
        Re: Slow count(*) again..., Devrim GÜNDÜZ
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Neil Whelchel
        
        Re: Slow count(*) again..., Dan Harris
- Re: Slow count(*) again..., Pierre C
- Re: Slow count(*) again..., bricklen
  - Re: Slow count(*) again..., Bruce Momjian
BBU Cache vs. spindles, Steve Crawford
- Re: BBU Cache vs. spindles, Ben Chobot
  - Re: BBU Cache vs. spindles, Bruce Momjian
    - Re: BBU Cache vs. spindles, Joshua D. Drake
      - Re: BBU Cache vs. spindles, Scott Marlowe
        
        Re: BBU Cache vs. spindles, Steve Crawford
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Andres Freund
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Tom Lane
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Jesper Krogh
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Scott Carey
        
        Re: BBU Cache vs. spindles, Josh Berkus
        
        Re: BBU Cache vs. spindles, Robert Haas
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Robert Haas
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Robert Haas
        
        Re: BBU Cache vs. spindles, Rob Wultsch
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Pierre C
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Kevin Grittner
        
        Re: BBU Cache vs. spindles, Bruce Momjian
        
        Re: BBU Cache vs. spindles, James Mansion
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Tom Lane
        
        Re: BBU Cache vs. spindles, James Mansion
        
        Re: BBU Cache vs. spindles, Tom Lane
        
        Re: BBU Cache vs. spindles, Robert Haas
        
        Re: BBU Cache vs. spindles, Aidan Van Dyk
        
        Re: BBU Cache vs. spindles, Robert Haas
        
        Re: BBU Cache vs. spindles, Tom Lane
        
        Re: BBU Cache vs. spindles, david
        
        Re: BBU Cache vs. spindles, James Mansion
        
        Re: BBU Cache vs. spindles, david
        
        Re: BBU Cache vs. spindles, Greg Smith
        
        Re: BBU Cache vs. spindles, Alvaro Herrera
- <Possible follow-ups>
- Re: BBU Cache vs. spindles, Kevin Grittner
large dataset with write vs read clients, Aaron Turner
- Re: large dataset with write vs read clients, Dan Harris
  - Re: large dataset with write vs read clients, Stephen Frost
- Re: large dataset with write vs read clients, Stephen Frost
- Re: large dataset with write vs read clients, Stephen Frost
  - Re: large dataset with write vs read clients, Aaron Turner
- Re: large dataset with write vs read clients, Greg Smith
  - Re: large dataset with write vs read clients, Aaron Turner
  - Re: large dataset with write vs read clients, Florian Weimer
    - Re: large dataset with write vs read clients, Mladen Gogala
      - Re: large dataset with write vs read clients, Craig Ringer
        
        Re: large dataset with write vs read clients, Mladen Gogala
        
        Re: large dataset with write vs read clients, Craig Ringer
        
        Re: large dataset with write vs read clients, Chris Browne
      - Re: large dataset with write vs read clients, Florian Weimer
        
        Re: large dataset with write vs read clients, Mladen Gogala
      - Re: large dataset with write vs read clients, Chris Browne
Re: Optimizing query, Srikanth K
- <Possible follow-ups>
- Optimizing query, pasman pasmański
  - Re: Optimizing query, Pierre C
- Re: Optimizing query, pasman pasmański
Re: On Scalability, Vincenzo Romano
XFS vs Ext3, and schedulers, for WAL, Josh Berkus
- Re: XFS vs Ext3, and schedulers, for WAL, Josh Berkus
  - Re: XFS vs Ext3, and schedulers, for WAL, Joshua D. Drake
    - Re: XFS vs Ext3, and schedulers, for WAL, Josh Berkus
Error message in wal_log for Streaming replication, Nimesh Satam
- Re: Error message in wal_log for Streaming replication, Jeff Davis
Runtime dependency from size of a bytea field, Sander, Ingo (NSN - DE/Munich)
- Re: Runtime dependency from size of a bytea field, Merlin Moncure
  - Re: Runtime dependency from size of a bytea field, Craig Ringer

[Index of Archives] [Postgresql Home] [Postgresql General] [PHP on Windows] [Yosemite News]

Powered by Linux