Home > mailing lists

Mailing lists [pgsql-performance]

1 October 2010

02:50 Re: gist indexes for distance calculations Marcelo Zabani
04:46 Re: gist indexes for distance calculations Karim Nassar
05:56 Re: gist indexes for distance calculations Jesper Krogh
11:13 Re: How does PG know if data is in memory? Fabrício dos Anjos Silva
12:24 Re: How does PG know if data is in memory? Craig Ringer
13:46 Re: How does PG know if data is in memory? Kevin Grittner
13:52 Re: How does PG know if data is in memory? Pierre C
14:01 Re: How does PG know if data is in memory? Fabrício dos Anjos Silva
14:40 Re: How does PG know if data is in memory? Tom Lane
16:04 Re: gist indexes for distance calculations Merlin Moncure
16:50 Re: How does PG know if data is in memory? Samuel Gendler
17:12 Re: gist indexes for distance calculations Marcelo Zabani
17:51 Re: turn off caching for performance test Willy-Bas Loos
23:46 Issue for partitioning with extra check constriants Josh Berkus
23:56 Re: Issue for partitioning with extra check constriants Tom Lane
23:58 Re: Issue for partitioning with extra check constriants Josh Berkus

2 October 2010

00:16 Re: Issue for partitioning with extra check constriants Tom Lane

3 October 2010

02:43 Re: How does PG know if data is in memory? Craig Ringer
21:40 Re: Wrong index choice Tom Lane

4 October 2010

03:07 Re: How does PG know if data is in memory? Greg Smith
03:23 Re: How does PG know if data is in memory? Greg Smith
03:29 Re: How does PG know if data is in memory? Greg Smith
03:34 Re: How does PG know if data is in memory? Greg Smith
04:02 Re: How does PG know if data is in memory? Greg Smith
15:16 MIT benchmarks pgsql multicore (up to 48)performance Hakan Kocaman
18:34 Re: Issue for partitioning with extra check constriants Josh Berkus
18:44 Re: Issue for partitioning with extra check constriants Joshua D. Drake
18:49 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Josh Berkus
19:35 Re: MIT benchmarks pgsql multicore (up to 48)performance Scott Marlowe
20:40 Re: How does PG know if data is in memory? Cédric Villemain
23:06 Re: How does PG know if data is in memory? Jeremy Harris
23:37 Re: Issue for partitioning with extra check constriants Tom Lane

5 October 2010

01:44 Re: Issue for partitioning with extra check constriants Joshua D. Drake
07:32 Runtime dependency from size of a bytea field Sander, Ingo (NSN - DE/Munich)
09:11 Error message in wal_log for Streaming replication Nimesh Satam
12:20 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Dan Ports
16:11 Re: Runtime dependency from size of a bytea field Merlin Moncure
21:05 Re: Error message in wal_log for Streaming replication Jeff Davis

6 October 2010

01:23 Re: Runtime dependency from size of a bytea field Craig Ringer
05:39 Re: Runtime dependency from size of a bytea field Sander, Ingo (NSN - DE/Munich)
12:51 Re: Runtime dependency from size of a bytea field Merlin Moncure
14:22 Re: Runtime dependency from size of a bytea field Sander, Ingo (NSN - DE/Munich)
14:50 Re: Runtime dependency from size of a bytea field Merlin Moncure
22:31 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras
22:42 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Jon Nelson
23:11 XFS vs Ext3, and schedulers, for WAL Josh Berkus

7 October 2010

00:39 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas
01:25 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Tom Lane
01:30 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost
02:01 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas
02:07 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost
04:12 Re: Runtime dependency from size of a bytea field Sander, Ingo (NSN - DE/Munich)
07:15 Re: On Scalability Vincenzo Romano
12:19 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras
12:33 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas
12:39 Re: Optimizing query Srikanth K
12:47 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras
14:49 Re: Runtime dependency from size of a bytea field Merlin Moncure
17:20 Re: Runtime dependency from size of a bytea field Merlin Moncure
17:29 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Kevin Grittner
17:48 large dataset with write vs read clients Aaron Turner
18:06 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost
18:22 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Kevin Grittner
18:38 Re: large dataset with write vs read clients Dan Harris
18:57 Re: large dataset with write vs read clients Stephen Frost
19:00 Re: large dataset with write vs read clients Stephen Frost
19:02 Re: large dataset with write vs read clients Stephen Frost
20:04 Re: large dataset with write vs read clients Aaron Turner
20:31 Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas
20:40 Re: Odd behaviour with redundant CREATE statement Robert Haas
21:47 Re: large dataset with write vs read clients Greg Smith
21:51 Re: Odd behaviour with redundant CREATE statement Dave Crooke
22:12 Re: large dataset with write vs read clients Aaron Turner
23:38 BBU Cache vs. spindles Steve Crawford

8 October 2010

04:53 Re: Runtime dependency from size of a bytea field Sander, Ingo (NSN - DE/Munich)
18:08 Re: BBU Cache vs. spindles Ben Chobot

9 October 2010

21:29 Re: large dataset with write vs read clients Florian Weimer
21:35 Re: large dataset with write vs read clients Mladen Gogala
23:26 Slow count(*) again... Neil Whelchel

10 October 2010

01:47 Re: Slow count(*) again... Scott Marlowe
02:04 Re: Slow count(*) again... Mladen Gogala
02:10 Re: Slow count(*) again... Joe Conway
02:44 Re: Slow count(*) again... Mladen Gogala
03:02 Re: Slow count(*) again... Neil Whelchel
03:07 Re: Slow count(*) again... Samuel Gendler
06:43 Re: large dataset with write vs read clients Craig Ringer
06:55 Re: large dataset with write vs read clients Mladen Gogala
06:56 Re: Slow count(*) again... Craig Ringer
07:14 Re: Slow count(*) again... Craig Ringer
07:21 Re: large dataset with write vs read clients Craig Ringer
09:52 Db slow down after table partition AI Rumman
10:29 Re: Slow count(*) again... Neil Whelchel
10:51 DB slow down after table partition AI Rumman
11:05 Re: DB slow down after table partition Thom Brown
11:45 Re: large dataset with write vs read clients Florian Weimer
12:02 Re: Slow count(*) again... Віталій Тимчишин
15:29 Re: large dataset with write vs read clients Mladen Gogala
15:30 Re: Slow count(*) again... Craig Ringer
16:10 Re: Slow count(*) again... Reid Thompson
17:14 Re: Slow count(*) again... Mladen Gogala
18:33 Re: Slow count(*) again... Reid Thompson
22:00 Re: Slow count(*) again... Neil Whelchel
22:41 Re: Slow count(*) again... Craig Ringer
22:50 Re: Slow count(*) again... Jon Nelson

11 October 2010

00:28 Re: Slow count(*) again... Joshua Tolley
00:52 Re: Slow count(*) again... Craig Ringer
03:14 Re: Slow count(*) again... Mladen Gogala
03:22 Re: Slow count(*) again... Joshua Tolley
04:12 Re: Slow count(*) again... Craig Ringer
04:17 Re: Slow count(*) again... Neil Whelchel
06:43 join order AI Rumman
06:47 Re: join order Scott Marlowe
10:09 Re: Slow count(*) again... Pierre C
17:46 Re: Slow count(*) again... Craig James
17:50 Re: XFS vs Ext3, and schedulers, for WAL Josh Berkus
18:06 Re: XFS vs Ext3, and schedulers, for WAL Joshua D. Drake
18:59 Re: XFS vs Ext3, and schedulers, for WAL Josh Berkus
20:03 Re: Slow count(*) again... Neil Whelchel
22:03 Re: Slow count(*) again... Samuel Gendler
23:50 Re: Slow count(*) again... Mladen Gogala

12 October 2010

