Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CE3EC2E37AD for ; Thu, 10 Jan 2008 04:58:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 42194-04 for ; Thu, 10 Jan 2008 04:57:46 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id C090D2E3712 for ; Thu, 10 Jan 2008 04:57:53 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id F2114B8180; Thu, 10 Jan 2008 10:57:46 +0200 (SAST) Message-ID: <4785DE0A.6020501@careerjunction.co.za> Date: Thu, 10 Jan 2008 10:57:46 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Jared Mauch CC: pgsql-performance@postgresql.org Subject: Re: big database performance References: <4784835A.8070604@careerjunction.co.za> <47848575.8000007@commandprompt.com> <20080109174243.GA8915@puck.nether.net> In-Reply-To: <20080109174243.GA8915@puck.nether.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=AWL=-0.000, BAYES_50=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200801/50 X-Sequence-Number: 28289 Hi > I do large databases in Pg, like 300GB/day of new data. Need a lot > more data on what you're having issues with. That is big! What sort of information do you need from me ? > Is your problem with performance database reads? > writes? (insert/copy?) How many indicies do you have? I think the problem is related to load. Everything is slow because there are way too many connections. So everything is making everything else slow. Not much detail, is it? We have 345 indicies on the db. -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842