croolyc <croolists(at)gmail(dot)com> wrote:
> can you help me with performance optimization
For overall tuning you could start here:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
If, after some general tuning, you are having problems with slow
queries, it is best if you pick one and show it with EXPLAIN ANALYZE
output and the schema of the tables involved.
http://wiki.postgresql.org/wiki/SlowQueryQuestions
-Kevin