00:52 Re: gist indexes for distance calculations Robert Haas
02:11 Re: Slow count(*) again... Scott Carey
02:19 Re: Slow count(*) again... Greg Smith
02:20 Re: Slow count(*) again... Scott Carey
02:23 Re: Slow count(*) again... Mladen Gogala
02:36 Re: Slow count(*) again... Neil Whelchel
02:59 Re: How does PG know if data is in memory? Robert Haas
03:11 Re: How does PG know if data is in memory?
03:42 Re: Slow count(*) again... Neil Whelchel
03:58 Re: Slow count(*) again... Samuel Gendler
04:05 Re: Slow count(*) again... Scott Carey
04:22 Re: Slow count(*) again... Samuel Gendler
04:42 Re: Slow count(*) again... david@lang.hm
06:32 Re: Slow count(*) again... Greg Smith
06:39 Re: Slow count(*) again... Greg Smith
07:56 Re: Slow count(*) again... Vitalii Tymchyshyn
08:15 Re: Slow count(*) again... Craig Ringer
08:22 Re: Slow count(*) again... david@lang.hm
08:34 Re: Slow count(*) again... Vitalii Tymchyshyn
11:45 Re: Slow count(*) again... Craig Ringer
12:27 Re: Slow count(*) again... Mladen Gogala
12:34 Re: How does PG know if data is in memory? Robert Haas
12:36 Re: Runtime dependency from size of a bytea field Robert Haas
13:08 Re: Slow count(*) again... Jon Nelson
13:19 Re: Slow count(*) again... Greg Smith
13:20 Re: Slow count(*) again... Luca Tettamanti
13:20 Re: Slow count(*) again... Jon Nelson
13:56 Re: Slow count(*) again... Tom Lane
13:56 Re: Slow count(*) again... Kevin Grittner
14:04 Re: Slow count(*) again... Mladen Gogala
14:20 Re: How does PG know if data is in memory?
14:23 Re: Slow count(*) again... Joe Uhl
14:36 Re: How does PG know if data is in memory? Kevin Grittner
14:49 Re: How does PG know if data is in memory?
15:15 Re: How does PG know if data is in memory? Kevin Grittner
15:15 Re: Slow count(*) again... bricklen
15:29 Re: Slow count(*) again... Kevin Grittner
15:39 Re: Slow count(*) again... Dan Harris
15:48 Re: Slow count(*) again... david@lang.hm
15:52 Re: Slow count(*) again... david@lang.hm
15:54 Re: Slow count(*) again... david@lang.hm
16:01 Re: Slow count(*) again... Scott Carey
16:23 Re: Slow count(*) again... Samuel Gendler
16:29 Re: Slow count(*) again... Chris Browne
16:34 Re: Slow count(*) again... Scott Carey
16:38 Re: Slow count(*) again... Jesper Krogh
16:43 Re: Slow count(*) again... Scott Carey
16:45 Re: Slow count(*) again... Scott Carey
16:49 Re: Slow count(*) again... Scott Carey
16:59 Re: large dataset with write vs read clients Chris Browne
16:59 Re: large dataset with write vs read clients Chris Browne
17:06 Re: Slow count(*) again... Dan Harris
17:08 Re: Slow count(*) again... Tom Lane
17:25 read only transactions Jon Nelson
17:36 Re: Slow count(*) again... Mladen Gogala
18:22 Re: Slow count(*) again... Jesper Krogh
18:58 Re: Slow count(*) again... Tom Lane
18:58 Re: read only transactions Kevin Grittner
19:33 Re: read only transactions Tom Lane
20:59 Re: read only transactions Chris Browne
21:16 bulk load performance question Samuel Gendler
21:17 Re: read only transactions Tom Lane
21:22 Re: bulk load performance question Tom Lane
21:35 Re: Slow count(*) again... Pierre C
22:21 Re: Slow count(*) again... Neil Whelchel
22:30 Re: Slow count(*) again... Mladen Gogala
22:33 Re: Slow count(*) again... Neil Whelchel
23:19 Re: Slow count(*) again... Neil Whelchel

13 October 2010

00:00 Re: Slow count(*) again... Dan Harris
00:23 Re: Query much faster with enable_seqscan=0 Ogden
02:29 Re: Query much faster with enable_seqscan=0 Samuel Gendler
03:23 Re: How does PG know if data is in memory? Ron Mayer
06:40 Re: How does PG know if data is in memory? Robert Haas
06:45 Re: Slow count(*) again... Robert Haas
06:47 Re: Slow count(*) again... Neil Whelchel
07:19 Re: Slow count(*) again... Mark Kirkwood
07:40 SQL functions vs. PL/PgSQL functions Reuven M. Lerner
07:46 Re: Slow count(*) again... Pierre C
08:12 Re: SQL functions vs. PL/PgSQL functions Craig Ringer
08:38 Re: Slow count(*) again... Neil Whelchel
08:42 Re: Slow count(*) again... Mladen Gogala
08:44 Re: Slow count(*) again... Mladen Gogala
08:50 Re: Slow count(*) again... Mark Kirkwood
10:16 Re: Slow count(*) again... Neil Whelchel
10:41 Re: Slow count(*) again... Vitalii Tymchyshyn
10:54 Re: Slow count(*) again... Vitalii Tymchyshyn
11:42 Re: Slow count(*) again... Craig Ringer
12:12 Re: Slow count(*) again... Greg Smith
12:34 Re: Slow count(*) again... Mladen Gogala
13:02 Re: Slow count(*) again... Greg Smith
13:27 Re: Slow count(*) again... Robert Haas
13:29 Re: Slow count(*) again... Robert Haas
13:45 Re: Slow count(*) again... Kevin Grittner
13:49 Re: Slow count(*) again... Tom Lane
13:50 Re: SQL functions vs. PL/PgSQL functions Merlin Moncure
14:14 Re: SQL functions vs. PL/PgSQL functions Tom Lane
17:16 Bogus startup cost for WindowAgg Ants Aasma
21:48 Re: Slow count(*) again... Jesper Krogh
23:59 Re: Slow count(*) again... Alex Hunsaker

14 October 2010

