| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | std pik <stdpik(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres performance |
| Date: | 2009-09-28 14:11:17 |
| Message-ID: | 4AC0C405.2070801@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-www |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Kirtley | 2009-09-28 15:54:54 | Re: Use of sequence rather than index scan for one text column on one instance of a database |
| Previous Message | Robert Haas | 2009-09-28 11:38:54 | Re: LIMIT confuses the planner (again) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2009-09-28 18:08:18 | Re: Forcing wrapping of 'pre' text in the archives |
| Previous Message | webmaster | 2009-09-28 14:00:01 | PostgreSQL moderation report: 2009-9-28 |