Mailing lists [pgsql-performance]

1 November 2002

• 09:15   Is dump-reload the only cure? 
• 10:52   Re: Is dump-reload the only cure? Rod Taylor
• 11:03   Re: Is dump-reload the only cure? 
• 11:15   Re: Is dump-reload the only cure? 
• 12:07   Re: Is dump-reload the only cure? Rod Taylor
• 12:10   Re: Is dump-reload the only cure? Rod Taylor
• 12:38   Re: Is dump-reload the only cure? Rod Taylor
• 12:41   Re: Is dump-reload the only cure? 
• 17:54   Re: [pgsql-performance] Is dump-reload the only cure? Robert Treat
• 18:18   Does this matter? Wei Weng
• 18:24   Re: Does this matter? Josh Berkus
• 18:52   Re: Does this matter? Wei Weng
• 18:53   Re: Does this matter? Philip Hallstrom
• 19:10   Re: Does this matter? Andrew Sullivan
• 20:00   Re: Does this matter? Josh Berkus
• 20:00   Re: Does this matter? Curtis Faith
• 20:01   Re: Does this matter? Josh Berkus

4 November 2002

• 02:08   Re: Does this matter? Neil Conway

11 November 2002

• 08:08   Slow response from 'SELECT * FROM table' Jirka Novak
• 08:13   Re: Slow response from 'SELECT * FROM table' Jakub Ouhrabka
• 15:18   Re: Slow response from 'SELECT * FROM table' Wei Weng
• 15:24   Re: Slow response from 'SELECT * FROM table' Josh Berkus
• 15:44   Query performance discontinuity Mike Nielsen
• 15:59   Re: Slow response from 'SELECT * FROM table' Andrew Sullivan
• 17:13   Re: Query performance discontinuity Josh Berkus
• 17:37   Re: Query performance discontinuity Stephan Szabo
• 23:39   Re: Query performance discontinuity Tom Lane

12 November 2002

• 02:10   Re: Query performance discontinuity Mike Nielsen
• 02:50   Re: Query performance discontinuity Rod Taylor
• 05:30   Re: Slow response from 'SELECT * FROM table' Jirka Novak
• 14:54   Re: Query performance discontinuity Josh Berkus
• 22:04   Re: Query performance discontinuity Mike Nielsen

13 November 2002

• 15:02   Re: Upgrade to dual processor machine? Josh Berkus
• 15:18   Re: Upgrade to dual processor machine? Josh Berkus
• 19:44   Re: Query performance discontinuity Josh Berkus

14 November 2002

• 02:04   Re: Upgrade to dual processor machine? Shridhar Daithankar
• 07:28   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 07:41   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 07:44   Docs about buffers and sortmem setting Ryszard Lach
• 08:27   Re: [GENERAL] Upgrade to dual processor machine? Shridhar Daithankar
• 09:56   Re: Docs about buffers and sortmem setting Andrew Sullivan
• 10:20   Re: Docs about buffers and sortmem setting Bjoern Metzdorf
• 11:35   Re: Docs about buffers and sortmem setting Andrew Sullivan
• 12:30   swapping? Wei Weng
• 12:36   Re: swapping? Shridhar Daithankar
• 12:53   Re: swapping? Wei Weng
• 12:56   Re: swapping? Bruce Momjian
• 13:07   Re: swapping? Wei Weng
• 13:17   Re: swapping? Andrew Sullivan
• 13:21   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 13:31   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 13:34   Re: [GENERAL] Upgrade to dual processor machine? Shridhar Daithankar
• 15:20   Re: Docs about buffers and sortmem setting Neil Conway
• 15:39   Sort time pginfo
• 16:01   Re: Docs about buffers and sortmem setting Andrew Sullivan
• 17:26   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 17:27   Re: Docs about buffers and sortmem setting scott.marlowe
• 17:35   Re: [GENERAL] Upgrade to dual processor machine? Doug McNaught
• 17:37   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 17:54   Re: [GENERAL] Upgrade to dual processor machine? scott.marlowe
• 18:00   Re: [GENERAL] Upgrade to dual processor machine? scott.marlowe
• 18:00   Re: Sort time scott.marlowe
• 18:20   Re: [GENERAL] Upgrade to dual processor machine? Tom Lane
• 18:37   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 18:51   Re: [GENERAL] Upgrade to dual processor machine? Doug McNaught
• 18:54   Re: [GENERAL] Upgrade to dual processor machine? Josh Berkus
• 18:55   Re: [GENERAL] Upgrade to dual processor machine? Medi Montaseri
• 19:28   Re: [GENERAL] Upgrade to dual processor machine? Neil Conway
• 19:29   Re: swapping? Robert Treat
• 19:32   Re: [GENERAL] Upgrade to dual processor machine? jmelesky@performics.com
• 19:46   digest Laurette Cisneros
• 21:33   Re: [GENERAL] Upgrade to dual processor machine? Josh Berkus
• 22:26   Re: digest Josh Berkus
• 22:30   Re: [GENERAL] Upgrade to dual processor machine? Steve Wolfe
• 22:34   Re: digest Laurette Cisneros
• 22:35   Re: [GENERAL] Upgrade to dual processor machine? Steve Wolfe

