pgsql-performance - July 2004

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 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 27 28 29 30 31

July 1, 2004

Thread Author Time
planner and worst case scenario Joseph Shraibman 03:14
network address query Litao Wu 16:12
Re: Query gets slow when where clause increases Dennis Bjorklund 20:44

July 2, 2004

Thread Author Time
Mysterious performance of query because of plsql function in where condition Peter Alberer 07:48
BUG #1186: Broken Index? PostgreSQL Bugs List 07:50
Re: Mysterious performance of query because of plsql function in where condition Jeff 11:52
Re: Mysterious performance of query because of plsql function in where condition Bruno Wolff III 13:07
Re: BUG #1186: Broken Index? Bruno Wolff III 13:12
Re: Mysterious performance of query because of plsql function in CoL 14:23
finding a max value Edoardo Ceccarelli 18:50

July 3, 2004

Thread Author Time
Re: BUG #1186: Broken Index? Gaetano Mendola 14:51

July 5, 2004

Thread Author Time
Odd sorting behaviour Steinar H. Gunderson 09:18
Seq scan vs. Index scan with different query conditions eleven 10:15
Re: Seq scan vs. Index scan with different query conditions Richard Huxton 11:41
Re: Seq scan vs. Index scan with different query Andrew McMillan 11:44
Re: Seq scan vs. Index scan with different query conditions eleven 13:46
Re: Seq scan vs. Index scan with different query Andrew McMillan 19:22
Forcing HashAggregation prior to index scan? Eugene 23:14

July 6, 2004

Thread Author Time
to fsync or not to fsync Rodrigo Filgueira 14:57
Re: to fsync or not to fsync Frank Hsueh 15:45
Re: to fsync or not to fsync (ext3?) Rodrigo Filgueira 16:43
Keyword searching question borajetta 17:52
Re: Keyword searching question borajetta 17:56

July 7, 2004

Thread Author Time
Implementatiion of Inheritance in Postgres Ioannis Theoharis 15:13
Terrible performance after deleting/recreating indexes Bill Chandler 16:16
inserting into brand new database faster than old database Missner, T. R. 17:24
Re: inserting into brand new database faster than old database Matthew T. O'Connor 19:17
Re: inserting into brand new database faster than old database Missner, T. R. 19:28
Re: finding a max value James Antill 19:29
Re: [PERFORM] finding a max value Rosser Schwarz 20:27
query plan wierdness? Joel McGraw 21:27
Re: query plan wierdness? Guido Barosio 21:45
Re: query plan wierdness? Joel McGraw 22:12
Re: query plan wierdness? Stephan Szabo 22:50

July 8, 2004

Thread Author Time
Re: inserting into brand new database faster than old database Shridhar Daithankar 09:02
Re: Terrible performance after deleting/recreating indexes Shridhar Daithankar 09:07
Odd sorting behaviour Steinar H. Gunderson 10:19
Re: query plan wierdness? Rod Taylor 16:50
vacuum_mem Litao Wu 18:03
Working on huge RAM based datasets Andy Ballingall 18:05
Re: vacuum_mem Rod Taylor 18:25
Re: Terrible performance after deleting/recreating indexes Bill Chandler 20:49

July 9, 2004

Thread Author Time
Re: Terrible performance after deleting/recreating indexes Mark Kirkwood 00:14
Re: Working on huge RAM based datasets Christopher Kings-Lynne 01:41
Re: Working on huge RAM based datasets Andy Ballingall 09:28
Re: Working on huge RAM based datasets Merlin Moncure 14:16
Re: Terrible performance after deleting/recreating indexes Bill Chandler 15:18
Re: Working on huge RAM based datasets Andy Ballingall 16:08
Re: query plan wierdness? Joel McGraw 18:15
Re: query plan wierdness? Rod Taylor 19:18
Cursors performance (was: Re: [PERFORM] Terrible performance after deleting/recreating indexes) Bill Chandler 20:24
Re: Cursors performance (was: Re: [PERFORM] Terrible Dave Cramer 20:39
Re: Cursors performance (was: Re: [PERFORM] Terrible performance Kris Jurka 20:44
Re: Cursors performance (was: Re: [PERFORM] Terrible performance after deleting/recreating indexes) Bill Chandler 21:03
Re: Cursors performance (was: Re: [PERFORM] Terrible Dave Cramer 21:10
Re: Cursors performance (was: Re: [PERFORM] Terrible performance after deleting/recreating indexes) Bill Chandler 21:18
Re: Cursors performance Oliver Jowett 21:55
Re: Inverted-list databases (was: Working on huge RAM based datasets) Mischa Sandberg 22:23

July 10, 2004

Thread Author Time
Re: inserting into brand new database faster than old database Tom Lane 02:52
Re: Cursors performance Mark Kirkwood 03:06
Re: Forcing HashAggregation prior to index scan? Tom Lane 03:10
Re: achat borne wifi Laurent Martelli 10:00
Re: Working on huge RAM based datasets Andy Ballingall 12:25
Re: Working on huge RAM based datasets Christopher Browne 13:06

July 11, 2004

Thread Author Time
Re: Working on huge RAM based datasets Jan Wieck 14:12
Re: Working on huge RAM based datasets Christopher Browne 17:04

July 12, 2004

Thread Author Time
Re: Working on huge RAM based datasets Merlin Moncure 14:05
Re: Working on huge RAM based datasets Merlin Moncure 14:23
Re: Working on huge RAM based datasets Rod Taylor 14:38
Re: Working on huge RAM based datasets Josh Berkus 16:38
Swapping in 7.4.3 Jim Ewert 16:59
Re: Working on huge RAM based datasets Jan Wieck 18:01
Re: [PERFORM] Cursors performance Bill Chandler 18:07
Re: Fw: invitation au "Village du Logiciel Libre" de la Laurent Martelli 18:33
Re: [PERFORM] Cursors performance Barry Lind 21:05
Re: [PERFORM] Cursors performance Kris Jurka 21:11
Re: query plan wierdness? Joel McGraw 23:54

July 13, 2004

Thread Author Time
Re: query plan wierdness? Rod Taylor 02:06
How to create an index for type timestamp column using rtree? Chris Cheston 05:51
Re: How to create an index for type timestamp column using rtree? Tom Lane 06:14
Re: How to create an index for type timestamp column using Christopher Kings-Lynne 06:33
Re: How to create an index for type timestamp column using rtree? Chris Cheston 07:56
Re: [PERFORM] Cursors performance Bill Chandler 16:13
Insert are going slower ... Hervé Piedvache 16:50
Re: [PERFORM] Cursors performance Tom Lane 17:08
Re: Insert are going slower ... Josh Berkus 17:10
Re: Swapping in 7.4.3 Matthew T. O'Connor 20:26
Re: Insert are going slower ... Hervé Piedvache 23:42

July 14, 2004

Thread Author Time
Re: Insert are going slower ... gnari 10:06
Re: Insert are going slower ... Shridhar Daithankar 10:13
Re: Insert are going slower ... Hervé Piedvache 14:08
Re: Insert are going slower ... Shridhar Daithankar 14:32
Re: Insert are going slower ... Josh Berkus 16:28
Re: Insert are going slower ... Hervé Piedvache 21:19
vacuum full 100 mins plus? Patrick Hatcher 21:29
Re: Insert are going slower ... Hervé Piedvache 21:32
Re: vacuum full 100 mins plus? Patrick Hatcher 22:36
Re: Odd sorting behaviour Steinar H. Gunderson 23:11

July 15, 2004

Thread Author Time
Re: vacuum full 100 mins plus? Josh Berkus 00:13
Re: Odd sorting behaviour Josh Berkus 01:41
Re: vacuum full 100 mins plus? Christopher Browne 02:21
Re: vacuum full 100 mins plus? Tom Lane 04:36
Re: Odd sorting behaviour Tom Lane 04:52
Re: Insert are going slower ... Shridhar Daithankar 06:21
extrem bad performance Stefan 10:24
Re: Odd sorting behaviour Steinar H. Gunderson 12:08
Re: Swapping in 7.4.3 Jim Ewert 13:49
Re: vacuum full 100 mins plus? Mike Rylander 15:14
Re: Swapping in 7.4.3 Scott Marlowe 16:20
hardware raid suggestions Brian Hirt 18:07
Re: Insert are going slower ... Josh Berkus 18:09
Re: Odd sorting behaviour Josh Berkus 18:11
Wierd issues Andrew Matthews 19:35
Re: Odd sorting behaviour Steinar H. Gunderson 22:16

July 16, 2004

Thread Author Time
Re: hardware raid suggestions Josh Berkus 02:55
Re: hardware raid suggestions Mark Aufflick 03:25
Re: Swapping in 7.4.3 Matt Clark 07:35
Re: Insert are going slower ... Hervé Piedvache 11:17
same plan, different time Litao Wu 21:36

July 17, 2004

Thread Author Time
Re: extrem bad performance Rod Taylor 02:31
Re: hardware raid suggestions Fred Moyer 03:20
Scaling with lazy index updates Fred Moyer 03:30
Re: same plan, different time Tom Lane 04:43

July 18, 2004

Thread Author Time
Re: Scaling with lazy index updates Josh Berkus 00:02
Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Gaetano Mendola 09:42
Re: Insert are going slower ... Josh Berkus 17:23

July 19, 2004

Thread Author Time
Re: Working on huge RAM based datasets Andy Ballingall 09:12

July 20, 2004

Thread Author Time
NAS, SAN or any alternate solution ? bsimon 07:52
Re: NAS, SAN or any alternate solution ? Scott Marlowe 08:20
Réf. : Re: NAS, SAN or any alternate solution ? bsimon 09:32
Re: Réf. : Re: [PERFORM] NAS, Mark Kirkwood 10:04
Réf. : Re: Réf. : Re: NAS, SAN or any alternate solution ? bsimon 10:18
Re: Working on huge RAM based datasets abhousehunt 10:45
Re: Odd sorting behaviour Steinar H. Gunderson 11:51
Re: NAS, SAN or any alternate solution ? Grega Bremec 12:23
Re: NAS, SAN or any alternate solution ? Grega Bremec 13:01
Re: Réf. : Re: NAS, SAN or any Scott Marlowe 15:28
Re: NAS, SAN or any alternate solution ? Joe Conway 16:44
Re: Odd sorting behaviour Josh Berkus 17:02
Re: Odd sorting behaviour Josh Berkus 17:06
Re: Odd sorting behaviour Steinar H. Gunderson 17:21
Re: NAS, SAN or any alternate solution ? Rod Taylor 17:25
Unbearably slow cascading deletes andrew 19:19
Re: Unbearably slow cascading deletes Stephan Szabo 19:45
Re: Unbearably slow cascading deletes Stephan Szabo 19:55
Re: Unbearably slow cascading deletes andrew 19:59
Re: Unbearably slow cascading deletes andrew 20:06
Index type Ilia Kantor 21:46

July 21, 2004

Thread Author Time
Re: Unbearably slow cascading deletes Christopher Kings-Lynne 01:37
Re: Odd sorting behaviour Rod Taylor 02:18
Re: Odd sorting behaviour Steinar H. Gunderson 10:04
Re: Odd sorting behaviour Rod Taylor 14:58
Re: extrem bad performance Stefan 16:25
Beowulf Cluster & Postgresql? joe 20:45
Re: Beowulf Cluster & Postgresql? Scott Marlowe 21:08

July 22, 2004

Thread Author Time
Re: Beowulf Cluster & Postgresql? Mark Kirkwood 02:47

July 23, 2004

Thread Author Time
Performance over a LAN William Carney 05:50
Re: Performance over a LAN Christopher Kings-Lynne 06:02
Re: Performance over a LAN Mark Aufflick 06:20
Re: Performance over a LAN Scott Marlowe 06:29
Re: Performance over a LAN William Carney 07:57
Wrong index choosen? Gaetano Mendola 08:26
Re: Performance over a LAN Rod Taylor 11:43
Re: Wrong index choosen? Dennis Bjorklund 12:01
Re: Performance over a LAN Jeff 12:07
Re: Wrong index choosen? Tom Lane 14:45
Re: Performance over a LAN Michael Adler 15:34
Re: Performance over a LAN Gary Cowell 16:26
Re: Performance over a LAN Greg Stark 17:09
Re: [HACKERS] Wrong index choosen? Gaetano Mendola 17:41
Re: [HACKERS] Wrong index choosen? Matthew T. O'Connor 18:12
variable length - user defined types/storage place martin.bokler 21:28
Re: [HACKERS] Wrong index choosen? Jaime Casanova 21:51
Re: [HACKERS] Wrong index choosen? Scott Marlowe 22:02

July 24, 2004

Thread Author Time
Re: [HACKERS] Wrong index choosen? Gaetano Mendola 00:07
Re: [HACKERS] Wrong index choosen? Matthew T. O'Connor 01:49

July 26, 2004

Thread Author Time
arrays and indexes Ross J. Reedstrom 04:57
Re: arrays and indexes Greg Stark 06:27
Re: hardware raid suggestions Gaetano Mendola 14:01
Re: Insert are going slower ... Gaetano Mendola 14:12
Re: Insert are going slower ... Gaetano Mendola 14:20
Timestamp-based indexing Harmon S. Nine 14:49
Re: arrays and indexes Merlin Moncure 14:56
Re: Timestamp-based indexing Kevin Barnard 14:58
Re: Timestamp-based indexing Matthew T. O'Connor 15:09
Re: Timestamp-based indexing Harmon S. Nine 15:42
Re: Timestamp-based indexing Harmon S. Nine 15:46
Re: Timestamp-based indexing Tom Lane 15:59
Re: Timestamp-based indexing Stephan Szabo 16:02
Re: Insert are going slower ... Scott Marlowe 16:25
Re: Timestamp-based indexing Harmon S. Nine 18:37
Re: arrays and indexes Ross J. Reedstrom 18:47
Re: arrays and indexes Pierre-Frédéric Caillaud 20:35
Re: arrays and indexes Greg Stark 20:40
Re: arrays and indexes Tom Lane 21:21
Re: Timestamp-based indexing Litao Wu 21:26
Re: Timestamp-based indexing Tom Lane 21:40

July 27, 2004

Thread Author Time
Re: Timestamp-based indexing Christopher Kings-Lynne 01:53
Re: arrays and indexes Greg Stark 04:32
Little understanding for tuning ... Hervé Piedvache 07:35

Browse Archives

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