| From: | "Mark Wong" <markwkm(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Simple postgresql.conf wizard |
| Date: | 2008-12-19 05:06:51 |
| Message-ID: | 70c01d1d0812182106j2ee430faw80744e8d765b8877@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Dec 8, 2008 at 4:34 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Mark Wong" <markwkm(at)gmail(dot)com> writes:
>> On Tue, Dec 2, 2008 at 2:25 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Are any of the queries complicated enough to trigger GEQO planning?
>
>> Is there a debug option that we could use to see?
>
> Well, you could set geqo=off and see if the behavior changes, but
> it'd be easier just to count how many tables are in each query ...
Sorry for the delay in responding, here's the queries and the number
of tables in each:
Q1: 1
Q2: 2
Q3: 3
Q4: 1
Q5: 6
Q6: 1
Q7: 6 (5 unique) + 1 temp table
Q8: 8 (7 uniqie) + 1 temp table
Q9: 6 + 1 temp table
Q10: 4
Q11: 3
Q12: 2
Q13: 3 + 1 temp table
Q14: 2
Q15: 5
Q16: 2
Q17: 2
Q18: 3
Q19: 2
Q20: 2
Q21: 4
Q22: 3 + 1 temp table
Regards,
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2008-12-19 05:17:38 | Re: Updates of SE-PostgreSQL 8.4devel patches (r1324) |
| Previous Message | Rushabh Lathia | 2008-12-19 04:14:57 | Re: Function with defval returns error |