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 B14469DD713 for ; Sun, 11 Dec 2005 22:49:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09646-05 for ; Sun, 11 Dec 2005 22:49:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by postgresql.org (Postfix) with ESMTP id 449949DD446 for ; Sun, 11 Dec 2005 22:49:05 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i12so1875954wra for ; Sun, 11 Dec 2005 18:49:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=BPHLO7nJKpg5k/uW5pTkk9x3Z4PbCX2rYCAhXERqZah+XJ/d/N07cSiSXpCssEUbztSFQl+6L1FIdiGwr7pDGzT+n4FroCTt3ZMGY9avF6oXB9tWdXYHqccPLMmRieRLPdRhq2AozLZ5l2drxM6z6gvu5aVx0Mmb8boGLghvBco= Received: by 10.65.241.17 with SMTP id t17mr5387253qbr; Sun, 11 Dec 2005 18:49:10 -0800 (PST) Received: by 10.65.160.12 with HTTP; Sun, 11 Dec 2005 18:49:10 -0800 (PST) Message-ID: Date: Mon, 12 Dec 2005 15:49:10 +1300 From: Mike C To: pgsql-performance@postgresql.org Subject: Re: Table Partitions / Partial Indexes In-Reply-To: <20805.1134355148@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6339_20576547.1134355750237" References: <20805.1134355148@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/287 X-Sequence-Number: 16108 ------=_Part_6339_20576547.1134355750237 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 12/12/05, Tom Lane wrote: > > Mike C writes: > > CLUSTER on PC_TRAFFIC_IDX3 gives me significantly improved performance: > > How can you tell? Neither of these are EXPLAIN ANALYZE output. > > regards, tom lane Sorry that's a result of my bad record keeping. I've been keeping records o= f the explain but not the analyze. IIRC the times dropped from ~25 seconds down to ~8 seconds (using analyze). Regards, Mike ------=_Part_6339_20576547.1134355750237 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 12/12/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
smith.not.western= @gmail.com> writes:
> CLUSTER on PC_TRAFFIC_IDX3 gives me sign= ificantly improved performance:

How can you tell?  Neither= of these are EXPLAIN ANALYZE output.

           &= nbsp;           &nbs= p;regards, tom lane


Sorry that's a result of my bad record keeping. I've been keeping records of the explain but not the analyze. IIRC the times dropped from ~25 seconds down to ~8 seconds (using analyze).

Regards,

Mike


------=_Part_6339_20576547.1134355750237--