Re: AS OF queries - Mailing list pgsql-hackers

From Konstantin Knizhnik
Subject Re: AS OF queries
Date
Msg-id 309e84e7-3636-1ef6-0608-34a44964ee69@postgrespro.ru
Whole thread Raw
In response to Re: AS OF queries  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: AS OF queries
List pgsql-hackers
Attached please find new version of AS OF patch which allows to specify 
time travel period.
Older versions outside this period may be reclaimed by autovacuum.
This behavior is controlled by "time_travel_period" parameter.

Zero value of this parameter disables time travel and postgres behaves 
in standard way.
Actually you can still use AS AF construction but there is no warranty 
that requested versions are not reclaimed and result of query actually 
belongs to the specified time slice.

Value -1 means infinite history: versions are never reclaimed and 
autovacuum is disabled.

And positive value of this parameter specifies maximal time travel 
period in seconds.
As in case of disabled time travel, you can specify AS OF timestamp 
older than this period.
But there is no warranty that requested versions still exist.

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Attachment

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: The pg_indent on on ftp is outdated
Next
From: Magnus Hagander
Date:
Subject: Re: Basebackups reported as idle