pgsql-performance - December 2002

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 23 24 26 27 29 31

Dec. 2, 2002

Thread Author Time
v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc. 15:45
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Andrew Sullivan 16:00
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane 16:13
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc. 17:20
[No subject] typea 18:30
Re: Rod Taylor 19:20
Re: typea 20:45
Re: Hannu Krosing 21:18
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION ir. F.T.M. van Vugt bc. 23:51

Dec. 3, 2002

Thread Author Time
Re: Ron Johnson 03:56
Is there any limitations li li 05:46
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane 05:59
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Frank van Vugt 09:38
Re: Is there any limitations Andrew Sullivan 12:34
Re: Is there any limitations Nikk Anderson 13:41
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Tom Lane 14:35
Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION Frank van Vugt 15:23
v7.3 planner and user-defined functions Ben Gunter 19:11
Re: Is there any limitations li li 19:49
Re: Is there any limitations li li 20:06

Dec. 4, 2002

Thread Author Time
Re: Is there any limitations Richard Huxton 09:29
Re: Is there any limitations Hannu Krosing 12:23
Re: Low Budget Performance, Part 2 scott.marlowe 20:28

Dec. 5, 2002

Thread Author Time
Is a better way to have the same result of this query? Vernon Wu 00:26
Re: Is a better way to have the same result of this Ron Johnson 05:26
ORDER BY ... LIMIT.. performance john cartmell 09:51
Re: Is a better way to have the same result of this query? Jochem van Dieten 10:01
Index question with LIKE keyword Eric Theis 16:34
Re: Index question with LIKE keyword Stephan Szabo 16:47
Re: Is a better way to have the same result of this query? Vernon Wu 18:44
Re: Is a better way to have the same result of this Vernon Wu 19:08
Re: Is a better way to have the same result of this Tomasz Myrta 19:37
Re: Is a better way to have the same result of this Jean-Luc Lachance 19:45
Re: Is a better way to have the same result of this Andrew Sullivan 19:57
Re: Is a better way to have the same result of this Vernon Wu 20:35
Filesystem optimisation for postgresql tables and WAL logs on linux. Rajesh Kumar Mallah. 20:41
Re: Is a better way to have the same result of this Vernon Wu 20:58
Re: Is a better way to have the same result of this Jean-Luc Lachance 21:04
Re: Is a better way to have the same result of this query? Jochem van Dieten 21:06
Re: Is a better way to have the same result of this Tomasz Myrta 21:19
Re: Is a better way to have the same result of this query? Vernon Wu 21:23
Re: ORDER BY ... LIMIT.. performance Tom Lane 22:00
Re: Is a better way to have the same result of this query? Jochem van Dieten 22:05
Re: ORDER BY ... LIMIT.. performance Josh Berkus 22:21
Re: Filesystem optimisation for postgresql tables and WAL Bruce Momjian 22:42
Re: Is a better way to have the same result of this Vernon Wu 23:19
Re: Is a better way to have the same result of this Andrew Sullivan 23:56
Re: Is a better way to have the same result of this Andrew Sullivan 23:58

Dec. 6, 2002

Thread Author Time
Re: Is a better way to have the same result of this scott.marlowe 00:18
Re: Is a better way to have the same result of this Vernon Wu 00:43
ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor 04:11
Re: ALTER TABLE .. < ADD | DROP > OIDS Bruce Momjian 05:00
Re: ALTER TABLE .. < ADD | DROP > OIDS Bruce Momjian 05:08
Re: ORDER BY ... LIMIT.. performance john cartmell 11:32
Speeding up aggregates Josh Berkus 17:30
Re: Speeding up aggregates Joe Conway 18:10
Re: ORDER BY ... LIMIT.. performance Josh Berkus 18:13
Re: ALTER TABLE .. < ADD | DROP > OIDS Tom Lane 20:19
Re: ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor 20:35
Re: Speeding up aggregates Tom Lane 20:46
Re: ALTER TABLE .. < ADD | DROP > OIDS Tom Lane 21:05
Re: ALTER TABLE .. < ADD | DROP > OIDS Rod Taylor 21:24
Re: ORDER BY ... LIMIT.. performance Tom Lane 21:28
Re: Speeding up aggregates Hannu Krosing 21:32
Re: Speeding up aggregates Tom Lane 21:42
Re: Speeding up aggregates Hannu Krosing 21:49
Re: Speeding up aggregates Hannu Krosing 21:55
Re: Speeding up aggregates Hannu Krosing 21:57
Re: Speeding up aggregates Josh Berkus 21:58
Re: Speeding up aggregates Tom Lane 23:07
query question Laurette Cisneros 23:32

