Re: optimization

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "croolyc" <croolists(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: optimization
Date: 2011-02-28 14:57:06
Message-ID: 4D6B6362020000250003B0B3@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2011-02-28 15:35:37 Re: inheritance: planning time vs children number vs column number
Previous Message Marc Cousin 2011-02-28 13:09:55 Re: inheritance: planning time vs children number vs column number