Re: What to index to speed up my UNION views?

From: Ashley Moran <work(at)ashleymoran(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What to index to speed up my UNION views?
Date: 2006-03-28 08:43:05
Message-ID: 200603280943.06079.work@ashleymoran.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 27 March 2006 13:57, Jim C. Nasby wrote:
> BTW, you might also find inheritance to be of use:
> http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html

I'm not sure inheritance will help here or not. I need to aggregate all the
sub tables and add a field whose value depends on which table the data came
from. I think views are probably easier but I've never actually used table
inheritance.

Ashley

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashley Moran 2006-03-28 08:45:02 Re: What to index to speed up my UNION views?
Previous Message Achilleus Mantzios 2006-03-28 08:16:06 Proposed dbmirror change