15 November 2002

• 05:04   Re: Sort time pginfo
• 05:09   Re: [GENERAL] Upgrade to dual processor machine? Shridhar Daithankar
• 05:25   Re: Sort time pginfo
• 06:47   Re: [GENERAL] Upgrade to dual processor machine? Cedric Dufour (Cogito Ergo Soft)
• 07:43   Re: swapping? Adam Witney
• 08:11   Re: [GENERAL] Upgrade to dual processor machine? Henrik Steffen
• 10:38   for/loop performance in plpgsql ? Federico
• 10:59   Re: [GENERAL] Upgrade to dual processor machine? Andrew Sullivan
• 11:37   Re: [GENERAL] Upgrade to dual processor machine? Cedric Dufour (Cogito Ergo Soft)
• 11:45   Re: for/loop performance in plpgsql ? Richard Huxton
• 12:34   Re: [GENERAL] Upgrade to dual processor machine? Andrew Sullivan
• 13:43   Re: Sort time Tom Lane
• 14:08   Re: Sort time pginfo
• 14:36   Re: [GENERAL] Upgrade to dual processor machine? Stephan Szabo
• 14:46   Re: Sort time Tom Lane
• 14:46   Re: Sort time pginfo
• 15:50   Re: Sort time pginfo
• 15:52   Re: Upgrade to dual processor machine? Josh Berkus
• 15:55   Re: Sort time Josh Berkus
• 15:57   Re: Sort time Josh Berkus
• 16:53   Re: [GENERAL] Upgrade to dual processor machine? Josh Berkus
• 17:24   Re: Sort time Rod Taylor
• 17:25   Re: Sort time Josh Berkus
• 17:53   can this query be made to run faster? Peter T. Brown
• 18:08   Re: can this query be made to run faster? Rod Taylor
• 18:54   Re: Sort time Rod Taylor
• 19:16   Re: Sort time Josh Berkus
• 20:39   Re: Sort time Rod Taylor
• 21:02   ANALYZE and indexes (was Re: Sort time) Tom Lane
• 21:32   Re: Sort time Tom Lane

16 November 2002

• 05:16   Re: Sort time pginfo
• 05:32   Re: Sort time pginfo
• 15:15   Re: Sort time Stephan Szabo

17 November 2002

• 05:27   Re: Sort time pginfo
• 05:44   Re: Sort time Stephan Szabo
• 06:18   Re: Sort time Stephan Szabo
• 06:25   Re: Sort time pginfo
• 07:12   Re: Sort time pginfo
• 15:29   Re: Sort time Stephan Szabo
• 18:56   Re: Sort time Tom Lane
• 19:10   Re: Sort time Hannu Krosing
• 21:05   Re: Sort time Tom Lane
• 21:54   Re: Sort time Tom Lane

18 November 2002

• 05:06   Re: Sort time pginfo
• 09:12   Re: Sort time pginfo
• 09:56   Re: Sort time Stephan Szabo
• 10:33   selects from large tables Nikk Anderson
• 11:02   Re: selects from large tables Stephan Szabo
• 13:04   Re: for/loop performance in plpgsql ? Federico
• 13:08   Re: selects from large tables Tom Lane
• 13:31   Re: selects from large tables Nikk Anderson
• 13:36   Re: selects from large tables Nikk Anderson
• 13:43   Re: selects from large tables Andrew Sullivan
• 13:58   Re: selects from large tables Charles H. Woloszynski
• 14:27   Re: selects from large tables Tom Lane
• 14:32   Re: selects from large tables Stephan Szabo
• 14:33   Re: selects from large tables Nikk Anderson
• 14:36   Re: selects from large tables Nikk Anderson
• 16:48   Re: selects from large tables Robert Treat

19 November 2002

• 03:23   Re: for/loop performance in plpgsql ? Tom Lane
• 07:53   Re: for/loop performance in plpgsql ? Federico /* juri */ Pedemonte
• 11:46   Re: [HACKERS] Question regarding effects of Vacuum, Vacuum Rod Taylor
• 12:08   Re: for/loop performance in plpgsql ? Tom Lane
• 12:26   Slow DELETE with IN clausule Jirka Novak
• 12:39   Re: Slow DELETE with IN clausule Andrew Sullivan
• 12:45   Re: Slow DELETE with IN clausule Richard Huxton

20 November 2002

• 13:08   Re: selects from large tables Nikk Anderson
• 13:18   Re: selects from large tables Bruce Momjian
• 13:19   Re: selects from large tables Tom Lane
• 13:30   Re: selects from large tables Rod Taylor
• 13:49   Re: selects from large tables Nikk Anderson
• 13:56   Re: selects from large tables Rod Taylor
• 16:53   ... Francisco Reyes
• 18:26   Re: selects from large tables Hannu Krosing
• 21:40   Query Analysis 
• 21:50   Re: Query Analysis Josh Berkus

21 November 2002

• 07:29   Is there a system of cache in pgsql 7.3rc1 ? David Pradier
• 14:16   Re: Query Analysis 
• 14:40   H/W RAID 5 on slower disks versus no raid on faster HDDs Rajesh Kumar Mallah.
• 14:52   vacuum full Henrik Steffen
• 15:05   Re: H/W RAID 5 on slower disks versus no raid on faster Charles H. Woloszynski
• 15:21   stange optimizer results Peter T. Brown
• 15:32   Re: H/W RAID 5 on slower disks versus no raid on faster scott.marlowe
• 15:34   Re: vacuum full scott.marlowe
• 15:42   Re: Is there a system of cache in pgsql 7.3rc1 ? scott.marlowe
• 15:42   Re: H/W RAID 5 on slower disks versus no raid on faster HDDs Rajesh Kumar Mallah.
• 15:54   Re: H/W RAID 5 on slower disks versus no raid on faster HDDs Rajesh Kumar Mallah.
• 16:18   Re: vacuum full Henrik Steffen
• 16:20   Re: vacuum full Henrik Steffen
• 16:34   Re: stange optimizer results Stephan Szabo
• 16:35   Re: stange optimizer results Stephan Szabo
• 16:50   Re: vacuum full george young
• 16:56   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs Steve Crawford
• 17:04   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs Rajesh Kumar Mallah.
• 17:14   Re: vacuum full scott.marlowe
• 17:21   Re: Query Analysis 
• 17:22   Re: vacuum full Tom Lane
• 17:24   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs Bjoern Metzdorf
• 17:31   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on faster HDDs eric soroos
• 17:39   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on scott.marlowe
• 17:41   Re: Query Analysis Tom Lane
• 18:04   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Mike Nielsen
• 18:14   performance of insert/delete/update Wei Weng
• 18:17   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on scott.marlowe
• 18:36   Re: stange optimizer results Peter T. Brown
• 18:42   ... Francisco J Reyes
• 18:53   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Bjoern Metzdorf
• 19:16   Re: [ADMIN] H/W RAID 5 on slower disks versus no Josh Berkus
• 19:17   Re: [ADMIN] H/W RAID 5 on slower disks versus no Josh Berkus
• 19:19   Re: performance of insert/delete/update Josh Berkus
• 19:24   Re: performance of insert/delete/update Wei Weng
• 19:25   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on scott.marlowe
• 19:26   Re: stange optimizer results Stephan Szabo
• 19:50   Re: performance of insert/delete/update scott.marlowe
• 19:58   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Bjoern Metzdorf
• 20:22   Re: performance of insert/delete/update Josh Berkus
• 20:38   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on scott.marlowe
• 20:55   Re: performance of insert/delete/update scott.marlowe
• 21:32   Re: performance of insert/delete/update Josh Berkus

