Postgres Pro
Downloads
Home   >   mailing lists

Re: Calculated view fields (8.1 != 8.2) - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Calculated view fields (8.1 != 8.2)
Date
Msg-id 20070309145401.GA7358@svana.org
Whole thread Raw
In response to Re: Calculated view fields (8.1 != 8.2)  (Gaetano Mendola <mendola@bigfoot.com>)
Responses 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>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Dave Page
Date:
Subject: Re: [COMMITTERS] pgsql: Remove unsafe calling of WSAStartup and WSA Cleanup from DllMain.
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Estimating seq_page_fetch and random_page_fetch