Re: Calculated view fields (8.1 != 8.2)

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Calculated view fields (8.1 != 8.2)
Дата
Msg-id 20070309145401.GA7358@svana.org
обсуждение исходный текст
Ответ на Re: Calculated view fields (8.1 != 8.2)  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Calculated view fields (8.1 != 8.2)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Calculated view fields (8.1 != 8.2)  ("Florian G. Pflug" <fgp@phlo.org>)
Re: Calculated view fields (8.1 != 8.2)  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-hackers
On Fri, Mar 09, 2007 at 10:59:56AM +0100, Gaetano Mendola wrote:
> Is really this what we want? I did a migration 8.0.x => 8.2.3 and I had on first hour of service up
> lot of queries "blocked" due to this, consider in my case I have on v_ta milions of records and usually
> that join extracts 1 row. Is there a way to set till I don't check all my huge schema to disable this
> behaviour?

Most people figured it was a improvment. It's configured per function
now, which wasn't the case before. I dont't think there was ever any
discussion about having a global switch.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Remove unsafe calling of WSAStartup and WSA Cleanup from DllMain.
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Estimating seq_page_fetch and random_page_fetch