X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B3CA54030 for ; Wed, 20 Apr 2005 14:40:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89572-03 for ; Wed, 20 Apr 2005 17:40:28 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by svr1.postgresql.org (Postfix) with ESMTP id A2FAF54042 for ; Wed, 20 Apr 2005 14:40:25 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so228584wri for ; Wed, 20 Apr 2005 10:40:26 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bf1VFeNqXnOZBsWc3Yh0zgZy6RUqnnqnZ2b86viFQkPYejdAIHJHlHDn70PiJGeNwGpPUBEp4eXjuMMJ8NuWynmtQjRMnZPQCJDvXp7L1B7dixvrEb07hjL2jXR6A92ruYTDQ3sIEFk1o/h8NKKt+FJpKM7Asn5UUnrMBrKKVmY= Received: by 10.54.7.33 with SMTP id 33mr32219wrg; Wed, 20 Apr 2005 10:40:25 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Wed, 20 Apr 2005 10:40:25 -0700 (PDT) Message-ID: <33c6269f05042010407e6acbd9@mail.gmail.com> Date: Wed, 20 Apr 2005 13:40:25 -0400 From: Alex Turner Reply-To: Alex Turner To: "Jim C. Nasby" Subject: Re: How to improve db performance with $7K? Cc: "Mohan, Ross" , pgsql-performance@postgresql.org In-Reply-To: <20050420001224.GT58835@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050420001224.GT58835@decibel.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.277 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/514 X-Sequence-Number: 11911 I wonder if thats something to think about adding to Postgresql? A setting for multiblock read count like Oracle (Although having said that I believe that Oracle natively caches pages much more aggressively that postgresql, which allows the OS to do the file caching). Alex Turner netEconomist P.S. Oracle changed this with 9i, you can change the Database block size on a tablespace by tablespace bassis making it smaller for OLTP tablespaces and larger for Warehousing tablespaces (at least I think it's on a tablespace, might be on a whole DB). On 4/19/05, Jim C. Nasby wrote: > On Mon, Apr 18, 2005 at 06:41:37PM -0000, Mohan, Ross wrote: > > Don't you think "optimal stripe width" would be > > a good question to research the binaries for? I'd > > think that drives the answer, largely. (uh oh, pun alert) > > > > EG, oracle issues IO requests (this may have changed _just_ > > recently) in 64KB chunks, regardless of what you ask for. > > So when I did my striping (many moons ago, when the Earth > > was young...) I did it in 128KB widths, and set the oracle > > "multiblock read count" according. For oracle, any stripe size > > under 64KB=3Dstupid, anything much over 128K/258K=3Dwasteful. > > > > I am eager to find out how PG handles all this. >=20 > AFAIK PostgreSQL requests data one database page at a time (normally > 8k). Of course the OS might do something different. > -- > Jim C. Nasby, Database Consultant decibel@decibel.org > Give your computer some brain candy! www.distributed.net Team #1828 >=20 > Windows: "Where do you want to go today?" > Linux: "Where do you want to go tomorrow?" > FreeBSD: "Are you guys coming, or what?" >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >