Re: Any Good Way To Do Sync DB's?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gordan Bobic <gordan(at)bobich(dot)net>
Cc: Doug McNaught <doug(at)wireboard(dot)com>, joe(at)jwebmedia(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Any Good Way To Do Sync DB's?
Date: 2001-10-13 14:54:19
Message-ID: 9511.1002984859@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gordan Bobic <gordan(at)bobich(dot)net> writes:
> I'm going to have to rant now. The "dump" and "restore" which use the COPY
> method are actually totally useless for large databases. The reason for
> this is simple. Copying a 4 GB table with 40M rows requires over 40GB of
> temporary scratch space to copy, due to the WAL temp files. That sounds
> totally silly. Why doesn't pg_dump insert commits every 1000 rows or so???

Yup, "rant" is the correct term. The WAL file growth problem has been
fixed as of 7.1.3, so your premise is false.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-13 15:13:52 Re: [Off-topic, Meta-question] Problems with psql-general list
Previous Message Stephan Szabo 2001-10-13 14:13:25 Re: COMMIT after an ERROR?