Mailing lists [pgsql-performance]

1 June 2008

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

2 June 2008

• 17:08   Re: Outer joins and equivalence Simon Riggs
• 19:44   Re: Outer joins and equivalence Simon Riggs
• 21:43   getting estimated cost to agree with actual Justin
• 23:38   Re: getting estimated cost to agree with actual Scott Marlowe

3 June 2008

• 01:20   Re: getting estimated cost to agree with actual Gregory Stark
• 03:13   Re: getting estimated cost to agree with actual Scott Marlowe
• 08:18   query performance question Marcin Citowicki
• 08:31   Re: query performance question hubert depesz lubaczewski
• 08:58   Re: query performance question Marcin Citowicki
• 09:26   Re: query performance question tv@fuzzy.cz
• 22:42   insert/update tps slow with indices on table > 1M rows andrew klassen

4 June 2008

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

5 June 2008

• 00:52   Re: RAM / Disk ratio, any rule? Greg Smith
• 06:18   Re: insert/update tps slow with indices on table > 1M rows Heikki Linnakangas
• 16:08   Re: query performance question Dan Harris
• 17:16   Re: query performance question Kenneth Marshall
• 20:23   Re: query performance question Dan Harris

6 June 2008

• 06:30   Checkpoint tuning on 8.2.4 Greg Smith
• 13:21   Optimizing AGE() Volkan YAZICI
• 15:01   Re: PgPool parallel query performance rules of thumb Mason Sharp
• 17:29   Re: Checkpoint tuning on 8.2.4 Scott Marlowe

8 June 2008

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

9 June 2008

• 22:58   Re: Performance of aggregates over set-returning functions John Smith

10 June 2008

• 00:48   Re: Performance of aggregates over set-returning functions Tom Lane

11 June 2008

• 09:59   Scalability question Zoltan Boszormenyi
• 10:15   Re: Scalability question tv@fuzzy.cz
• 10:37   Re: Scalability question Zoltan Boszormenyi
• 13:34   Re: Scalability question Alvaro Herrera
• 14:13   Re: Scalability question Scott Marlowe

12 June 2008

• 01:56   8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Josh Rovero
• 12:28   Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Kenneth Marshall
• 13:26   Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Josh Rovero

15 June 2008

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

16 June 2008

• 09:06   function difference(geometry,geometry) is SLOW! luke.78@libero.it
• 17:57   Tsearch2 Initial Search Speed Howard Cole
• 18:25   Re: Tsearch2 Initial Search Speed Alan Hodgson
• 19:26   Re: [pgsql-performance] function difference(geometry,geometry) is SLOW! Chris Mair

17 June 2008

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

18 June 2008

• 01:15   Re: Which hardware ? Jon D
• 10:42   Re: Tsearch2 Initial Search Speed Howard Cole
• 12:39   Re: Tsearch2 Initial Search Speed Matthew Wakeling
• 16:18   Partial backup of linked tables Cisko
• 19:43   WAL DUDAS Antonio Perez

19 June 2008

• 01:13   An "obvious" index not being used Daniele Varrazzo
• 01:43   Re: An "obvious" index not being used Tom Lane
• 02:19   Re: An "obvious" index not being used Daniele Varrazzo
• 07:13   Re: WAL DUDAS Albe Laurenz
• 09:06   Re: Tsearch2 Initial Search Speed Howard Cole
• 13:47   Re: An "obvious" index not being used Kevin Grittner
• 14:13   Re: An "obvious" index not being used Daniele Varrazzo

20 June 2008

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

23 June 2008

• 11:06   Postgresql is very slow bijayant kumar
• 12:35   Re: Postgresql is very slow Jan de Visser
• 13:36   Re: Postgresql is very slow Jeremy Harris
• 13:49   Re: Postgresql is very slow tv@fuzzy.cz
• 22:21   Re: Postgresql is very slow Gregory S. Youngblood
• 22:42   Re: Checkpoint tuning on 8.2.4 Kevin Grittner

24 June 2008

• 06:23   Re: Postgresql is very slow bijayant kumar
• 07:52   Re: Postgresql is very slow Scott Marlowe
• 07:53   Re: Postgresql is very slow Scott Marlowe
• 08:17   Re: Postgresql is very slow tv@fuzzy.cz
• 09:17   Re: Postgresql is very slow bijayant kumar
• 09:33   Re: Postgresql is very slow Ian Barwick
• 10:01   Re: Postgresql is very slow tv@fuzzy.cz
• 12:14   Re: Postgresql is very slow bijayant kumar
• 12:15   Re: Postgresql is very slow PFC

25 June 2008

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

26 June 2008

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

27 June 2008

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

28 June 2008

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

29 June 2008

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

30 June 2008

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