04:04 Re: Slow count(*) again... Alex Hunsaker
04:59 Re: Bogus startup cost for WindowAgg Mladen Gogala
04:59 Re: SQL functions vs. PL/PgSQL functions Reuven M. Lerner
05:07 Re: Slow count(*) again... david@lang.hm
06:46 Re: Slow count(*) again... Neil Whelchel
07:11 Re: Slow count(*) again... Neil Whelchel
08:11 Re: Bogus startup cost for WindowAgg Tom Lane
09:11 Re: Slow count(*) again... Mark Kirkwood
09:25 Re: Slow count(*) again... Mark Kirkwood
09:44 Re: Bogus startup cost for WindowAgg Mladen Gogala
09:45 Re: Slow count(*) again... Robert Haas
10:15 Re: Slow count(*) again... mark
10:17 Re: Bogus startup cost for WindowAgg Ants Aasma
14:30 Re: SQL functions vs. PL/PgSQL functions Merlin Moncure
14:43 Re: SQL functions vs. PL/PgSQL functions Tom Lane
15:32 Re: Slow count(*) again... Jesper Krogh
18:48 Re: How does PG know if data is in memory? Cédric Villemain
19:49 oracle to psql migration - slow query in postgres Tony Capobianco
19:56 Re: Slow count(*) again... Robert Haas
20:23 Re: oracle to psql migration - slow query in postgres bricklen
20:32 Re: oracle to psql migration - slow query in postgres Ivan Voras
21:26 Re: oracle to psql migration - slow query in postgres Cédric Villemain
22:57 Re: oracle to psql migration - slow query in postgres Pierre C

15 October 2010

00:24 Re: oracle to psql migration - slow query in postgres Jon Nelson
03:59 Re: oracle to psql migration - slow query in postgres Mladen Gogala
05:04 Re: Slow count(*) again... Jesper Krogh
05:23 odd postgresql performance (excessive lseek) Jon Nelson
08:13 Re: oracle to psql migration - slow query in postgres Samuel Gendler
08:36 Re: Slow count(*) again... Devrim GÜNDÜZ
14:51 Re: oracle to psql migration - slow query in postgres Mladen Gogala
15:06 Re: oracle to psql migration - slow query in postgres Merlin Moncure
15:48 Re: oracle to psql migration - slow query in postgres Tony Capobianco
15:49 Re: oracle to psql migration - slow query in postgres Maciek Sakrejda
16:29 Re: Slow count(*) again... Mladen Gogala
16:29 Stored procedure declared as VOLATILE => no good optimization is done Damon Snyder
16:29 Re: Slow count(*) again... Mladen Gogala
16:29 help with understanding EXPLAIN and boosting performance Brandon Casci
16:29 Index scan / Index cond limitation or ? Nikolai Zhubr
16:29 Re: Auto ANALYZE criteria Joe Miller
16:29 help with understanding EXPLAIN Brandon Casci
17:43 Re: oracle to psql migration - slow query in postgres Igor Neyman
18:14 Re: oracle to psql migration - slow query in postgres Tony Capobianco
18:29 Re: Index scan / Index cond limitation or ? Tom Lane
18:35 Re: help with understanding EXPLAIN and boosting performance Tom Lane
18:54 Re: oracle to psql migration - slow query in postgres Igor Neyman
19:23 Re: oracle to psql migration - slow query in postgres Tony Capobianco
19:24 Re: Stored procedure declared as VOLATILE => no good optimization is done Kevin Grittner
21:07 Re: Stored procedure declared as VOLATILE => no good optimization is done Merlin Moncure

16 October 2010

01:47 Re: Stored procedure declared as VOLATILE => no good optimization is done Tatsuo Ishii
01:58 UUID performance as primary key Navkirat Singh
02:31 Re: Stored procedure declared as VOLATILE => no good optimization is done Tom Lane
02:59 Re: UUID performance as primary key Craig Ringer
03:28 Re: Slow count(*) again... Greg Smith
03:47 Re: UUID performance as primary key Andy
05:03 Re: No hash join across partitioned tables? Alvaro Herrera
05:22 Re: No hash join across partitioned tables? Tom Lane
05:35 Re: No hash join across partitioned tables? Samuel Gendler
15:29 Re: No hash join across partitioned tables? Alvaro Herrera
16:54 Select count(*), the sequel Mladen Gogala
18:30 Re: UUID performance as primary key Craig James
18:44 Re: Select count(*), the sequel Kenneth Marshall
19:35 Re: UUID performance as primary key Merlin Moncure
19:54 Re: Stored procedure declared as VOLATILE => no good optimization is done Merlin Moncure

18 October 2010

05:16 how to get the total number of records in report AI Rumman
06:04 Re: Index scan / Index cond limitation or ? Nikolai Zhubr
06:04 Help with duration of statement: EXECUTE [PREPARE: COMMIT] Eric Comeau
06:04 Select count(*), the sequel Mladen Gogala
06:15 Re: No hash join across partitioned tables? Samuel Gendler
07:58 Re: Select count(*), the sequel Vitalii Tymchyshyn
11:41 Re: Select count(*), the sequel Mladen Gogala
14:14 Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT] Tom Lane
14:25 Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT] Mladen Gogala
14:45 Re: No hash join across partitioned tables? Alvaro Herrera
15:02 Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT] Tom Lane
15:53 Re: how to get the total number of records in report Josh Kupershmidt
20:59 unexpected query failure: ERROR: GIN indexes do not support whole-index scans Jon Nelson
23:01 Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans Tom Lane

