Re: Postgres performance - Mailing list pgsql-performance

From Andy Colson
Subject Re: Postgres performance
Date
Msg-id 4AC0C405.2070801@squeakycode.net
Whole thread Raw
Responses Re: Postgres performance
List pgsql-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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: LIMIT confuses the planner (again)
Next
From: Josh Berkus
Date:
Subject: Re: PG 8.3 and large shared buffer settings