Mailing lists [pgsql-performance]

1 June 2008

• 06:08   Re: 2GB or not 2GB Simon Riggs

2 June 2008

• 14:08   Re: Outer joins and equivalence Simon Riggs
• 16:44   Re: Outer joins and equivalence Simon Riggs
• 18:43   getting estimated cost to agree with actual Justin
• 20:38   Re: getting estimated cost to agree with actual Scott Marlowe
• 22:20   Re: getting estimated cost to agree with actual Gregory Stark

3 June 2008

• 00:13   Re: getting estimated cost to agree with actual Scott Marlowe
• 05:18   query performance question Marcin Citowicki
• 05:31   Re: query performance question hubert depesz lubaczewski
• 05:58   Re: query performance question Marcin Citowicki
• 06:26   Re: query performance question [email protected]
• 19:42   insert/update tps slow with indices on table > 1M rows andrew klassen
• 21:04   Re: query performance question PFC
• 21:08   Re: insert/update tps slow with indices on table > 1M rows PFC
• 23:44   Re: insert/update tps slow with indices on table > 1M rows andrew klassen

4 June 2008

• 03:04   Re: insert/update tps slow with indices on table > 1M rows Scott Marlowe
• 07:31   Re: insert/update tps slow with indices on table > 1M rows Matthew Wakeling
• 11:08   RAM / Disk ratio, any rule? Mathieu Gilardet
• 11:53   backend pid changing Lewis Kapell
• 12:05   Re: insert/update tps slow with indices on table > 1M rows andrew klassen
• 12:07   Re: backend pid changing Matthew Wakeling
• 12:10   Re: backend pid changing Tom Lane
• 12:11   Re: insert/update tps slow with indices on table > 1M rows Matthew Wakeling
• 12:18   Re: backend pid changing Lewis Kapell
• 12:58   PgPool parallel query performance rules of thumb John Beaver
• 14:24   Re: insert/update tps slow with indices on table > 1M rows andrew klassen
• 17:10   Re: insert/update tps slow with indices on table > 1M rows James Mansion
• 17:15   Re: insert/update tps slow with indices on table > 1M rows James Mansion
• 18:30   Re: insert/update tps slow with indices on table > 1M rows andrew klassen
• 18:42   Re: insert/update tps slow with indices on table > 1M rows PFC
• 19:52   Re: insert/update tps slow with indices on table > 1M rows Tom Lane
• 21:52   Re: RAM / Disk ratio, any rule? Greg Smith

5 June 2008

• 03:18   Re: insert/update tps slow with indices on table > 1M rows Heikki Linnakangas
• 13:08   Re: query performance question Dan Harris
• 14:16   Re: query performance question Kenneth Marshall
• 17:23   Re: query performance question Dan Harris

6 June 2008

• 03:30   Checkpoint tuning on 8.2.4 Greg Smith
• 10:21   Optimizing AGE() Volkan YAZICI
• 12:01   Re: PgPool parallel query performance rules of thumb Mason Sharp
• 14:29   Re: Checkpoint tuning on 8.2.4 Scott Marlowe

8 June 2008

• 03:12   Re: Optimizing AGE() Scott Marlowe

9 June 2008

• 19:58   Re: Performance of aggregates over set-returning functions John Smith
• 21:48   Re: Performance of aggregates over set-returning functions Tom Lane

11 June 2008

• 06:59   Scalability question Zoltan Boszormenyi
• 07:15   Re: Scalability question [email protected]
• 07:37   Re: Scalability question Zoltan Boszormenyi
• 10:34   Re: Scalability question Alvaro Herrera
• 11:13   Re: Scalability question Scott Marlowe
• 22:56   8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Josh Rovero

12 June 2008

• 09:28   Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Kenneth Marshall
• 10:26   Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Josh Rovero

15 June 2008

• 10:48   how to find the sql using most of the i/o in an oltp system Uwe Bartels
• 11:41   Re: how to find the sql using most of the i/o in an oltp system Uwe Bartels
• 12:00   Re: how to find the sql using most of the i/o in an oltp system Gavin M. Roy

16 June 2008

• 06:06   function difference(geometry,geometry) is SLOW! [email protected]
• 14:57   Tsearch2 Initial Search Speed Howard Cole
• 15:25   Re: Tsearch2 Initial Search Speed Alan Hodgson
• 16:26   Re: [pgsql-performance] function difference(geometry,geometry) is SLOW! Chris Mair

17 June 2008

• 06:56   Re: Tsearch2 Initial Search Speed Howard Cole
• 07:56   Re: Tsearch2 Initial Search Speed Howard Cole
• 08:01   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 08:05   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 08:25   Re: Tsearch2 Initial Search Speed Howard Cole
• 08:31   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 09:02   Re: Tsearch2 Initial Search Speed Howard Cole
• 10:14   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 10:14   Migration Articles.. ??? sathiya psql
• 10:23   Re: Migration Articles.. ??? Matthew Wakeling
• 10:34   Re: Tsearch2 Initial Search Speed Howard Cole
• 11:06   Which hardware ? Lionel
• 11:23   Re: Which hardware ? Scott Marlowe
• 11:25   Re: Which hardware ? Andrew Sullivan
• 11:32   Re: Which hardware ? Scott Marlowe
• 11:34   Re: Which hardware ? Matthew Wakeling
• 12:06   Re: Which hardware ? Lionel
• 12:32   Re: Which hardware ? Greg Smith
• 12:43   Re: Which hardware ? Scott Marlowe
• 12:43   Re: Which hardware ? Andrew Sullivan
• 12:55   Re: Tsearch2 Initial Search Speed Alan Hodgson
• 12:56   Re: Tsearch2 Initial Search Speed Alan Hodgson
• 13:04   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 13:22   Re: Which hardware ? Scott Marlowe
• 13:32   Re: Which hardware ? Greg Smith
• 13:56   Re: Which hardware ? Greg Smith
• 14:07   Re: Which hardware ? Scott Marlowe
• 15:06   Re: Which hardware ? Lionel
• 15:31   Re: Which hardware ? Scott Marlowe
• 18:15   Re: Which hardware ? Greg Smith
• 22:15   Re: Which hardware ? Jon D

18 June 2008

• 07:42   Re: Tsearch2 Initial Search Speed Howard Cole
• 09:39   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 13:18   Partial backup of linked tables Cisko
• 16:43   WAL DUDAS Antonio Perez
• 22:13   An "obvious" index not being used Daniele Varrazzo
• 22:43   Re: An "obvious" index not being used Tom Lane
• 23:19   Re: An "obvious" index not being used Daniele Varrazzo

19 June 2008

• 04:13   Re: WAL DUDAS Albe Laurenz
• 06:06   Re: Tsearch2 Initial Search Speed Howard Cole
• 10:47   Re: An "obvious" index not being used Kevin Grittner
• 11:13   Re: An "obvious" index not being used Daniele Varrazzo

20 June 2008

• 08:07   Re: Which hardware ? Lionel
• 10:13   Re: Tsearch2 Initial Search Speed Howard Cole

23 June 2008

• 08:06   Postgresql is very slow bijayant kumar
• 09:35   Re: Postgresql is very slow Jan de Visser
• 10:36   Re: Postgresql is very slow Jeremy Harris
• 10:49   Re: Postgresql is very slow [email protected]
• 19:21   Re: Postgresql is very slow Gregory S. Youngblood
• 19:42   Re: Checkpoint tuning on 8.2.4 Kevin Grittner

24 June 2008

• 03:23   Re: Postgresql is very slow bijayant kumar
• 04:52   Re: Postgresql is very slow Scott Marlowe
• 04:53   Re: Postgresql is very slow Scott Marlowe
• 05:17   Re: Postgresql is very slow [email protected]
• 06:17   Re: Postgresql is very slow bijayant kumar
• 06:33   Re: Postgresql is very slow Ian Barwick
• 07:01   Re: Postgresql is very slow [email protected]
• 09:14   Re: Postgresql is very slow bijayant kumar
• 09:15   Re: Postgresql is very slow PFC

25 June 2008

