Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A4A66650E7A for ; Wed, 2 Jul 2008 10:29:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87572-05 for ; Wed, 2 Jul 2008 10:28:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.28]) by postgresql.org (Postfix) with ESMTP id 50938650DBC for ; Wed, 2 Jul 2008 10:29:03 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so74118yxb.73 for ; Wed, 02 Jul 2008 06:29:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=0HEDdy/vDep1ELoR7ti2CYG8wLYfXuoMMR9Mr+XfrGs=; b=qnlZaqtvyc7VTENLkhzsJmYEX/+t1+5zwBVzJa515ZKs565YTrVsb6bIIMJ7HbatrS hnyOcTHnPtahKMk4mhxGyEocJ9DTEcJx4cxc/MCJTbOu84tsoVXISQ1IMsBQKovQ8UDT hBToRvqCXmhJPVWcob1ujeUDLUEV0GHTJh74s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=YtXQNxbLcwTE6b30MCmkQftwVo+2kHnTK23Z/3nFGZ8AcAJG68iVFZ1jF6jCq69Q3x Nk/w/2x5/2PP4BAlgkzaPRGJ5ai8Xn7y2kWsBtuv7VPHGqjipwfuY7XB2Ks8EvAz6ahh V196UzXGhjc/Sb3dvEB4cqIpTmTbEUo4sn8Z4= Received: by 10.150.49.1 with SMTP id w1mr12968730ybw.21.1215005342157; Wed, 02 Jul 2008 06:29:02 -0700 (PDT) Received: by 10.150.186.15 with HTTP; Wed, 2 Jul 2008 06:29:02 -0700 (PDT) Message-ID: <36e682920807020629h2b0432e9k39cc01f1693e6a40@mail.gmail.com> Date: Wed, 2 Jul 2008 09:29:02 -0400 From: "Jonah H. Harris" To: "Gauri Kanekar" Subject: Re: Hot Issue Cc: "=?ISO-8859-1?Q?Devrim_G=DCND=DCZ?=" , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550807020611x3dac7fffw8497d168c7a0e9d8@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com> <1215004084.2842.32.camel@laptop.gunduz.org> <7e4ba9550807020611x3dac7fffw8497d168c7a0e9d8@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/23 X-Sequence-Number: 30623 On Wed, Jul 2, 2008 at 9:11 AM, Gauri Kanekar wrote: > hot have a limitation that it do not work if, the index column is updated. > But that not the case over here. Another limitation is that HOT won't work if there's not enough space to fit the update on the same page. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/