Skip site navigation
(1)
Skip section navigation
(2)
Search
Peripheral Links
Text Size:
Normal
/
Large
Donate
Contact
Home
About
Download
Documentation
Community
Developers
Support
Your account
Community
Contributors
Mailing Lists
User lists
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-bugs
pgsql-docs
pgsql-general
pgsql-interfaces
pgsql-jobs
pgsql-novice
pgsql-performance
pgsql-php
pgsql-sql
pgsql-students
Developer lists
Regional lists
Associations
User groups
Project lists
Inactive lists
IRC
Featured Users
International Sites
Propaganda
Resources
Weekly News
pgsql-performance - February 2009
Search archives
(enter a message-id to go directly to that message)
Advanced Search
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