pg 7.0.2-2 vacuum slowness / loop? (fwd) - Mailing list pgsql-general

From Oliver Elphick
Subject pg 7.0.2-2 vacuum slowness / loop? (fwd)
Date
Msg-id 200007170957.e6H9vLA21801@linda.lfix.co.uk
Whole thread Raw
Responses Re: pg 7.0.2-2 vacuum slowness / loop? (fwd)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Has anyone any suggestions for dealing with this, please?

------- Forwarded Message

Date:    Mon, 17 Jul 2000 09:06:48 +0200
From:    "J.H.M. Dassen (Ray)" <jdassen@cistron.nl>
To:      Oliver.Elphick@lfix.co.uk
Subject: pg 7.0.2-2 vacuum slowness / loop?

Hi Oliver,

I'm currently encountering problems using postgresql 7.0.2-2 on a potato
system: PostgreSQL works fine, except that vacuuming seems to loop or take a
/very/ long time.  I'm working on a dual PIII 500 Mhz machine with a
database of approx. 1.5 million records in a single table. An attempt to
vacuum the databases on this machine started on friday evening, and still
hasn't finished.

Do you have any suggestions on how to deal with this, tests which you'd like
to seen run etc.?

Greetings & TIA,,
Ray
- --
Signs of world domination:
    "Tonight on Celebrity Deathmatch: Tux takes on the BSD daemon"


------- End of Forwarded Message


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "But my God shall supply all your need according to his
      riches in glory by Christ Jesus."     Philippians 4:19



pgsql-general by date:

Previous
From: jprem
Date:
Subject: urgent help on function/trigger
Next
From: "Nagel, Thomas"
Date:
Subject: AW: performance question