| From: | Giles Constant <gilesc(at)hyperlink-interactive(dot)co(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Mirroring with WAL? |
| Date: | 2001-10-19 08:57:29 |
| Message-ID: | Pine.LNX.4.33.0110190955130.10700-100000@gilecpc.d1.hyperlink-interactive.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 18 Oct 2001, Tom Lane wrote:
> In its present form it's far too bulky to be kept around over any long
> period of time --- or didn't you notice all the squawks about WAL files
> overrunning disk as soon as anyone had a long-running transaction?
hm.. How does this compare with the Oracle system? Are the Oracle logs
smaller? This is how we perform most of our mirroring with Oracle, and
yes, it does produce rather large files, but once the most recent file has
been transferred over and uploaded into the mirror database, they get
deleted. Admittedly this involves lots of cron writing, but it works..
:-)
--
Giles Constant, Systems Programmer
Hyperlink Interactive
http://www.hyperlink-interactive.co.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Sawler | 2001-10-19 13:10:35 | RedHat logging |
| Previous Message | Brett Schwarz | 2001-10-19 05:35:31 | Re: Please help - tks |