19 October 2010

01:39 HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey
02:48 Re: unexpected query failure: ERROR: GIN indexes do not support whole-index scans Jon Nelson
03:43 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane
07:18 Re: how to get the total number of records in report AI Rumman
08:59 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey
11:53 Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT] Eric Comeau
13:11 Re: odd postgresql performance (excessive lseek) Jon Nelson
13:28 Re: odd postgresql performance (excessive lseek) Merlin Moncure
13:41 Re: odd postgresql performance (excessive lseek) Jon Nelson
14:12 Re: how to get the total number of records in report Greg Spiegelberg
14:22 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Mladen Gogala
14:25 Re: Help with duration of statement: EXECUTE [PREPARE: COMMIT] Tom Lane
14:36 Re: odd postgresql performance (excessive lseek) Tom Lane
15:17 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Kevin Grittner
15:35 Re: odd postgresql performance (excessive lseek) Jon Nelson
16:28 Re: odd postgresql performance (excessive lseek) Greg Smith
17:41 Re: odd postgresql performance (excessive lseek) Merlin Moncure
18:22 Slow Query- Simple taking Ozer, Pam
21:02 Re: Slow Query- Simple taking Kevin Grittner
21:51 Re: Slow Query- Simple taking Mathieu De Zutter
22:06 Re: Slow Query- Simple taking Ozer, Pam
23:56 Re: how to get the total number of records in report Merlin Moncure

20 October 2010

19:07 What is postmaster doing? Dimi Paun
19:31 Re: What is postmaster doing? Reid Thompson
19:51 Re: What is postmaster doing? Dimi Paun
19:59 Re: What is postmaster doing? Jeff Davis
20:26 Re: What is postmaster doing? Tom Lane
20:30 Re: What is postmaster doing? Mladen Gogala
20:39 Re: What is postmaster doing? Dimi Paun
20:45 Re: What is postmaster doing? Tom Lane
20:55 Re: What is postmaster doing? Dimi Paun
20:57 Re: What is postmaster doing? Tom Lane
21:47 Re: What is postmaster doing? Scott Marlowe
21:51 Re: What is postmaster doing? Scott Marlowe

21 October 2010

02:14 Re: BBU Cache vs. spindles Bruce Momjian
02:26 Re: BBU Cache vs. spindles Joshua D. Drake
02:39 Re: What is postmaster doing? Greg Smith
04:07 Re: Slow count(*) again... Bruce Momjian
04:45 Re: BBU Cache vs. spindles Scott Marlowe
04:46 Re: Slow count(*) again... Scott Carey
05:25 Index scan is not working, why?? AI Rumman
07:51 Re: Index scan is not working, why?? Samuel Gendler
07:54 Re: Index scan is not working, why?? Scott Marlowe
12:52 Periodically slow inserts Gael Le Mignot
13:03 Re: Periodically slow inserts Kenneth Marshall
13:15 Re: Periodically slow inserts Leonardo Francalanci
13:27 Re: Index scan is not working, why?? Mladen Gogala
14:08 New wiki page on write reliability Greg Smith
14:34 Re: New wiki page on write reliability Brad Nicholson
14:56 Re: Periodically slow inserts Tom Lane
15:07 Re: Periodically slow inserts Gael Le Mignot
15:11 Re: Periodically slow inserts Leonardo Francalanci
15:30 Re: Periodically slow inserts Leonardo Francalanci
15:45 Re: New wiki page on write reliability Greg Smith
15:49 Re: Periodically slow inserts Cédric Villemain
16:03 Re: Periodically slow inserts Greg Smith
16:08 Re: Periodically slow inserts Gael Le Mignot
16:09 Re: New wiki page on write reliability Bruce Momjian
16:15 Re: Periodically slow inserts Mladen Gogala
16:43 Re: BBU Cache vs. spindles Steve Crawford
16:50 Re: Periodically slow inserts Tom Lane
16:51 Re: BBU Cache vs. spindles Bruce Momjian
16:56 Re: BBU Cache vs. spindles Kevin Grittner
17:00 Re: BBU Cache vs. spindles Bruce Momjian
17:04 Re: BBU Cache vs. spindles Greg Smith
17:15 Re: BBU Cache vs. spindles Kevin Grittner
17:31 Re: BBU Cache vs. spindles Greg Smith
18:14 Re: Slow count(*) again... Jesper Krogh
18:54 Re: BBU Cache vs. spindles Kevin Grittner
18:55 Re: How does PG know if data is in memory? Bruce Momjian
19:00 Experiences with running PostgreSQL on Blue Arc Network Storage Tim Goodaire
19:08 Re: BBU Cache vs. spindles Bruce Momjian
19:31 Re: BBU Cache vs. spindles Kevin Grittner
19:35 Re: BBU Cache vs. spindles Bruce Momjian
19:42 Re: BBU Cache vs. spindles Kevin Grittner
20:01 Re: BBU Cache vs. spindles Bruce Momjian
20:14 Re: Index scan is not working, why?? Igor Neyman
20:18 Re: BBU Cache vs. spindles Andres Freund
23:10 Re: Slow count(*) again... Scott Carey

22 October 2010

03:47 Re: BBU Cache vs. spindles Greg Smith
04:05 Re: BBU Cache vs. spindles Tom Lane
04:06 Re: BBU Cache vs. spindles Greg Smith
07:50 Re: Periodically slow inserts Leonardo Francalanci
13:46 Re: BBU Cache vs. spindles Kevin Grittner
15:11 Re: Periodically slow inserts Gael Le Mignot
15:37 Re: BBU Cache vs. spindles Greg Smith
16:36 Re: BBU Cache vs. spindles Jesper Krogh
17:17 Re: BBU Cache vs. spindles Rob Wultsch
17:28 Re: BBU Cache vs. spindles Kevin Grittner
18:42 Re: BBU Cache vs. spindles Rob Wultsch
19:05 Re: BBU Cache vs. spindles Kevin Grittner
20:06 Re: BBU Cache vs. spindles Rob Wultsch
20:15 Re: BBU Cache vs. spindles Kevin Grittner

23 October 2010

04:08 Re: BBU Cache vs. spindles Rob Wultsch
16:41 Re: BBU Cache vs. spindles Kevin Grittner
21:03 Re: BBU Cache vs. spindles Josh Berkus

24 October 2010

08:15 Re: BBU Cache vs. spindles James Mansion
16:53 Re: BBU Cache vs. spindles Greg Smith
17:05 Re: BBU Cache vs. spindles Greg Smith
20:40 Re: BBU Cache vs. spindles Tom Lane

25 October 2010

10:24 Re: Useless sort by Gaetano Mendola
18:16 Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:20 Re: Postgres insert performance and storage requirement compared to Oracle Joshua D. Drake
18:26 Re: Postgres insert performance and storage requirement compared to Oracle Scott Marlowe
18:28 AIX slow buffer reads André Volpato
18:31 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:33 Re: Postgres insert performance and storage requirement compared to Oracle Josh Kupershmidt
18:36 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:39 Re: Postgres insert performance and storage requirement compared to Oracle Joshua D. Drake
18:46 Re: Postgres insert performance and storage requirement compared to Oracle Steve Singer
18:49 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:50 Re: AIX slow buffer reads Merlin Moncure
18:52 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:56 Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala
19:22 Re: Postgres insert performance and storage requirement compared to Oracle Ray Stell
19:26 Re: AIX slow buffer reads André Volpato
19:26 Re: Postgres insert performance and storage requirement compared to Oracle Scott Marlowe
19:51 Re: Postgres insert performance and storage requirement compared to Oracle Alan Hodgson
20:29 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
20:51 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
22:37 interpret statement log duration information Mark Rostron
22:54 Re: interpret statement log duration information Tom Lane

26 October 2010

07:21 Re: BBU Cache vs. spindles Scott Carey
10:56 which one is faster AI Rumman
10:59 Re: which one is faster Szymon Guz
11:44 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
11:59 Re: which one is faster Marcin Mirosław
12:06 Re: which one is faster Szymon Guz
12:08 Re: which one is faster Grzegorz Jaśkiewicz
12:16 Re: which one is faster Szymon Guz
12:20 Re: which one is faster Grzegorz Jaśkiewicz
12:23 Re: which one is faster Szymon Guz
12:23 Re: No hash join across partitioned tables? Robert Haas
12:24 Re: Auto ANALYZE criteria Robert Haas
12:33 Re: which one is faster Mladen Gogala
12:41 Re: BBU Cache vs. spindles Robert Haas
12:55 CPUs for new databases Christian Elmerot
13:20 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
14:07 Re: AIX slow buffer reads Brad Nicholson
14:14 Re: BBU Cache vs. spindles Rob Wultsch
14:25 Re: BBU Cache vs. spindles Robert Haas
14:27 Re: CPUs for new databases Kevin Grittner
14:51 Re: CPUs for new databases Scott Marlowe
15:08 Re: Postgres insert performance and storage requirement compared to Oracle Leonardo Francalanci
15:23 Re: CPUs for new databases Christian Elmerot
15:42 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
20:54 Re: CPUs for new databases Josh Berkus
21:03 Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala
21:04 Re: AIX slow buffer reads André Volpato
21:27 Re: Postgres insert performance and storage requirement compared to Oracle Jon Nelson
21:55 Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala
22:14 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
22:45 Re: Select count(*), the sequel Robert Haas
22:50 Re: Postgres insert performance and storage requirement compared to Oracle Robert Haas
22:51 Re: Select count(*), the sequel Tom Lane
23:17 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
23:27 Slow Query- Bad Row Estimate Ozer, Pam
23:49 Re: CPUs for new databases James Cloos

