Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

J. R. Nield <jrnield@usol.com>

View thread View on postgr.es
From: "J. R. Nield" <jrnield@usol.com>
To: Curt Sampson <cjs@cynic.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <pgman@candle.pha.pa.us>, Michael Loftis <mloftis@wgops.com>, mlw <markw@mohawksoft.com>, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-06-23T18:15:17Z
Lists: pgsql-hackers 
On Sun, 2002-06-23 at 12:10, Curt Sampson wrote:
> 
> So what we would really need to implement, if we wanted to be more
> efficient with trusted disk subsystems, would be the option of writing
> to the log only the changed row or changed part of the row, or writing
> the entire changed page. I don't know how hard this would be....
> 
We already log that stuff. The page images are in addition to the
"Logical Changes", so we could just stop logging the page images.

-- 
J. R. Nield
jrnield@usol.com