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

Поиск
Список
Период
Сортировка
От Ashley Moran
Тема Re: What to index to speed up my UNION views?
Дата
Msg-id 200603280943.06079.work@ashleymoran.me.uk
обсуждение исходный текст
Ответ на Re: What to index to speed up my UNION views?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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 по дате отправления:

Предыдущее
От: Stefan Fink
Дата:
Сообщение: table owner of cloned databases
Следующее
От: Ashley Moran
Дата:
Сообщение: Re: What to index to speed up my UNION views?