Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CAAA36516CC for ; Mon, 23 Jun 2008 10:36:37 -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 96211-01 for ; Mon, 23 Jun 2008 10:36:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from wizmail.org (wizmail.org [217.146.104.199]) by postgresql.org (Postfix) with ESMTP id 0DC7665153B for ; Mon, 23 Jun 2008 10:36:34 -0300 (ADT) Received: from ebony.jgh.adsl.wizards.co.uk ([217.146.123.59]) (from_AS 16353) by wizmail.org with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.67) id 1KAmDg-0000bA-1i for pgsql-performance@postgresql.org (return-path ); Mon, 23 Jun 2008 13:36:32 +0000 Message-ID: <485FA6DC.9090204@wizmail.org> Date: Mon, 23 Jun 2008 14:36:28 +0100 From: Jeremy Harris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.14) Gecko/20080501 Fedora/2.0.0.14-1.fc7 Thunderbird/2.0.0.14 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Postgresql is very slow References: <306870.66258.qm@web32707.mail.mud.yahoo.com> In-Reply-To: <306870.66258.qm@web32707.mail.mud.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/105 X-Sequence-Number: 30455 bijayant kumar wrote: > select * from tablename takes 10-15 mins to give the output There are better ways to dump data than using a database; that's not a useful query. > Any query select,insert,update simple or complex behaves in the same way Have you set up suitable indexes for your operations (and then run analyze)? Cheers, Jeremy