Content-Type: text/plain;
  charset="iso-8859-1"
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Performance
Date: Fri, 7 Feb 2003 14:10:51 +0530
User-Agent: KMail/1.4.3
References: <Pine.LNX.4.44.0302071002070.1308-100000@localhost.localdomain>
In-Reply-To: <Pine.LNX.4.44.0302071002070.1308-100000@localhost.localdomain>
MIME-Version: 1.0
Message-Id: <200302071410.51302.shridhar_daithankar@persistent.co.in>
Content-Transfer-Encoding: quoted-printable

On Friday 07 February 2003 01:41 pm, you wrote:
> I come from a Sybase background and have just started working with
> Postgre. Are there any books or tutorials that cover general performance
> issues for beginners? I don't just want to start creating databases and
> tables or writing mad queries without really understanding what is
> happening in the background. I know quite a few tips and tricks for Sybase
> but I don't think that much of it is relevant on Postgres. I would like to
> know how the query optimizer works, i.e. does the order of tables in the
> from clause make a difference in speed and how does indexing work on
> Postgres? Any help pointing me in the right direction would be appreciate=
d.

Religously go thr. admin guide. and then a quick look thr. all SQL commands=
.=20
May take a day or two but believe me, it is worth that.

 Shridhar