Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - February 2009

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

2009-02-02

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)

2009-02-03

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)

2009-02-04

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)

2009-02-05

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)

2009-02-06

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)

2009-02-07

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)

2009-02-08

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)

2009-02-09

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)

2009-02-10

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)

2009-02-11

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)

2009-02-12

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)

2009-02-13

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)

2009-02-14

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 ?==?windows-1252?Q?– 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)

2009-02-15

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)

2009-02-16

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)

2009-02-17

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)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group