create snapshot?
От | hubert depesz lubaczewski |
---|---|
Тема | create snapshot? |
Дата | |
Msg-id | 20001124120945.A1478@gruby обсуждение исходный текст |
Ответы |
Re: create snapshot?
|
Список | pgsql-general |
hi, i was wondering if there is something in postgresql like "create snapshot". i once saw ti on friend's database (dont know what it was), and i really like it. snapshot is something like materialized view. it is a physically existing table, with only select's allowable, and update snapshot command which recreates the table using defined at "create snapshot" selects. this is especially usefull for data warehouses, but not only, and could greatly improve performance of database system. importnant thing is that snapshots are not only for one session. they are difned, created, and stay on storage after closing session - till some other sessions does make "drop snapshot". i'm not sure if i'm clear, but ... let's hope so. any way to do it in pgsql? depesz -- hubert depesz lubaczewski ------------------------------------------------------------------------ najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo, jest niesamowita wręcz łatwość unikania kontaktów z nim ...
В списке pgsql-general по дате отправления: