Re: autovacuum question - Mailing list pgsql-general

From Scot Kreienkamp
Subject Re: autovacuum question
Date
Msg-id 59E62072D4EFFF4BB912EC607F8FA60B741D5F@lzbs6304.na.lzb.hq
Whole thread Raw
In response to Re: autovacuum question  (Scott Mead <scott.lists@enterprisedb.com>)
List 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. 

pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: autovacuum question
Next
From: Bryan Montgomery
Date:
Subject: Re: autovacuum question