| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Calculated view fields (8.1 != 8.2) |
| Date: | 2007-03-09 14:54:01 |
| Message-ID: | 20070309145401.GA7358@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-03-09 15:01:47 | Re: Estimating seq_page_fetch and random_page_fetch |
| Previous Message | Dave Page | 2007-03-09 14:49:24 | Re: [COMMITTERS] pgsql: Remove unsafe calling of WSAStartup and WSA Cleanup from DllMain. |