| From: | Hervé Piedvache <herve(at)elma(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | lifo(at)elma(dot)fr |
| Subject: | Vacuum analyze with 7 millions records ... takes 1 hour ! |
| Date: | 2001-10-10 16:11:11 |
| Message-ID: | 3BC4731F.1D5C6045@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é
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan | 2001-10-10 18:07:35 | Re: Postgres server locks up, HELP! |
| Previous Message | Hervé Piedvache | 2001-10-10 15:45:12 | Rotating PostgreSQL LOGs on Web site ?? |