From: CG <cgg007@yahoo.com>
To: PFC <lists@boutiquenumerique.com>
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: Clustering problem
Date: Mon, 11 Jul 2005 11:02:42 -0700 (PDT)
Message-ID: <20050711180242.88540.qmail@web32509.mail.mud.yahoo.com> (raw)
In-Reply-To: <op.stmbbpfjth1vuj@localhost>
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 <lists@boutiquenumerique.com> 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cgg007@yahoo.com, lists@boutiquenumerique.com
Subject: Re: Clustering problem
In-Reply-To: <20050711180242.88540.qmail@web32509.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox