X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3CF9E476988 for ; Fri, 16 May 2003 04:47:11 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 14527-10 for ; Fri, 16 May 2003 04:47:06 -0400 (EDT) Received: from uucp3.netcore.co.in (unknown [202.162.229.13]) by postgresql.org (Postfix) with ESMTP id B9532475F0D for ; Fri, 16 May 2003 04:47:05 -0400 (EDT) Received: from uucp1.netcore.co.in (unknown [202.162.229.12]) by uucp3.netcore.co.in (Postfix) with ESMTP id E7046142EA for ; Fri, 16 May 2003 14:16:22 +0530 (IST) Received: (from uucp@localhost) by uucp1.netcore.co.in (8.11.0/8.8.7) with UUCP id h4G8vu313432 for pgsql-admin@postgresql.org; Fri, 16 May 2003 14:27:56 +0530 Received: (from root@localhost) by netserv.ho.acplexports.com (8.11.6/8.11.2) id h4G8lCu26292; Fri, 16 May 2003 14:17:12 +0530 Received: from devserver ([192.168.1.221]) by netserv.ho.acplexports.com (8.11.6/8.11.2) with SMTP id h4G8lCa26285 for ; Fri, 16 May 2003 14:17:12 +0530 Message-ID: <012001c31b86$e216ab90$dd01a8c0@devserver> From: "Hargobind Singh" To: Subject: Performance. Date: Fri, 16 May 2003 14:10:43 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xmilter: ho.acplexports.com X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/233 X-Sequence-Number: 8795 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 --------------------------