croolyc <croolists@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance