Skip site navigation (1) Skip section navigation (2)

Re: Optimzing Postgresql

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimzing Postgresql
Date: 2008-05-25 20:01:08
Message-ID: 4839C584.1010501@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-general
Steve Atkins wrote:

> Hang out on the pgsql-performance mailing list and see what other people 
> do - "How do I tune a database for X" comes up pretty regularly, and 
> gets good answers, so trolling through the mailing list archive can give 
> some very good advice.
> 

Aside from the hardware and server options that can be adjusted - the 
sql you use can make a big difference to performance as well.

That goes from good table design and index usage through to select 
statement structure as well.

The mailing lists are often a good place to get help with selects that 
perform slowly.



-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

In response to

pgsql-general by date

Next:From: Dan DascalescuDate: 2008-05-25 21:36:47
Subject: FAQ correction for Windows 2000/XP
Previous:From: Shane AmblerDate: 2008-05-25 19:51:58
Subject: Re: Copying data from a table to another database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group