Forum OpenACS Q&A: Help Tuning PL/pgSQL

Collapse
1: Help Tuning PL/pgSQL
Posted by Carl Coryell-Martin on 04/08/03 09:01 PM
Okay so I have a PL/pgSQL procedure that takes data from a temp table (a list of media outlets) and creates a content repository item and a revision.

This proc takes about .5 seconds/outlet and creates three objects: the item, the first revision and an address object.

Two questions:
1) is there a way that I can speed that up?
2) any tips on how to tune pl/pgsql procs?

Thanks

Carl

Collapse
2: Re: Help Tuning PL/pgSQL (response to 1)
Posted by Peter Alberer on 04/09/03 10:05 PM
your question is rather unspecific...
Here is a fine document on postgres software tuning http://www.argudo.org/postgresql/soft-tuning.html.
You can of course also tune your server hardware http://www.ca.postgresql.org/docs/momjian/hw_performance/

hope that helps a bit, peter