Обсуждение: Re: Postgres performance

std pik wrote:
> Hi all..
> please, how can i tune postgres performance?
>
> Thanks.

Thats a very generic question.  Here are some generic answers:

You can tune the hardware underneath.  Faster hardware = faster pg.

You can tune the memory usage, and other postgres.conf setting to match
your hardware.  See the online manuals.

You can tune a single slow query, use explain analyze.

-Andy

Didn't see the original message so I replied to this one.

On Mon, Sep 28, 2009 at 8:11 AM, Andy Colson <andy@squeakycode.net> wrote:
> std pik wrote:
>>
>> Hi all..
>> please, how can i tune postgres performance?

Start here:
http://www.westnet.com/~gsmith/content/postgresql/