Dec. 7, 2002

Thread Author Time
Re: query question Josh Berkus 00:38
Re: Speeding up aggregates Josh Berkus 01:54
Query optimization Fred Moyer 02:16
Re: Speeding up aggregates Ron Johnson 15:48
Re: Query optimization Richard Huxton 17:13
Re: Query optimization Fred Moyer 20:10
Re: Query optimization Jochem van Dieten 20:41

Dec. 8, 2002

Thread Author Time
Re: Query optimization Richard Huxton 13:48
Re: Speeding up aggregates Joe Conway 19:31
Re: Speeding up aggregates Joe Conway 19:37

Dec. 9, 2002

Thread Author Time
is insertion and movement times are correlated to the size of the database? Kalle Barck-Holst 06:30
Re: Speeding up aggregates Hannu Krosing 10:16
questions about disk configurations Hubert depesz Lubaczewski 11:32
Re: questions about disk configurations Adrian 'Dagurashibanipal' von Bidder 12:01
Re: is insertion and movement times are correlated to Rod Taylor 13:04
Re: questions about disk configurations Hubert depesz Lubaczewski 13:05
Re: Speeding up aggregates Bruce Momjian 18:09
Re: questions about disk configurations Josh Berkus 19:53
Re: questions about disk configurations Keith Bottner 20:00
Re: questions about disk configurations Ron Johnson 20:46
Re: Speeding up aggregates Joe Conway 21:04
Re: Speeding up aggregates Tom Lane 21:26
Re: questions about disk configurations eric soroos 21:42
Re: Speeding up aggregates Joe Conway 21:48
Re: Speeding up aggregates Tom Lane 22:06
Re: questions about disk configurations Josh Berkus 22:14
Re: questions about disk configurations scott.marlowe 22:22
Re: questions about disk configurations eric soroos 22:44
Re: questions about disk configurations scott.marlowe 23:00
Re: questions about disk configurations Josh Berkus 23:26

Dec. 10, 2002

Thread Author Time
Re: questions about disk configurations scott.marlowe 00:06
Re: questions about disk configurations Tom Lane 00:08
Performance of multi-column index on INSERT Ludwig Lim 16:55
Re: Performance of multi-column index on INSERT Hannu Krosing 20:50
Re: questions about disk configurations Hubert depesz Lubaczewski 21:16
Re: questions about disk configurations Ron Johnson 23:13

Dec. 11, 2002

Thread Author Time
Which of the solution is better? Wei Weng 05:20
Re: Which of the solution is better? Ron Johnson 05:46
Re: Which of the solution is better? Andrew Sullivan 15:48
Re: Which of the solution is better? Wei Weng 16:26
Docs: GIST Lincoln Yeoh 18:07
Capping CPU usage? Josh Berkus 18:12
Re: Capping CPU usage? Rod Taylor 18:24
Re: Capping CPU usage? Cory 'G' Watson 18:27
Re: Capping CPU usage? eric soroos 18:44
Good/Bad RAID and SCSI controllers? Josh Berkus 21:49
Re: Which of the solution is better? Josh Berkus 21:53
Re: Good/Bad RAID and SCSI controllers? Justin Clift 22:06
Re: Good/Bad RAID and SCSI controllers? Josh Berkus 22:26
Re: Good/Bad RAID and SCSI controllers? scott.marlowe 22:34
Re: Good/Bad RAID and SCSI controllers? Justin Clift 22:50

Dec. 12, 2002

Thread Author Time
Re: Docs: GIST Tom Lane 05:41
Re: Capping CPU usage? Tom Lane 05:52
Re: Good/Bad RAID and SCSI controllers? Shridhar Daithankar 07:13
Time to commit a change Ludwig Lim 07:35
Re: Time to commit a change Shridhar Daithankar 08:07
Re: Time to commit a change Stephan Szabo 17:15
Re: Capping CPU usage? Josh Berkus 17:43
Re: Time to commit a change Josh Berkus 17:49
Re: Capping CPU usage? Ron Johnson 17:57
Re: Docs: GIST Lincoln Yeoh 21:02
CLUSTER command Jean-Luc Lachance 21:31
Re: [PERFORM] CLUSTER command Jean-Luc Lachance 21:40
Re: CLUSTER command Stephan Szabo 22:03
Re: CLUSTER command Jean-Luc Lachance 22:15
Re: [GENERAL] CLUSTER command johnnnnnn 22:26
Re: CLUSTER command Stephan Szabo 22:27
Re: [PERFORM] CLUSTER command Jean-Luc Lachance 22:39
Re: CLUSTER command Lincoln Yeoh 22:49
PerformPortalClose warning in 7.3 Michael Engelhart 22:50
Re: [GENERAL] CLUSTER command johnnnnnn 23:00

