Mailing lists [pgsql-performance]

2 December 2002

• 13:47   v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc.
• 14:02   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Andrew Sullivan
• 14:14   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane
• 15:18   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc.
• 16:54    
• 17:39   Re: Rod Taylor
• 18:55   Re: 
• 19:21   Re: Hannu Krosing
• 21:49   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc.

3 December 2002

• 01:56   Re: Ron Johnson
• 03:46   Is there any limitations li li
• 03:59   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane
• 07:38   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Frank van Vugt
• 10:35   Re: Is there any limitations Andrew Sullivan
• 11:41   Re: Is there any limitations Nikk Anderson
• 12:35   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane
• 13:23   Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Frank van Vugt
• 17:12   v7.3 planner and user-defined functions Ben Gunter
• 18:03   Re: Is there any limitations li li
• 18:26   Re: Is there any limitations li li

4 December 2002

• 07:30   Re: Is there any limitations Richard Huxton
• 08:29   Re: Is there any limitations Hannu Krosing
• 18:36   Re: Low Budget Performance, Part 2 scott.marlowe
• 22:30   Is a better way to have the same result of this query? Vernon Wu

5 December 2002

• 03:27   Re: Is a better way to have the same result of this Ron Johnson
• 07:51   ORDER BY ... LIMIT.. performance john cartmell
• 08:01   Re: Is a better way to have the same result of this query? Jochem van Dieten
• 14:30   Index question with LIKE keyword Eric Theis
• 14:48   Re: Index question with LIKE keyword Stephan Szabo
• 16:45   Re: Is a better way to have the same result of this query? Vernon Wu
• 17:18   Re: Is a better way to have the same result of this Vernon Wu
• 17:59   Re: Is a better way to have the same result of this Tomasz Myrta
• 18:13   Re: Is a better way to have the same result of this Jean-Luc Lachance
• 18:23   Re: Is a better way to have the same result of this Andrew Sullivan
• 19:16   Re: Is a better way to have the same result of this Vernon Wu
• 19:21   Filesystem optimisation for postgresql tables and WAL logs on linux. Rajesh Kumar Mallah.
• 19:53   Re: Is a better way to have the same result of this Vernon Wu
• 19:56   Re: Is a better way to have the same result of this Jean-Luc Lachance
• 20:00   Re: Is a better way to have the same result of this query? Jochem van Dieten
• 20:21   Re: Is a better way to have the same result of this Tomasz Myrta
• 20:27   Re: Is a better way to have the same result of this query? Vernon Wu
• 20:51   Re: ORDER BY ... LIMIT.. performance Tom Lane
• 21:00   Re: Is a better way to have the same result of this query? Jochem van Dieten
• 21:10   Re: ORDER BY ... LIMIT.. performance Josh Berkus
• 21:23   Re: Filesystem optimisation for postgresql tables and WAL Bruce Momjian
• 21:58   Re: Is a better way to have the same result of this Vernon Wu
• 23:10   Re: Is a better way to have the same result of this Andrew Sullivan
• 23:11   Re: Is a better way to have the same result of this Andrew Sullivan
• 23:26   Re: Is a better way to have the same result of this scott.marlowe
• 23:41   Re: Is a better way to have the same result of this Vernon Wu

6 December 2002

