Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 016B46515EF for ; Mon, 23 Jun 2008 08:06:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58276-02 for ; Mon, 23 Jun 2008 08:06:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web32707.mail.mud.yahoo.com (web32707.mail.mud.yahoo.com [68.142.207.251]) by postgresql.org (Postfix) with SMTP id BD3886514DA for ; Mon, 23 Jun 2008 08:06:55 -0300 (ADT) Received: (qmail 66385 invoked by uid 60001); 23 Jun 2008 11:06:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=pxVlUoe7qMQxdq45fIZ+4Fv/x90zS6IzC/ehAhOAEqxUqeYfAkxrx/BO11hL35EmN5StOzyAbNZ+G3PiSiXLVtkPVruJ4z3T0yFv1+4j2yGeJNRiaiO29QqZQ5D5WA+5PL4bWg0YUA8mQmLOo+8ioR5NUBGyO2otO5qHSh96MnE=; Received: from [122.167.177.148] by web32707.mail.mud.yahoo.com via HTTP; Mon, 23 Jun 2008 04:06:54 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Mon, 23 Jun 2008 04:06:54 -0700 (PDT) From: bijayant kumar Reply-To: bijayant4u@yahoo.com Subject: Postgresql is very slow To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Message-ID: <306870.66258.qm@web32707.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/103 X-Sequence-Number: 30453 Hello to list, We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling = with postgresql performance. Any query say select * from tablename takes 10= -15 mins to give the output, and while executing the query system loads goe= s up like anything. After the query output, system loads starts decresing. Any query select,insert,update simple or complex behaves in the same way, w= hat i have explained above. System Specification: OS :- CentOs 5 Postgresql 8.1.8 RAM :- 1 GB SWAP 2 GB Some relevent part(uncommented) of my /var/lib/pgsql/data/postgresql.conf listen_addresses =3D 'localhost' max_connections =3D 100 shared_buffers =3D 1000 The one more strange thing is that with the same setting on another server,= postgresql is running very smooth. I had run vacum also some times back. Please help me out and let me know if you need any other information. Thanks & Regards, Bijayant Kumar=0A=0ASend instant messages to your online friends http://uk.= messenger.yahoo.com