Hi, Brandan,
Brendan Duddridge wrote:
> So how do you overlap the restore process with the retrieving of files?
You need a shell script as restore command that does both uncompressing
the current file, and starting a background decompress of the next
file(s). It also has to check whether the current file is already in
progress from a last run, and wait until this is finished instead of
decompressing it. Seems to be a little complicated than it sounds first.
> restore_command = 'gunzip </wal_archive/%f.gz>%p &'
Warning: Don't do it this way!
It will break things because PostgreSQL will try to access a
not-completely-restored wal file.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