• 01:58   Postgresql update op is very very slow jay
• 03:39   Re: [SOLVED] Postgresql is very slow bijayant kumar
• 03:42   Re: Postgresql update op is very very slow Rusty Conover
• 04:41   答复: [PERFORM] Postgresql update op is very very slow jay
• 05:06   PostgreSQL and Ruby on Rails - better accessibility Amol Pujari
• 05:36   Re: PostgreSQL and Ruby on Rails - better accessibility Nikhils
• 07:11   Re: Postgresql update op is very very slow Heikki Linnakangas
• 07:16   Hardware suggestions for high performance 8.3 Henrik
• 07:57   Re: Hardware suggestions for high performance 8.3 Claus Guttesen
• 08:05   Hardware vs Software RAID Adrian Moisey
• 08:16   Re: Hardware suggestions for high performance 8.3 Matthew Wakeling
• 09:13   Re: Hardware suggestions for high performance 8.3 Henrik
• 09:15   Re: Hardware suggestions for high performance 8.3 Henrik
• 09:40   Re: Hardware suggestions for high performance 8.3 Claus Guttesen
• 09:48   Re: Hardware suggestions for high performance 8.3 Matthew Wakeling
• 09:52   Re: Hardware vs Software RAID Merlin Moncure
• 10:04   Re: Hardware vs Software RAID Matthew Wakeling
• 10:26   Re: Hardware vs Software RAID Peter T. Breuer
• 10:51   Re: Postgresql update op is very very slow Greg Smith
• 10:57   Re: Hardware suggestions for high performance 8.3 Greg Smith
• 12:24   Re: Hardware vs Software RAID Greg Smith
• 12:31   Re: Hardware vs Software RAID Jonah H. Harris
• 12:35   Re: Hardware vs Software RAID Joshua D. Drake
• 12:35   Re: Hardware vs Software RAID Matthew Wakeling
• 12:45   Re: Hardware suggestions for high performance 8.3 Greg Smith
• 12:53   Re: Hardware vs Software RAID Scott Marlowe
• 12:56   Re: Hardware vs Software RAID Joshua D. Drake
• 13:05   Re: Hardware vs Software RAID Peter T. Breuer
• 14:35   Re: Hardware vs Software RAID Merlin Moncure
• 14:46   Re: Hardware vs Software RAID Merlin Moncure
• 15:00   Re: Hardware vs Software RAID Andrew Sullivan
• 15:07   Re: Hardware vs Software RAID Kevin Grittner
• 15:27   Re: Hardware vs Software RAID Andrew Sullivan
• 17:00   Re: Hardware vs Software RAID Greg Smith
• 17:06   Re: Hardware vs Software RAID Greg Smith
• 18:07   Query Planner not choosing hash_aggregate appropriately. Scott Carey
• 19:36   Re: Hardware suggestions for high performance 8.3 Henrik

26 June 2008

• 01:20   Typecast bug? Craig James
• 02:30   Re: RAID 10 Benchmark with different I/O schedulers Craig James
• 02:34   Re: Typecast bug? Tom Lane
• 03:24   Re: Typecast bug? Craig James
• 04:03   Re: Typecast bug? Frank Joerdens
• 04:13   Re: Typecast bug? Guillaume Smet
• 07:06   答复: [PERFORM] Postgresql update op is very very slow jay
• 07:31   Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow Pavan Deolasee
• 09:19   Re: ??: Postgresql update op is very very slow Heikki Linnakangas
• 10:05   Re: ??: Postgresql update op is very very slow Holger Hoffstaette
• 10:17   Re: ??: Postgresql update op is very very slow Craig Ringer
• 10:38   Re: Hardware suggestions for high performance 8.3 Henrik
• 10:45   Re: Hardware vs Software RAID Greg Smith
• 10:49   Re: Hardware vs Software RAID Vivek Khera
• 10:53   Re: ??: Postgresql update op is very very slow Andrew Sullivan
• 10:55   Re: ??: Postgresql update op is very very slow Andrew Sullivan
• 11:02   Re: Hardware vs Software RAID Peter T. Breuer
• 11:53   Re: ??: Postgresql update op is very very slow Mark Mielke
• 12:04   Re: 答复: [PERFORM] Postgresql update op is very very slow  Tom Lane
• 13:00   Re: [PERFORM] Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow Scott Marlowe
• 13:03   Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow Scott Marlowe
• 13:14   Re: Hardware vs Software RAID Matthew Wakeling
• 13:32   Re: Hardware vs Software RAID Scott Marlowe
• 14:27   Re: Hardware vs Software RAID Merlin Moncure
• 14:35   Re: Hardware vs Software RAID Merlin Moncure
• 16:15   Re: Hardware vs Software Raid Peter T. Breuer
• 17:01   Re: Hardware vs Software Raid Merlin Moncure
• 17:23   Re: Hardware vs Software Raid [email protected]
• 17:40   Federated Postgresql architecture ? kevin kempter
• 17:57   Re: Federated Postgresql architecture ? Jonah H. Harris
• 18:36   Re: Federated Postgresql architecture ? Josh Berkus
• 18:41   Re: Federated Postgresql architecture ? Jonah H. Harris
• 19:15   Re: ??: Postgresql update op is very very slow Greg Smith
• 19:20   Re: ??: Postgresql update op is very very slow Greg Smith
• 19:26   Re: Federated Postgresql architecture ? Josh Berkus
• 20:16   Re: Hardware vs Software Raid Greg Smith
• 23:05   Re: Federated Postgresql architecture ? Jonah H. Harris
• 23:18   Re: Hardware vs Software RAID Robert Treat

