pgsql-performance - December 2008

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 21 22 23 24 25 26 28 29 30 31

Dec. 1, 2008

Thread Author Time
Re: Query optimization PFC 13:24
Not so simple query and a half million loop Daniel Cristian Cruz 13:26
Re: Not so simple query and a half million loop 📎 Daniel Cristian Cruz 15:21

Dec. 2, 2008

Thread Author Time
Sort causes system to freeze Craig James 05:49
Re: Sort causes system to freeze Craig James 08:27
Context switch storms Omar Kilani 08:51
Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 09:22
Re: Sort causes system to freeze Richard Huxton 09:59
Re: Not so simple query and a half million loop Daniel Cristian Cruz 10:10
Re: Sort causes system to freeze Tom Lane 10:34
Re: Sort causes system to freeze PFC 11:54
analyzing intermediate query Andrus 12:06
Re: analyzing intermediate query PFC 13:48
Re: analyzing intermediate query Andrus 14:00
Re: analyzing intermediate query PFC 14:13
Re: analyzing intermediate query Andrus 14:37
Re: analyzing intermediate query PFC 15:14
Re: analyzing intermediate query Andrus 15:50
Fwd: Not so simple query and a half million loop 📎 Daniel Cristian Cruz 16:02
Re: Not so simple query and a half million loop Alvaro Herrera 16:07
Re: Not so simple query and a half million loop DANIEL CRISTIAN CRUZ 16:36
Re: analyzing intermediate query Scott Carey 17:50
Re: analyzing intermediate query Andrus 18:58
Re: analyzing intermediate query Scott Carey 21:21

Dec. 3, 2008

Thread Author Time
Postgres using more memory than it should Matthew Wakeling 16:01
Re: Postgres using more memory than it should Bill Moran 16:14
Re: Postgres using more memory than it should tv 16:25
Re: Postgres using more memory than it should Matthew Wakeling 16:34
Re: Postgres using more memory than it should Scott Marlowe 16:48
Re: Postgres using more memory than it should Matthew Wakeling 16:59
Re: Postgres using more memory than it should hubert depesz lubaczewski 17:53
Re: Postgres using more memory than it should Scott Marlowe 19:14
How to profile an "SQL script"? Kynn Jones 19:31
Re: How to profile an "SQL script"? Andreas Kretschmer 19:40
Re: How to profile an "SQL script"? Heikki Linnakangas 20:46

Dec. 4, 2008

Thread Author Time
Re: How to profile an "SQL script"? Kynn Jones 00:03
Re: Postgres using more memory than it should Matthew Wakeling 11:35
Re: Postgres using more memory than it should Matthew Wakeling 13:06
Trigger function, bad performance Rogatzki Rainer 13:32
pg_restore : out of memory Franck Routier 14:08

Dec. 5, 2008

Thread Author Time
Re: Trigger function, bad performance Albe Laurenz 08:24
Re: Trigger function, bad performance Rogatzki Rainer 10:41
Re: Trigger function, bad performance A. Kretschmer 11:08
Re: Trigger function, bad performance Rogatzki Rainer 13:23
Re: Trigger function, bad performance A. Kretschmer 13:36
Re: Trigger function, bad performance Albe Laurenz 15:16
Re: Trigger function, bad performance Rogatzki Rainer 15:41
Re: Context switch storms Kevin Grittner 22:42
Re: Experience with HP Smart Array P400 and SATA drives? Kevin Grittner 22:48
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 23:00
Re: Experience with HP Smart Array P400 and SATA drives? Alan Hodgson 23:30

Dec. 6, 2008

Thread Author Time
Re: Experience with HP Smart Array P400 and SATA drives? Greg Smith 00:29
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 01:39
Re: file system and raid performance 📎 Bruce Momjian 21:34

Dec. 7, 2008

Thread Author Time
Need help with 8.4 Performance Testing Josh Berkus 19:38

Dec. 8, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Kenneth Marshall 02:08
Re: Need help with 8.4 Performance Testing Scott Marlowe 05:40
Re: file system and raid performance M. Edward (Ed) Borasky 05:59
Re: Need help with 8.4 Performance Testing Derek Lewis 06:45
Re: file system and raid performance Jean-David Beyer 12:15
Re: file system and raid performance Scott Marlowe 16:05
Re: Need help with 8.4 Performance Testing Greg Smith 20:15
Re: Need help with 8.4 Performance Testing Scott Marlowe 20:31
Re: file system and raid performance david 20:51
Re: Need help with 8.4 Performance Testing Greg Smith 22:52

