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 - November 2004

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 29 30

2004-11-01

Re: Speeding up Gist Index creations Josh Berkus (00:01)
Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Gaetano Mendola (01:11)
Re: Thanks Chariot Solutions D'Arcy J.M. Cain (12:59)
Re: psql large RSS (1.6GB) Gavin Sherry (13:45)
Re: psql large RSS (1.6GB) Bruce Momjian (14:04)
Re: psql large RSS (1.6GB) Tom Lane (16:03)
shared_buffers and Shared Memory Segments Anjan Dave (17:37)
Re: psql large RSS (1.6GB) Josh Berkus (18:49)
Performance difference when using views Alvaro Nunes Melo (21:40)
Re: [PERFORM] [PATCHES] ARC Memory Usage analysis Simon Riggs (22:03)
Re: Performance difference when using views Tom Lane (22:08)
Re: Performance difference when using views Simon Riggs (22:28)

2004-11-02

Re: Speeding up Gist Index creations Neil Conway (01:35)
Re: Speeding up Gist Index creations Josh Berkus (05:58)
Restricting Postgres Martin Foster (23:52)

2004-11-03

Re: Restricting Postgres Andrew Sullivan (14:17)
preloading indexes stuff (17:30)
Re: preloading indexes Matt Clark (17:59)
vacuum analyze slows sql query patrick ~ (18:56)
Re: preloading indexes stuff (19:12)
Re: vacuum analyze slows sql query Doug Y (19:17)
Re: Restricting Postgres Simon Riggs (19:21)
Re: preloading indexes Andrew Sullivan (19:35)
Re: preloading indexes Pierre-Frédéric Caillaud (19:50)
Re: preloading indexes Tom Lane (19:55)
Re: vacuum analyze slows sql query Tom Lane (20:12)
Re: preloading indexes stuff (20:19)
Re: preloading indexes Tom Lane (20:53)
Re: preloading indexes Andrew Sullivan (20:53)
Re: preloading indexes stuff (20:56)
Re: Restricting Postgres Martin Foster (21:25)
Re: vacuum analyze slows sql query patrick ~ (22:22)
Re: Restricting Postgres John A Meinel (23:25)
Re: Restricting Postgres Martin Foster (23:35)

2004-11-04

Re: preloading indexes Mike Benoit (00:50)
index not used if using IN or OR Mario Ivankovits (07:55)
Re: Restricting Postgres Matt Clark (08:29)
Re: index not used if using IN or OR Richard Huxton (08:32)
Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber (11:00)
Re: Restricting Postgres Simon Riggs (12:19)
Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud (12:29)
Re: Restricting Postgres Martin Foster (13:10)
Re: Restricting Postgres Martin Foster (13:17)
Re: preloading indexes Andrew Sullivan (14:02)
Re: index not used if using IN or OR Tom Lane (14:52)
Re: Anything to be gained from a 'Postgres Filesystem'? Chris Browne (15:47)
Re: [PERFORM] Restricting Postgres Kevin Barnard (16:00)
Re: Restricting Postgres Martin Foster (16:15)
Re: Restricting Postgres Matt Clark (16:33)
Re: Restricting Postgres Matthew Nuzum (16:37)
Re: Restricting Postgres Matt Clark (16:46)
Re: Restricting Postgres Pierre-Frédéric Caillaud (17:25)
Re: Restricting Postgres Martin Foster (17:59)
Re: Restricting Postgres Martin Foster (18:04)
Re: Restricting Postgres Matt Clark (18:20)
Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs (19:03)
Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson (19:20)
Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane (19:34)
Re: Restricting Postgres Martin Foster (20:30)
Re: Restricting Postgres Pierre-Frédéric Caillaud (20:30)
Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs (20:40)
Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane (20:45)
Re: Restricting Postgres Steinar H. Gunderson (20:46)
Re: Restricting Postgres Matt Clark (21:00)
Re: Restricting Postgres Matt Clark (21:01)
Better Hardware, worst Results Alvaro Nunes Melo (21:06)
Re: Better Hardware, worst Results Rod Taylor (21:16)
Re: Better Hardware, worst Results Tom Lane (21:46)
Re: Restricting Postgres Pierre-Frédéric Caillaud (22:00)
appropriate indexing T E Schmitz (22:32)
Re: Restricting Postgres Matt Clark (22:37)
Re: appropriate indexing Matt Clark (22:38)
Re: Better Hardware, worst Results al_nunes (22:42)
Re: Better Hardware, worst Results Rod Taylor (22:58)
Re: Better Hardware, worst Results Matt Clark (22:58)
Re: Better Hardware, worst Results Matt Clark (23:08)
Re: Restricting Postgres Bruno Wolff III (23:14)
Re: Restricting Postgres Pierre-Frédéric Caillaud (23:21)
Re: Restricting Postgres Matt Clark (23:22)
Re: Restricting Postgres Matt Clark (23:32)
Re: Restricting Postgres Matt Clark (23:35)

