pgsql-performance - February 2009

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 18 19 20 21 22 23 24 25 26 27 28

Feb. 2, 2009

Thread Author Time
Deleting millions of rows Brian Cox 18:17
Re: Deleting millions of rows Robert Haas 18:38
Re: Deleting millions of rows Jerry Champlin 19:15
Re: Deleting millions of rows Dave Dutcher 19:35
Re: Deleting millions of rows Brian Cox 20:01
Re: Deleting millions of rows Robert Haas 20:07
Re: Deleting millions of rows David Wilson 20:20
Re: Deleting millions of rows Brian Cox 20:37
Re: Deleting millions of rows David Wilson 20:57
Re: Deleting millions of rows Scott Marlowe 20:58
Re: Deleting millions of rows Tom Lane 20:58
Re: Deleting millions of rows Brian Cox 22:01
Re: Deleting millions of rows Scott Marlowe 22:33
Re: Deleting millions of rows Robert Haas 23:26

Feb. 3, 2009

Thread Author Time
Re: SSD performance Jeff 17:54
Re: Deleting millions of rows Alvaro Herrera 18:20
Re: SSD performance David Rees 18:26
Re: SSD performance Scott Carey 18:43
Re: SSD performance Scott Marlowe 19:50
Re: Deleting millions of rows Tom Lane 21:17
Re: Deleting millions of rows 📎 Andrew Lazarus 22:04

Feb. 4, 2009

Thread Author Time
Re: Deleting millions of rows Robert Haas 00:08
Getting error while running DBT2 test for PostgreSQL 📎 Rohan Pethkar 10:42
Re: Deleting millions of rows Gregory Stark 12:35
Re: SSD performance Jeff 13:06
Re: Deleting millions of rows Robert Haas 13:59
Re: SSD performance david 14:45
suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah 18:45
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe 20:09
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gary Doades 20:25
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden 21:11
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe 21:36

Feb. 5, 2009

Thread Author Time
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 04:24
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 05:04
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller justin 05:47
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke 12:40
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Glyn Astill 12:55
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Ivan Voras 13:01
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke 13:12
Number of occurrence of characters? Ivan Voras 13:31
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gregory Stark 14:04
Re: Number of occurrence of characters? hubert depesz lubaczewski 14:13
Re: Number of occurrence of characters? Heikki Linnakangas 14:35
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Joshua D. Drake 16:13
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah 16:38
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 18:42
bitmap heap scan recheck on full text search with gin index Hal Roberts 23:13

Feb. 6, 2009

Thread Author Time
Re: bitmap heap scan recheck on full text search with gin index Oleg Bartunov 04:22
Re: dbt-2 tuning results with postgresql-8.3.5 📎 Mark Wong 05:04
Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith 08:22
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke 08:32
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke 09:04
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe 09:17
Re: Number of occurrence of characters? Ivan Voras 09:42
Can't locate Test/Parser/Dbt2.pm in DBT2 tests Rohan Pethkar 11:37
Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests Richard Huxton 11:46
Re: Number of occurrence of characters? Grzegorz Jaśkiewicz 13:13
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Bruce Momjian 14:23
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Glyn Astill 14:34
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matt Burke 15:19
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Bruce Momjian 15:27
Postgres not willing to use an index? Mario Splivalo 15:43
Re: Postgres not willing to use an index? Grzegorz Jaśkiewicz 15:55
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller 📎 justin 16:05
Re: Postgres not willing to use an index? Tom Lane 16:14
Re: Postgres not willing to use an index? Robert Haas 16:29
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe 17:36
Re: Postgres not willing to use an index? Kevin Grittner 17:41
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden 17:53
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 17:57
inheritance, and plans Grzegorz Jaśkiewicz 18:00
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Arjen van der Meijden 18:09
Re: Postgres not willing to use an index? Robert Haas 18:12
Re: inheritance, and plans Robert Haas 18:15
Re: inheritance, and plans Grzegorz Jaśkiewicz 18:20
Re: inheritance, and plans Grzegorz Jaśkiewicz 18:21
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Greg Smith 18:49
Re: inheritance, and plans Tom Lane 21:50

Feb. 7, 2009

Thread Author Time
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 00:10
explanation of some configs Thomas Finneid 00:52
Re: explanation of some configs Joshua D. Drake 00:59
Re: Getting error while running DBT2 test for PostgreSQL Mark Wong 05:31
Re: Can't locate Test/Parser/Dbt2.pm in DBT2 tests Mark Wong 05:46
Re: explanation of some configs Thomas Finneid 09:27
Re: inheritance, and plans Grzegorz Jaśkiewicz 10:59
Re: inheritance, and plans Grzegorz Jaśkiewicz 11:03
Re: explanation of some configs justin 15:40
Re: explanation of some configs Robert Haas 16:36
Re: inheritance, and plans Grzegorz Jaśkiewicz 17:23
Re: inheritance, and plans Tom Lane 17:39
Re: inheritance, and plans Grzegorz Jaśkiewicz 17:43
Re: inheritance, and plans Grzegorz Jaśkiewicz 17:52
Re: inheritance, and plans Andrew Gierth 17:58

Feb. 8, 2009

Thread Author Time
Re: inheritance, and plans Tom Lane 18:34
Re: inheritance, and plans Andrew Gierth 18:58
Re: inheritance, and plans Grzegorz Jaśkiewicz 19:37

Feb. 9, 2009

Thread Author Time
Re: Postgres not willing to use an index? Mario Splivalo 09:28
Re: Postgres not willing to use an index? Mario Splivalo 09:40
Re: Postgres not willing to use an index? Mario Splivalo 10:07
Re: explanation of some configs Matthew Wakeling 10:30
Re: explanation of some configs justin 15:44
Re: explanation of some configs Robert Haas 17:38

Feb. 10, 2009

Thread Author Time
query slow only after reboot Wei Yan 01:21
Re: query slow only after reboot Steve Crawford 01:35
Re: query slow only after reboot Scott Carey 02:20
query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah 10:31
Re: explanation of some configs Matthew Wakeling 12:09
ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521. Rohan Pethkar 12:46
Re: query becomes fas on 'SET enable_hashjoin TO off;' Robert Haas 13:06
Re: query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah 14:29
Re: ERROR: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Test/Parser/Dbt2.pm line 521. Rajesh Kumar Mallah 14:36
Re: query slow only after reboot Kevin Grittner 15:00
Re: query becomes fas on 'SET enable_hashjoin TO off;' Tom Lane 15:39
Re: query becomes fas on 'SET enable_hashjoin TO off;' Rajesh Kumar Mallah 15:52
Re: explanation of some configs 📎 justin 18:07
Re: explanation of some configs Greg Smith 19:45
Re: explanation of some configs justin 20:23
Re: explanation of some configs Greg Smith 20:37
Re: explanation of some configs justin 21:01
View performance degraded between 8.1 and 8.3 Mark Roghelia 22:20

Feb. 11, 2009

Thread Author Time
Re: View performance degraded between 8.1 and 8.3 Tom Lane 00:37
please help with the explain analyze plan Rajesh Kumar Mallah 10:58
Re: please help with the explain analyze plan Glyn Astill 11:55
Re: please help with the explain analyze plan Rajesh Kumar Mallah 12:37
Re: please help with the explain analyze plan Rajesh Kumar Mallah 12:53
scheduling autovacuum at lean hours only. Rajesh Kumar Mallah 12:55
Re: scheduling autovacuum at lean hours only. Guillaume Cottenceau 13:41
Re: scheduling autovacuum at lean hours only. Glyn Astill 13:54
Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah 14:57
Re: scheduling autovacuum at lean hours only. Alvaro Herrera 16:21
Re: scheduling autovacuum at lean hours only. Grzegorz Jaśkiewicz 16:33
Re: scheduling autovacuum at lean hours only. Ben 16:46
Re: scheduling autovacuum at lean hours only. Scott Carey 17:23
Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah 17:27
Re: scheduling autovacuum at lean hours only. Ben Chobot 17:57
Re: scheduling autovacuum at lean hours only. Brad Nicholson 18:00
Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah 18:16

Feb. 12, 2009

Thread Author Time
Re: scheduling autovacuum at lean hours only. Guillaume Cottenceau 08:23
col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' milos d 11:50
Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' Richard Huxton 12:04
Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' Scott Carey 19:50
GIST versus GIN indexes for intarrays Rusty Conover 20:09
Re: GIST versus GIN indexes for intarrays Tom Lane 20:54
Re: GIST versus GIN indexes for intarrays Rusty Conover 21:05
Re: [PERFORM] GIST versus GIN indexes for intarrays Tom Lane 21:29
Re: col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%' milos d 23:49

Feb. 13, 2009

Thread Author Time
Re: GIST versus GIN indexes for intarrays Rusty Conover 01:32
I/O increase after upgrading to 8.3.5 Alexander Staubo 11:53
Re: [PERFORM] GIST versus GIN indexes for intarrays Teodor Sigaev 13:12
dissimilar drives in Raid10 , does it make difference ? Rajesh Kumar Mallah 13:30
Re: [PERFORM] GIST versus GIN indexes for intarrays Kenneth Marshall 14:04
Re: dissimilar drives in Raid10 , does it make difference ? Matthew Wakeling 14:45
Re: I/O increase after upgrading to 8.3.5 Kevin Grittner 14:46
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 15:58
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 16:04
Re: I/O increase after upgrading to 8.3.5 Kevin Grittner 16:17
Re: I/O increase after upgrading to 8.3.5 📎 Alexander Staubo 16:31
Re: [PERFORM] GIST versus GIN indexes for intarrays Tom Lane 17:20
Re: I/O increase after upgrading to 8.3.5 Kevin Grittner 17:35
Re: scheduling autovacuum at lean hours only. Chris Browne 17:37

Feb. 14, 2009

Thread Author Time
Re: dissimilar drives in Raid10 , does it make difference ? Craig Ringer 08:46
Re: I/O increase after upgrading to 8.3.5 Craig Ringer 08:49
Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah 11:58
Retrieving data from PostgreSQL to .NET application – performance test – surprising results Peter G. 16:11
Slow queries from information schema Octavio Alvarez 18:13
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 18:26
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 18:27
Re: I/O increase after upgrading to 8.3.5 Tom Lane 19:23
Re: Slow queries from information schema Tom Lane 20:02
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 20:04
Re: Slow queries from information schema Octavio Alvarez 20:15
Bad plan for nested loop + limit Alexander Staubo 22:25

Feb. 15, 2009

Thread Author Time
Re: Bad plan for nested loop + limit David Wilson 04:29
Re: Bad plan for nested loop + limit Alexander Staubo 16:45
Re: I/O increase after upgrading to 8.3.5 Greg Smith 17:35
Re: I/O increase after upgrading to 8.3.5 Greg Smith 17:38

Feb. 16, 2009

Thread Author Time
Partial index usage Laszlo Nagy 08:54
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gregory Stark 13:31
Re: I/O increase after upgrading to 8.3.5 Alexander Staubo 14:59
Re: Partial index usage Craig Ringer 15:07
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah 20:34
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah 20:36

Feb. 17, 2009

Thread Author Time
TCP network cost Ross J. Reedstrom 07:04
Re: TCP network cost Rusty Conover 07:20
Re: TCP network cost david 08:34
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matthew Wakeling 11:45
Query composite index range in an efficient way Havasvölgyi Ottó 12:44
Re: Query composite index range in an efficient way Matthew Wakeling 12:56
Re: Query composite index range in an efficient way Gregory Stark 13:10
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah 13:25
Cannot interpret EXPLAIN Jörg Kiegeland 14:33
Re: Query composite index range in an efficient way Tom Lane 15:53
Re: Query composite index range in an efficient way Kevin Grittner 16:16
Call of function inside trigger much slower than explicit function call Alexander Gorban 16:17
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey 16:19
Re: Call of function inside trigger much slower than explicit function call Robert Haas 17:24
Re: Call of function inside trigger much slower than explicit function call Alexander Gorban 17:46
Re: TCP network cost Aaron Turner 18:13
Re: Query composite index range in an efficient way Havasvölgyi Ottó 18:55
Re: Call of function inside trigger much slower than explicit function call Robert Haas 19:31

Browse Archives

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