Dec. 9, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Merlin Moncure 01:23
Re: Need help with 8.4 Performance Testing Greg Smith 04:00
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 12:10
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 12:15
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 12:17
Re: Need help with 8.4 Performance Testing Gregory Stark 13:02
Re: Need help with 8.4 Performance Testing Jean-David Beyer 13:08
Re: Need help with 8.4 Performance Testing Simon Waters 13:58
Re: file system and raid performance M. Edward (Ed) Borasky 14:35
Re: Need help with 8.4 Performance Testing Greg Stark 14:56
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 15:30
Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake 15:58
Re: Experience with HP Smart Array P400 and SATA drives? Gabriele Turchi 16:03
Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk 16:17
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 16:25
Re: Experience with HP Smart Array P400 and SATA drives? Peter Eisentraut 16:27
Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk 16:35
Re: Need help with 8.4 Performance Testing Scott Carey 16:37
Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake 16:43
Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake 16:43
Re: Need help with 8.4 Performance Testing Scott Marlowe 17:21
Re: Need help with 8.4 Performance Testing Joshua D. Drake 17:26
Re: Need help with 8.4 Performance Testing Scott Carey 17:28
Re: Need help with 8.4 Performance Testing Matthew Wakeling 17:35
Re: Need help with 8.4 Performance Testing Scott Marlowe 17:46
Re: Need help with 8.4 Performance Testing Scott Carey 18:01
Re: Need help with 8.4 Performance Testing Scott Marlowe 18:08
Re: Need help with 8.4 Performance Testing Joshua D. Drake 18:11
query plan with index having a btrim is different for strings of different length Richard Yen 19:56
Re: Need help with 8.4 Performance Testing Merlin Moncure 20:07
Re: Need help with 8.4 Performance Testing Joshua D. Drake 20:20
Re: Need help with 8.4 Performance Testing Scott Carey 22:05
Re: Need help with 8.4 Performance Testing Tom Lane 22:38
Re: query plan with index having a btrim is different for strings of different length David Wilson 22:41
Re: Need help with 8.4 Performance Testing Robert Haas 22:58
Re: Need help with 8.4 Performance Testing Joshua D. Drake 23:05
Re: Need help with 8.4 Performance Testing Ben Chobot 23:07
Re: Need help with 8.4 Performance Testing justin 23:19
Re: query plan with index having a btrim is different for strings of different length Tom Lane 23:27
Re: Need help with 8.4 Performance Testing Scott Carey 23:34

Dec. 10, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Gregory Stark 00:45
Re: Need help with 8.4 Performance Testing Gregory Stark 00:54
Re: Need help with 8.4 Performance Testing Ron Mayer 01:37
Re: Need help with 8.4 Performance Testing Craig James 01:56
Re: Need help with 8.4 Performance Testing Robert Haas 03:06
Degenerate Performance Problem Vincent Predoehl 03:16
Re: Degenerate Performance Problem Scott Marlowe 03:47
Re: Need help with 8.4 Performance Testing Scott Carey 05:48
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 07:45
Re: Experience with HP Smart Array P400 and SATA drives? Scott Carey 07:58
Re: Need help with 8.4 Performance Testing Scott Carey 08:20
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 12:29
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 13:34
Re: Need help with 8.4 Performance Testing Matthew Wakeling 13:41
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 14:17
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 14:30
Re: Experience with HP Smart Array P400 and SATA drives? Gregory Williamson 15:21
Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk 15:52
Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni 16:05
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 16:17
Re: Experience with HP Smart Array P400 and SATA drives? Matthew Wakeling 18:08
Re: Experience with HP Smart Array P400 and SATA drives? Greg Smith 19:13
Re: query plan with index having a btrim is different for strings of different length Richard Yen 19:28
Re: query plan with index having a btrim is different for strings of different length Tom Lane 19:34
Re: query plan with index having a btrim is different for strings of different length Robert Haas 19:39
Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe 19:41
Re: query plan with index having a btrim is different for strings of different length Tom Lane 20:04
Re: Experience with HP Smart Array P400 and SATA drives? David Wilson 21:37
Re: query plan with index having a btrim is different for strings of different length Richard Yen 21:54
Re: query plan with index having a btrim is different for strings of different length Richard Yen 22:04
Re: query plan with index having a btrim is different for strings of different length Vladimir Sitnikov 22:36

