Re: Slow update with simple query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow update with simple query
Date
Msg-id 20426.1166109494@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow update with simple query  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: Slow update with simple query
List pgsql-performance
Arnaud Lesauvage <thewild@freesurf.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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Arnaud Lesauvage
Date:
Subject: Re: Slow update with simple query