Apologies - I should have said output of 'VACUUM VERBOSE mytable'.

(been using 8.1, which displays dead tuple info in ANALYZE...).


Yves Vindevogel wrote:
rvponp=# analyze verbose tblPrintjobs ;
INFO: analyzing "public.tblprintjobs"
INFO: "tblprintjobs": 19076 pages, 3000 rows sampled, 588209 estimated total rows

On 13 Jun 2005, at 04:43, Mark Kirkwood wrote:

    Yves Vindevogel wrote:

        I'm trying to update a table that has about 600.000 records.
        The update query is very simple : update mytable set pagesdesc =
        - pages ;
        The query takes about half an hour to an hour to execute. I have
        tried a lot of things.

    Half an hour seem a bit long - I would expect less than 5 minutes on
    reasonable hardware.

    You may have dead tuple bloat - can you post the output of 'ANALYZE
    VERBOSE mytable' ?

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to