Dec. 13, 2002

Thread Author Time
Re: [PERFORM] CLUSTER command Stephan Szabo 00:03
Re: [PERFORM] CLUSTER command Alvaro Herrera 00:47
Re: [PERFORM] CLUSTER command Charles H. Woloszynski 01:06
Re: [PERFORM] CLUSTER command Stephan Szabo 02:11
automated index suggestor -- request for comment johnnnnnn 03:22
Re: automated index suggestor -- request for comment Hannu Krosing 12:05
Capping CPU usage? brew 13:27
Re: automated index suggestor -- request for comment Tom Lane 14:49
Re: automated index suggestor -- request for comment johnnnnnn 15:20
Re: automated index suggestor -- request for comment johnnnnnn 15:37
Re: [PERFORM] CLUSTER command Jean-Luc Lachance 16:42
Re: automated index suggestor -- request for comment Hannu Krosing 17:00
Re: Capping CPU usage? Josh Berkus 18:18
Odd Sort/Limit/Max Problem Josh Berkus 19:55
Re: Odd Sort/Limit/Max Problem Stephan Szabo 20:10
Re: Odd Sort/Limit/Max Problem Tom Lane 20:24
Re: Odd Sort/Limit/Max Problem Hannu Krosing 22:22

Dec. 14, 2002

Thread Author Time
Re: Fwd: Re: [PERFORM] Odd Sort/Limit/Max Problem Laurette Cisneros 00:00
Re: Odd Sort/Limit/Max Problem Tom Lane 00:03
~* + LIMIT => infinite time? typea 02:16
Re: ~* + LIMIT => infinite time? Josh Berkus 02:23
Re: ~* + LIMIT => infinite time? Tom Lane 04:48
Re: automated index suggestor -- request for comment Ron Johnson 19:46
Re: [GENERAL] PerformPortalClose warning in 7.3 Bruce Momjian 22:58

Dec. 15, 2002

Thread Author Time
Re: ~* + LIMIT => infinite time? typea 00:41
Re: ~* + LIMIT => infinite time? Josh Berkus 20:22

Dec. 16, 2002

Thread Author Time
Re: ~* + LIMIT => infinite time? Hannu Krosing 00:03
Re: ~* + LIMIT => infinite time? typea 08:21
Re: ~* + LIMIT => infinite time? typea 10:20
Re: ~* + LIMIT => infinite time? Josh Berkus 18:26
Re: ~* + LIMIT => infinite time? Tom Lane 18:34
Problem with GEQO when using views and nested selects Jeff Davis 18:55
Re: Problem with GEQO when using views and nested selects Tom Lane 19:30
Re: Problem with GEQO when using views and nested selects Jeff Davis 21:47

Dec. 17, 2002

Thread Author Time
Profiling Josh Berkus 04:03
Re: Profiling Josh Berkus 04:12
Re: Profiling Justin Clift 04:30
Re: Profiling Shridhar Daithankar 06:57
Re: Profiling 📎 Cory 'G' Watson 13:29
Re: Profiling 📎 Cory 'G' Watson 13:30
Re: Profiling Shridhar Daithankar 13:35
Re: Profiling Cory 'G' Watson 13:43
Re: Profiling Shridhar Daithankar 13:49
Re: Profiling Cory 'G' Watson 14:20
Re: Profiling Shridhar Daithankar 14:29
Re: Profiling Tom Lane 14:49
Re: Profiling scott.marlowe 16:18

Dec. 19, 2002

Thread Author Time
EXISTS vs IN vs OUTER JOINS Tomasz Myrta 10:12
Re: EXISTS vs IN vs OUTER JOINS Josh Berkus 17:15
Re: EXISTS vs IN vs OUTER JOINS jasiek 17:27
Re: EXISTS vs IN vs OUTER JOINS Joe Conway 17:43
Re: EXISTS vs IN vs OUTER JOINS Josh Berkus 19:02
Re: 4G row table? Manfred Koizar 19:07
4G row table? george young 19:10
Re: 4G row table? Josh Berkus 19:15
Re: 4G row table? Charles H. Woloszynski 19:27
Re: EXISTS vs IN vs OUTER JOINS jasiek 19:28
Re: 4G row table? Ron Johnson 19:36

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 23 24 26 27 29 31