Re: What to index to speed up my UNION views? - Mailing list pgsql-general

From Ashley Moran
Subject Re: What to index to speed up my UNION views?
Date
Msg-id 200603280943.06079.work@ashleymoran.me.uk
Whole thread Raw
In response to Re: What to index to speed up my UNION views?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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

pgsql-general by date:

Previous
From: Stefan Fink
Date:
Subject: table owner of cloned databases
Next
From: Ashley Moran
Date:
Subject: Re: What to index to speed up my UNION views?