On Tue, 2005-04-26 at 19:03 -0400, Greg Stark wrote: > This one looks *really* good. > > http://www.aladdin.cs.cmu.edu/papers/pdfs/y2001/dist_sampl.pdf > > It does require a single full table scan
Ack.. Not by default please. I have a few large append-only tables (vacuum isn't necessary) which do need stats rebuilt periodically. Lets just say that we've been working hard to upgrade to 8.0 primarily because pg_dump was taking over 18 hours to make a backup. -- Rod Taylor <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings