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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461