Query Optimization

Поиск
Список
Период
Сортировка
От shakil tanvir
Тема Query Optimization
Дата
Msg-id 20060521065619.9666.qmail@web52403.mail.yahoo.com
обсуждение исходный текст
Ответ на Where to get more info. about the optimizer?  ("Dhruv Matani" <dhruvbird@gmail.com>)
Ответы Re: Query Optimization  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-novice
Hi Guys,

Can anyone tell me, how i can see at psql that how fast my query is executing?

Shakil

Dhruv Matani <dhruvbird@gmail.com> wrote:
Hello,
  I have downloaded the PgSql sources, and saw the README file in the optimizer directory of the sources. Is there any other resource(s) for getting more info. on this?
More specifically, I'm interested in knowing if the optimizer uses the Referential Integrity constraints while performing optimizations. I mean things such as the FOREIGN key, CHECK constraints, etc....


--
   -Dhruv Matani.
http://www.geocities.com/dhruvbird/

"The biggest room is the room for improvement."
     -- Navjot Singh Siddhu.


Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

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

Предыдущее
От: kmh496
Дата:
Сообщение: Re: PG on zeta 1.0
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Query Optimization