• 02:14   ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor
• 03:00   Re: ALTER TABLE .. < ADD | DROP > OIDS Bruce Momjian
• 03:10   Re: ALTER TABLE .. < ADD | DROP > OIDS Bruce Momjian
• 09:33   Re: ORDER BY ... LIMIT.. performance john cartmell
• 15:31   Speeding up aggregates Josh Berkus
• 16:13   Re: Speeding up aggregates Joe Conway
• 16:16   Re: ORDER BY ... LIMIT.. performance Josh Berkus
• 18:21   Re: ALTER TABLE .. < ADD | DROP > OIDS Tom Lane
• 18:35   Re: ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor
• 18:50   Re: Speeding up aggregates Tom Lane
• 19:06   Re: ALTER TABLE .. < ADD | DROP > OIDS Tom Lane
• 19:24   Re: ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor
• 19:29   Re: ORDER BY ... LIMIT.. performance Tom Lane
• 19:34   Re: Speeding up aggregates Hannu Krosing
• 19:43   Re: Speeding up aggregates Tom Lane
• 19:50   Re: Speeding up aggregates Hannu Krosing
• 19:55   Re: Speeding up aggregates Josh Berkus
• 19:55   Re: Speeding up aggregates Hannu Krosing
• 19:58   Re: Speeding up aggregates Hannu Krosing
• 21:07   Re: Speeding up aggregates Tom Lane
• 21:33   query question Laurette Cisneros
• 22:35   Re: query question Josh Berkus
• 23:51   Re: Speeding up aggregates Josh Berkus

7 December 2002

• 00:22   Query optimization Fred Moyer
• 13:48   Re: Speeding up aggregates Ron Johnson
• 15:15   Re: Query optimization Richard Huxton
• 18:16   Re: Query optimization Fred Moyer
• 18:43   Re: Query optimization Jochem van Dieten

8 December 2002

• 11:49   Re: Query optimization Richard Huxton
• 17:33   Re: Speeding up aggregates Joe Conway
• 17:39   Re: Speeding up aggregates Joe Conway

9 December 2002

• 04:39   is insertion and movement times are correlated to the size of the database? Kalle Barck-Holst
• 06:22   Re: Speeding up aggregates Hannu Krosing
• 09:36   questions about disk configurations Hubert depesz Lubaczewski
• 10:02   Re: questions about disk configurations Adrian 'Dagurashibanipal' von Bidder
• 11:05   Re: is insertion and movement times are correlated to Rod Taylor
• 16:14   Re: Speeding up aggregates Bruce Momjian
• 17:49   Re: questions about disk configurations Hubert depesz Lubaczewski
• 17:51   Re: questions about disk configurations Josh Berkus
• 18:00   Re: questions about disk configurations Keith Bottner
• 18:47   Re: questions about disk configurations Ron Johnson
• 19:12   Re: Speeding up aggregates Joe Conway
• 19:31   Re: Speeding up aggregates Tom Lane
• 19:51   Re: questions about disk configurations eric soroos
• 19:59   Re: Speeding up aggregates Joe Conway
• 20:11   Re: Speeding up aggregates Tom Lane
• 20:15   Re: questions about disk configurations Josh Berkus
• 20:36   Re: questions about disk configurations scott.marlowe
• 20:59   Re: questions about disk configurations eric soroos
• 21:06   Re: questions about disk configurations scott.marlowe
• 21:28   Re: questions about disk configurations Josh Berkus
• 22:13   Re: questions about disk configurations Tom Lane
• 22:19   Re: questions about disk configurations scott.marlowe

10 December 2002

• 14:55   Performance of multi-column index on INSERT Ludwig Lim
• 18:50   Re: Performance of multi-column index on INSERT Hannu Krosing
• 19:17   Re: questions about disk configurations Hubert depesz Lubaczewski
• 21:13   Re: questions about disk configurations Ron Johnson

11 December 2002

• 03:20   Which of the solution is better? Wei Weng
• 03:46   Re: Which of the solution is better? Ron Johnson
• 13:28   Re: Which of the solution is better? Wei Weng
• 13:48   Re: Which of the solution is better? Andrew Sullivan
• 16:12   Capping CPU usage? Josh Berkus
• 16:24   Re: Capping CPU usage? Cory 'G' Watson
• 16:25   Re: Capping CPU usage? Rod Taylor
• 16:44   Re: Capping CPU usage? eric soroos
• 19:49   Good/Bad RAID and SCSI controllers? Josh Berkus
• 19:53   Re: Which of the solution is better? Josh Berkus
• 20:06   Re: Good/Bad RAID and SCSI controllers? Justin Clift
• 20:26   Re: Good/Bad RAID and SCSI controllers? Josh Berkus
• 20:40   Re: Good/Bad RAID and SCSI controllers? scott.marlowe
• 20:50   Re: Good/Bad RAID and SCSI controllers? Justin Clift

12 December 2002

• 03:52   Re: Capping CPU usage? Tom Lane
• 05:12   Re: Good/Bad RAID and SCSI controllers? Shridhar Daithankar
• 05:35   Time to commit a change Ludwig Lim
• 06:07   Re: Time to commit a change Shridhar Daithankar
• 15:15   Re: Time to commit a change Stephan Szabo
• 15:44   Re: Capping CPU usage? Josh Berkus
• 15:54   Re: Time to commit a change Josh Berkus
• 16:04   Re: Capping CPU usage? Ron Johnson
• 19:31   CLUSTER command Jean-Luc Lachance
• 19:41   Re: CLUSTER command Jean-Luc Lachance
• 20:08   Re: [GENERAL] CLUSTER command Stephan Szabo
• 20:20   Re: [GENERAL] CLUSTER command Jean-Luc Lachance
• 20:24   Re: [GENERAL] CLUSTER command johnnnnnn
• 20:27   Re: [GENERAL] CLUSTER command Stephan Szabo
• 20:33   Re: [GENERAL] CLUSTER command Lincoln Yeoh
• 20:39   Re: [GENERAL] CLUSTER command Jean-Luc Lachance
• 20:55   Re: [GENERAL] CLUSTER command johnnnnnn
• 22:03   Re: [GENERAL] CLUSTER command Stephan Szabo
• 22:47   Re: [GENERAL] CLUSTER command Alvaro Herrera
• 23:06   Re: [GENERAL] CLUSTER command Charles H. Woloszynski

13 December 2002

• 00:11   Re: [GENERAL] CLUSTER command Stephan Szabo
• 01:18   automated index suggestor -- request for comment johnnnnnn
• 08:11   Re: automated index suggestor -- request for comment Hannu Krosing
• 11:27   Capping CPU usage? brew@theMode.com
• 12:50   Re: automated index suggestor -- request for comment Tom Lane
• 13:07   Re: automated index suggestor -- request for comment Hannu Krosing
• 13:17   Re: automated index suggestor -- request for comment johnnnnnn
• 13:34   Re: automated index suggestor -- request for comment johnnnnnn
• 14:42   Re: [GENERAL] CLUSTER command Jean-Luc Lachance
• 16:19   Re: Capping CPU usage? Josh Berkus
• 17:53   Odd Sort/Limit/Max Problem Josh Berkus
• 18:10   Re: Odd Sort/Limit/Max Problem Stephan Szabo
• 18:24   Re: Odd Sort/Limit/Max Problem Tom Lane
• 20:22   Re: Odd Sort/Limit/Max Problem Hannu Krosing
• 22:00   Re: Fwd: Re: Odd Sort/Limit/Max Problem Laurette Cisneros
• 22:03   Re: Odd Sort/Limit/Max Problem Tom Lane

14 December 2002

• 00:15   ~* + LIMIT => infinite time? 
• 00:19   Re: ~* + LIMIT => infinite time? Josh Berkus
• 02:48   Re: ~* + LIMIT => infinite time? Tom Lane
• 17:47   Re: automated index suggestor -- request for comment Ron Johnson
• 22:42   Re: ~* + LIMIT => infinite time? 

15 December 2002

• 18:21   Re: ~* + LIMIT => infinite time? Josh Berkus
• 22:04   Re: ~* + LIMIT => infinite time? Hannu Krosing

16 December 2002

• 06:21   Re: ~* + LIMIT => infinite time? 
• 08:20   Re: ~* + LIMIT => infinite time? 
• 16:29   Re: ~* + LIMIT => infinite time? Josh Berkus
• 16:35   Re: ~* + LIMIT => infinite time? Tom Lane
• 16:55   Problem with GEQO when using views and nested selects Jeff Davis
• 17:30   Re: Problem with GEQO when using views and nested selects Tom Lane
• 19:52   Re: Problem with GEQO when using views and nested selects Jeff Davis

17 December 2002

• 02:03   Profiling Josh Berkus
• 02:12   Re: Profiling Josh Berkus
• 02:30   Re: Profiling Justin Clift
• 04:56   Re: Profiling Shridhar Daithankar
• 11:25   Re: Profiling Cory 'G' Watson
• 11:26   Re: Profiling Cory 'G' Watson
• 11:36   Re: Profiling Shridhar Daithankar
• 11:39   Re: Profiling Cory 'G' Watson
• 11:49   Re: Profiling Shridhar Daithankar
• 12:17   Re: Profiling Cory 'G' Watson
• 12:29   Re: Profiling Shridhar Daithankar
• 12:49   Re: Profiling Tom Lane
• 14:23   Re: Profiling scott.marlowe

19 December 2002

• 08:09   EXISTS vs IN vs OUTER JOINS Tomasz Myrta
• 15:16   Re: EXISTS vs IN vs OUTER JOINS Josh Berkus
• 15:47   Re: EXISTS vs IN vs OUTER JOINS jasiek@klaster.net
• 15:48   Re: EXISTS vs IN vs OUTER JOINS Joe Conway
• 16:16   4G row table? george young
• 16:58   Re: EXISTS vs IN vs OUTER JOINS Josh Berkus
• 17:08   Re: 4G row table? Manfred Koizar
• 17:11   Re: 4G row table? Josh Berkus
• 17:28   Re: 4G row table? Charles H. Woloszynski
• 17:36   Re: 4G row table? Ron Johnson
• 17:45   Re: EXISTS vs IN vs OUTER JOINS jasiek@klaster.net
• 20:47   Re: EXISTS vs IN vs OUTER JOINS Tom Lane
• 20:53   Re: EXISTS vs IN vs OUTER JOINS Bruce Momjian
• 21:20   Re: EXISTS vs IN vs OUTER JOINS Josh Berkus
• 22:03   Re: EXISTS vs IN vs OUTER JOINS Tom Lane

20 December 2002

• 06:54   Re: EXISTS vs IN vs OUTER JOINS Manfred Koizar
• 08:28   Re: 4G row table? Manfred Koizar
• 15:01   Re: 4G row table? Josh Berkus
• 20:58   Speed Question Noah Silverman
• 21:24   Re: Speed Question scott.marlowe
• 21:50   Re: Speed Question Tom Lane
• 21:58   Re: Speed Question Josh Berkus
• 22:10   Re: Speed Question Noah Silverman
• 23:01   Re: Speed Question Philip Hallstrom

21 December 2002

• 10:21   Re: Speed Question Manfred Koizar
• 16:45   Re: Speed Question Noah Silverman
• 18:04   Re: Speed Question Manfred Koizar
• 18:17   Re: Speed Question Noah Silverman
• 18:28   Re: Speed Question Tom Lane

23 December 2002

• 19:55   Re: Speed Question Noah Silverman

24 December 2002

• 18:05   View performance Bruno Wolff III
• 18:55   Re: View performance Bruno Wolff III
• 19:14   Re: View performance Bruno Wolff III

26 December 2002

• 17:42   Re: View performance Tom Lane
• 17:50   Re: View performance Tom Lane
• 18:25   Re: View performance Bruno Wolff III
• 18:45   Re: View performance Tom Lane
• 21:43   Re: View performance Tom Lane

27 December 2002

• 05:01   executing pgsql on Xeon-dual machine yutaka_inada@justsystem.co.jp
• 16:36   Re: executing pgsql on Xeon-dual machine Tom Lane

29 December 2002

• 20:09   A question about inheritance li li

30 December 2002

• 23:42   Re: A question about inheritance Oliver Elphick

31 December 2002

• 20:14   preliminary testing, two very slow situations... Michael Teter
• 21:05   Re: preliminary testing, two very slow situations... Neil Conway