On Mon, 2003-09-22 at 18:30, Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > Fair enough. On another front then... would all this energy we are > > talking about with pg_upgrade > > be better spent on pg_dump/pg_dumpall/pg_restore? > > Well, we need to work on pg_dump too. But I don't foresee it ever > getting fast enough to satisfy the folks who want zero-downtime
Multi-threaded pg_dump. "It'll choke the IO system!!!" you say? Well, heck, get a better IO system!!!! Or... use fewer threads. No, it won't eliminate down-time, but is necessary for big data- bases. -- ----------------------------------------------------------------- Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA "You ask us the same question every day, and we give you the same answer every day. Someday, we hope that you will believe us..." U.S. Secretary of Defense Donald Rumsfeld, to a reporter ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
