Postgres Pro
Downloads
Home   >   mailing lists

Re: optimization - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: optimization
Date
Msg-id 4D6B6362020000250003B0B3@gw.wicourts.gov
Whole thread Raw
In response to optimization  (croolyc <croolists@gmail.com>)
List pgsql-performance
Tree view 
croolyc <croolists@gmail.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

pgsql-performance by date:

Previous
From: Marc Cousin
Date:
Subject: Re: inheritance: planning time vs children number vs column number
Next
From: Tom Lane
Date:
Subject: Re: inheritance: planning time vs children number vs column number