| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Peter Geoghegan <pg(at)bowt(dot)ie>, ro b <bigbro_wq(at)hotmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Self contradictory examining on rel's baserestrictinfo |
| Date: | 2024-11-26 16:55:29 |
| Message-ID: | CA+TgmobukqP10A4fVjxwGaku94Hfi7ZoiX5j=mQApm=2UvTAfQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Nov 25, 2024 at 4:39 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> BTW, it's also worth pointing out the constraint_exclusion GUC.
> If that's turned up to "on" from its default setting of "partition",
> it authorizes the planner to spend more effort looking for
> contradictory quals. It might be reasonable to gate some of these
> checks with that. (I also can't help wondering if any of them are
> already implemented but are hidden behind that. I think Robert
> must have had constraint_exclusion = on for his examples a
> couple messages back.)
I definitely didn't change the value of that setting. It's possible I
was running on an older branch, but I don't think it was anything
ancient.
--
Robert Haas
EDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2024-11-26 17:08:30 | Re: Make postmaster environment dump easier to skim over |
| Previous Message | Andres Freund | 2024-11-26 16:55:18 | Make postmaster environment dump easier to skim over |