Performance

Поиск
Список
Период
Сортировка
От jeandre@itvs.co.za
Тема Performance
Дата
Msg-id Pine.LNX.4.44.0302071002070.1308-100000@localhost.localdomain
обсуждение исходный текст
Ответы Re: Performance  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Re: Performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
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.

Many Thanks
Jeandre


В списке pgsql-performance по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: how to configure my new server
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Performance