From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | A few notes |
Date: | 2003-05-31 04:40:09 |
Message-ID: | 3ED83229.8030903@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello. I thought I'd just toss out a few thoughts:
1) Should a link to the release changes for 7.3.3 be on the website? I
had to look into the web-interface of CVS to see what was actually
changed.
2) It would be nice if some regular performance tests could be done
upon every release on some stock machine whose configuration never
changes to give some numerical hints as to the value of an upgrade.
3) I got bit by using the explicit join syntax just like Thomas
Lockhart had predicted. I then removed the syntax to let the planner
do its job. Queries which took around 10 seconds took 5 minutes. I
then disabled GEQO and the queries ran in around a second. I noticed
that the explicit join syntax will no longer confine planning choices
in 7.4, but is it possible the GEQO threshold, as a default, is too low?
Mike Mascari
mascarm(at)mascari(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2003-05-31 04:55:11 | Re: Testing the return value of fclose() in the backend |
Previous Message | Tom Lane | 2003-05-31 04:32:15 | Re: default locale considered harmful? (was Re: [GENERAL] |