Dec. 11, 2008

Thread Author Time
Re: query plan with index having a btrim is different for strings of different length Tom Lane 00:08
Re: query plan with index having a btrim is different for strings of different length Richard Yen 01:44
Re: Experience with HP Smart Array P400 and SATA drives? Matthew Wakeling 13:47
Re: Need help with 8.4 Performance Testing Josh Berkus 20:05
Re: Need help with 8.4 Performance Testing Josh Berkus 20:07
Re: Need help with 8.4 Performance Testing Josh Berkus 20:15
Re: Need help with 8.4 Performance Testing James Mansion 23:09

Dec. 12, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Greg Smith 07:55
db server load Stefano Nichele 10:07
Re: db server load Scott Marlowe 21:44

Dec. 13, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Robert Haas 13:22
Re: Need help with 8.4 Performance Testing Scott Marlowe 15:15
Re: Need help with 8.4 Performance Testing david 15:44
Re: Need help with 8.4 Performance Testing Joshua D. Drake 18:37
Re: Need help with 8.4 Performance Testing Scott Marlowe 19:45
Re: Need help with 8.4 Performance Testing Joshua D. Drake 19:47
Re: Need help with 8.4 Performance Testing Scott Marlowe 19:57
Re: Need help with 8.4 Performance Testing Joshua D. Drake 20:03
Re: Need help with 8.4 Performance Testing Angel Alvarez 21:00

Dec. 14, 2008

Thread Author Time
Re: Need help with 8.4 Performance Testing Scott Marlowe 02:16
Re: Need help with 8.4 Performance Testing Joshua D. Drake 03:09
Re: Need help with 8.4 Performance Testing Tom Lane 05:48

Dec. 15, 2008

Thread Author Time
filesystems benchmark Adrian Moisey 06:46
Re: filesystems benchmark Vladimir Sitnikov 12:02
Re: filesystems benchmark Greg Smith 17:31

Dec. 16, 2008

Thread Author Time
rebellious pg stats collector (reopened case) Laszlo Nagy 12:00
Re: rebellious pg stats collector (reopened case) Alvaro Herrera 13:45
measure database contention Jaime Casanova 19:32

Dec. 17, 2008

Thread Author Time
insert and Update slow after implementing slony. Nimesh Satam 04:03
Re: measure database contention Albe Laurenz 07:34
Re: measure database contention Robert Haas 14:18
Re: measure database contention Merlin Moncure 14:49
Re: measure database contention Jaime Casanova 15:22
Re: measure database contention Jaime Casanova 15:38
Re: measure database contention Robert Haas 16:56
Re: measure database contention Jaime Casanova 18:19
Re: measure database contention Scott Marlowe 18:57
Re: insert and Update slow after implementing slony. David Rees 19:59
Re: measure database contention Robert Haas 21:14

Dec. 19, 2008

Thread Author Time
Re: Fwd: Not so simple query and a half million loop Craig Ringer 01:25
Re: pg_restore : out of memory Craig Ringer 01:50
Re: pg_restore : out of memory sathiya psql 08:00
Re: rebellious pg stats collector (reopened case) Laszlo Nagy 08:54
Re: rebellious pg stats collector (reopened case) Alvaro Herrera 13:04
Re: rebellious pg stats collector (reopened case) Laszlo Nagy 13:13

Dec. 21, 2008

Thread Author Time
dbt-2 tuning results with postgresql-8.3.5 Mark Wong 00:54
Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark 01:33
PostgreSQL vs Oracle Victor Nawothnig 08:17
Re: PostgreSQL vs Oracle Scott Marlowe 08:51
Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong 09:29
Re: PostgreSQL vs Oracle Stefano Dal Pra 10:15
Query planner plus partitions equals very bad plans, again Scott Carey 20:08

Dec. 22, 2008

Thread Author Time
Re: PostgreSQL vs Oracle Guy Rouillier 03:31
Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark 06:56
Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong 08:50
Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith 08:59
Re: rebellious pg stats collector (reopened case) Laszlo Nagy 10:11
Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark 10:35
Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark 10:56
Slow table update Laszlo Nagy 11:06
Re: Slow table update Laszlo Nagy 11:34
Re: Slow table update Gregory Williamson 11:45
Re: Slow table update Laszlo Nagy 12:54
Re: rebellious pg stats collector (reopened case) Tom Lane 13:23

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 21 22 23 24 25 26 28 29 30 31