On Jun 16, 2006, at 8:43 AM, Jonah H. Harris wrote:
Yes, this is certainly the most noticible case. This is one reason
I'm behind the freespace patch. Unfortunately, a lot of inexperienced
people use VACUUM FULL and don't understand why VACUUM is *generally*
better.(to free up block-level freespace and update FSM) assuming they
have enough hard disk space for the database.
Another reason to turn autovac on by default in 8.2...
That and of course the visibility bitmap that has been
much-discussed
I'd certainly like to see it.
What's the hold-up on this? I thought there were some technical
issues that had yet to be resolved?
BTW, I'll point out that DB2 and MSSQL didn't switch to MVCC until
their most recent versions.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