27 October 2010

00:21 Re: CPUs for new databases Ivan Voras
01:14 Re: CPUs for new databases Scott Marlowe
01:48 Re: Select count(*), the sequel Robert Haas
02:56 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Robert Haas
03:05 Re: odd postgresql performance (excessive lseek) Robert Haas
03:48 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane
03:57 Re: odd postgresql performance (excessive lseek) Tom Lane
04:42 Re: BBU Cache vs. spindles Rob Wultsch
07:32 Re: CPUs for new databases Yeb Havinga
07:52 Re: CPUs for new databases Scott Marlowe
08:07 Re: CPUs for new databases Scott Marlowe
10:13 Re: Postgres insert performance and storage requirement compared to Oracle Ivan Voras
11:05 Re: Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
12:42 Re: AIX slow buffer reads Brad Nicholson
12:48 Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes
13:17 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Pavel Stehule
14:00 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
14:53 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes
14:56 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Marcin Mirosław
15:14 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes
15:19 Re: Running 9 in production? Sticking with 8.4.4 for a while? Francisco Reyes
15:42 Re: Postgres insert performance and storage requirement compared to Oracle Steve Singer
15:49 Re: Postgres insert performance and storage requirement compared to Oracle Reid Thompson
15:50 Re: Postgres insert performance and storage requirement compared to Oracle David Wilson
16:09 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Tom Lane
16:12 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
17:02 Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Francisco Reyes
17:05 Re: AIX slow buffer reads André Volpato
17:30 temporary tables, indexes, and query plans Jon Nelson
17:44 Re: temporary tables, indexes, and query plans Mladen Gogala
17:47 Re: Postgres insert performance and storage requirement compared to Oracle Scott Carey
18:03 Re: CPUs for new databases Josh Berkus
18:06 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
18:07 Re: Postgres insert performance and storage requirement compared to Oracle Mladen Gogala
18:07 Re: temporary tables, indexes, and query plans Jon Nelson
18:13 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
18:14 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
18:23 Re: temporary tables, indexes, and query plans Jon Nelson
18:28 Re: CPUs for new databases Scott Marlowe
18:28 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
18:33 Re: temporary tables, indexes, and query plans Reid Thompson
18:38 Massive update, memory usage Trenta sis
18:42 Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh
18:51 Re: Postgres insert performance and storage requirement compared to Oracle Steve Singer
18:51 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
18:58 Re: Massive update, memory usage Andreas Kretschmer
19:00 Re: temporary tables, indexes, and query plans Jon Nelson
19:17 Re: CPUs for new databases Scott Marlowe
19:24 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey
19:24 Re: AIX slow buffer reads Greg Smith
19:29 Re: temporary tables, indexes, and query plans Jon Nelson
19:43 Re: temporary tables, indexes, and query plans Tom Lane
19:45 Re: Postgres insert performance and storage requirement compared to Oracle Alex Hunsaker
19:47 Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh
19:53 Re: Select count(*), the sequel Pierre C
19:56 Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane
19:59 Re: CPUs for new databases Greg Smith
20:10 Re: AIX slow buffer reads Tom Lane
20:11 Re: Select count(*), the sequel Kevin Grittner
20:36 Re: temporary tables, indexes, and query plans Jon Nelson
20:41 Re: Select count(*), the sequel Kenneth Marshall
20:54 Re: Select count(*), the sequel Thomas Kellerer
20:57 Re: AIX slow buffer reads André Volpato
21:46 Re: temporary tables, indexes, and query plans Tom Lane
21:49 Re: Select count(*), the sequel Tom Lane
22:03 Re: temporary tables, indexes, and query plans Jon Nelson
22:36 Re: temporary tables, indexes, and query plans Tom Lane
22:37 Re: AIX slow buffer reads Brad Nicholson
22:45 Re: AIX slow buffer reads Tom Lane
23:24 Re: Massive update, memory usage Craig Ringer

28 October 2010