27 June 2008

• 01:48   Re: Hardware suggestions for high performance 8.3 Greg Smith
• 02:40   Re: Hardware suggestions for high performance 8.3 Scott Marlowe
• 03:23   Re: Hardware suggestions for high performance 8.3 Joshua D. Drake
• 08:00   Re: Hardware vs Software RAID Matthew Wakeling
• 10:16   Re: Hardware vs Software RAID Merlin Moncure
• 11:48   A guide/tutorial to performance monitoring and tuning Nikhil G. Daddikar
• 12:38   Re: A guide/tutorial to performance monitoring and tuning Andreas Kretschmer
• 14:21   Re: A guide/tutorial to performance monitoring and tuning Scott Marlowe
• 14:56   Sources of information about sizing of hardwares to run PostgreSQL Sérgio R F Oliveira
• 16:08   Re: Federated Postgresql architecture ? Chris Browne

28 June 2008

• 12:22   Subquery WHERE IN or WHERE EXISTS faster? Ulrich
• 12:53   Re: Subquery WHERE IN or WHERE EXISTS faster? Tom Lane
• 13:54   Planner should use index on a LIKE 'foo%' query Moritz Onken
• 16:59   Re: Planner should use index on a LIKE 'foo%' query Steinar H. Gunderson
• 19:07   Re: Subquery WHERE IN or WHERE EXISTS faster? Ulrich
• 20:01   Re: Subquery WHERE IN or WHERE EXISTS faster? Gregory Stark

29 June 2008

• 07:15   Re: Subquery WHERE IN or WHERE EXISTS faster? Ulrich
• 09:09   Re: Subquery WHERE IN or WHERE EXISTS faster? Gregory Stark
• 15:59   Re: A guide/tutorial to performance monitoring and tuning Greg Smith
• 16:04   Re: Sources of information about sizing of hardwares to run PostgreSQL Greg Smith
• 18:52   sequence scan problem John Beaver
• 19:10   Re: sequence scan problem Jeremy Harris
• 19:20   Re: sequence scan problem John Beaver
• 19:32   Re: sequence scan problem John Beaver

30 June 2008

• 00:33   Re: sequence scan problem Tom Lane
• 01:20   Out of memory for Select query. Nimesh Satam
• 01:34   Re: Subquery WHERE IN or WHERE EXISTS faster? Jaime Casanova
• 01:49   Re: Subquery WHERE IN or WHERE EXISTS faster? Tom Lane
• 03:50   Re: Subquery WHERE IN or WHERE EXISTS faster? Rusty Conover
• 03:59   Re: Out of memory for Select query. Rusty Conover
• 04:17   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 04:22   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 04:29   Re: Subquery WHERE IN or WHERE EXISTS faster? Ulrich
• 04:44   Re: Subquery WHERE IN or WHERE EXISTS faster? Rusty Conover
• 07:19   Re: Planner should use index on a LIKE 'foo%' query Matthew Wakeling
• 07:21   Re: Planner should use index on a LIKE 'foo%' query Dimitri Fontaine
• 07:59   Re: sequence scan problem John Beaver
• 09:46   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 09:52   Re: Planner should use index on a LIKE 'foo%' query Matthew Wakeling
• 09:57   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 10:16   Re: Federated Postgresql architecture ? Marko Kreen
• 10:52   Re: Federated Postgresql architecture ? Jonah H. Harris
• 11:06   Re: A guide/tutorial to performance monitoring and tuning Cédric Villemain
• 12:06   VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller
• 12:26   Re: sequence scan problem Tom Lane
• 12:27   Re: VACUUM ANALYZE blocking both reads and writes to a table Alvaro Herrera
• 12:39   Re: VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller
• 12:43   Re: VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller
• 13:12   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 13:22   Re: Planner should use index on a LIKE 'foo%' query Matthew Wakeling
• 13:23   Re: VACUUM ANALYZE blocking both reads and writes to a table Alvaro Herrera
• 13:42   Re: Planner should use index on a LIKE 'foo%' query Moritz Onken
• 14:46   Does max size of varchar influence index size Franck Routier
• 16:00   Re: VACUUM ANALYZE blocking both reads and writes to a table Tom Lane
• 16:06   Re: VACUUM ANALYZE blocking both reads and writes to a table Alvaro Herrera
• 16:11   Re: VACUUM ANALYZE blocking both reads and writes to a table Alvaro Herrera
• 17:25   Re: Does max size of varchar influence index size Mark Roberts
• 21:39   Re: sequence scan problem John Beaver