From revoohc@gmail.com Tue Feb 5 19:42:34 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AE3B52E447E for ; Tue, 5 Feb 2008 15:42:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98536-09 for ; Tue, 5 Feb 2008 15:42:22 -0400 (AST) Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.183]) by postgresql.org (Postfix) with ESMTP id 853792E41D1 for ; Tue, 5 Feb 2008 15:42:21 -0400 (AST) Received: by ik-out-1112.google.com with SMTP id c21so314152ika.3 for ; Tue, 05 Feb 2008 11:42:19 -0800 (PST) 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:mime-version:content-type; bh=gQaUvsO4JGoKC8BnkIHyNjUlSjGGwNMFexECl/7pHzc=; b=Wg7f/ePW973NKCluqSeur+c9fVFegacNhDinFKXJ1xcaFIcAHltgHP5Oi/61TBdfvRAhiGGpTAMHE5QWGPYCORg/vcnOqpm/CNGhVbbZiEfu9c7tddP6stVtrz/I4FfA0RyKCrCF+St9PzzMjBg5TpCF89WnpQ/yUg1Jqr7ZXAo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=BAUxalYLeT82OQA5z2OgbYpu1DF12iEDW/52xgmyBSDBcjSroTwHnx6qGnUf6IOcPHH1mMg/NXJ5qLA+ZnS8NZYOQunKxz468DcZ9AONuAmk1VEwyq9BNXSoeMHBxZtyYjdAddM/dxouYvmjF5mNA3u4aNmo0NHO8gd8kKzFaG4= Received: by 10.151.9.1 with SMTP id m1mr3736256ybi.150.1202240537991; Tue, 05 Feb 2008 11:42:17 -0800 (PST) Received: by 10.150.197.17 with HTTP; Tue, 5 Feb 2008 11:42:17 -0800 (PST) Message-ID: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> Date: Tue, 5 Feb 2008 14:42:17 -0500 From: "Chris Hoover" To: "pgsql-admin@postgresql.org Admin" Subject: Where to find information on the new HOT tables? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6895_15501334.1202240537968" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/34 X-Sequence-Number: 28108 ------=_Part_6895_15501334.1202240537968 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have been searching through the 8.3 documentation trying to find information on the new HOT tables that 8.3 provides and can not seem to find any. Can someone please point me towards some documentation on this new feature so I can better understand it, and see if I can implement it into our current application when we upgrade in a few months. thanks, Chris -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_6895_15501334.1202240537968 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have been searching through the 8.3 documentation trying to find information on the new HOT tables that 8.3 provides and can not seem to find any.  Can someone please point me towards some documentation on this new feature so I can better understand it, and see if I can implement it into our current application when we upgrade in a few months.

thanks,

Chris

