Re: TB-sized databases

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: TB-sized databases
Дата
Msg-id 1196418583.31315.47.camel@PCD12478
обсуждение исходный текст
Ответ на Re: TB-sized databases  ("Trevor Talbot" <quension@gmail.com>)
Список pgsql-performance
> Isn't that what statement_timeout is for? Since this is entirely based
> on estimates, using arbitrary fuzzy numbers for this seems fine to me;
> precision isn't really the goal.

There's an important difference to statement_timeout: this proposal
would avoid completely taking any resources if it estimates it can't be
executed in proper time, but statement_timeout will allow a bad query to
run at least statement_timeout long...

Cheers,
Csaba.



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

Предыдущее
От: "Trevor Talbot"
Дата:
Сообщение: Re: TB-sized databases
Следующее
От: cluster
Дата:
Сообщение: Appending "LIMIT" to query drastically decreases performance