Dave,<br /><br />Ok thanks. Yes, we've got over 1/2 billion rows in one of our tables which is interesting!<br /><br
/>Willpost back soon.<br /><br />Rob<br /><br /><div class="gmail_quote">2008/11/25 Dave Page <span dir="ltr"><<a
href="mailto:dpage@pgadmin.org">dpage@pgadmin.org</a>></span><br/><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On
Tue,Nov 25, 2008 at 8:39 PM, Rob Kirkbride <<a href="mailto:rob.kirkbride@gmail.com">rob.kirkbride@gmail.com</a>>
wrote:<br/> > Hi,<br /> ><br /> > I'm very new to hacking postgresql but am using on a very big site<br />
>(<a href="http://ojp.nationalrail.co.uk" target="_blank">http://ojp.nationalrail.co.uk</a>). One of the issues that
wehave is moving<br /> > data from a live database to a reports one. I've hacked an extra option to<br /> >
pg_dumpto delete from tables rather than dropping them.<br /><br /></div>National Rail use Postgres for their journey
planner?Cool :-)<br /><div class="Ih2E3d"><br /> > Once I'm happy with it (I'm a bit rusty at C!), do I post the
patchhere?<br /><br /></div>Yes (and please add details to<br /><a
href="http://wiki.postgresql.org/wiki/CommitFestOpen"target="_blank">http://wiki.postgresql.org/wiki/CommitFestOpen</a>
soit doesn't get<br /> lost), but please note that we're in the middle of the final phase of<br /> the development
cycleat the moment, so new patches are unlikely to be<br /> looked at for at least a couple of months.<br /><font
color="#888888"><br/><br /> --<br /> Dave Page<br /> EnterpriseDB UK: <a href="http://www.enterprisedb.com"
target="_blank">http://www.enterprisedb.com</a><br/></font></blockquote></div><br />