Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8KJo6e05705 for ; Thu, 20 Sep 2001 15:50:06 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 122765; Thu, 20 Sep 2001 12:50:02 -0700 From: "Josh Berkus" Subject: Re: Out of free buffers... HELP! To: "Diehl, Jeffrey" , "'Josh Berkus'" , darcy@druid.net Cc: "Diehl, Jeffrey" , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Thu, 20 Sep 2001 12:50:02 -0700 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200109/181 X-Sequence-Number: 4863 Diehl, > Um no, I just need a smaller problem to solve. The database worked > quite > well when the problem was half this size. > could do with 60 day's...!" And they are right, if it can be done... > If it > can't, I'll tell them and they will understand. What I'm saying is, based on your description, you need a lot of hand-on performance tuning help. Someone who knows the pgsql performance parameters and can experiment with tweaking and tuning to avoid swamping the memory of the machine(s) you're running on. Because that's what it sounds like the problem is. However, that sort of help will take some paid consultant time and possibly hardware. I think that if you can run a query on 150gb of data, you can probably run it on 355gb ... you just need some help performance tuning. But I don't think general advice on a list is gonna do it, y'know? -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco