Re: Nested loop in simple query taking long time

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Nested loop in simple query taking long time
Дата
Msg-id 20071206211830.GL8451@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Nested loop in simple query taking long time  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Ответы Re: Nested loop in simple query taking long time
Список 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 по дате отправления:

Предыдущее
От: Ted Byers
Дата:
Сообщение: Re: SQL design pattern for a delta trigger?
Следующее
От: "John Wells"
Дата:
Сообщение: Determining current block size?