| From: | "Scot Kreienkamp" <SKreien(at)la-z-boy(dot)com> |
|---|---|
| To: | "Scott Mead" <scott(dot)lists(at)enterprisedb(dot)com>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: autovacuum question |
| Date: | 2010-03-09 15:25:52 |
| Message-ID: | 59E62072D4EFFF4BB912EC607F8FA60B741D5F@lzbs6304.na.lzb.hq |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
ISTM that 9.0's read-only standby feature may be of use to you. I know
it doesn't help you *today* but have you looked at it yet?
Okay, so the RO database won't work. How much data are we talking?
How much growth do you see between snapshots?
The initial database size is 31 gigs. I give it 5 gigs in the snapshot
to grow in, but I would be surprised if more than 200 megs of data
changes. The actual change rate should be very low.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Wood | 2010-03-09 15:42:51 | Re: Urgent help needed- alias name in update statement |
| Previous Message | Scott Mead | 2010-03-09 15:23:26 | Re: autovacuum question |