Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2004-11 Chronological Index (2/3)
Last updated: Wed Jan 18 04:21:21 2012
422 messages
16 November 2004
Re: Tsearch2 really slower than ilike ? Oleg Bartunov (21:13)
nuderstanding 'explain analyse' Alexandre Leclerc (21:11)
Re: mis-estimation on data-warehouse aggregate creation Kris Jurka (19:49)
Re: Insertion puzzles J. Andrew Rogers (19:43)
Re: Tsearch2 really slower than ilike ? Oleg Bartunov (16:27)
Re: Tsearch2 really slower than ilike ? Hervé Piedvache (16:21)
Re: Tsearch2 really slower than ilike ? Oleg Bartunov (16:18)
Re: Tsearch2 really slower than ilike ? Joshua D. Drake (16:07)
Re: Tsearch2 really slower than ilike ? Joshua D. Drake (16:05)
Efficient way to remove OID data James Gunzelman (15:58)
Re: Tsearch2 really slower than ilike ? Hervé Piedvache (15:48)
Re: Tsearch2 really slower than ilike ? Michael Fuhr (15:33)
Tsearch2 really slower than ilike ? Hervé Piedvache (14:56)
Re: mis-estimation on data-warehouse aggregate creation F. Senault (10:56)
mis-estimation on data-warehouse aggregate creation Kris Jurka (09:09)
15 November 2004
Performance difference: SELECT from VIEW or not? Alexandre Leclerc (23:10)
Re: Strange (?) Index behavior? Allen Landsidel (22:22)
Why distinct so slow ? Hervé Piedvache (21:23)
Re: Question on pgsql optimisation of SQL and structure (index, etc) Josh Berkus (21:01)
Question on pgsql optimisation of SQL and structure (index, etc) Alexandre Leclerc (17:48)
Re: Large Database Performance suggestions Andrew Hammond (15:23)
Re: Some quick Opteron 32-bit/64-bit results William Yu (07:55)
Re: Some quick Opteron 32-bit/64-bit results Greg Stark (07:04)
Re: Insertion puzzles Dave Cramer (00:44)
14 November 2004
Re: Insertion puzzles Josh Berkus (01:37)
Re: Some quick Opteron 32-bit/64-bit results William Yu (00:54)
Re: Some quick Opteron 32-bit/64-bit results William Yu (00:24)
Re: Some quick Opteron 32-bit/64-bit results Gustavo Franklin Nóbrega (00:14)
13 November 2004
Re: Insertion puzzles Stephan Szabo (17:13)
Re: Insertion puzzles Dave Cramer (16:53)
Re: Insertion puzzles Andreas Åkre Solberg (13:31)
Insertion puzzles vivek singh (11:26)
Re: Strange (?) Index behavior? Allen Landsidel (03:02)
12 November 2004
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (21:19)
Re: Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (21:08)
Re: Strange (?) Index behavior? Allen Landsidel (20:12)
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (19:20)
Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (18:39)
11 November 2004
Re: Strange (?) Index behavior? Tom Lane (21:42)
Re: Strange (?) Index behavior? Allen Landsidel (21:13)
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (21:11)
Re: Strange (?) Index behavior? Greg Stark (20:49)
Re: Strange (?) Index behavior? Allen Landsidel (19:31)
Re: Strange (?) Index behavior? Josh Berkus (18:50)
Re: Strange (?) Index behavior? Allen Landsidel (17:56)
Re: vacuum analyze slows sql query Gaetano Mendola (17:06)
Re: seqscan strikes again Gaetano Mendola (17:06)
Re: How to speed-up inserts with jdbc Steinar H. Gunderson (17:06)
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (08:04)
Re: int4 in a GiST index Mike Rylander (05:53)
Re: int4 in a GiST index George Essig (02:50)
10 November 2004
Solaris 9 Tuning Tips requested Rod Taylor (17:06)
Re: seqscan strikes again Jim C. Nasby (17:01)
Tuning suggestions wanted Rod Taylor (16:54)
Re: How to speed-up inserts with jdbc Leeuw van der, Tim (14:27)
Re: How to speed-up inserts with jdbc Dave Cramer (14:04)
Re: How to speed-up inserts with jdbc Jeff (13:55)
How to speed-up inserts with jdbc Michael Kleiser (13:52)
Re: Need advice on postgresql.conf settings Jeff (13:04)
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (11:45)
Re: simple select-statement takes more than 25 sec Cao Duy (11:22)
Re: simple select-statement takes more than 25 sec gnari (10:29)
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (10:17)
simple select-statement takes more than 25 sec Cao Duy (09:36)
09 November 2004
Re: seqscan strikes again Joshua D. Drake (23:14)
seqscan strikes again Jim C. Nasby (22:52)
Re: Need advice on postgresql.conf settings Sean Chittenden (22:44)
Re: Need advice on postgresql.conf settings Tom Lane (21:57)
Re: vacuum analyze slows sql query patrick ~ (19:26)
Need advice on postgresql.conf settings Shane | SkinnyCorp (19:01)
Re: [ADMIN] poor performance in migrated database Carlos Lopez (14:56)
Re: Question regarding the file system Josh Berkus (01:28)
Re: Slow performance with Group By Tom Lane (00:56)
Re: vacuum analyze slows sql query John Meinel (00:32)
Slow performance with Group By Erik Norvelle (00:10)
Re: vacuum analyze slows sql query Pierre-Frédéric Caillaud (00:03)
Re: vacuum analyze slows sql query John Meinel (00:01)
08 November 2004
Re: vacuum analyze slows sql query patrick ~ (23:20)
Re: [ADMIN] poor performance in migrated database Carlos Lopez (21:28)
Re: vacuum analyze slows sql query John Meinel (19:30)
Re: vacuum analyze slows sql query patrick ~ (18:57)
Re: Question regarding the file system Josh Berkus (17:45)
Re: ext3 journalling type Josh Berkus (17:39)
Re: ext3 journalling type Mark Wong (16:30)
Re: ext3 journalling type Matt Clark (15:14)
Re: ext3 journalling type Bruce Momjian (14:05)
Re: postgresql amd-64 Merlin Moncure (13:20)
ext3 journalling type Dawid Kuroczko (12:26)
Re: Postgresql is using seqscan when is should use indexes. Russell Smith (12:07)
Re: Better Hardware, worst Results Alvaro Nunes Melo (11:46)
Re: postgresql amd-64 Radu-Adrian Popescu (11:40)
Postgresql is using seqscan when is should use indexes. Andreas Åkre Solberg (10:40)
Re: postgresql amd-64 Iain (07:36)
Re: postgresql amd-64 Iain (02:12)
07 November 2004
06 November 2004
Re: poor performance in migrated database Simon Riggs (21:41)
Re: poor performance in migrated database Troels Arvin (20:41)
Re: poor performance in migrated database Troels Arvin (20:07)
poor performance in migrated database Carlos Lopez (19:52)
Re: Strange (?) Index behavior? Allen Landsidel (07:27)
Re: vacuum analyze slows sql query Tom Lane (06:39)
Re: vacuum analyze slows sql query patrick ~ (06:18)
Re: vacuum analyze slows sql query Tom Lane (04:07)
Re: Strange (?) Index behavior? Tom Lane (04:04)
Re: postgresql amd-64 Vishal Kashyap @ [Sai Hertz And Control Systems] (03:02)
Re: vacuum analyze slows sql query patrick ~ (00:26)
Re: Strange (?) Index behavior? Matt Clark (00:14)
05 November 2004
Re: Strange (?) Index behavior? Allen Landsidel (22:40)
Re: postgresql amd-64 Merlin Moncure (21:17)
Re: Strange (?) Index behavior? Tom Lane (21:09)
Re: Strange (?) Index behavior? Allen Landsidel (21:02)
Question regarding the file system Gabriele Bartolini (21:00)
Re: Strange (?) Index behavior? Allen Landsidel (20:36)
Re: What is the difference between these? Tom Lane (20:32)
Re: Strange (?) Index behavior? Tom Lane (19:57)
Re: What is the difference between these? Matthew T. O'Connor (19:44)
Re: Strange (?) Index behavior? Matt Clark (18:34)
Re: vacuum analyze slows sql query patrick ~ (18:26)
Re: postgresql amd-64 Daniel Ceregatti (18:23)
What is the difference between these? Matt Nuzum (18:09)
Re: Strange (?) Index behavior? Allen Landsidel (17:56)
Re: Checking = with timestamp field is slow Michael Fuhr (17:45)
Re: Strange (?) Index behavior? Bruno Wolff III (17:40)
Re: Strange (?) Index behavior? Allen Landsidel (16:54)
postgresql amd-64 Merlin Moncure (15:34)
Re: Strange (?) Index behavior? Allen Landsidel (15:32)
Re: Strange (?) Index behavior? Rod Taylor (15:09)
Re: Strange (?) Index behavior? Matt Clark (15:06)
Strange (?) Index behavior? Allen Landsidel (14:39)
Re: Checking = with timestamp field is slow Christopher Browne (12:54)
Re: Checking = with timestamp field is slow Michael Fuhr (09:13)
Re: Checking = with timestamp field is slow Andrew McMillan (08:49)
Re: Restricting Postgres Leeuw van der, Tim (08:48)
Re: Checking = with timestamp field is slow Michael Fuhr (08:34)
Re: Checking = with timestamp field is slow Michael Glaesemann (08:33)
Re: Checking = with timestamp field is slow Michael Glaesemann (08:14)
Checking = with timestamp field is slow Antony Paul (07:16)
Re: Restricting Postgres Bruno Wolff III (05:05)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:35)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:34)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:29)
Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (02:53)
Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (02:53)
Re: Restricting Postgres Martin Foster (02:53)
04 November 2004
Re: Restricting Postgres Matt Clark (23:33)
Re: Restricting Postgres Matt Clark (23:22)
Re: Restricting Postgres Pierre-Frédéric Caillaud (23:21)
Re: Better Hardware, worst Results Matt Clark (23:09)
Re: Restricting Postgres Bruno Wolff III (23:03)
Re: Better Hardware, worst Results Rod Taylor (23:00)
Re: Better Hardware, worst Results Matt Clark (22:58)
Re: Better Hardware, worst Results al_nunes (22:42)
Re: appropriate indexing Matt Clark (22:41)
Re: Restricting Postgres Matt Clark (22:39)
appropriate indexing T E Schmitz (22:33)
Re: Restricting Postgres Pierre-Frédéric Caillaud (22:00)
Re: Better Hardware, worst Results Tom Lane (21:46)
Re: Better Hardware, worst Results Rod Taylor (21:18)
Better Hardware, worst Results Alvaro Nunes Melo (21:06)
Re: Restricting Postgres Matt Clark (21:03)