X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9CE1711F66BF for ; Tue, 4 Apr 2006 00:46:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02401-06 for ; Tue, 4 Apr 2006 00:46:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw04.mi8.com [63.240.6.44]) by postgresql.org (Postfix) with ESMTP id 1282F11F6632 for ; Tue, 4 Apr 2006 00:46:36 -0300 (ADT) Received: from 172.16.1.148 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Mon, 03 Apr 2006 23:46:30 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 3 Apr 2006 23:46:29 -0400 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Tue, 4 Apr 2006 03:46:29 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Mon, 03 Apr 2006 20:46:28 -0700 Subject: Re: bad performance on Solaris 10 From: "Luke Lonergan" To: "Josh Berkus" , pgsql-performance@postgresql.org cc: "Chris Mair" Message-ID: Thread-Topic: [PERFORM] bad performance on Solaris 10 Thread-Index: AcZXgfrvibtj36e5TR+PBPObekfkdQAGF97b In-Reply-To: <200604031749.27580.josh@agliodbs.com> MIME-Version: 1.0 X-OriginalArrivalTime: 04 Apr 2006 03:46:29.0870 (UTC) FILETIME=[5B8598E0:01C6579A] X-WSS-ID: 682F339C20C38499773-01-01 Content-Type: multipart/alternative; boundary=B_3226941988_49453 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.352 required=5 tests=[AWL=0.098, HTML_MESSAGE=0.001, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.352 X-Spam-Level: * X-Archive-Number: 200604/40 X-Sequence-Number: 18124 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3226941988_49453 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Jignesh=B9s blog has some of the good stuff in it: http://blogs.sun.com/roller/page/jkshah - Luke On 4/3/06 5:49 PM, "Josh Berkus" wrote: > Chris, >=20 >> > Eons ago PCs had those "turbo" switches (it was never totally clear >> > why they put them there in the first place, anyway). I've this bad >> > feeling there's a secret "turbo" switch I can't spot hidden somewhere >> > in Solaris :/ >=20 > Yes. Check out Jignesh's configuration advice .... ach, this is down. > Hold on, I will get you instructions on how to turn on filesystem caching > and readahead in Solaris. >=20 > -- > --Josh >=20 > Josh Berkus > Aglio Database Solutions > San Francisco >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >=20 >=20 --B_3226941988_49453 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Re: [PERFORM] bad performance on Solaris 10 Jigne= sh’s blog has some of the good stuff in it:
  http://blogs.= sun.com/roller/page/jkshah

- Luke


On 4/3/06 5:49 PM, "Josh Berkus" <josh@agliodbs.com> wrote:=

Chris,

> Eons ago PCs had those "turbo" switches (it was never totall= y clear
> why they put them there in the first place, anyway). I've this bad
> feeling there's a secret "turbo" switch I can't spot hidden = somewhere
> in Solaris :/

Yes.   Check out Jignesh's configuration advice .... ach, this is= down.  
Hold on, I will get you instructions on how to turn on filesystem caching and readahead in Solaris.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings



 --B_3226941988_49453--