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
> 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
In response to
pgsql-performance by date
|Next:||From: Jim Nasby||Date: 2006-06-17 19:53:03|
|Subject: Re: SAN performance mystery|
|Previous:||From: Jim Nasby||Date: 2006-06-17 19:25:14|
|Subject: Re: Precomputed constants?|