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
Message-ID: <200302071410.51302.shridhar_daithankar@persistent.co.in> (raw)
In-Reply-To: <Pine.LNX.4.44.0302071002070.1308-100000@localhost.localdomain>
References: <Pine.LNX.4.44.0302071002070.1308-100000@localhost.localdomain>
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 appreciated.
Religously go thr. admin guide. and then a quick look thr. all SQL commands.
May take a day or two but believe me, it is worth that.
Shridhar
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shridhar_daithankar@persistent.co.in
Subject: Re: Performance
In-Reply-To: <200302071410.51302.shridhar_daithankar@persistent.co.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox