Vacuum analyze with 7 millions records ... takes 1 hour !

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum analyze with 7 millions records ... takes 1 hour !
Date: 2001-10-12 17:56:40
Message-ID: 3BC72ED8.7CA208B7@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table (not so big) 7 millions records ... about 13 fields
inside and 5 indexes ...
I'm usign a Bi-Pentium III 800 Mhz with 1Gb under Linux kernel 2.4.10
... and the database do nothing else !

Inside this table I insert about 10000 records every days, and have to
update some records (about 3 to 10 000) by day.

So if I want a good timing access to my database I have to vacuum
analyze it every day ...

But the vacuum analyze take about 1 hour ... exactly 59 minutes ... ;) I
hour the table is locked ... so impossible to be used :(

Do you have any idea to get a better result for the vacuum ... ? And why
it take 1 hour ?

Or any solutionq to get good timing and better results ? ;)

Looking for your reply,

Regards,
--
Hervé

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-12 18:00:48 Re: VACUUM, 24/7 availability and 7.2
Previous Message Hervé Piedvache 2001-10-12 17:56:13 Rotating PostgreSQL LOGs on Web site ??