pgsql-performance - April 2007

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)

Browse Archives

Prev | Next

April 1, 2007

Thread Author Time
Re: scalablility problem Ron Mayer 10:22
Re: scalablility problem Xiaoning Ding 17:51

April 2, 2007

Thread Author Time
Re: scalablility problem Dave Cramer 00:26
Re: How to determine which indexes are not using or using seldom in database Andreas Kostyrka 07:45
How to determine which indexes are not using or using seldom in database Denis Lishtovny 08:12
Re: How to determine which indexes are not using or using seldom in database Thomas Pundt 08:45
Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller 10:34
Providing user based previleges to Postgres DB ramachandra.bhaskaram 10:35
Re: Wrong plan sequential scan instead of an index one [8.2 solved it] Gaetano Mendola 10:40
Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller 10:53
Re: Providing user based previleges to Postgres DB Carlos Moreno 14:42
postgres 7.4 vs. 8.x redux Alex Deucher 14:50
Re: Scaling SELECT:s with the number of disks on a stripe Andrew - Supernews 17:00

April 3, 2007

Thread Author Time
postgres 7.4 vs 8.x redux: query plans Alex Deucher 05:09
Re: postgres 7.4 vs 8.x redux: query plans Tom Lane 05:28
Cache hit ratio Jean Arnaud 14:12
Re: Cache hit ratio Guillaume Cottenceau 14:53
Re: Cache hit ratio Luke Lonergan 16:17
Re: Shared buffers, db transactions commited, and write IO on Solaris Josh Berkus 16:26
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 16:37
Re: Shared buffers, db transactions commited, and write IO on Solaris Dimitri 16:51
Re: Cache hit ratio Ben 17:33
Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau 18:59
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Josh Berkus 19:05
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Tom Lane 19:08
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M. 19:16
Re: Shared buffers, db transactions commited, and write IO on Solaris Erik Jones 19:24
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 19:30
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" C. Bergström 19:39
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M. 19:47
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Alan Hodgson 20:00
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M. 20:06
Re: postgres 7.4 vs 8.x redux: query plans Merlin Moncure 20:13
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 20:18
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 20:34
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 20:45
Re: postgres 7.4 vs 8.x redux: query plans Tom Lane 21:21
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 21:38
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 21:43
Re: [HACKERS] EXISTS optimization Craig A. James 21:47
SCSI vs SATA jason@ohloh.net 22:13
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 22:17
Re: SCSI vs SATA Ron 23:07
Re: SCSI vs SATA Ron 23:13

April 4, 2007

Thread Author Time
Re: SCSI vs SATA Geoff Tolley 01:54
Re: SCSI vs SATA Brian A. Seklecki 03:36
Re: SCSI vs SATA david 04:15
Re: compact flash disks? James Mansion 05:18
Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller 06:01
postgresql.conf file for PostgreSQL 8.2.3 Eugene Ogurtsov 06:07
Re: SCSI vs SATA Ron Mayer 08:36
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau 08:50
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Ansgar -59cobalt- Wiechers 11:08
Re: SCSI vs SATA Peter Kovacs 11:16
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau 11:51
Re: Scaling SELECT:s with the number of disks on a stripe Dave Cramer 11:52
Re: Scaling SELECT:s with the number of disks on a stripe Andrew - Supernews 12:03
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau 12:35
Re: SCSI vs SATA Andreas Kostyrka 12:46
Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Dimitri 12:46
Re: SCSI vs SATA Alvaro Herrera 13:19
Re: SCSI vs SATA Peter Kovacs 13:30
Re: SCSI vs SATA Alvaro Herrera 13:36
Re: SCSI vs SATA Rod Taylor 13:38
Re: SCSI vs SATA Andreas Kostyrka 13:48
Large objetcs performance Alexandre Vasconcelos 14:03
Re: Large objetcs performance Guido Neitzer 14:11
Re: SCSI vs SATA jason@ohloh.net 14:12
Re: SCSI vs SATA Ron 14:57
Re: SCSI vs SATA Joshua D. Drake 15:16
Re: SCSI vs SATA Stefan Kaltenbrunner 15:33
Re: SCSI vs SATA Joshua D. Drake 15:40
Re: SCSI vs SATA Andreas Kostyrka 15:43
Re: SCSI vs SATA Joshua D. Drake 15:50
Re: SCSI vs SATA Stefan Kaltenbrunner 15:59
Re: SCSI vs SATA david 16:04
Can't drop tablespace or user after disk gone Craig A. James 16:43
Re: Can't drop tablespace or user after disk gone Tom Lane 16:57
Re: SCSI vs SATA mark 16:58
Re: SCSI vs SATA Geoff Tolley 17:36
Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller 17:44
Re: SCSI vs SATA Geoff Tolley 18:03
Re: SCSI vs SATA Geoff Tolley 18:40
Re: SCSI vs SATA James Mansion 18:45
Re: SCSI vs SATA Arjen van der Meijden 19:09
Re: SCSI vs SATA jason@ohloh.net 19:17
Re: SCSI vs SATA Arjen van der Meijden 19:38
Re: SCSI vs SATA Bruce Momjian 20:27
Re: SCSI vs SATA Joshua D. Drake 20:32
Re: SCSI vs SATA Bruce Momjian 20:36
Re: SCSI vs SATA Carlos Moreno 20:48
Re: SCSI vs SATA jason@ohloh.net 23:42

