Performance.

From: "Hargobind Singh" <hgs(at)acplexports(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Performance.
Date: 2003-05-16 08:40:43
Message-ID: 012001c31b86$e216ab90$dd01a8c0@devserver
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message matt 2003-05-16 12:43:59 Re: Performance.
Previous Message Raquel Vieira 2003-05-16 08:12:32 Re: Postgresql suddenly shutdown. Please help