From: Richard Huxton <dev@archonet.com>
To: josh@agliodbs.com, Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Subject: Re: Indexing UNIONs
Date: Wed, 17 Jul 2002 10:29:16 +0100
Message-ID: <200207171029.17572.dev@archonet.com> (raw)
In-Reply-To: <200207161542.23433.josh@agliodbs.com>
References: <20020716114553.GB29323@wolff.to>
<20020716192006.GC32419@wolff.to>
<200207161542.23433.josh@agliodbs.com>
On Tuesday 16 Jul 2002 11:42 pm, Josh Berkus wrote:
> OK, I guess I'll have to get into detail:
>
[detail on cases and trial-groups]
>
> Thus, I need to relate (in views and queries) each Event to the Union of
> Cases and Trial Groups. I just can't figure out how to do so without the
> database discarding the indexes on Cases in the process and things slowing
> to a crawl.
Well, if there was some commonality between cases and trial groups you'd have
noticed it. How about two event tables, one for each type of schedulable
event and unioning those?
Of course, that's just shuffling the complexity around since you'll need a
view with the relevant rewrites and possibly some way of detecting scheduling
conflicts?
- Richard Huxton
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: dev@archonet.com, bruno@wolff.to
Subject: Re: Indexing UNIONs
In-Reply-To: <200207171029.17572.dev@archonet.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