April 5, 2007

Thread Author Time
Re: SCSI vs SATA James Mansion 05:25
Re: SCSI vs SATA Tom Lane 05:32
Re: SCSI vs SATA Arjen van der Meijden 07:07
Re: SCSI vs SATA Heikki Linnakangas 09:28
Re: SCSI vs SATA Ron 11:09
Re: SCSI vs SATA Scott Marlowe 15:03
Re: SCSI vs SATA Scott Marlowe 15:19
Re: SCSI vs SATA Jeff Frost 15:21
Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher 15:34
Re: SCSI vs SATA jason@ohloh.net 15:38
Re: SCSI vs SATA jason@ohloh.net 15:58
Re: SCSI vs SATA Joshua D. Drake 16:02
Re: SCSI vs SATA Alex Deucher 16:10
Re: SCSI vs SATA Ron 16:25
Re: SCSI vs SATA Arjen van der Meijden 16:29
a question about Direct I/O and double buffering Xiaoning Ding 17:09
What do the adminpack functions do? (8.2.3) Michael Dengler 18:01
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Josh Berkus 18:05
Re: What do the adminpack functions do? (8.2.3) Joshua D. Drake 18:07
Re: a question about Direct I/O and double buffering Erik Jones 18:09
Re: a question about Direct I/O and double buffering Xiaoning Ding 18:22
Re: a question about Direct I/O and double buffering Mark Lewis 18:27
Premature view materialization in 8.2? Jonathan Ellis 18:46
Re: a question about Direct I/O and double buffering Erik Jones 18:47
Re: a question about Direct I/O and double buffering Alex Deucher 18:56
Re: a question about Direct I/O and double buffering Erik Jones 18:58
Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Dimitri 19:00
High Load on Postgres 7.4.16 Server John Allgood 19:06
Re: High Load on Postgres 7.4.16 Server Jeff Frost 19:23
Re: High Load on Postgres 7.4.16 Server C. Bergström 19:28
Re: SCSI vs SATA James Mansion 19:30
Re: High Load on Postgres 7.4.16 Server John Allgood 19:33
Re: High Load on Postgres 7.4.16 Server Jeff Frost 19:47
Re: a question about Direct I/O and double buffering Mark Lewis 19:56
Re: High Load on Postgres 7.4.16 Server Dave Cramer 20:00
Re: a question about Direct I/O and double buffering Erik Jones 20:10
Re: SCSI vs SATA david 20:11
Re: High Load on Postgres 7.4.16 Server John Allgood 20:13
Re: SCSI vs SATA david 20:15
Re: High Load on Postgres 7.4.16 Server Dave Cramer 20:27
Re: a question about Direct I/O and double buffering david 20:33
Re: a question about Direct I/O and double buffering Xiaoning Ding 20:58
Re: a question about Direct I/O and double buffering Alex Deucher 21:06
Re: SCSI vs SATA Scott Marlowe 21:13
Re: a question about Direct I/O and double buffering Erik Jones 21:39
Re: Weird performance drop Vincenzo Romano 21:52

April 6, 2007

Thread Author Time
Re: ERROR: out of shared memory Joseph S 00:25
Re: a question about Direct I/O and double buffering david 01:47
Re: SCSI vs SATA david 02:07
Re: SCSI vs SATA Ron 03:19
Re: SCSI vs SATA david 03:40
Re: a question about Direct I/O and double buffering david 04:33
Re: SCSI vs SATA Greg Smith 04:37
Re: SCSI vs SATA Richard Troy 04:40
Re: SCSI vs SATA Ron 05:27
Re: Premature view materialization in 8.2? Tom Lane 05:43
Re: High Load on Postgres 7.4.16 Server Tom Lane 05:50
Re: Premature view materialization in 8.2? Jonathan Ellis 05:51
Re: SCSI vs SATA david 05:53
Re: SCSI vs SATA Tom Lane 06:00
Re: SCSI vs SATA Greg Smith 06:10
Re: Premature view materialization in 8.2? Tom Lane 06:23
Re: SCSI vs SATA Tom Lane 06:38
Re: SCSI vs SATA Michael Stone 11:38
Re: SCSI vs SATA Michael Stone 11:43
Re: SCSI vs SATA Ron 12:31
Re: SCSI vs SATA Geoffrey 12:43
Re: SCSI vs SATA Geoffrey 12:46
Re: SCSI vs SATA Ron 12:49
Re: SCSI vs SATA Michael Stone 13:23
Re: Premature view materialization in 8.2? Jonathan Ellis 14:24
Re: SCSI vs SATA Scott Marlowe 15:20
Re: High Load on Postgres 7.4.16 Server John Allgood 15:21
more on high load on postgres 7.4.16 Geoffrey 15:41
Re: more on high load on postgres 7.4.16 Stefan Kaltenbrunner 15:58
Re: SCSI vs SATA Ron 16:41
Re: more on high load on postgres 7.4.16 Geoffrey 17:04
Re: Premature view materialization in 8.2? Tom Lane 17:40
Re: Premature view materialization in 8.2? Jonathan Ellis 17:57
Re: Premature view materialization in 8.2? Tom Lane 18:00
Re: Premature view materialization in 8.2? Jonathan Ellis 18:03
Re: SCSI vs SATA Michael Stone 18:19
Re: Premature view materialization in 8.2? Tom Lane 18:34
Re: SCSI vs SATA Ron 19:37
Re: Premature view materialization in 8.2? Jonathan Ellis 20:26
postgres 8.2 seems to prefer Seq Scan Alex Deucher 20:38
Re: SCSI vs SATA Greg Smith 20:44
Re: SCSI vs SATA Michael Stone 21:02
Re: postgres 8.2 seems to prefer Seq Scan Michael Fuhr 21:31
Re: postgres 8.2 seems to prefer Seq Scan Alex Deucher 21:48
Re: SCSI vs SATA david 22:04
Re: SCSI vs SATA Charles Sprickman 22:40
Re: SCSI vs SATA david 23:00
Re: SCSI vs SATA Andreas Kostyrka 23:17
Re: SCSI vs SATA Mark Kirkwood 23:24

April 7, 2007

Thread Author Time
Re: SCSI vs SATA Bruce Momjian 02:35
fast DISTINCT or EXIST Tilo Buschmann 10:47
Re: fast DISTINCT or EXIST Arjen van der Meijden 12:32
Re: SCSI vs SATA Ron 13:03
Re: fast DISTINCT or EXIST Tom Lane 15:54
Re: fast DISTINCT or EXIST Tilo Buschmann 16:24
Re: fast DISTINCT or EXIST Tom Lane 16:39
Re: fast DISTINCT or EXIST Arjen van der Meijden 17:28
Re: SCSI vs SATA david 21:42

April 8, 2007

Thread Author Time
Re: SCSI vs SATA Ron 00:46
Re: SCSI vs SATA david 03:13
Re: SCSI vs SATA Joshua D. Drake 03:20
Re: SCSI vs SATA mark 07:49

Browse Archives

Prev | Next