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

help / color / mirror / Atom feed

From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-performance@postgresql.org
Cc: Decibel! <decibel@decibel.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dan Harris <fbsd@drivefaster.net>
Subject: Re: Minimizing dead tuples caused by update triggers
Date: Thu, 20 Dec 2007 12:14:34 +0100
Message-ID: <200712201214.37113.dfontaine@hi-media.com> (raw)
In-Reply-To: <C0FED37D-7CC9-4D3E-BB1F-D8DB685E9E2D@decibel.org>
References: <624895BA-B4D0-470B-80FC-4AE55C4FD85E@drivefaster.net>
	<1279.1198111185@sss.pgh.pa.us>
	<C0FED37D-7CC9-4D3E-BB1F-D8DB685E9E2D@decibel.org>

Le jeudi 20 décembre 2007, Decibel! a écrit :
> A work-around others have used is to have the trigger just insert
> into a 'staging' table and then periodically take the records from
> that table and summarize them somewhere else.

And you can even use the PgQ skytools implementation to easily have this kind 
of 'staging'-table with a producer and one or many subscribers. See those 
references if you're interrested:
http://kaiv.wordpress.com/2007/10/19/skytools-database-scripting-framework-pgq/
  http://skytools.projects.postgresql.org/doc/pgq-sql.html
  http://skytools.projects.postgresql.org/doc/pgq-admin.html
  http://skytools.projects.postgresql.org/doc/pgq-nodupes.html

Hope this helps, regards,
-- 
dim

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (4+ messages)

Message-ID: <200712201214.37113.dfontaine@hi-media.com>
Permalink:  ../200712201214.37113.dfontaine@hi-media.com/
Also on:    postgresql.org/message-id/200712201214.37113.dfontaine@hi-media.com

copy link · copy postgr.es

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: dfontaine@hi-media.com, decibel@decibel.org, tgl@sss.pgh.pa.us, fbsd@drivefaster.net
  Subject: Re: Minimizing dead tuples caused by update triggers
  In-Reply-To: <200712201214.37113.dfontaine@hi-media.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