create snapshot?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: create snapshot?
Date: 2000-11-24 11:09:45
Message-ID: 20001124120945.A1478@gruby
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francis Solomon 2000-11-24 11:10:52 RE: Comparing dates in 3.0
Previous Message Max Fonin 2000-11-24 11:02:14 Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions