| From: | mark(at)mark(dot)mielke(dot)cc |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL 8.2 (from CVS devel) first impressions |
| Date: | 2006-11-05 06:38:15 |
| Message-ID: | 20061105063814.GA2603@mark.mielke.cc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Nov 05, 2006 at 01:15:51AM -0500, mark(at)mark(dot)mielke(dot)cc wrote:
> One of my complicated queries that I threw at it seems to run about
> 10% - 20% faster now, which is pretty sweet.
I take this back. I forgot to 'analyze'. After 'analyze', the times
returned to the slower 8.1 times. :-(
I will have to investigate. The generated plan is more complex after
'analyze'...
Cheers,
mark
--
mark(at)mielke(dot)cc / markm(at)ncf(dot)ca / markm(at)nortel(dot)com __________________________
. . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder
|\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ |
| | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada
One ring to rule them all, one ring to find them, one ring to bring them all
and in the darkness bind them...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-11-05 09:11:07 | Re: PostgreSQL 8.2 (from CVS devel) first impressions |
| Previous Message | mark | 2006-11-05 06:15:51 | PostgreSQL 8.2 (from CVS devel) first impressions |