From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Performance |
Date: | 2003-02-07 08:40:51 |
Message-ID: | 200302071410.51302.shridhar_daithankar@persistent.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Toepp | 2003-02-07 10:26:47 | postgres on solaris 8 |
Previous Message | jeandre | 2003-02-07 08:11:46 | Performance |