Re: Slow update with simple query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
Cc: Ragnar <gnari(at)hive(dot)is>, Jens Schipkowski <jens(dot)schipkowski(at)apus(dot)co(dot)at>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow update with simple query
Date: 2006-12-14 15:18:14
Message-ID: 20426.1166109494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
> I must be missing something, so here is the full table description.

It looks pretty harmless, except for

> CREATE TRIGGER parse_log_trigger
> BEFORE INSERT
> ON statistiques.log
> FOR EACH ROW
> EXECUTE PROCEDURE statistiques.parse_log_trigger();

It seems the time must be going into this trigger function. What
does it do?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-12-14 15:23:00 Re: Slow update with simple query
Previous Message Greg Smith 2006-12-14 15:00:14 Re: New to PostgreSQL, performance considerations