X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8874B5282F for ; Mon, 11 Jul 2005 15:02:58 -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 11145-05 for ; Mon, 11 Jul 2005 18:02:47 +0000 (GMT) Received: from web32509.mail.mud.yahoo.com (web32509.mail.mud.yahoo.com [68.142.207.219]) by svr1.postgresql.org (Postfix) with SMTP id 5A2F552801 for ; Mon, 11 Jul 2005 15:02:42 -0300 (ADT) Received: (qmail 88542 invoked by uid 60001); 11 Jul 2005 18:02:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=jW6gbcPPDOx1drnUfDchvOHBaE/0DkyMVC/ggdu8C+dbtZIa1kxBe25TX1+p/JJKDffCDYbDggt4EuGXvBkrswLCp2tOiUMq5kumv7fCkRoN+gPcSLXeo1ZlE17MQd3PPH9nbfs2OTv0F8l/8Lw4tMBXOkIx5f8iZ+hgjVY9D3E= ; Message-ID: <20050711180242.88540.qmail@web32509.mail.mud.yahoo.com> Received: from [216.173.173.66] by web32509.mail.mud.yahoo.com via HTTP; Mon, 11 Jul 2005 11:02:42 PDT Date: Mon, 11 Jul 2005 11:02:42 -0700 (PDT) From: CG Reply-To: cgg007@yahoo.com Subject: Re: Clustering problem To: PFC , PostgreSQL SQL In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.631 tagged_above=0 required=5 tests=AWL, FORGED_YAHOO_RCVD, FROM_ENDS_IN_NUMS X-Spam-Level: ** X-Archive-Number: 200507/98 X-Sequence-Number: 22076 Why would you then drop the index? Performance and storage issues? I imagine that I would cluster the table at regular intervals to maintain the ordering, so I'd need to to keep the index around, yes? --- PFC wrote: > > > > Is it even possible to cluster a table based on the clustering scheme > > (which is > > not the link_id ...) from the master table? > > > > Can you gurus think of a better strategy? :) (Please??) :) > > You can create a functional index on a function which returns the desired > order by looking in the main table, cluster it, then drop the index... > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ____________________________________________________ Sell on Yahoo! Auctions – no fees. Bid on great items. http://auctions.yahoo.com/