pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: ??: Postgresql update op is very very slow
Date: Thu, 26 Jun 2008 18:20:15 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0806261817490.22988@westnet.com> (raw)
In-Reply-To: <486396A9.1030208@postnewspapers.com.au>
References: <473587.97248.qm@web32701.mail.mud.yahoo.com>
	<op.uc83c7m2cigqcu@apollo13.peufeu.com>
	<004b01c8d671$3dec1630$0544000a@hz.ali.com>
	<486219B6.7050003@enterprisedb.com>
	<005101c8d773$ff81b2c0$0644000a@hz.ali.com>
	<48638939.5080500@enterprisedb.com>
	<pan.2008.06.26.12.40.59.151500@wizards.de>
	<486396A9.1030208@postnewspapers.com.au>

On Thu, 26 Jun 2008, Craig Ringer wrote:

> I'd be interested to have this confirmed, as I don't think I've seen it 
> documented anywhere. Is it a side-effect/benefit of HOT somehow?

The documentation is in README.HOT, for example: 
http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/README.HOT?rev=1.3;content-ty...

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (12+ messages)

Message-ID: <Pine.GSO.4.64.0806261817490.22988@westnet.com>
Permalink:  ../Pine.GSO.4.64.0806261817490.22988@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0806261817490.22988@westnet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmith@gregsmith.com, craig@postnewspapers.com.au
  Subject: Re: ??: Postgresql update op is very very slow
  In-Reply-To: <Pine.GSO.4.64.0806261817490.22988@westnet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox