pgsql-performance - May 2003

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 19 20 21 22 23 27 28 29 30 31

May 1, 2003

Thread Author Time
Re: [SQL] 7.3 analyze & vacuum analyze problem Tom Lane 00:10
Re: [SQL] 7.3 analyze & vacuum analyze problem Christopher Kings-Lynne 01:51
Re: profiling plpgsql functions.. Rajesh Kumar Mallah 14:59

May 2, 2003

Thread Author Time
Query Priority Peter Childs 12:55
Re: Query Priority Andrew Sullivan 14:05
Re: Query Priority Tom Lane 14:23
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 16:29
Looking for a cheap upgrade (RAID) Chad Thompson 18:53
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 19:03
Re: Looking for a cheap upgrade (RAID) scott.marlowe 20:04
Re: Looking for a cheap upgrade (RAID) Josh Berkus 20:10
Re: Looking for a cheap upgrade (RAID) Chad Thompson 20:53
Re: Looking for a cheap upgrade (RAID) scott.marlowe 21:20
Re: Looking for a cheap upgrade (RAID) Josh Berkus 22:10
Re: Looking for a cheap upgrade (RAID) scott.marlowe 22:18

May 3, 2003

Thread Author Time
Re: Query Priority Ron Mayer 03:10
looking for large dataset Antoine 05:52
NOT IN doesn't use index? Becky Neville 05:56
Re: Looking for a cheap upgrade (RAID) D'Arcy J.M. Cain 07:57
Re: Looking for a cheap upgrade (RAID) Shridhar Daithankar 08:02
Re: Looking for a cheap upgrade (RAID) Shridhar Daithankar 08:15
Re: looking for large dataset Christopher Kings-Lynne 10:04
Re: NOT IN doesn't use index? Andrew Sullivan 14:52
Re: looking for large dataset Becky Neville 15:13
why is the db so slow? Becky Neville 17:40
Re: NOT IN doesn't use index? (fwd) Becky Neville 17:57
Re: why is the db so slow? Joe Conway 18:31
Re: why is the db so slow? Josh Berkus 18:32
Re: NOT IN doesn't use index? (fwd) Josh Berkus 18:34
Re: NOT IN doesn't use index? (fwd) Joe Conway 18:34
Re: NOT IN doesn't use index? (fwd) Becky Neville 19:08
Re: NOT IN doesn't use index? (fwd) Joe Conway 19:31
Re: NOT IN doesn't use index? (fwd) Becky Neville 19:56
Re: NOT IN doesn't use index? (fwd) Joe Conway 20:24
Re: why is the db so slow? brew 20:30
Re: Looking for a cheap upgrade (RAID) Ron Johnson 20:39
Re: NOT IN doesn't use index? (fwd) Rod Taylor 21:16

May 4, 2003

Thread Author Time
Suggestions wanted for 7.2.4 query Josh Berkus 02:28
Re: NOT IN doesn't use index? (fwd) Christopher Kings-Lynne 04:05
Re: Suggestions wanted for 7.2.4 query Tom Lane 04:42
Re: Suggestions wanted for 7.2.4 query Josh Berkus 16:07
Re: More tablescanning fun Jim C. Nasby 16:22
Re: Suggestions wanted for 7.2.4 query Tom Lane 17:23
Re: Suggestions wanted for 7.2.4 query Josh Berkus 17:59

May 5, 2003

Thread Author Time
Indices are not used by the optimizer Reiner Dassing 12:16
Wrong index usage in 7.3.2 Achilleus Mantzios 12:30
Re: Indices are not used by the optimizer Rod Taylor 13:33
Re: looking for large dataset 📎 scott.marlowe 16:25
Re: Looking for a cheap upgrade (RAID) scott.marlowe 16:31
Re: Looking for a cheap upgrade (RAID) scott.marlowe 16:38
Re: Suggestions wanted for 7.2.4 query Josh Berkus 17:59
Re: [SQL] Indices are not used by the optimizer Achilleus Mantzios 18:38
Hypothetical suggestions for planner, indexing improvement Josh Berkus 19:19
Re: Suggestions wanted for 7.2.4 query Josh Berkus 19:27
Re: Looking for a cheap upgrade (RAID) Ron Johnson 21:54
Re: Looking for a cheap upgrade (RAID) scott.marlowe 22:22

May 6, 2003

Thread Author Time
Re: Hypothetical suggestions for planner, indexing improvement Tom Lane 04:25
Re: Hypothetical suggestions for planner, indexing improvement Josh Berkus 04:33
Re: Hypothetical suggestions for planner, indexing improvement Tom Lane 04:45
Select on timestamp-day slower than timestamp alone Reiner Dassing 06:59
Re: [HACKERS] Hypothetical suggestions for planner, indexing Peter Childs 07:25
Re: Looking for a cheap upgrade (RAID) Ron Johnson 11:04
Re: [HACKERS] Hypothetical suggestions for planner, Ron Johnson 11:49
A query with performance problems. Fabio C. Bon 12:21
Re: Select on timestamp-day slower than timestamp alone Richard Huxton 13:04
Re: [HACKERS] Hypothetical suggestions for planner, indexing improvement Jim C. Nasby 13:07
Re: [HACKERS] Hypothetical suggestions for planner, indexing improvement Jim C. Nasby 13:10
Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement Tom Lane 13:45
Re: Select on timestamp-day slower than timestamp alone Tom Lane 13:59
Re: Select on timestamp-day slower than timestamp alone Reiner Dassing 14:00
Re: [PERFORM] Hypothetical suggestions for planner, indexing Christopher Kings-Lynne 14:04
Re: [ADMIN] A query with performance problems. Stephan Szabo 14:39
Re: Hypothetical suggestions for planner, indexing Robert Treat 15:33
Re: Looking for a cheap upgrade (RAID) scott.marlowe 18:12
Re: [PERFORM] Hypothetical suggestions for planner, indexing Dennis Björklund 18:32
Re: Looking for a cheap upgrade (RAID) Ron Johnson 19:33
Re: Looking for a cheap upgrade (RAID) scott.marlowe 20:40

May 7, 2003

Thread Author Time
Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement Jim C. Nasby 05:08
Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement Tom Lane 05:20
Re: [PERFORM] Hypothetical suggestions for planner, indexing Dennis Björklund 07:36
Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement Jim C. Nasby 13:36
Re: An unresolved performance problem. Hannu Krosing 13:40
Yet another 'why does it not use my index' question. Ryan 14:11
Re: [PERFORM] Hypothetical suggestions for planner, indexing Tom Lane 14:19
Re: Yet another 'why does it not use my index' question. Ryan 14:43
Re: An unresolved performance problem. Josh Berkus 15:26
Re: [SQL] An unresolved performance problem. Mendola Gaetano 15:36
Re: An unresolved performance problem. scott.marlowe 15:42
Re: Yet another 'why does it not use my index' question. Bruno Wolff III 16:28
An unresolved performance problem. Achilleus Mantzios 16:33
Re: Unanswered Questions WAS: An unresolved performance problem. Josh Berkus 16:57
Re: An unresolved performance problem. Manfred Koizar 18:42
Re: An unresolved performance problem. Achilleus Mantzios 19:09
Hack around lack of CORRESPONDING BY in EXCEPT? Lucas Adamski 19:11
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Stephan Szabo 19:36
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Patrick Hatcher 19:40
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Stephan Szabo 19:43
Re: [SQL] An unresolved performance problem. Bernd von den Brincken 19:57
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Manfred Koizar 20:22
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Lucas Adamski 22:28
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Lucas Adamski 22:37
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Lucas Adamski 22:49
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Stephan Szabo 22:58
Re: [SQL] Unanswered Questions WAS: An unresolved performance problem. Randall Lucas 23:52
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Manfred Koizar 23:54

May 8, 2003

Thread Author Time
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Tom Lane 04:13
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Sean Chittenden 04:57
Re: An unresolved performance problem. Andrew Sullivan 11:20
Re: [SQL] An unresolved performance problem. Achilleus Mantzios 12:09
Re: An unresolved performance problem. Achilleus Mantzios 12:48
Re: An unresolved performance problem. Tom Lane 14:42
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. johnnnnnn 14:47
Type casting and indexes David Olbersen 15:36
Re: Type casting and indexes Stephan Szabo 16:13
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance scott.marlowe 16:20
Re: Type casting and indexes Tom Lane 16:25
Re: Type casting and indexes Tom Lane 22:35

May 9, 2003

Thread Author Time
Re: An unresolved performance problem. Tom Lane 12:31
Re: An unresolved performance problem. Achilleus Mantzios 13:00
Re: An unresolved performance problem. Tom Lane 13:08
Re: An unresolved performance problem. Tom Lane 13:30
Re: An unresolved performance problem. Achilleus Mantzios 18:11
Re: An unresolved performance problem. Achilleus Mantzios 18:22
Re: An unresolved performance problem. Achilleus Mantzios 19:13
Re: An unresolved performance problem. Achilleus Mantzios 19:25

May 10, 2003

Thread Author Time
realtime data inserts Adam Siegel 15:25
Re: realtime data inserts Tom Lane 16:00
Re: realtime data inserts Ericson Smith 16:02
Re: realtime data inserts Jim C. Nasby 17:08
Re: realtime data inserts Ron Johnson 18:31

May 11, 2003

Thread Author Time
Re: realtime data inserts Tom Lane 02:46
Yet another question about not use on indexes Xevi Serrats 13:16
Re: Yet another question about not use on indexes Richard Huxton 14:08
Re: Yet another question about not use on indexes Tom Lane 14:15
Re: realtime data inserts Ron Johnson 16:54
Re: realtime data inserts Doug McNaught 16:58

May 12, 2003

Thread Author Time
Re: Hack around lack of CORRESPONDING BY in EXCEPT? Lucas Adamski 07:29
Re: realtime data inserts Adam Siegel 14:51
Re: PERFORMANCE and SIZE Josh Berkus 15:49
Re: realtime data inserts Steve Crawford 15:56
Re: How are null's stored? Ryan 18:58
How are null's stored? Jim C. Nasby 19:01
PERFORMANCE and SIZE Alfranio Junior 19:35
Re: How are null's stored? Josh Berkus 20:44
Re: How are null's stored? Andrew Sullivan 21:04
Re: How are null's stored? Josh Berkus 22:46
Re: How are null's stored? Stephan Szabo 23:19
Re: How are null's stored? Tom Lane 23:50
partial index / funxtional idx or bad sql? csajl 23:51

May 13, 2003

Thread Author Time
[repost] partial index / funxtional idx or bad sql? csajl 00:07
Re: [repost] partial index / funxtional idx or bad sql? Josh Berkus 00:13
Re: [repost] partial index / funxtional idx or bad sql? csajl 00:47
Re: PERFORMANCE and SIZE Nikolaus Dilger 02:14
Re: [repost] partial index / funxtional idx or bad sql? Josh Berkus 03:32
Re: [repost] partial index / funxtional idx or bad sql? Stephan Szabo 03:47
Re: [repost] partial index / funxtional idx or bad sql? csajl 03:58
Re: [repost] partial index / funxtional idx or bad sql? csajl 04:03
Re: [repost] partial index / funxtional idx or bad sql? Jim C. Nasby 10:58
Re: [repost] partial index / funxtional idx or bad sql? Tom Lane 14:46
Re: PERFORMANCE and SIZE Josh Berkus 16:15
Re: How are null's stored? Stephan Szabo 19:45
Re: How are null's stored? Tom Lane 20:16
Re: PERFORMANCE and SIZE Alfranio Junior 20:28
Re: PERFORMANCE and SIZE scott.marlowe 20:51
Re: Finding filenames for tables Andreas Pflug 21:52
Re: How are null's stored? -- Some numbers Jim C. Nasby 21:55
Finding filenames for tables Jamie Lawrence 22:30

May 14, 2003

Thread Author Time
Re: Finding filenames for tables Jamie Lawrence 00:11
constraint with reference to the same table Victor Yegorov 23:11
Re: constraint with reference to the same table Stephan Szabo 23:28
Re: constraint with reference to the same table Rudi Starcevic 23:57

May 15, 2003

Thread Author Time
Re: constraint with reference to the same table Rudi Starcevic 00:07
Re: constraint with reference to the same table Victor Yegorov 00:12
Re: constraint with reference to the same table Stephan Szabo 00:46
Re: constraint with reference to the same table Stephan Szabo 00:49
Re: constraint with reference to the same table Rudi Starcevic 00:53
Re: constraint with reference to the same table Victor Yegorov 01:03
Re: constraint with reference to the same table Rudi Starcevic 01:09
Re: constraint with reference to the same table Stephan Szabo 01:23
Re: constraint with reference to the same table Stephan Szabo 01:24
INNER JOIN vs WHERE T. Alex Beamish 01:45
Re: constraint with reference to the same table Rudi Starcevic 01:48
Re: constraint with reference to the same table Victor Yegorov 01:58
Re: constraint with reference to the same table Rudi Starcevic 02:07
Re: constraint with reference to the same table Rudi Starcevic 02:14
Re: constraint with reference to the same table Victor Yegorov 02:21
Re: INNER JOIN vs WHERE Tom Lane 02:25
Re: constraint with reference to the same table Rudi Starcevic 02:29
Re: PERFORMANCE and SIZE Bruce Momjian 03:30
Re: PERFORMANCE and SIZE Rudi Starcevic 03:46
Re: nested select query failing Victor Yegorov 03:51
nested select query failing amol 03:57
Re: nested select query failing Christopher Kings-Lynne 04:24
FW: [ADMIN] Out of disk space- error code Anagha Joshi 10:39
Re: nested select query failing SZUCS Gábor 11:56
Re: FW: [ADMIN] Out of disk space- error code Andrew Sullivan 12:38
nested query too expensive Sub Director - Sistemas Informáticos 13:20
Re: nested select query failing Stephan Szabo 14:56
Re: [ADMIN] nested query too expensive Stephan Szabo 15:08

May 16, 2003

Thread Author Time
Re: realtime data inserts alex b. 20:27

Browse Archives

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