Re: performance problem aftrer update from 7.1 to 7.4.2

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