Re: Auto-partitioning?

Hi

Just a hint.
We do this auto-partitioning with PgQ. Instead of writing records into table
we push them into queue and use consumer called table_dispatcher to creates
tartitioned tables as needed and put records into them. We have multiple
destination databases where to write data and target tables have different
structures so queue based solution is convenient for us.

Asko

On 8/21/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Steve Wampler wrote:
> > Steve Wampler wrote:
> >> ... Specifically, I'm wondering if it's
> >> possible to add a default rule that would create a new partition
> >> (with indices, etc.) and would add a new rule for this partition
> >> to match the similar ones above (and, of course, then move the
> >> INSERT into the new partition).
> >
> > I think I've answered my own question, but would love an expert
> > to validate the answer:
> >
> > The answer is "no", apparently because 'name' in
>
> That answer is no but you could probably pull it off with a trigger.
>
> Sincerely,
>
> Joshua D. Drake
>
>
> - --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
> PostgreSQL solutions since 1997 http://www.commandprompt.com/
> UNIQUE NOT NULL
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGy1BNATb/zqfZUUQRAlhxAJsEpKJicoMkvFXS+T5DiCjroSYj9QCcCjmt
> qaaXSe764ULKH5h3z8p6QUc=
> =2xC8
> -----END PGP SIGNATURE-----
>
> ---------------------------(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
>