--
Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY.  Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_6895_15501334.1202240537968-- From bruce@momjian.us Tue Feb 5 19:53:47 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 472402E35C2 for ; Tue, 5 Feb 2008 15:53:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03913-03 for ; Tue, 5 Feb 2008 15:53:44 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id A36352E0363 for ; Tue, 5 Feb 2008 15:53:43 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m15JrgJ00998; Tue, 5 Feb 2008 14:53:42 -0500 (EST) From: Bruce Momjian Message-Id: <200802051953.m15JrgJ00998@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> To: Chris Hoover Date: Tue, 5 Feb 2008 14:53:42 -0500 (EST) CC: "pgsql-admin@postgresql.org Admin" X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/35 X-Sequence-Number: 28109 Chris Hoover wrote: > I have been searching through the 8.3 documentation trying to find > information on the new HOT tables that 8.3 provides and can not seem to find > any. Can someone please point me towards some documentation on this new > feature so I can better understand it, and see if I can implement it into > our current application when we upgrade in a few months. HOT is automatic. All tables are HOT-enabled. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From revoohc@gmail.com Tue Feb 5 20:12:05 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 94B8F2E463E for ; Tue, 5 Feb 2008 16:12:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 60500-01-5 for ; Tue, 5 Feb 2008 16:11:53 -0400 (AST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 6CBCF2E44A8 for ; Tue, 5 Feb 2008 16:11:52 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so255709ugf.49 for ; Tue, 05 Feb 2008 12:11:51 -0800 (PST) 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:references; bh=j1nCsicxQytcYbn/wUh6X6inH9pIDRYzbI+WC3+tNSc=; b=DXbAEOUKeUBeCf6V9kr8HczJZVoFZcKcn5B1pKqXe1Tj9hyWYpa8D+KYoZFyX8EZq39FCNRU6RcoQq72T6LWlJum1u5n5SXJ6xLoHMYL1CFLa5arCgEmAKh0xltHuvjl6DljGe6XxNXi+btrqCZ8B/SEP6tRYkWE3XKJBPRp8Z4= 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:references; b=aLTjaF+JRJI+zqmwz2rHp+nAenTrw/ICkPrsGOxVZmG5RFtiXc5pgv2YdyL2MPZ3yv0R6I8xrJb3HmKIzJSh1NnGkSIo0X//H45SB9ZhSbhb6K2RVYKivLGpc9czBTZ2ihferRY32xYIGUrJ2gFjWwFrsUPF8DM6DTXovkMrGso= Received: by 10.151.83.12 with SMTP id k12mr440350ybl.0.1202242309981; Tue, 05 Feb 2008 12:11:49 -0800 (PST) Received: by 10.150.197.17 with HTTP; Tue, 5 Feb 2008 12:11:49 -0800 (PST) Message-ID: <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> Date: Tue, 5 Feb 2008 15:11:49 -0500 From: "Chris Hoover" To: "Bruce Momjian" Subject: Re: Where to find information on the new HOT tables? Cc: "pgsql-admin@postgresql.org Admin" In-Reply-To: <200802051953.m15JrgJ00998@momjian.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6998_32968881.1202242309964" References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802051953.m15JrgJ00998@momjian.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/36 X-Sequence-Number: 28110 ------=_Part_6998_32968881.1202242309964 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Feb 5, 2008 2:53 PM, Bruce Momjian wrote: > Chris Hoover wrote: > > I have been searching through the 8.3 documentation trying to find > > information on the new HOT tables that 8.3 provides and can not seem to > find > > any. Can someone please point me towards some documentation on this new > > feature so I can better understand it, and see if I can implement it > into > > our current application when we upgrade in a few months. > > HOT is automatic. All tables are HOT-enabled. > > Ok that's awesome. However, is there any documentation out there explaining this feature in detail, and how it works, what to expect, etc. ? Thanks, Chris -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_6998_32968881.1202242309964 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On Feb 5, 2008 2:53 PM, Bruce Momjian <bruce@momjian.us> wrote:
Chris Hoover wrote:
> I have been searching through the 8.3 documentation trying to find
> information on the new HOT tables that 8.3 provides and can not seem to find
> any.  Can someone please point me towards some documentation on this new
> feature so I can better understand it, and see if I can implement it into
> our current application when we upgrade in a few months.

HOT is automatic.  All tables are HOT-enabled.

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

Thanks,

Chris


--
Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY.  Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_6998_32968881.1202242309964-- From jd@commandprompt.com Tue Feb 5 20:22:11 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D3C722E3EEC for ; Tue, 5 Feb 2008 16:22:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85738-08 for ; Tue, 5 Feb 2008 16:22:05 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 7B4422E3480 for ; Tue, 5 Feb 2008 16:22:08 -0400 (AST) Received: from jd-laptop (cmdalert.com [69.55.229.115]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m15KMFgL001113 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 5 Feb 2008 12:22:16 -0800 Date: Tue, 5 Feb 2008 12:21:58 -0800 From: "Joshua D. Drake" To: "Chris Hoover" Cc: "Bruce Momjian" , "pgsql-admin@postgresql.org Admin" Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080205122158.253e4a71@jd-laptop> In-Reply-To: <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802051953.m15JrgJ00998@momjian.us> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.2.0 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/vQ3C5n0ZkFet3hcUJDuhfx6"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 05 Feb 2008 12:22:16 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/37 X-Sequence-Number: 28111 --Sig_/vQ3C5n0ZkFet3hcUJDuhfx6 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Tue, 5 Feb 2008 15:11:49 -0500 "Chris Hoover" 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 =3D current_date WHERE sid =3D . last_active may not indexed. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 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 --Sig_/vQ3C5n0ZkFet3hcUJDuhfx6 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHqMVmATb/zqfZUUQRAsDpAJ4qESX5OgyoiIzdCEqw22r7JuT2SwCgrrm+ b3JQSIwG0SrL5+BV9dnSfqU= =ZFfd -----END PGP SIGNATURE----- --Sig_/vQ3C5n0ZkFet3hcUJDuhfx6-- From alvherre@commandprompt.com Tue Feb 5 20:29:05 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 76E062E422F for ; Tue, 5 Feb 2008 16:29:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 00664-03 for ; Tue, 5 Feb 2008 16:28:58 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id BD2732E41FD for ; Tue, 5 Feb 2008 16:29:01 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-28-116.bk17-dsl.surnet.cl [190.95.28.116]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m15KSnp1001350 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 5 Feb 2008 12:29:08 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E8CFF47BEC; Tue, 5 Feb 2008 17:28:31 -0300 (CLST) Date: Tue, 5 Feb 2008 17:28:31 -0300 From: Alvaro Herrera To: Chris Hoover Cc: Bruce Momjian , "pgsql-admin@postgresql.org Admin" Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080205202831.GF6483@alvh.no-ip.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802051953.m15JrgJ00998@momjian.us> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 05 Feb 2008 12:29:10 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/38 X-Sequence-Number: 28112 Chris Hoover escribió: > Ok that's awesome. However, is there any documentation out there > explaining this feature in detail, and how it works, what to expect, etc. ? Implementation documentation: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT?rev=1.2 Perhaps there is a user-level document somewhere. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support From dfontaine@hi-media.com Tue Feb 5 21:13:55 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D8AC42E02A8 for ; Tue, 5 Feb 2008 17:13:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67748-05 for ; Tue, 5 Feb 2008 17:13:50 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id EB9132E01B5 for ; Tue, 5 Feb 2008 17:13:46 -0400 (AST) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by hi-media.com (Postfix) with ESMTP id 6EA791880DF; Tue, 5 Feb 2008 22:11:19 +0100 (CET) From: Dimitri Fontaine To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Date: Tue, 5 Feb 2008 22:13:37 +0100 User-Agent: KMail/1.9.7 Cc: Alvaro Herrera , Chris Hoover , Bruce Momjian References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> In-Reply-To: <20080205202831.GF6483@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2469296.iHBBnY6Ei4"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802052213.41185.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/39 X-Sequence-Number: 28113 --nextPart2469296.iHBBnY6Ei4 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Le Tuesday 05 February 2008 21:28:31 Alvaro Herrera, vous avez =E9crit=A0: > Perhaps there is a user-level document somewhere. I don't think such a document already exists, even rtfm_please doesn't know= =20 about any as of now. So I'll try to begin something here, and depending on= =20 the comments I'll publish a short user oriented HOT introduction article. Here we go... PostgreSQL implements HOT (Heap Only Tuples), a way for the server to limit= =20 the work it has to make when updating tuples. That's what we call an=20 optimization :) PostgreSQL MVCC implementation choice means that updating a tuple create a= =20 entire new version of it and mark the old one as no longer valid (as of the= =20 updating transaction id). Then VACUUM will have to clean out the old=20 reference as soon as possible. Let's not forget that the indexes pointing the the old tuples need to point= to=20 the new version of it as of transaction id. PostgreSQL currently does not=20 save visibility information into the index, though, reducing the janitoring= =20 here. But still, for the index, the operation of updating a tuple is=20 equivalent to a delete and an insert. That's before HOT. Starting with PostgreSQL 8.3, when a tuple is updated and if the update onl= y=20 concerns non-indexed columns, the RDBMS is smart enough for the existing=20 indexes not to need any update at all. This is done by creating a new tuple if possible on the same page as the ol= d=20 one, and maintaining a chain of updated tuples linking a new version to the= =20 old one. An HOT tuple is in fact one that can't be reached from any index.= =20 VACUUM will now only have to prune the tuple versions of the chain that are= =20 no more visible, and as no index were updated (there was no need to), there= 's=20 no VACUUM work to get done on the indexes. Of course, for HOT to work properly, PostgreSQL has now to follow each HOT= =20 chain when SELECT'ing tuples and using an index, but the same amount of=20 tuples version was to be read before HOT too. The difference is that with H= OT=20 the new versions of the HOT-updated tuples are no more reachable via the=20 index directly, so PostgreSQL has to follow the chain when reading the heap. Please comment and correct me if my understanding is wrong (which wouldn't = be=20 a surprise), if this article over simplified, or not really written in=20 English :) I'd like to publish a correct version of this for us to point asking users = to,=20 or maybe it could even end up as official documentation/FAQ material? Regards, =2D-=20 dim --nextPart2469296.iHBBnY6Ei4 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHqNGFlBXRlnbh1bkRAvSsAKCSSDvcTNB57TZEDx97xQ2dPL+m4QCgtlyX 2pvFjn+wW7FSM1c4v+eMx9o= =MGCb -----END PGP SIGNATURE----- --nextPart2469296.iHBBnY6Ei4-- From tgl@sss.pgh.pa.us Tue Feb 5 21:35:59 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1291F2E2DCC for ; Tue, 5 Feb 2008 17:35:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 71237-01 for ; Tue, 5 Feb 2008 17:35:47 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 074482E3F95 for ; Tue, 5 Feb 2008 17:35:50 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m15LZCe8028212; Tue, 5 Feb 2008 16:35:12 -0500 (EST) To: Dimitri Fontaine cc: pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? In-reply-to: <200802052213.41185.dfontaine@hi-media.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> <200802052213.41185.dfontaine@hi-media.com> Comments: In-reply-to Dimitri Fontaine message dated "Tue, 05 Feb 2008 22:13:37 +0100" Date: Tue, 05 Feb 2008 16:35:11 -0500 Message-ID: <28211.1202247311@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/41 X-Sequence-Number: 28115 Dimitri Fontaine writes: > Le Tuesday 05 February 2008 21:28:31 Alvaro Herrera, vous avez écrit : >> Perhaps there is a user-level document somewhere. > I don't think such a document already exists, even rtfm_please doesn't know > about any as of now. The reason there isn't one is it doesn't need one; it's an implementation detail not a user-visible feature. regards, tom lane From dfontaine@hi-media.com Tue Feb 5 22:14:11 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4B3152E0318 for ; Tue, 5 Feb 2008 18:14:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05225-07 for ; Tue, 5 Feb 2008 18:14:03 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id 005222E0300 for ; Tue, 5 Feb 2008 18:14:07 -0400 (AST) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by hi-media.com (Postfix) with ESMTP id A389918807A; Tue, 5 Feb 2008 23:11:40 +0100 (CET) From: Dimitri Fontaine To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Date: Tue, 5 Feb 2008 23:13:59 +0100 User-Agent: KMail/1.9.7 Cc: Tom Lane , Alvaro Herrera , Chris Hoover , Bruce Momjian References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> In-Reply-To: <28211.1202247311@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart9398253.pthyt6xjmU"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802052314.02679.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/43 X-Sequence-Number: 28117 --nextPart9398253.pthyt6xjmU Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez =E9crit=A0: > The reason there isn't one is it doesn't need one; it's an > implementation detail not a user-visible feature. So how do you want us to handle the users questions about how HOT is good f= or=20 them and who'd like to have some insights of its inner working, but don't=20 want to properly learn the internals of PostgreSQL implementation? Such users exist, are (in my POV) sanely curious about this open source=20 product they're using, and HOT has received full marketing lights now. I=20 think we should provide some user-level material about it, and that the fac= t=20 it is not a user-visible feature is not really relevant here. Of course=20 that's only a curious user opinion :) Regards, =2D-=20 dim --nextPart9398253.pthyt6xjmU Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHqN+qlBXRlnbh1bkRAkDpAJ4jbAkOuPSkP3CtBdWYq+UfwX2XvgCglkDZ YbbRo4Gh6DBaWSyrb6b/Yw0= =PQeH -----END PGP SIGNATURE----- --nextPart9398253.pthyt6xjmU-- From jd@commandprompt.com Tue Feb 5 22:26:44 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F3172E3E0E for ; Tue, 5 Feb 2008 18:26:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36109-01-8 for ; Tue, 5 Feb 2008 18:26:38 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 3502A2E4061 for ; Tue, 5 Feb 2008 18:26:13 -0400 (AST) Received: from jd-laptop (cmdalert.com [69.55.229.115]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m15MPp70005479 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 5 Feb 2008 14:25:55 -0800 Date: Tue, 5 Feb 2008 14:25:35 -0800 From: "Joshua D. Drake" To: Dimitri Fontaine Cc: pgsql-admin@postgresql.org, Tom Lane , Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080205142535.12e5c28e@jd-laptop> In-Reply-To: <200802052314.02679.dfontaine@hi-media.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.2.0 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/6SBqg698NcBeYtB3GhbqO0Y"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 05 Feb 2008 14:25:55 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/44 X-Sequence-Number: 28118 --Sig_/6SBqg698NcBeYtB3GhbqO0Y Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, 5 Feb 2008 23:13:59 +0100 Dimitri Fontaine wrote: > Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez =C3=A9crit=C2=A0: > > The reason there isn't one is it doesn't need one; it's an > > implementation detail not a user-visible feature. , Although it is an implementation detail it is certainly a very user-visible detail. It can and will affect how people design their databases to take advantage of the implementation detail. >=20 > So how do you want us to handle the users questions about how HOT is > good for them and who'd like to have some insights of its inner > working, but don't want to properly learn the internals of PostgreSQL > implementation? We need to write a one page mini-HOWTO on taking advantage of HOT and HOTs limitations. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 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 --Sig_/6SBqg698NcBeYtB3GhbqO0Y Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHqOJfATb/zqfZUUQRAsZyAKCC3HVbCKd4mPv9ErWhkZybYAL4DwCdFLHx jEWqiSjb36TNxME4Gt2Irko= =xBJb -----END PGP SIGNATURE----- --Sig_/6SBqg698NcBeYtB3GhbqO0Y-- From tgl@sss.pgh.pa.us Tue Feb 5 22:58:00 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AD85C2E31F0 for ; Tue, 5 Feb 2008 18:58:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 04805-01 for ; Tue, 5 Feb 2008 18:57:52 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 843F02E0290 for ; Tue, 5 Feb 2008 18:57:57 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m15MvVm1029237; Tue, 5 Feb 2008 17:57:32 -0500 (EST) To: "Joshua D. Drake" cc: Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? In-reply-to: <20080205142535.12e5c28e@jd-laptop> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> Comments: In-reply-to "Joshua D. Drake" message dated "Tue, 05 Feb 2008 14:25:35 -0800" Date: Tue, 05 Feb 2008 17:57:31 -0500 Message-ID: <29236.1202252251@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/45 X-Sequence-Number: 28119 "Joshua D. Drake" writes: > Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez écrit : >>> The reason there isn't one is it doesn't need one; it's an >>> implementation detail not a user-visible feature. , > Although it is an implementation detail it is certainly a very > user-visible detail. It can and will affect how people design their > databases to take advantage of the implementation detail. We have no user-facing documentation on TOAST, either, which would seem to me to be at least as much of a candidate for people to custom-design their databases around. In practice I don't think anyone does. regards, tom lane From decibel@decibel.org Wed Feb 6 01:54:05 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9EB042E3020 for ; Tue, 5 Feb 2008 21:54:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 00749-06 for ; Tue, 5 Feb 2008 21:53:54 -0400 (AST) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1CD662E07DD for ; Tue, 5 Feb 2008 21:54:01 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id EB5A856479; Wed, 6 Feb 2008 01:53:59 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 5 Feb 2008 19:53:52 -0600 Date: Tue, 5 Feb 2008 19:53:52 -0600 From: Decibel! To: Tom Lane Cc: "Joshua D. Drake" , Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206015351.GM1212@decibel.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Dv8qlObl6UganL0I" Content-Disposition: inline In-Reply-To: <29236.1202252251@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:080206:tgl@sss.pgh.pa.us::8/7F5J1x7clgMZbn:00000000000000000000 0000000000000000000000004fde X-Hashcash: 1:20:080206:jd@commandprompt.com::/iJMniSzUxEOZ0tt:00000000000000000 00000000000000000000000046m8 X-Hashcash: 1:20:080206:dfontaine@hi-media.com::OY5cbfNV8YBvo7yL:000000000000000 0000000000000000000000000fhU X-Hashcash: 1:20:080206:pgsql-admin@postgresql.org::U9NVdUUkgMcOXVDq:00000000000 000000000000000000000000149d X-Hashcash: 1:20:080206:alvherre@commandprompt.com::UKs40340vkakWRFM:00000000000 000000000000000000000000A0Le X-Hashcash: 1:20:080206:revoohc@gmail.com::1wnmqF5PwiRtd16s:00000000000000000000 0000000000000000000000003hTP X-Hashcash: 1:20:080206:bruce@momjian.us::fTnjuuCycSdgbon2:03FV4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/46 X-Sequence-Number: 28120 --Dv8qlObl6UganL0I Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Feb 05, 2008 at 05:57:31PM -0500, Tom Lane wrote: > "Joshua D. Drake" writes: > > Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez =C3=A9crit=C2= =A0: > >>> The reason there isn't one is it doesn't need one; it's an > >>> implementation detail not a user-visible feature. , >=20 > > Although it is an implementation detail it is certainly a very > > user-visible detail. It can and will affect how people design their > > databases to take advantage of the implementation detail. >=20 > We have no user-facing documentation on TOAST, either, which would seem > to me to be at least as much of a candidate for people to custom-design > their databases around. In practice I don't think anyone does. Uh... http://www.postgresql.org/docs/8.3/interactive/storage-toast.html --=20 Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org=20 Give your computer some brain candy! www.distributed.net Team #1828 --Dv8qlObl6UganL0I Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFHqRMvdO30qud8SkgRAj07AKCNb3E9kAjV3ZJkkDqIT03dbKB3zwCg48mN FF5n71WOvh0PePuLur/swRo= =sIyM -----END PGP SIGNATURE----- --Dv8qlObl6UganL0I-- From tgl@sss.pgh.pa.us Wed Feb 6 03:11:45 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 987202E30B7 for ; Tue, 5 Feb 2008 23:11:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65870-04 for ; Tue, 5 Feb 2008 23:11:43 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8961F2E30B2 for ; Tue, 5 Feb 2008 23:11:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m163BVL0001251; Tue, 5 Feb 2008 22:11:31 -0500 (EST) To: Decibel! cc: "Joshua D. Drake" , Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? In-reply-to: <20080206015351.GM1212@decibel.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> Comments: In-reply-to Decibel! message dated "Tue, 05 Feb 2008 19:53:52 -0600" Date: Tue, 05 Feb 2008 22:11:31 -0500 Message-ID: <1250.1202267491@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/47 X-Sequence-Number: 28121 Decibel! writes: > On Tue, Feb 05, 2008 at 05:57:31PM -0500, Tom Lane wrote: >> We have no user-facing documentation on TOAST, either, which would seem >> to me to be at least as much of a candidate for people to custom-design >> their databases around. In practice I don't think anyone does. > Uh... http://www.postgresql.org/docs/8.3/interactive/storage-toast.html That's developer documentation, buried in the "internals" volume. regards, tom lane From decibel@decibel.org Wed Feb 6 04:54:20 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B95F62E00BC for ; Wed, 6 Feb 2008 00:54:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 22220-08 for ; Wed, 6 Feb 2008 00:54:16 -0400 (AST) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 75DA82E00DD for ; Wed, 6 Feb 2008 00:54:16 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 9D7DD56477; Wed, 6 Feb 2008 04:54:14 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 5 Feb 2008 22:54:06 -0600 Date: Tue, 5 Feb 2008 22:54:06 -0600 From: Decibel! To: Tom Lane Cc: "Joshua D. Drake" , Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206045406.GP1212@decibel.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> <1250.1202267491@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="v+ytF4ERyld7fWQH" Content-Disposition: inline In-Reply-To: <1250.1202267491@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:080206:tgl@sss.pgh.pa.us::FKycil0XFRLP1YDd:00000000000000000000 000000000000000000000000FcDz X-Hashcash: 1:20:080206:jd@commandprompt.com::rvtleQwJEyNkkB3E:00000000000000000 0000000000000000000000002uN9 X-Hashcash: 1:20:080206:dfontaine@hi-media.com::XetSTtf9Rio+ktR/:000000000000000 00000000000000000000000024hG X-Hashcash: 1:20:080206:pgsql-admin@postgresql.org::sA7R7Xznyewfzoog:00000000000 00000000000000000000000052lk X-Hashcash: 1:20:080206:alvherre@commandprompt.com::ZZoGFsfVjLG5iR8z:00000000000 0000000000000000000000002i7f X-Hashcash: 1:20:080206:revoohc@gmail.com::weT0QzT5UbJTz8YJ:00000000000000000000 0000000000000000000000004RKP X-Hashcash: 1:20:080206:bruce@momjian.us::TXOc850e2UmOwV2I:003q2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/48 X-Sequence-Number: 28122 --v+ytF4ERyld7fWQH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Feb 05, 2008 at 10:11:31PM -0500, Tom Lane wrote: > Decibel! writes: > > On Tue, Feb 05, 2008 at 05:57:31PM -0500, Tom Lane wrote: > >> We have no user-facing documentation on TOAST, either, which would seem > >> to me to be at least as much of a candidate for people to custom-design > >> their databases around. In practice I don't think anyone does. >=20 > > Uh... http://www.postgresql.org/docs/8.3/interactive/storage-toast.html >=20 > That's developer documentation, buried in the "internals" volume. Which any serious user will find and read. One of the things that drew me to Postgres years ago was that I could actually read about how it works in a clear, concise manner. --=20 Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org=20 Give your computer some brain candy! www.distributed.net Team #1828 --v+ytF4ERyld7fWQH Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFHqT1udO30qud8SkgRAm5WAKCZz/59DUiFJEiMwGExl3ppNeX4PQCgrPnt Z9Q1MCMuYLN2FZ2dPNhmnmo= =pQXg -----END PGP SIGNATURE----- --v+ytF4ERyld7fWQH-- From jonah.harris@gmail.com Wed Feb 6 05:45:16 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 925EC2E0213 for ; Wed, 6 Feb 2008 01:45:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 27744-09 for ; Wed, 6 Feb 2008 01:45:06 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.233]) by postgresql.org (Postfix) with ESMTP id 057F82E017E for ; Wed, 6 Feb 2008 01:45:07 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so2279315wxc.28 for ; Tue, 05 Feb 2008 21:45:07 -0800 (PST) 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=lTZpZn8YMOPrz90rNEXJrv3FWaNIEU7tZpv2ulHefRw=; b=YEAVLKx3WYx8JOZyhH5rA+DJsopwfzfeCyL81DQf0fdetAUCYJ9mzuwmVVsiu3vQ0Mw+w6lB4kKI3frkU4dhcPNehiXuc7RnTmRqsQzUTSiDLfPik3xgNe17eDhRCM8XjNFiimXE7ksvWx/tPQrRhA48FKBIyWzcYYOxlMbumS0= 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=rhupCjGIozvqr4itNA3nVpWMAY88R7D7551snfcF+fNZ8JOFK2hPu1Egdw0aNZYEOzBadk9rmcsWEIYs/agq+OW1lBOP9Mn2EtG+r/ES05JWqnWuKCTP/0t48WQmLhVN2tebhbRO0sodUVI24qqx8fSxMH4TqjSUtUYOERP66Zw= Received: by 10.142.131.18 with SMTP id e18mr4943171wfd.39.1202276706600; Tue, 05 Feb 2008 21:45:06 -0800 (PST) Received: by 10.143.53.4 with HTTP; Tue, 5 Feb 2008 21:45:06 -0800 (PST) Message-ID: <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> Date: Wed, 6 Feb 2008 00:45:06 -0500 From: "Jonah H. Harris" To: Decibel! Subject: Re: Where to find information on the new HOT tables? Cc: "Tom Lane" , "Joshua D. Drake" , "Dimitri Fontaine" , pgsql-admin@postgresql.org, "Alvaro Herrera" , "Chris Hoover" , "Bruce Momjian" In-Reply-To: <20080206045406.GP1212@decibel.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> <1250.1202267491@sss.pgh.pa.us> <20080206045406.GP1212@decibel.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/49 X-Sequence-Number: 28123 On Feb 5, 2008 11:54 PM, Decibel! wrote: > One of the things that drew me to Postgres years ago was that I could > actually read about how it works in a clear, concise manner. Agreed. -- 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/ From tgl@sss.pgh.pa.us Wed Feb 6 06:16:39 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A8D3E2E4248 for ; Wed, 6 Feb 2008 02:16:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00814-05 for ; Wed, 6 Feb 2008 02:16:36 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9921B2E4168 for ; Wed, 6 Feb 2008 02:16:36 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m166GUHe002828; Wed, 6 Feb 2008 01:16:30 -0500 (EST) To: "Jonah H. Harris" cc: Decibel! , "Joshua D. Drake" , "Dimitri Fontaine" , pgsql-admin@postgresql.org, "Alvaro Herrera" , "Chris Hoover" , "Bruce Momjian" Subject: Re: Where to find information on the new HOT tables? In-reply-to: <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> <1250.1202267491@sss.pgh.pa.us> <20080206045406.GP1212@decibel.org> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> Comments: In-reply-to "Jonah H. Harris" message dated "Wed, 06 Feb 2008 00:45:06 -0500" Date: Wed, 06 Feb 2008 01:16:30 -0500 Message-ID: <2827.1202278590@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/50 X-Sequence-Number: 28124 "Jonah H. Harris" writes: > On Feb 5, 2008 11:54 PM, Decibel! wrote: >> One of the things that drew me to Postgres years ago was that I could >> actually read about how it works in a clear, concise manner. > Agreed. Not sure how you could argue "concise" as a benefit here. There are literally thousands of aspects of the PG codebase that could impact performance in user-visible ways. Most of them are not documented in the SGML docs. If we tried to expose all that, the docs would become completely unreadable. (I just got done reading some slashdot griping about how our docs are already too long and too complicated for novices, so I'm not feeling particularly charitable about proposals to dump even more seldom-useful details into them.) I'm really not seeing the case for user-level documentation of HOT, when for instance most of the planner's optimization behavior is not so documented. regards, tom lane From mbertheau.pg@googlemail.com Wed Feb 6 07:17:04 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9266F2E3EAC for ; Wed, 6 Feb 2008 03:17:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30493-03 for ; Wed, 6 Feb 2008 03:17:00 -0400 (AST) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.191]) by postgresql.org (Postfix) with ESMTP id A426B2E3EB5 for ; Wed, 6 Feb 2008 03:17:00 -0400 (AST) Received: by rv-out-0910.google.com with SMTP id g13so2058243rvb.43 for ; Tue, 05 Feb 2008 23:16:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.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=wV6U2uXboe5thtM40GUUol3dwKR792qGBFaEAfHK/LU=; b=t0BfFCvQQj+yNFUths4f50Ol4KMic/GiSm5NXqCIXI98G66YnMRVsrZKBkX6lSUfyE+OwYrBbbYnA8X7VuO3SpkIb+P/eVnZ4mkAVNXlq/rzksXFqgEeHkwRxidJo9TDSbXjR4RlmOPwaZnH9G72+J3FIDNARb0uh4w4iekpZjA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.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=pc+H6/g6vsvvyS3FpJ6WXkAo9+27ANIRrdliCSqeP5qIsnJXZwoKm3COYBZIMs13gabyzbONErbPqMcc0yzpAF2nZqqbyW/ZLRjG2newGQP6hOv6BGOXeyLXjoMq48dwQr63RMEJ7N75XuVMPjB6MLTaA0W20vRJTvcwgpFUG54= Received: by 10.141.83.15 with SMTP id k15mr6378414rvl.120.1202282219478; Tue, 05 Feb 2008 23:16:59 -0800 (PST) Received: by 10.141.169.5 with HTTP; Tue, 5 Feb 2008 23:16:59 -0800 (PST) Message-ID: <684362e10802052316w50d34c0n20262dfef4f7a06c@mail.gmail.com> Date: Wed, 6 Feb 2008 13:16:59 +0600 From: "Markus Bertheau" To: "Tom Lane" Subject: Re: Where to find information on the new HOT tables? Cc: "Jonah H. Harris" , Decibel! , "Joshua D. Drake" , "Dimitri Fontaine" , pgsql-admin@postgresql.org, "Alvaro Herrera" , "Chris Hoover" , "Bruce Momjian" In-Reply-To: <2827.1202278590@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> <1250.1202267491@sss.pgh.pa.us> <20080206045406.GP1212@decibel.org> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/51 X-Sequence-Number: 28125 2008/2/6, Tom Lane : > I'm really not seeing the case for user-level documentation of HOT, > when for instance most of the planner's optimization behavior is not > so documented. Actually that would be very useful information. Questions like how is cost calculated, how are joins ordered, which kinds of subselects are pulled up to the outer query and so on are quite essential when optimizing queries and understanding query plans. Also more detailed information on how to tune the various performance parameters for bg_writer, autovacuum, checkpointing and so on would be useful in my opinion. I find the current manual very useful and the fact that it's 2000 pages doesn't make it any less useful. Markus From dfontaine@hi-media.com Wed Feb 6 09:39:45 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 341B82E3AC6 for ; Wed, 6 Feb 2008 05:39:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59456-03-3 for ; Wed, 6 Feb 2008 05:39:34 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id DF79F2E3E72 for ; Wed, 6 Feb 2008 05:11:16 -0400 (AST) Received: from dim (gut75-1-81-57-27-121.fbx.proxad.net [81.57.27.121]) by hi-media.com (Postfix) with ESMTP id 6371618807A; Wed, 6 Feb 2008 10:08:47 +0100 (CET) From: Dimitri Fontaine Organization: Hi-Media To: Tom Lane Subject: Re: Where to find information on the new HOT tables? Date: Wed, 6 Feb 2008 10:11:09 +0100 User-Agent: KMail/1.9.7 Cc: "Jonah H. Harris" , Decibel! , "Joshua D. Drake" , pgsql-admin@postgresql.org, "Alvaro Herrera" , "Chris Hoover" , "Bruce Momjian" References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> In-Reply-To: <2827.1202278590@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart6573818.E74r5SsFfP"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802061011.11929.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/53 X-Sequence-Number: 28127 --nextPart6573818.E74r5SsFfP Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le mercredi 06 f=C3=A9vrier 2008, Tom Lane a =C3=A9crit=C2=A0: > I'm really not seeing the case for user-level documentation of HOT, > when for instance most of the planner's optimization behavior is not > so documented. In my POV, the case for HOT to appear in the documentation as been made by = the=20 PR and Presskit. They both announce HOT to be a major performance addition = in=20 8.3 that users will want to benefit from. Now we have to tell some more to= =20 the users, I think we want to answer those two basic questions:=20 - How do I check that I'm using HOT? (you don't, transparent feature, blah) - What's HOT is so good about compared to how PostgreSQL used to work? My proposal was about answering this without requiring the user to be capab= le=20 of understanding internals and 'developer topics'. If you want me to talk about another documentation missing entry, I'll be=20 happy to request a user targetted presentation of Executor Nodes, their inp= ut=20 and output, relative costs (simplified algorithms?) and the reason behind=20 their choice by the planner. I'm slowly becoming familiar with their names,= a=20 little more each time I Explain [Analyze] a query, but not enough so to yet= =20 be able to sketch an article about this... I'd also like to add that people judging documentation effectiveness by its= =20 length are certainly not real users of it. I've yet to meet a PostgreSQL us= er=20 who doesn't praise the product documentation, even if newcomers often need= =20 some time to be able to understand where to find what. The Tsearch enabled= =20 website has been a huge improvement here. To ease PostgreSQL newbies manual grasping, I certainly don't think it will= =20 need shortening the documentation. Once more, all of this is only a enthusiastic user POV, the kind who think= =20 he's helping when writing this mail ;) =2D-=20 dim --nextPart6573818.E74r5SsFfP Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHqXmvlBXRlnbh1bkRAjQZAKCWJaRGPSngnrZKBKtojZKSCZKxXACgqa6l CmRmExmAPKdWZzIfhfDvc5E= =zQb/ -----END PGP SIGNATURE----- --nextPart6573818.E74r5SsFfP-- From guillaume@lelarge.info Wed Feb 6 09:41:33 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EA6BA2E47C3 for ; Wed, 6 Feb 2008 05:41:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66087-01 for ; Wed, 6 Feb 2008 05:41:11 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id DF1042E327E for ; Wed, 6 Feb 2008 05:27:52 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-10-117.w83-112.abo.wanadoo.fr [83.112.72.117]) by sd-2317.dedibox.fr (Postfix) with ESMTP id 538FAA223; Wed, 6 Feb 2008 10:27:45 +0100 (CET) Message-ID: <47A97D90.1010607@lelarge.info> Date: Wed, 06 Feb 2008 10:27:44 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: Tom Lane CC: "Jonah H. Harris" , "Decibel!" , "Joshua D. Drake" , Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> <20080206015351.GM1212@decibel.org> <1250.1202267491@sss.pgh.pa.us> <20080206045406.GP1212@decibel.org> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> In-Reply-To: <2827.1202278590@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/55 X-Sequence-Number: 28129 Tom Lane wrote: > "Jonah H. Harris" writes: >> On Feb 5, 2008 11:54 PM, Decibel! wrote: >>> One of the things that drew me to Postgres years ago was that I could >>> actually read about how it works in a clear, concise manner. > >> Agreed. > > Not sure how you could argue "concise" as a benefit here. > > There are literally thousands of aspects of the PG codebase that could > impact performance in user-visible ways. Most of them are not > documented in the SGML docs. If we tried to expose all that, the docs > would become completely unreadable. (I just got done reading some > slashdot griping about how our docs are already too long and too > complicated for novices, so I'm not feeling particularly charitable > about proposals to dump even more seldom-useful details into them.) > That's something we hear on booths too. Someone, at Solutions Linux 2008, told me the manual is great but not that easy to begin with. He reads Sébastien Lardière's french book on PostgreSQL and finds it more convenient for him. And now he needs something more advanced but still not the manual... problem is, he's not able to explain why he doesn't like our current manual. > I'm really not seeing the case for user-level documentation of HOT, > when for instance most of the planner's optimization behavior is not > so documented. > A user level, no. But an advanced/developper level documentation would be greatly appreciated. Really, I found our manual great. I've read it many times, I've translated it, I think I know it a bit. But I think a 1500 pages manual is a bit too much for a beginner. It kind of afraids them. And it may not be enough for advanced users. Drawing the line between not enough and too much is not that easy. But I'm sure there's work to do on the documentation front. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com From postgresql@tisc.de Wed Feb 6 10:20:19 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2E6BC2E0077 for ; Wed, 6 Feb 2008 06:20:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16205-08 for ; Wed, 6 Feb 2008 06:20:11 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id A0CC62E0057 for ; Wed, 6 Feb 2008 06:20:10 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 86D14B289B for ; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id j8N0q-O7j4AA for ; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 751F6B2675; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Date: Wed, 6 Feb 2008 11:20:08 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206102008.GD16997@easy2.in-chemnitz.de> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> <200802061011.11929.dfontaine@hi-media.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200802061011.11929.dfontaine@hi-media.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/56 X-Sequence-Number: 28130 Hi there, On Wed, Feb 06, 2008 at 10:11:09AM +0100, Dimitri Fontaine wrote: > > I'm really not seeing the case for user-level documentation of HOT, > > when for instance most of the planner's optimization behavior is not > > so documented. > > In my POV, the case for HOT to appear in the documentation as been made by the > PR and Presskit. They both announce HOT to be a major performance addition in > 8.3 that users will want to benefit from. Now we have to tell some more to > the users, I think we want to answer those two basic questions: > - How do I check that I'm using HOT? (you don't, transparent feature, blah) > - What's HOT is so good about compared to how PostgreSQL used to work? > > My proposal was about answering this without requiring the user to be capable > of understanding internals and 'developer topics'. Which might be pretty difficult, if it's an internal feature. But a short HOT-FAQ would be great, something like this: - What is HOT? ... - How do I exploit it? Make sure that ... - When will HOT kick in? If ... and ... and ... > I'd also like to add that people judging documentation effectiveness by its > length are certainly not real users of it. I've yet to meet a PostgreSQL user > who doesn't praise the product documentation, even if newcomers often need > some time to be able to understand where to find what. The Tsearch enabled > website has been a huge improvement here. Yes, I praise it, too! Even though it needs some reading and thinking and reading and thinking to understand, e.g. the internals of VACUUM or freeze_max_age etc., the documentation is very helpful to understand what's going on. > To ease PostgreSQL newbies manual grasping, I certainly don't think it will > need shortening the documentation. Maybe there could be quickstart chapters or HOWTOs. Bye, Tino. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz From adamtaunowilliams@gmail.com Wed Feb 6 13:42:45 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C71BF2E30CF for ; Wed, 6 Feb 2008 09:42:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 52836-02 for ; Wed, 6 Feb 2008 09:42:34 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id 8017C2E2368 for ; Wed, 6 Feb 2008 09:42:41 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so2912272wri.5 for ; Wed, 06 Feb 2008 05:42:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; bh=lqI+Yq+ZzWgAckmRTfXbwOBG/N+U5YZfmzFJFK53G0s=; b=KEeb4osrqwzYfErPqFUfCArcf6OmKqqnaVuBPNXaz6ufEOzWEArJky7CRPnZ63vr2uiMgy0aTnXev5P7uOW5U/hhogW9WkpV56tnB8bfhekz97n26VkCPlgNa3KYDIbVdlt/LM6x4QK8EcsSDl1CdRXBgmftk/deLitb8KMtDzk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=urCqJidQm9BiT88cP2CjZlKsD8201bv1qk8+m55+SsoZur5zcPPjyUo/oqE59Vpx5HTep53lTOYwdeXNh4oCGS9IgI7WJ1zxKI0lkmNfKsqQuP4FGCKlIYqw3K4Pp2a9fJum+LRsypNalvTGFZmRWXyoLIv0vfzFuJu8deG7NPA= Received: by 10.142.212.19 with SMTP id k19mr5223711wfg.224.1202305359313; Wed, 06 Feb 2008 05:42:39 -0800 (PST) Received: from ?192.168.1.212? ( [206.114.45.107]) by mx.google.com with ESMTPS id n44sm28514528pyh.26.2008.02.06.05.42.38 (version=SSLv3 cipher=RC4-MD5); Wed, 06 Feb 2008 05:42:38 -0800 (PST) Subject: Re: Where to find information on the new HOT tables? From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-admin In-Reply-To: <200802061011.11929.dfontaine@hi-media.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> <200802061011.11929.dfontaine@hi-media.com> Content-Type: text/plain Date: Wed, 06 Feb 2008 08:43:32 -0500 Message-Id: <1202305412.5753.13.camel@WM_ADAM1.morrison.iserv.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/58 X-Sequence-Number: 28132 > I'd also like to add that people judging documentation effectiveness by its > length are certainly not real users of it. I've yet to meet a PostgreSQL user > who doesn't praise the product documentation, even if newcomers often need > some time to be able to understand where to find what. The Tsearch enabled > website has been a huge improvement here. > To ease PostgreSQL newbies manual grasping, I certainly don't think it will > need shortening the documentation. Agree, 125%. There are quick start guides for newbies, and a quadrillion goofy little howtos (although I've come to have some contempt for the whole "howto" category). I chose PostgreSQL over that-other-database because it had useful documentation and smelled like a "real" database. I'm also an Informix/DB2 DBA and I think the documentation is very good, there can't be too much documentation so anyone judging on length just needs to be dope-slapped. [And I've personally used the TOAST section to tune a database that uses lots of large values]. The current manual is divided into sections, including a tutorial so I just don't see any grounds for a complexity complaint at all. A new user should, of course, wade into the "System Administration" section with some sense of trepidation. My experience [now extensive] with users of that-other-database is that they will *ALWAYS* claim *ANYTHING* else is too complicated [most of them have never used anything else] before starting to explain why they have two storage backends and the merits between MyISAM and InnoDb; Sheeesh! It is important to distinguish between informed criticism and the triumvirate of laziness, fanboy FUD, and outright whining. OTOH, I think a paragraph explaining how HOT causes performance to differ from previous versions would be sufficient. It isn't really a user, or even an admin, tunable AFAIK. It is just an inherent good in the current version - but since it was mentioned allot in release announcements it merits some mention in the docs. Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org From alvherre@commandprompt.com Wed Feb 6 15:42:05 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9053A2E309C for ; Wed, 6 Feb 2008 11:42:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23712-01 for ; Wed, 6 Feb 2008 11:41:53 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 60A492E2E5B for ; Wed, 6 Feb 2008 11:41:52 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-28-116.bk17-dsl.surnet.cl [190.95.28.116]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m16Ff8fn021299 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 6 Feb 2008 07:41:16 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id AC15E47BED; Wed, 6 Feb 2008 12:40:22 -0300 (CLST) Date: Wed, 6 Feb 2008 12:40:22 -0300 From: Alvaro Herrera To: Tom Lane Cc: Dimitri Fontaine , pgsql-admin@postgresql.org, Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206154022.GB17371@alvh.no-ip.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <28211.1202247311@sss.pgh.pa.us> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 06 Feb 2008 07:41:17 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/60 X-Sequence-Number: 28134 Tom Lane escribió: > Dimitri Fontaine writes: > > Le Tuesday 05 February 2008 21:28:31 Alvaro Herrera, vous avez écrit : > >> Perhaps there is a user-level document somewhere. > > > I don't think such a document already exists, even rtfm_please doesn't know > > about any as of now. > > The reason there isn't one is it doesn't need one; it's an > implementation detail not a user-visible feature. One reason to think it needs to be explained is that it affects how you plan for VACUUM. In tables where HOT is in charge of a large part of cleanup, you need to do a lot less vacuuming than you were for 8.2. In that sense it is very much user-visible. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. From adamtaunowilliams@gmail.com Wed Feb 6 16:06:48 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 341302E456E for ; Wed, 6 Feb 2008 12:06:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31551-01 for ; Wed, 6 Feb 2008 12:06:45 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id 05BE12E4645 for ; Wed, 6 Feb 2008 12:06:20 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d37so5175948pye.29 for ; Wed, 06 Feb 2008 08:06:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; bh=+Wx1LLU7+mxNzoduGMqiiApxm8/kZ63o7ei/2i0vEys=; b=ZTckWldMy7Ux+kVwChyGZPmytcB329qnn89Rkd20gY1F9km3Sd19YbcekW7pFzIjIwuswybGLWkrn+zloqSACAs/leVQRvPjk/Ii6ko1tvDKEiRI0JS0EUOlvZdV+unyja2AU7j0vBTyFy3pvDfjCZ3Ndn6kTyFmp6MAB/mWw5U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=WbHdaC11Fv1ZGgc9Y+DcO9x8+9gX2UPUMpqqE3Io+svPXGOS1oCcZh23mvZCDTqStJmMBW42M+f4gd5Q27jSpqDxn/E6EEd3g9eVRQUjsZCLV/rmZ2skMN33tMFsfs83Arl+1oT5GRjuELv7HhILlA04PDpsKH7M1qGoxHUoC1k= Received: by 10.35.22.12 with SMTP id z12mr6697517pyi.42.1202313980228; Wed, 06 Feb 2008 08:06:20 -0800 (PST) Received: from ?192.168.1.212? ( [206.114.45.107]) by mx.google.com with ESMTPS id f77sm29122247pyh.32.2008.02.06.08.06.19 (version=SSLv3 cipher=RC4-MD5); Wed, 06 Feb 2008 08:06:19 -0800 (PST) Subject: Re: Where to find information on the new HOT tables? From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-admin In-Reply-To: <20080206154022.GB17371@alvh.no-ip.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <20080206154022.GB17371@alvh.no-ip.org> Content-Type: text/plain Date: Wed, 06 Feb 2008 11:07:14 -0500 Message-Id: <1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/61 X-Sequence-Number: 28135 > > > I don't think such a document already exists, even rtfm_please doesn't know > > > about any as of now. > > The reason there isn't one is it doesn't need one; it's an > > implementation detail not a user-visible feature. > One reason to think it needs to be explained is that it affects how you > plan for VACUUM. In tables where HOT is in charge of a large part of > cleanup, you need to do a lot less vacuuming than you were for 8.2. In > that sense it is very much user-visible. Wouldn't the thresholds in the auto-vaccuming make that adjustment transparent? From alvherre@commandprompt.com Wed Feb 6 16:12:47 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6EF9E2E35F8 for ; Wed, 6 Feb 2008 12:12:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 24559-02 for ; Wed, 6 Feb 2008 12:12:42 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 2FD9A2E444F for ; Wed, 6 Feb 2008 12:12:41 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-28-116.bk17-dsl.surnet.cl [190.95.28.116]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m16GCE6U022469 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 6 Feb 2008 08:12:57 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 66E1747BEC; Wed, 6 Feb 2008 13:12:02 -0300 (CLST) Date: Wed, 6 Feb 2008 13:12:02 -0300 From: Alvaro Herrera To: Adam Tauno Williams Cc: pgsql-admin Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206161202.GC17371@alvh.no-ip.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <20080206154022.GB17371@alvh.no-ip.org> <1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 06 Feb 2008 08:12:57 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/62 X-Sequence-Number: 28136 Adam Tauno Williams escribió: > > > > I don't think such a document already exists, even rtfm_please doesn't know > > > > about any as of now. > > > The reason there isn't one is it doesn't need one; it's an > > > implementation detail not a user-visible feature. > > One reason to think it needs to be explained is that it affects how you > > plan for VACUUM. In tables where HOT is in charge of a large part of > > cleanup, you need to do a lot less vacuuming than you were for 8.2. In > > that sense it is very much user-visible. > > Wouldn't the thresholds in the auto-vaccuming make that adjustment > transparent? For people that use autovacuum, yes, it would, but not everybody does. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support From hg@terma.com Thu Feb 7 08:58:27 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9574E2E34D3 for ; Thu, 7 Feb 2008 04:58:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26332-06 for ; Thu, 7 Feb 2008 04:58:17 -0400 (AST) Received: from asgaard.lystrup.terma.com (asgaard.lystrup.terma.com [193.163.1.112]) by postgresql.org (Postfix) with ESMTP id ADFA52E34DE for ; Thu, 7 Feb 2008 04:58:20 -0400 (AST) Received: from exch-fe.terma.com (localhost.localdomain [127.0.0.1]) by asgaard.lystrup.terma.com (8.13.5/8.12.8) with ESMTP id m178wI2Y018976 for ; Thu, 7 Feb 2008 09:58:18 +0100 Received: from exch-be.terma.com ([172.20.5.32]) by exch-fe.terma.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 7 Feb 2008 09:58:18 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Where to find information on the new HOT tables? Date: Thu, 7 Feb 2008 09:58:17 +0100 Message-ID: <85978993146E1A4AA9CC4B2945CAFC940258348E@exch-be.terma.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Re: Where to find information on the new HOT tables? Thread-Index: AchpZ5Rfp837gbhfRRK0EeNuz9YzzQ== From: "Hans Guijt" To: X-OriginalArrivalTime: 07 Feb 2008 08:58:18.0187 (UTC) FILETIME=[94F7B9B0:01C86967] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200802/73 X-Sequence-Number: 28147 On the subject of documentation I'd like to say this: I find PostgreSQL's documentation to be truly excellent (both in accessibility and depth), and it is one of the main reasons why we use PostgreSQL in our projects (the quality of the software itself is of course the other reason).=20 I certainly wouldn't mind explanations of 'internal' features on a user level; as others have stated, this may be helpful in understanding the output of EXPLAIN, as a means of building better databases, or even just because we are interested but not quite so much that we want to read source code. And I agree with earlier posters that, now that HOT has been pushed as a great new feature, it should be properly explained.=20 People who complain about the PostgreSQL documentation need to wake up: the documentation of PostgreSQL is one of the best, if not the best, I've ever seen for an open source project, and other projects should take it as a shining example of how things should be done.=20 Hans Guijt From michael.monnerie@it-management.at Thu Feb 7 15:53:04 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 54CBC2E02A1 for ; Thu, 7 Feb 2008 11:53:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 34535-07 for ; Thu, 7 Feb 2008 11:52:31 -0400 (AST) Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by postgresql.org (Postfix) with ESMTP id C49042E006C for ; Thu, 7 Feb 2008 11:52:40 -0400 (AST) Received: from mailsrv.i.zmi.at (85-125-129-125.neutorgasse.xdsl-line.inode.at [85.125.129.125]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mailsrv.i.zmi.at", Issuer "mailsrv.i.zmi.at" (not verified)) by mailsrv1.zmi.at (Postfix) with ESMTP id 868DACD7 for ; Thu, 7 Feb 2008 16:52:36 +0100 (CET) Received: from saturn.i.zmi.at (saturn.i.zmi.at [10.0.0.2]) by mailsrv.i.zmi.at (Postfix) with ESMTP id BF3FFBF0A for ; Thu, 7 Feb 2008 16:52:41 +0100 (CET) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Date: Thu, 7 Feb 2008 16:52:35 +0100 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) References: <85978993146E1A4AA9CC4B2945CAFC940258348E@exch-be.terma.com> In-Reply-To: <85978993146E1A4AA9CC4B2945CAFC940258348E@exch-be.terma.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1873110.HoxAOvCese"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802071652.36258@zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/76 X-Sequence-Number: 28150 --nextPart1873110.HoxAOvCese Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I let Hans' full e-mail quoted here because it's absolutely true: It's=20 the best documentation available, and that's why we always preferred=20 PostgreSQL over that other - ehrm - "database" MySQL. And of course=20 because it's really a DB ;-) And yes, I'd love even more docu for EXPLAIN, and howto optimize the DB=20 in general. Can there ever be enough detail? Those who don't understand=20 it don't have to read it. mfg zmi On Donnerstag, 7. Februar 2008 Hans Guijt wrote: > On the subject of documentation I'd like to say this: I find > PostgreSQL's documentation to be truly excellent (both in > accessibility and depth), and it is one of the main reasons why we > use PostgreSQL in our projects (the quality of the software itself is > of course the other reason). > > I certainly wouldn't mind explanations of 'internal' features on a > user level; as others have stated, this may be helpful in > understanding the output of EXPLAIN, as a means of building better > databases, or even just because we are interested but not quite so > much that we want to read source code. And I agree with earlier > posters that, now that HOT has been pushed as a great new feature, it > should be properly explained. > > People who complain about the PostgreSQL documentation need to wake > up: the documentation of PostgreSQL is one of the best, if not the > best, I've ever seen for an open source project, and other projects > should take it as a shining example of how things should be done. =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4 --nextPart1873110.HoxAOvCese Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQBHqylEzhSR9xwSCbQRAl15AJ9cOSece5ESyDaEDuuURkOopDgmhACfVrQ2 YgNhlFb5XiN2el5YSpcvxjg= =BRWh -----END PGP SIGNATURE----- --nextPart1873110.HoxAOvCese-- From dfontaine@hi-media.com Thu Feb 7 19:01:28 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 586A52E3E43 for ; Thu, 7 Feb 2008 15:01:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73439-06-3 for ; Thu, 7 Feb 2008 15:01:19 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id 68C802E3A29 for ; Thu, 7 Feb 2008 15:01:21 -0400 (AST) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by hi-media.com (Postfix) with ESMTP id 877AC2D089B; Thu, 7 Feb 2008 19:58:49 +0100 (CET) From: Dimitri Fontaine To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Date: Thu, 7 Feb 2008 20:01:12 +0100 User-Agent: KMail/1.9.7 Cc: Alvaro Herrera , Chris Hoover , Bruce Momjian References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <20080205202831.GF6483@alvh.no-ip.org> <200802052213.41185.dfontaine@hi-media.com> In-Reply-To: <200802052213.41185.dfontaine@hi-media.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart3761711.embAPGQIDh"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802072001.15100.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/78 X-Sequence-Number: 28152 --nextPart3761711.embAPGQIDh Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi, Le Tuesday 05 February 2008 22:13:37 Dimitri Fontaine, vous avez =E9crit=A0: > the comments I'll publish a short user oriented HOT introduction article. > Here we go... I don't think there was anythink like a consensus about the opportunity to= =20 publish a user-level presentation of HOT in the FAQ or any other official=20 documentation, and I still think we'll keep getting users questions about i= t,=20 with good reason for them to ask, so: http://pgsql.tapoueh.org/site/html/misc/hot.html > Please comment and correct me if my understanding is wrong (which wouldn't > be a surprise), if this article over simplified, or not really written in > English :) Regards, =2D-=20 dim --nextPart3761711.embAPGQIDh Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHq1V7lBXRlnbh1bkRAgWhAKCG/OxRm4AHir4GdYud8QngGL+joACgsv3z OubrEwZ5CX6vnXwojHVTVOQ= =fhuX -----END PGP SIGNATURE----- --nextPart3761711.embAPGQIDh-- From bruce@momjian.us Thu Feb 7 19:44:33 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A21AB2E439F for ; Thu, 7 Feb 2008 15:44:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72188-05 for ; Thu, 7 Feb 2008 15:44:30 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id CEEAC2E4394 for ; Thu, 7 Feb 2008 15:44:28 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m17Jhva22531; Thu, 7 Feb 2008 14:43:57 -0500 (EST) From: Bruce Momjian Message-Id: <200802071943.m17Jhva22531@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <200802072001.15100.dfontaine@hi-media.com> To: Dimitri Fontaine Date: Thu, 7 Feb 2008 14:43:57 -0500 (EST) CC: pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/79 X-Sequence-Number: 28153 Dimitri Fontaine wrote: -- Start of PGP signed section. > Hi, > > Le Tuesday 05 February 2008 22:13:37 Dimitri Fontaine, vous avez ?crit?: > > the comments I'll publish a short user oriented HOT introduction article. > > Here we go... > > I don't think there was anythink like a consensus about the opportunity to > publish a user-level presentation of HOT in the FAQ or any other official > documentation, and I still think we'll keep getting users questions about it, > with good reason for them to ask, so: > http://pgsql.tapoueh.org/site/html/misc/hot.html Does the release note item on HOT need additions? -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From dfontaine@hi-media.com Thu Feb 7 20:00:31 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8FE5B2E1891 for ; Thu, 7 Feb 2008 16:00:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06258-03 for ; Thu, 7 Feb 2008 16:00:28 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id E6ABC2E420A for ; Thu, 7 Feb 2008 16:00:27 -0400 (AST) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by hi-media.com (Postfix) with ESMTP id 7DB2E1D0275; Thu, 7 Feb 2008 20:57:57 +0100 (CET) From: Dimitri Fontaine To: Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Date: Thu, 7 Feb 2008 21:00:17 +0100 User-Agent: KMail/1.9.7 Cc: pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover References: <200802071943.m17Jhva22531@momjian.us> In-Reply-To: <200802071943.m17Jhva22531@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2357239.liu2zKuPnF"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802072100.20093.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/80 X-Sequence-Number: 28154 --nextPart2357239.liu2zKuPnF Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le Thursday 07 February 2008 20:43:57 Bruce Momjian, vous avez =E9crit=A0: > Does the release note item on HOT need additions? If I put the release not item on HOT here: =2D=3D-=3D-=3D- Heap-Only Tuples (HOT) accelerate space reuse for most UPDATEs and DELETEs= =20 (Pavan Deolasee, with ideas from many others)=20 UPDATEs and DELETEs leave dead tuples behind, as do failed INSERTs. Previou= sly=20 only VACUUM could reclaim space taken by dead tuples. With HOT dead tuple=20 space can be reclaimed at the time of INSERT or UPDATE if no changes are ma= de=20 to indexed columns. This allows for more consistent performance. Also, HOT= =20 avoids adding duplicate index entries. =2D=3D-=3D-=3D- I'd say it only misses the transparent & automatic precision, telling the=20 users they don't have anything to do about HOT: PostgreSQL is able on its o= wn=20 to decide when HOT is or is not safe to use. And I have to get it back that documentation is not verbose enough about ho= w=20 HOT is working, just that you have to know where to look... What about Alvaro's concern about manual vacuuming policies editing wrt to= =20 HOT? Regards, =2D-=20 dim --nextPart2357239.liu2zKuPnF Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHq2NUlBXRlnbh1bkRAnCwAJ9Vv2n0X/Lne+ffjdg6St2NYFvK2wCffKe5 ZJUfqjPOE4pNc+8Pw5/EG3g= =6Yd+ -----END PGP SIGNATURE----- --nextPart2357239.liu2zKuPnF-- From bruce@momjian.us Thu Feb 7 22:32:15 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D47482E0254 for ; Thu, 7 Feb 2008 18:32:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 38208-02-3 for ; Thu, 7 Feb 2008 18:32:11 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id DA2412E02CA for ; Thu, 7 Feb 2008 18:31:42 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m17MVBZ18035; Thu, 7 Feb 2008 17:31:11 -0500 (EST) From: Bruce Momjian Message-Id: <200802072231.m17MVBZ18035@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <200802072100.20093.dfontaine@hi-media.com> To: Dimitri Fontaine Date: Thu, 7 Feb 2008 17:31:11 -0500 (EST) CC: pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/81 X-Sequence-Number: 28155 Dimitri Fontaine wrote: -- Start of PGP signed section. > Le Thursday 07 February 2008 20:43:57 Bruce Momjian, vous avez ?crit?: > > Does the release note item on HOT need additions? > > If I put the release not item on HOT here: > > -=-=-=- > Heap-Only Tuples (HOT) accelerate space reuse for most UPDATEs and DELETEs > (Pavan Deolasee, with ideas from many others) > > UPDATEs and DELETEs leave dead tuples behind, as do failed INSERTs. Previously > only VACUUM could reclaim space taken by dead tuples. With HOT dead tuple > space can be reclaimed at the time of INSERT or UPDATE if no changes are made ^^^ > to indexed columns. This allows for more consistent performance. Also, HOT > avoids adding duplicate index entries. > -=-=-=- OK, what I did was to add the word "automatically" at the location indicated. Hopefully that will help. > I'd say it only misses the transparent & automatic precision, telling the > users they don't have anything to do about HOT: PostgreSQL is able on its own > to decide when HOT is or is not safe to use. > And I have to get it back that documentation is not verbose enough about how > HOT is working, just that you have to know where to look... > > What about Alvaro's concern about manual vacuuming policies editing wrt to > HOT? I think most people will be using autovacuum, and those who aren't will have to realize that HOT makes vacuuming less needed. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From alvherre@commandprompt.com Thu Feb 7 23:49:58 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 761D92E4179 for ; Thu, 7 Feb 2008 19:49:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 91037-09 for ; Thu, 7 Feb 2008 19:49:48 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 84F352E4187 for ; Thu, 7 Feb 2008 19:49:54 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-28-116.bk17-dsl.surnet.cl [190.95.28.116]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m17NmdxV016450 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 7 Feb 2008 15:48:47 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 8D1EA47BEB; Thu, 7 Feb 2008 20:48:44 -0300 (CLST) Date: Thu, 7 Feb 2008 20:48:44 -0300 From: Alvaro Herrera To: Bruce Momjian Cc: Dimitri Fontaine , pgsql-admin@postgresql.org, Chris Hoover Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080207234844.GH23336@alvh.no-ip.org> References: <200802072100.20093.dfontaine@hi-media.com> <200802072231.m17MVBZ18035@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200802072231.m17MVBZ18035@momjian.us> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 07 Feb 2008 15:48:48 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/83 X-Sequence-Number: 28157 Bruce Momjian escribió: > Dimitri Fontaine wrote: > > What about Alvaro's concern about manual vacuuming policies editing wrt to > > HOT? > > I think most people will be using autovacuum, and those who aren't will > have to realize that HOT makes vacuuming less needed. Hmm, and how will they realize it, if they don't understand how HOT comes into the equation? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. From revoohc@gmail.com Fri Feb 8 13:02:07 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D3E902E0336 for ; Fri, 8 Feb 2008 09:02:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53372-07 for ; Fri, 8 Feb 2008 09:01:39 -0400 (AST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.182]) by postgresql.org (Postfix) with ESMTP id 059B82E0346 for ; Fri, 8 Feb 2008 09:01:45 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so1697964ele.5 for ; Fri, 08 Feb 2008 05:01:44 -0800 (PST) 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:references; bh=d3IOXGLRJ0CS5DxP294xIZ+XgTyPWqF1fYPPvDJVQCk=; b=MU8Zs5TUKg0xdMjWhi8b1/9CC/zbMsyOdd2TNjjnvfJvqG0FnB40upwnXXNOhVHMByDAG+mxBIxYxiNtnh7sTey9TLAy6Sx8FodKYxiZmVCWbMdTYu4fThbTel1ErSIYIS6SNIf4/4ecD07Rxeu7dxXkv9EAEJGwLrdzqQPAbbk= 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:references; b=c+RM6p1TgbMIDRP+8RynO2UdzlRt9KsJFUtcsv2SwWNaPU6ihGgSl58uPcfEMQPDzTz+k1FpahE3SNTozzFaNpN5f6lyjomM1pzNKvxATfYpi/PX7JurtWe2u8J7lGsUm23rkDtuGzDcXy5EuifwELN5JVhiMoVj96Sb3QmdFwY= Received: by 10.151.12.1 with SMTP id p1mr5272859ybi.152.1202475704843; Fri, 08 Feb 2008 05:01:44 -0800 (PST) Received: by 10.150.197.17 with HTTP; Fri, 8 Feb 2008 05:01:44 -0800 (PST) Message-ID: <1d219a6f0802080501m442cfd83y1bcb38087fcba61b@mail.gmail.com> Date: Fri, 8 Feb 2008 08:01:44 -0500 From: "Chris Hoover" To: "Alvaro Herrera" Subject: Re: Where to find information on the new HOT tables? Cc: "Bruce Momjian" , "Dimitri Fontaine" , pgsql-admin@postgresql.org In-Reply-To: <20080207234844.GH23336@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13502_17449815.1202475704826" References: <200802072100.20093.dfontaine@hi-media.com> <200802072231.m17MVBZ18035@momjian.us> <20080207234844.GH23336@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/91 X-Sequence-Number: 28165 ------=_Part_13502_17449815.1202475704826 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Feb 7, 2008 6:48 PM, Alvaro Herrera wrote: > Bruce Momjian escribi=F3: > > Dimitri Fontaine wrote: > > > > What about Alvaro's concern about manual vacuuming policies editing > wrt to > > > HOT? > > > > I think most people will be using autovacuum, and those who aren't will > > have to realize that HOT makes vacuuming less needed. > > Hmm, and how will they realize it, if they don't understand how HOT > comes into the equation? > How about just adding a "for more information look here link" pointing to http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap= /README.HOT?rev=3D1.2 That is the link Alvaro sent me in the first part of the thread. It was a very good read explaining how HOT works along with the caveats. Chris --=20 Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_13502_17449815.1202475704826 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On Feb 7, 2008 6:48 PM, Alvaro Herrera &= lt;alvherre@commandprompt.com= > wrote:
> Dimitri Fontaine wr= ote:

> > What about Alvaro's concern about manual vacuumin= g policies editing wrt to
> > HOT?
>
> I think most pe= ople will be using autovacuum, and those who aren't will
> have to realize that HOT makes vacuuming less needed.

Hmm= , and how will they realize it, if they don't understand how HOT
com= es into the equation?

How about just adding a &quo= t;for more information look here link" pointing to http://developer.postgresql.org/cvsweb.cgi/pg= sql/src/backend/access/heap/README.HOT?rev=3D1.2

That is the link Alvaro sent me in the first part of the thread.  = It was a very good read explaining how HOT works along with the caveats.
Chris


--
Come see how to SAVE= money on fuel, decrease harmful emissions, and even make MONEY.  Visi= t http://colafuelguy.mybpi.com= and join the revolution! ------=_Part_13502_17449815.1202475704826-- From bruce@momjian.us Fri Feb 8 16:01:47 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 961902E424D for ; Fri, 8 Feb 2008 12:01:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 44000-01-8 for ; Fri, 8 Feb 2008 12:01:40 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id DB7DF2E4399 for ; Fri, 8 Feb 2008 12:01:19 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m18G08629377; Fri, 8 Feb 2008 11:00:08 -0500 (EST) From: Bruce Momjian Message-Id: <200802081600.m18G08629377@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <20080207234844.GH23336@alvh.no-ip.org> To: Alvaro Herrera Date: Fri, 8 Feb 2008 11:00:08 -0500 (EST) CC: Dimitri Fontaine , pgsql-admin@postgresql.org, Chris Hoover X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/97 X-Sequence-Number: 28171 Alvaro Herrera wrote: > Bruce Momjian escribi?: > > Dimitri Fontaine wrote: > > > > What about Alvaro's concern about manual vacuuming policies editing wrt to > > > HOT? > > > > I think most people will be using autovacuum, and those who aren't will > > have to realize that HOT makes vacuuming less needed. > > Hmm, and how will they realize it, if they don't understand how HOT > comes into the equation? Well, since this is a change in the behavior of this release, and not something that will change over time, perhaps we need a sentence in there about vacuuming changes. The release note item says we can now reclaim without vacuum: "UPDATE"s and "DELETE"s leave dead tuples behind, as do failed "INSERT"s. Previously only "VACUUM" could reclaim space taken by dead tuples. With HOT dead tuple space can be automatically reclaimed at the time of "INSERT" or ... so it seems logical that the need to vacuum would change. We can add an explicit sentence about that to the release notes. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From bruce@momjian.us Fri Feb 8 16:02:49 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 368E92E42F1 for ; Fri, 8 Feb 2008 12:02:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 95472-01-4 for ; Fri, 8 Feb 2008 12:02:43 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id D56122E43EE for ; Fri, 8 Feb 2008 12:02:34 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m18G1gn01904; Fri, 8 Feb 2008 11:01:42 -0500 (EST) From: Bruce Momjian Message-Id: <200802081601.m18G1gn01904@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <1d219a6f0802080501m442cfd83y1bcb38087fcba61b@mail.gmail.com> To: Chris Hoover Date: Fri, 8 Feb 2008 11:01:42 -0500 (EST) CC: Alvaro Herrera , Dimitri Fontaine , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/98 X-Sequence-Number: 28172 Chris Hoover wrote: > On Feb 7, 2008 6:48 PM, Alvaro Herrera wrote: > > > Bruce Momjian escribi?: > > > Dimitri Fontaine wrote: > > > > > > What about Alvaro's concern about manual vacuuming policies editing > > wrt to > > > > HOT? > > > > > > I think most people will be using autovacuum, and those who aren't will > > > have to realize that HOT makes vacuuming less needed. > > > > Hmm, and how will they realize it, if they don't understand how HOT > > comes into the equation? > > > > How about just adding a "for more information look here link" pointing > to http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT?rev=1.2 > > > That is the link Alvaro sent me in the first part of the thread. It was a > very good read explaining how HOT works along with the caveats. Sure, we could do that, but it is very technical. I would say 99% of users don't need to know those details. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From alvherre@commandprompt.com Fri Feb 8 16:31:37 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 05A6D2E0F91 for ; Fri, 8 Feb 2008 12:31:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05165-02 for ; Fri, 8 Feb 2008 12:31:33 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id ED4EE2E316D for ; Fri, 8 Feb 2008 12:31:32 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-28-116.bk17-dsl.surnet.cl [190.95.28.116]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m18GUe9J032291 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 8 Feb 2008 08:30:47 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id A1F1447BEB; Fri, 8 Feb 2008 13:30:48 -0300 (CLST) Date: Fri, 8 Feb 2008 13:30:48 -0300 From: Alvaro Herrera To: Bruce Momjian Cc: Dimitri Fontaine , pgsql-admin@postgresql.org, Chris Hoover Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080208163048.GE31022@alvh.no-ip.org> References: <20080207234844.GH23336@alvh.no-ip.org> <200802081600.m18G08629377@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200802081600.m18G08629377@momjian.us> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Fri, 08 Feb 2008 08:30:48 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/101 X-Sequence-Number: 28175 Bruce Momjian escribió: > The release note item says we can now reclaim without vacuum: > > "UPDATE"s and "DELETE"s leave dead tuples behind, as do failed > "INSERT"s. Previously only "VACUUM" could reclaim > space taken by dead tuples. With HOT dead tuple space can be > automatically reclaimed at the time of "INSERT" or ... > > so it seems logical that the need to vacuum would change. We can add > an explicit sentence about that to the release notes. Ok, but the problem is not only realizing that you need to change it; you also need to know what to. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support