01:55 Re: BBU Cache vs. spindles Robert Haas
02:01 Re: Re: Postgres insert performance and storage requirement compared to Oracle Robert Haas
02:30 Re: How does PG know if data is in memory? Francisco Reyes
03:09 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
03:32 Re: Re: Postgres insert performance and storage requirement compared to Oracle Tom Lane
03:44 Re: BBU Cache vs. spindles Rob Wultsch
04:24 Re: Postgres insert performance and storage requirement compared to Oracle Alex Hunsaker
04:26 Re: Postgres insert performance and storage requirement compared to Oracle Pavel Stehule
08:16 Massive update, memory usage Trenta sis
09:33 Re: Select count(*), the sequel Pierre C
12:33 Re: AIX slow buffer reads André Volpato
13:13 Re: Postgres insert performance and storage requirement compared to Oracle Merlin Moncure
13:34 Re: Select count(*), the sequel Kenneth Marshall
14:08 Re: temporary tables, indexes, and query plans Jon Nelson
14:23 Re: temporary tables, indexes, and query plans Tom Lane
14:39 Re: Slow Query- Simple taking Robert Haas
14:40 Re: Slow Query- Simple taking Robert Haas
14:42 Re: Slow Query- Simple taking Robert Haas
14:51 Re: Slow Query- Simple taking Mladen Gogala
14:53 Re: Slow Query- Simple taking Richard Broersma
15:23 Re: Slow Query- Simple taking Mladen Gogala
15:29 Re: Postgres insert performance and storage requirement compared to Oracle Jesper Krogh
15:31 Re: How does PG know if data is in memory? Cédric Villemain
15:38 Re: Massive update, memory usage Cédric Villemain
16:18 Re: Slow Query- Simple taking Robert Haas
16:21 Re: Query much faster with enable_seqscan=0 Robert Haas
16:37 partitioning question 1 Ben
17:05 Re: how to get the total number of records in report Robert Haas
17:31 Re: partitioning question 1 Joshua D. Drake
17:40 Re: how to get the total number of records in report Merlin Moncure
17:49 Re: how to get the total number of records in report AI Rumman
18:18 Re: how to get the total number of records in report Merlin Moncure
18:44 Re: partitioning question 1 Ben
18:50 Re: partitioning question 1 Joshua D. Drake
19:25 Re: partitioning question 1 Ben
19:44 Re: partitioning question 1 Joshua D. Drake
20:00 Re: partitioning question 1 Ben
20:08 Re: partitioning question 1 Reid Thompson
20:33 Re: BBU Cache vs. spindles James Mansion
20:48 Re: partitioning question 1 Joshua D. Drake
21:07 Re: partitioning question 1 Ben
21:26 Re: BBU Cache vs. spindles Tom Lane
21:48 Re: Massive update, memory usage Trenta sis
22:28 Re: Massive update, memory usage Emanuele Bracci Poste

29 October 2010

14:38 Re: partitioning question 1 Igor Neyman
15:44 Re: BBU Cache vs. spindles Robert Haas
15:56 Re: BBU Cache vs. spindles Aidan Van Dyk
15:57 Re: BBU Cache vs. spindles Tom Lane
16:16 Re: partitioning question 1 Ben
16:28 Re: partitioning question 1 Igor Neyman
16:44 Re: BBU Cache vs. spindles Robert Haas
16:45 typoed column name, but postgres didn't grump Jon Nelson
16:46 CPUs for new databases Christian Elmerot @ One.com
16:46 MVCC and Implications for (Near) Real-Time Application Steve Wong
16:46 Re: Stored procedure declared as VOLATILE => no good optimization is done Damon Snyder
16:46 Re: Postgres insert performance and storage requirement compared to Oracle Divakar Singh
16:46 Re: temporary tables, indexes, and query plans Justin Pitts
16:46 Re: temporary tables, indexes, and query plans Justin Pitts
17:05 Re: MVCC and Implications for (Near) Real-Time Application A.M.
17:18 Re: MVCC and Implications for (Near) Real-Time Application Kevin Grittner
17:48 Re: typoed column name, but postgres didn't grump Tom Lane
18:16 Re: temporary tables, indexes, and query plans Robert Haas
18:39 Re: typoed column name, but postgres didn't grump Kevin Grittner
18:49 Re: BBU Cache vs. spindles Alvaro Herrera
19:07 Re: typoed column name, but postgres didn't grump Tom Lane
19:09 Re: BBU Cache vs. spindles david@lang.hm
20:34 Re: MVCC and Implications for (Near) Real-Time Application Pierre C
20:52 Re: BBU Cache vs. spindles James Mansion
20:54 Slow Query- Bad Row Estimate Ozer, Pam
21:09 Re: Slow Query- Bad Row Estimate Josh Berkus
21:14 Re: BBU Cache vs. spindles david@lang.hm
21:17 Re: Slow Query- Bad Row Estimate Tom Lane
21:40 Re: Slow Query- Bad Row Estimate Kevin Grittner
21:46 Re: Slow Query- Bad Row Estimate Ozer, Pam
21:48 Re: Slow Query- Bad Row Estimate Ozer, Pam
21:50 Re: Slow Query- Bad Row Estimate Tom Lane
21:55 Re: Slow Query- Bad Row Estimate Josh Berkus
21:56 Re: Slow Query- Bad Row Estimate Ozer, Pam
22:03 Re: Slow Query- Bad Row Estimate Tom Lane
22:10 Re: Slow Query- Bad Row Estimate Ozer, Pam

31 October 2010

12:14 Defaulting wal_sync_method to fdatasync on Linux for 9.1? Marti Raudsepp
19:59 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Greg Smith
23:10 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? Andres Freund