Re: Nested loop in simple query taking long time - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Nested loop in simple query taking long time
Date
Msg-id 20071206211830.GL8451@alvh.no-ip.org
Whole thread Raw
In response to Re: Nested loop in simple query taking long time  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Nested loop in simple query taking long time
List pgsql-general
Gauthier, Dave wrote:
> Future Enhancement?
> If the column's new value can fit in the space already being used by the
> existing value, just change the column value in place and leave the
> record alone.  Would reduce the need for vacuum in many cases.

That's in 8.3.  Not exactly like that (because it doesn't work in
Postgres due to MVCC), but something close.  Look for HOT in release
notes.

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
Syntax error: function hell() needs an argument.
Please choose what hell you want to involve.

pgsql-general by date:

Previous
From: Ted Byers
Date:
Subject: Re: SQL design pattern for a delta trigger?
Next
From: "John Wells"
Date:
Subject: Determining current block size?