Re: [GENERAL] Question about updates and MVCC

2009-01-11 Thread Martijn van Oosterhout
On Sat, Jan 10, 2009 at 08:00:29AM -0800, mailingli...@net-virtual.com wrote: > Hello, > > I have a couple of questions regarding how MVCC (in postges 8.3.3 if it > makes a difference) affects vacuum. > > #1. If I am doing an update to a row and none of the values have changed, > will that cause

[GENERAL] Question about updates and MVCC

2009-01-10 Thread mailinglists
Hello, I have a couple of questions regarding how MVCC (in postges 8.3.3 if it makes a difference) affects vacuum. #1. If I am doing an update to a row and none of the values have changed, will that cause a "hole" that requires vacuum to reclaim? #2. I have a column in my table (called "status",