| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Mindaugas Riauba <mind(at)bi(dot)lt> |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Need advice about triggers |
| Date: | 2003-09-09 13:28:07 |
| Message-ID: | 1063114086.67981.5.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mindaugas Riauba | 2003-09-09 13:33:32 | Re: Need advice about triggers |
| Previous Message | Richard Huxton | 2003-09-09 13:14:23 | Re: Need advice about triggers |