22 November 2002

• 05:31   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Mario Weilguni
• 11:52   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Tom Lane
• 12:16   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on philip johnson
• 13:01   Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on Andrew Sullivan
• 13:57   Re: performance of insert/delete/update scott.marlowe

23 November 2002

• 02:14   Re: performance of insert/delete/update Josh Berkus
• 13:06   Re: performance of insert/delete/update Ron Johnson
• 17:23   Re: performance of insert/delete/update Josh Berkus
• 18:20   Re: performance of insert/delete/update Tom Lane
• 18:29   Re: performance of insert/delete/update Josh Berkus
• 18:42   Re: performance of insert/delete/update Tom Lane
• 18:46   Re: performance of insert/delete/update Josh Berkus
• 19:20   Re: performance of insert/delete/update Tom Lane
• 19:27   Re: performance of insert/delete/update Josh Berkus
• 19:41   Re: performance of insert/delete/update Tom Lane

25 November 2002

• 14:34   Re: performance of insert/delete/update scott.marlowe
• 20:30   Re: performance of insert/delete/update Josh Berkus
• 21:01   Re: performance of insert/delete/update scott.marlowe
• 21:44   Re: performance of insert/delete/update Tim Gardner
• 22:19   Re: performance of insert/delete/update Rod Taylor
• 22:25   Re: performance of insert/delete/update scott.marlowe
• 22:33   Re: performance of insert/delete/update scott.marlowe
• 22:41   Re: performance of insert/delete/update Tim Gardner
• 22:43   Re: performance of insert/delete/update scott.marlowe
• 22:43   Re: performance of insert/delete/update Rich Scott
• 23:39   Re: performance of insert/delete/update Josh Berkus
• 23:41   Re: performance of insert/delete/update Ron Johnson
• 23:52   Re: performance of insert/delete/update Ron Johnson

26 November 2002

• 01:30   Re: performance of insert/delete/update Tom Lane
• 01:45   Re: performance of insert/delete/update Tom Lane
• 01:52   Re: performance of insert/delete/update Rod Taylor
• 02:27   Re: performance of insert/delete/update Ron Johnson
• 07:37   Full Text Index disk space requirements 
• 10:49   Re: Full Text Index disk space requirements Maarten Boekhold
• 13:32   [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Curtis Faith
• 14:51   Re: performance of insert/delete/update Andrew Sullivan
• 14:54   Re: performance of insert/delete/update Andrew Sullivan
• 16:09   Re: performance of insert/delete/update scott.marlowe
• 16:24   Re: performance of insert/delete/update Andrew Sullivan
• 16:47   Re: performance of insert/delete/update scott.marlowe
• 17:16   Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Bruce Momjian
• 17:40   Re: performance of insert/delete/update Robert Treat
• 18:18   Re: Full Text Index disk space requirements 
• 19:33   Re: Full Text Index disk space requirements Hannu Krosing

27 November 2002

• 00:40   Re: Full Text Index disk space requirements 
• 01:13   Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Tom Lane
• 12:39   Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Nicolai Tufar
• 13:07   Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Jim Beckstrom
• 13:11   Child process procedures Thrasher
• 13:23   Re: [HACKERS] Realtime VACUUM, was: performance of insert/delete/update Dave Page
• 15:20   Re: [HACKERS] Realtime VACUUM, was: performance of scott.marlowe
• 16:51   Low Budget Performance, Part 2 eric soroos
• 17:19   Re: Low Budget Performance, Part 2 Tom Lane
• 18:45   Re: Low Budget Performance, Part 2 eric soroos

28 November 2002

• 07:45   Re: Low Budget Performance, Part 2 Richard Huxton
• 10:05   Re: Low Budget Performance, Part 2 Ron Johnson
• 10:57   Re: Low Budget Performance, Part 2 Justin Clift
• 16:14   Re: Low Budget Performance, Part 2 eric soroos
• 16:32   Re: Low Budget Performance, Part 2 eric soroos
• 16:39   Re: Low Budget Performance, Part 2 eric soroos

29 November 2002

• 16:24   Re: Query performance discontinuity Manfred Koizar

30 November 2002

• 14:40   Re: Low Budget Performance, Part 2 Laurette Cisneros
• 17:47   Re: Low Budget Performance, Part 2 Justin Clift