2004-11-05

Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (02:05)
Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne (02:29)
Re: Restricting Postgres Martin Foster (02:49)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:28)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:33)
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway (04:35)
Re: Restricting Postgres Bruno Wolff III (05:16)
Checking = with timestamp field is slow Antony Paul (07:16)
Re: Checking = with timestamp field is slow Michael Glaesemann (08:14)
Re: Checking = with timestamp field is slow Michael Glaesemann (08:32)
Re: Checking = with timestamp field is slow Michael Fuhr (08:34)
Re: Restricting Postgres Leeuw van der, Tim (08:48)
Re: Checking = with timestamp field is slow Andrew McMillan (08:48)
Re: Checking = with timestamp field is slow Michael Fuhr (09:13)
Re: Checking = with timestamp field is slow Christopher Browne (12:47)
Strange (?) Index behavior? Allen Landsidel (14:39)
Re: Strange (?) Index behavior? Matt Clark (15:06)
Re: Strange (?) Index behavior? Rod Taylor (15:07)
Re: Strange (?) Index behavior? Allen Landsidel (15:32)
postgresql amd-64 Merlin Moncure (15:33)
Re: Strange (?) Index behavior? Allen Landsidel (16:54)
Re: Checking = with timestamp field is slow Michael Fuhr (17:45)
Re: Strange (?) Index behavior? Bruno Wolff III (17:51)
Re: Strange (?) Index behavior? Allen Landsidel (17:56)
What is the difference between these? Matt Nuzum (18:09)
Re: postgresql amd-64 Daniel Ceregatti (18:23)
Re: vacuum analyze slows sql query patrick ~ (18:26)
Re: Strange (?) Index behavior? Matt Clark (18:34)
Re: What is the difference between these? Matthew T. O'Connor (19:44)
Re: Strange (?) Index behavior? Tom Lane (19:57)
Re: What is the difference between these? Tom Lane (20:32)
Re: Strange (?) Index behavior? Allen Landsidel (20:36)
Question regarding the file system Gabriele Bartolini (21:00)
Re: Strange (?) Index behavior? Allen Landsidel (21:02)
Re: Strange (?) Index behavior? Tom Lane (21:08)
Re: postgresql amd-64 Merlin Moncure (21:17)
Re: Strange (?) Index behavior? Allen Landsidel (22:40)
ia64 results with dbt2 and 8.0beta4 Mark Wong (23:13)

2004-11-06

Re: Strange (?) Index behavior? Matt Clark (00:14)
Re: vacuum analyze slows sql query patrick ~ (00:26)
Re: postgresql amd-64 Vishal Kashyap @ [Sai Hertz And Control Systems] (03:01)
Re: Strange (?) Index behavior? Tom Lane (04:04)
Re: vacuum analyze slows sql query Tom Lane (04:06)
Re: vacuum analyze slows sql query patrick ~ (06:18)
Re: vacuum analyze slows sql query Tom Lane (06:38)
Re: Strange (?) Index behavior? Allen Landsidel (07:27)
poor performance in migrated database Carlos Lopez (19:52)
Re: poor performance in migrated database Troels Arvin (20:07)
Re: poor performance in migrated database Troels Arvin (20:26)
Re: [PERFORM] poor performance in migrated database Simon Riggs (21:39)
Re: [PERFORM] poor performance in migrated database Scott Marlowe (23:00)

2004-11-07

DISTINCT and GROUP BY: possible performance enhancement? Ang Chin Han (11:04)

2004-11-08

