Performance.

I have a linux box P4 1.7, 512 RAM, 40GB HDD with 1.2 GB swap partition,
total 20GB free on the hard disk. RedHat 8.0 with GNome installed, and
Postgres 7.2 installed.

The performance of Postgres is very very poor. I have this table with 19
fields, a primary key, and i have indexed it as well. A single select query
on that filters a  single field takes 9 seconds to execute. THe table has
1,40,000 records.

Any place where i can find OPTIMIZATION of PostGres ??

Thanx..

Hargobind Singh
--------------------------