Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 586A79FB28B for ; Mon, 25 Sep 2006 21:29:45 -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 01817-05 for ; Mon, 25 Sep 2006 21:29:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gw.sandvine.com (sandvine.com [199.243.201.138]) by postgresql.org (Postfix) with ESMTP id A899F9FB27C for ; Mon, 25 Sep 2006 21:29:40 -0300 (ADT) Received: from mailserver.sandvine.com ([192.168.1.10]) by gw.sandvine.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 25 Sep 2006 20:29:38 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Decreasing BLKSZ Date: Mon, 25 Sep 2006 20:29:37 -0400 Message-ID: <2BCEB9A37A4D354AA276774EE13FB8C2011306A1@mailserver.sandvine.com> In-Reply-To: <16132.1159223246@sss.pgh.pa.us> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Decreasing BLKSZ Thread-Index: Acbg8csHNP15KgLFSYaUIxW+9sCeywAEOehQ From: "Marc Morin" To: "Tom Lane" Cc: "Markus Schaber" , X-OriginalArrivalTime: 26 Sep 2006 00:29:39.0002 (UTC) FILETIME=[D9FC69A0:01C6E102] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/335 X-Sequence-Number: 21021 =20 >=20 > The bottom line here is likely to be "you need more RAM" :-( Yup. Just trying to get a handle on what I can do if I need more than 16G Of ram... That's as much as I can put on the installed based of servers.... 100s of them. >=20 > I wonder whether there is a way to use table partitioning to=20 > make the insert pattern more localized? We'd need to know a=20 > lot more about your insertion patterns to guess how, though. >=20 > regards, tom lane We're doing partitioning as well..... >=20