Re: postgresql amd-64 Iain (02:13)
Re: postgresql amd-64 Iain (07:36)
Postgresql is using seqscan when is should use indexes. Andreas Åkre Solberg (10:40)
Re: postgresql amd-64 Radu-Adrian Popescu (11:40)
Re: Better Hardware, worst Results Alvaro Nunes Melo (11:46)
Re: Postgresql is using seqscan when is should use indexes. Russell Smith (12:04)
ext3 journalling type Dawid Kuroczko (12:26)
Re: postgresql amd-64 Merlin Moncure (13:20)
Re: ext3 journalling type Bruce Momjian (14:04)
Re: ext3 journalling type Matt Clark (15:14)
Re: ext3 journalling type Mark Wong (16:29)
Re: ext3 journalling type Josh Berkus (17:38)
Re: Question regarding the file system Josh Berkus (17:44)
Re: vacuum analyze slows sql query patrick ~ (18:57)
Re: vacuum analyze slows sql query John Meinel (19:29)
Re: [PERFORM] poor performance in migrated database Carlos Lopez (21:28)
Re: vacuum analyze slows sql query patrick ~ (23:19)
Re: [PERFORM] poor performance in migrated database Tom Lane (23:57)

2004-11-09

Re: vacuum analyze slows sql query John Meinel (00:01)
Re: vacuum analyze slows sql query Pierre-Frédéric Caillaud (00:04)
Slow performance with Group By Erik Norvelle (00:09)
Re: vacuum analyze slows sql query John Meinel (00:31)
Re: Slow performance with Group By Tom Lane (00:56)
Re: Question regarding the file system Josh Berkus (01:31)
Re: [PERFORM] poor performance in migrated database Carlos Lopez (14:56)
Need advice on postgresql.conf settings Shane | SkinnyCorp (19:01)
Re: vacuum analyze slows sql query patrick ~ (19:26)
Re: Need advice on postgresql.conf settings Tom Lane (21:56)
seqscan strikes again Jim C. Nasby (22:23)
Re: Need advice on postgresql.conf settings Sean Chittenden (22:44)
Re: seqscan strikes again Joshua D. Drake (23:14)
Re: seqscan strikes again Tom Lane (23:24)

2004-11-10

simple select-statement takes more than 25 sec Cao Duy (09:35)
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (10:17)
Re: simple select-statement takes more than 25 sec gnari (10:31)
Re: simple select-statement takes more than 25 sec Cao Duy (11:22)
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson (11:45)
Re: Need advice on postgresql.conf settings Jeff (13:04)
How to speed-up inserts with jdbc Michael Kleiser (13:51)
Re: How to speed-up inserts with jdbc Jeff (13:55)
Re: How to speed-up inserts with jdbc Dave Cramer (14:05)
Re: How to speed-up inserts with jdbc Leeuw van der, Tim (14:26)
Tuning suggestions wanted Rod Taylor (16:52)
Re: seqscan strikes again Jim C. Nasby (17:00)
Solaris 9 Tuning Tips requested Rod Taylor (17:04)
int4 in a GiST index Mike Rylander (21:51)

2004-11-11

Re: int4 in a GiST index George Essig (02:50)
Re: int4 in a GiST index Mike Rylander (05:53)
Re: seqscan strikes again Gaetano Mendola (07:58)
Re: vacuum analyze slows sql query Gaetano Mendola (08:03)
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (08:04)
Re: How to speed-up inserts with jdbc Steinar H. Gunderson (10:04)
Re: Strange (?) Index behavior? Allen Landsidel (16:21)
Re: Strange (?) Index behavior? Josh Berkus (18:52)
Re: Strange (?) Index behavior? Allen Landsidel (19:30)
Re: Strange (?) Index behavior? Greg Stark (20:49)
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas (21:10)
Re: Strange (?) Index behavior? Allen Landsidel (21:12)
Re: Strange (?) Index behavior? Tom Lane (21:41)
Re: Strange (?) Index behavior? Joshua D. Drake (21:48)

2004-11-12

Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (18:42)
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (19:20)
Re: Strange (?) Index behavior? Allen Landsidel (20:12)
Re: Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus (21:11)
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane (21:19)
Re: Strange (?) Index behavior? Tom Lane (22:35)

2004-11-13

Re: Strange (?) Index behavior? Allen Landsidel (00:26)

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 29 30

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