agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Hargobind Singh <hgs@acplexports.com>
To: pgsql-admin@postgresql.org
Subject: Performance.
Date: Fri, 16 May 2003 14:10:43 +0530
Message-ID: <012001c31b86$e216ab90$dd01a8c0@devserver> (raw)

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

view thread (16+ messages)  latest in thread

Message-ID: <012001c31b86$e216ab90$dd01a8c0@devserver>
Permalink:  ../012001c31b86$e216ab90$dd01a8c0@devserver/
Also on:    postgresql.org/message-id/012001c31b86$e216ab90$dd01a8c0@devserver

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: hgs@acplexports.com
  Subject: Re: Performance.
  In-Reply-To: <012001c31b86$e216ab90$dd01a8c0@devserver>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox