Re: keeping 3 tables in sync w/ each other

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Re: keeping 3 tables in sync w/ each other
Дата
Msg-id 1190195232.15764.26.camel@neuromancer.home.net
обсуждение исходный текст
Ответ на Re: keeping 3 tables in sync w/ each other  (btober@ct.metrocast.net)
Список pgsql-general
On Tue, 2007-09-18 at 08:37 -0400, btober@ct.metrocast.net wrote:
> Ow Mun Heng wrote:
> > Hi,
> >
> > create table foo (a int, b int, c int)
> > create table foo_loading_source1 (a int, b int, c int)
> > create table foo_loading_source2 (a int, b int, c int)
> >
> > Is there a way which can be made easier to keep these 3 tables DDL in
> > sync?

> Since these are temporary tables, why don't you just create them on the
> fly as temporary tables?
>
> CREATE TEMPORARY TABLE foo_loading_source1 (LIKE foo);
>
> CREATE TEMPORARY TABLE foo_loading_source2 (LIKE foo);
>
> Then do your loading process. Then you don't really have to worry about
> maintaining the loading tables at all.
>

Yes, I've thought of this, but wouldn't this cause additional overhead
as the loading process may be initiated between every 60sec to 30mins
for a handful of tables each time. (which was why I asked the list)




В списке pgsql-general по дате отправления:

Предыдущее
От: Ow Mun Heng
Дата:
Сообщение: Re: keeping 3 tables in sync w/ each other
Следующее
От: "Filip Rembiałkowski"
Дата:
Сообщение: Re: keeping 3 tables in sync w/ each other