0.050..0.050 rows=68 loops=1)
Index Cond: (start_date_time > '2006-12-11
00:00:00'::timestamp without time zone)
Total runtime: 1010.775 ms
Thanks for tips.
Best regards
Rolf Østvik
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--- Claus Guttesen <[EMAIL PROTECTED]> skrev:
> > I have a simple query which uses 32ms on 7.4.14
> and 1015ms on 8.2.0.
> > I guess 7.4.14 creates a better execution plan
> than 8.2.0 for this query but
> > i don't know how to get it to select a better one.
> > Explain analyse output will be fou
(I am sorry if my explain analyze outputs gets
garbled)
--- Dennis Bjorklund <[EMAIL PROTECTED]> skrev:
> Rolf Østvik skrev:
>
> > I have a simple query which uses 32ms on 7.4.14
> and 1015ms on 8.2.0.
> > I guess 7.4.14 creates a better execution plan
>
--- Dave Cramer <[EMAIL PROTECTED]> skrev:
>
> On 31-Dec-06, at 6:33 AM, Rolf Østvik wrote:
>
> >
> > Hi
> >
> > I have a simple query which uses 32ms on 7.4.14
> and 1015ms on 8.2.0.
> > I guess 7.4.14 creates a better execution plan
> than
scan? Are you sure you haven't
> tweaked any parameters
> you didn't tell us about, such as setting
> enable_seqscan = off?
I haven't touched enable_seqscan.
It could be that i have forgotton to tell you about a
parameter i have tweaked, but i doubt it.
Best regards
Rolf Øst
ive uut_result value instead of
> 42). If it doesn't
> want to use an indexscan for this, disable plan
> types until it does.
> This would perhaps shed some light on why 8.2
> doesn't want to use a scan
> like that as the inside of a nestloop.
>
>
=0.069..0.069 rows=0 loops=1)
Index Cond: (uut_result = $1)
Filter: (step_parent = 0)
Total runtime: 0.112 ms
(4 rows)
Best regards,
Rolf Østvik
__
Bruker du Yahoo!?
Lei av spam? Yahoo! Mail har den beste spambeskyttelsen
http
ate_time > '2006-12-11'"). I
will continue to
adjust other parameters and see what i can manage myself.
Best regards
Rolf Østvik
__
Bruker du Yahoo!?
Lei av spam? Yahoo! Mail har den beste spambeskyttelsen
http://no.mail.yahoo.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
eas from this thread , read some more documentation, read
the archives, and
tested other queries and will try to speed up some more advance queries.
Thanks everyone.
best regards
Rolf Østvik
__
Bruker du Yahoo!?
Lei av spam
