Re: Review of: explain / allow collecting row counts without timing info

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Review of: explain / allow collecting row counts without timing info
Дата
Msg-id 4F2DC2DD0200002500044DE0@gw.wicourts.gov
обсуждение исходный текст
Ответы Re: Review of: explain / allow collecting row counts without timing info  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Tom Lane  wrote:
> Yeah, I think we need to preserve that property. Unexpectedly
> executing query (which may have side-effects) is a very dangerous
> thing.  People are used to the idea that ANALYZE == execute, and
> adding random other flags that also cause execution is going to
> burn somebody.
+1
FWIW, another reason not to use Robert's suggested syntax is that you
get "rows=n" entries with or without the actual run.  You just don't
get the "actual" block to compare to the estimate.  So ROWS as an
option would be very ambiguous.
-Kevin


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 16-bit page checksums for 9.2
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.2] Add GUC sepgsql.client_label