Dave, Ok thanks. Yes, we've got over 1/2 billion rows in one of our tables which is interesting!
Will post back soon. Rob 2008/11/25 Dave Page <[EMAIL PROTECTED]> > On Tue, Nov 25, 2008 at 8:39 PM, Rob Kirkbride <[EMAIL PROTECTED]> > wrote: > > Hi, > > > > I'm very new to hacking postgresql but am using on a very big site > > (http://ojp.nationalrail.co.uk). One of the issues that we have is > moving > > data from a live database to a reports one. I've hacked an extra option > to > > pg_dump to delete from tables rather than dropping them. > > National Rail use Postgres for their journey planner? Cool :-) > > > Once I'm happy with it (I'm a bit rusty at C!), do I post the patch here? > > Yes (and please add details to > http://wiki.postgresql.org/wiki/CommitFestOpen so it doesn't get > lost), but please note that we're in the middle of the final phase of > the development cycle at the moment, so new patches are unlikely to be > looked at for at least a couple of months. > > > -- > Dave Page > EnterpriseDB UK: http://www.enterprisedb.com >
