From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "Development - multi(dot)art(dot)studio" <dev(dot)null(at)multiartstudio(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance problem aftrer update from 7.1 to 7.4.2 |
Date: | 2004-04-14 09:18:46 |
Message-ID: | 200404141018.46812.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 14 April 2004 01:56, Development - multi.art.studio wrote:
>
> i compared some querys from 7.1 to 7.4.2 and put all the output of the
> explain command to a website, because i think its too much for posting
> it here.
Something funny here - notice the width of newsletter (84) in the old version
against the width in the new one (610).
> 7.1:
> mcms09=> explain select * from newsletter where site_id='m000000-970' order
> by date desc,id desc limit 10; NOTICE: QUERY PLAN:
> Limit (cost=9.26..9.26 rows=7 width=84)
> 7.4.2:
> mcms=# explain select * from newsletter where site_id='m000000-970' order
> by date desc,id desc limit 10; QUERY PLAN
> ---------------------------------------------------------------------------
>------------------------------ Limit (cost=17.78..17.81 rows=10 width=610)
> -> Sort (cost=17.78..17.81 rows=11 width=610)
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-04-14 09:22:58 | Re: Disable NOTICE echoing |
Previous Message | Karel Zak | 2004-04-14 08:34:21 | Re: verifying unicode locale support |