X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C1B839FB278 for ; Tue, 8 Aug 2006 09:24:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 70756-04 for ; Tue, 8 Aug 2006 09:24:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from MVGTREND2.mvg.local (unknown [217.33.193.205]) by postgresql.org (Postfix) with ESMTP id 8E17B9FB24E for ; Tue, 8 Aug 2006 09:24:53 -0300 (ADT) Received: from MVGMAIL.mvg.local ([10.100.2.6]) by MVGTREND2.mvg.local with InterScan Message Security Suite; Tue, 08 Aug 2006 13:25:47 +0100 Content-class: urn:content-classes:message Subject: Query response time MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Date: Tue, 8 Aug 2006 13:25:47 +0100 Message-ID: <746457F7E51F3B4BB53A8447D7204B78E456@MVGMAIL.mvg.local> X-MimeOLE: Produced By Microsoft Exchange V6.5 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Query response time thread-index: Aca65ca6B9TwJt0zTWqPoNoPs71RZw== From: "Jonathan Sinclair" To: X-imss-version: 2.041 X-imss-result: Passed X-imss-scanInfo: M:P L:E SM:0 X-imss-tmaseResult: TT:0 TS:0.0000 TC:00 TRN:0 TV:3.52.1006(14616.002) X-imss-scores: Clean:25.55460 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:2 C:1 M:1 S:1 R:1 (0.1500 0.1500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/47 X-Sequence-Number: 26005 Hi all, I am using PostgresSQL 7.4 and having some serious performance issues. Trawling through the archives and previous posts the only visible advice I could see was either by running vacuum or setting the fsynch flag to false.=0D I am using tables that only contain approx 2GB of data. However performing a number of simple conditional select statements takes a great deal of time. Putting limits on the data obviously reduces the time, but there is still a delay. (Note: on one particular query I set the limit to 538 and the query returns in under 2mins if the limit becomes 539 the query loops indefinitely!)=0D From previous experience I know these delays are longer than both Informix and MySql. In some instances it takes so long I end up having to kill the query.=0D The install was performed by yum onto a RAID server using Centos. I am sure there is something fundamentally wrong for I can't believe that postgres would have the reputation it has based on the statistics I'm getting. Does anyone have any advice?=0D The data I am using was imported from an Informix system as part of a migration strategy.=0D I know this is long shot but I hope someone can shed some light. Regards, Jonathan =0D This email may contain information which is privileged or confidential.= This information is intended only for the named recipient. If you are not= the intended recipient, please be aware that disclosure, copying,= distribution or use of this information is prohibited. If you have= received this email in error, we would be grateful if you would inform us= as soon as possible by telephoning +44 (0) 1769 573431, or by email to= admin@molevalleyfarmers.com and then delete this email. Views or opinions= expressed in this email are those of the writer, and are not necessarily= the views of Mole Valley Farmers Limited or its subsidiary companies.= Unless specifically stated, this email does not constitute any part of an= offer or contract.=0D