Re: Where to find information on the new HOT tables?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 5 Feb 2008 15:11:49 -0500
"Chris Hoover" <revoohc@xxxxxxxxx> wrote:

> > Ok that's awesome.  However, is there any documentation out there
> explaining this feature in detail, and how it works, what to expect,
> etc. ?

As I understand it, the key to hot is that it is only useful if you are
updating non-indexed columns. This is great when dealing with things
like session tables where you are doing this:

UPDATE sessions SET last_active = current_date WHERE sid = <session_id>.

last_active may not indexed.

Sincerely,

Joshua D. Drake



-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

Attachment: signature.asc
Description: PGP signature


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux