Re: Need advice about triggers - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Need advice about triggers
Date
Msg-id 1063114086.67981.5.camel@jester
Whole thread Raw
In response to Need advice about triggers  ("Mindaugas Riauba" <mind@bi.lt>)
List pgsql-performance
>   How can I improve performance and will version 7.4 bring something
> valuable for my task? Rewrite to some other scripting language is not
> a problem. Trigger is simple enough.

Your best bet is to have additional clients connected to the database
requesting work. Approx NUMCPUs * 2 + 1 seems to be ideal. (+1 to ensure
there is something waiting when the others complete.  *2 to ensure that
you can have 50% reading from disk, 50% doing calculations)

You may simply want to put vacuum into a loop of it's own so it executes
~1 second after the previous run finished.  Work should still be going
on even though vacuum is running.

Attachment

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Need advice about triggers
Next
From: "Mindaugas Riauba"
Date:
Subject: Re: Need advice about triggers