pg 7.0.2-2 vacuum slowness / loop? (fwd)

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Cc: "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron(dot)nl>
Subject: pg 7.0.2-2 vacuum slowness / loop? (fwd)
Date: 2000-07-17 09:57:21
Message-ID: 200007170957.e6H9vLA21801@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cistron(dot)nl>
To: Oliver(dot)Elphick(at)lfix(dot)co(dot)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(dot)Elphick(at)lfix(dot)co(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nagel, Thomas 2000-07-17 10:03:03 AW: performance question
Previous Message jprem 2000-07-17 09:53:17 urgent help on function/trigger