Postgres Pro
Downloads
Home   >   mailing lists

Vacuum takes more than 1 hr - Mailing list pgsql-sql

From Postgres
Subject Vacuum takes more than 1 hr
Date
Msg-id 001001bf1ed7$01dc9b20$9befaace@usedcars.com
Whole thread Raw
In response to Re: [SQL] Limit doesn't work with select unions  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: [SQL] Vacuum takes more than 1 hr
List pgsql-sql
Tree view 
I have a table with about 30 columns and 200K rows. When I perform a vacuum
on it (no analyze) it takes usually a little more than 1 hour. Since I do it
everyday, for me, this basically means my database, which is now getting
about a million queries a month, is down for an hour every day, since all
selects to that table wait until the vacuum is done. I have smaller tables,
10 columns, 5K rows, which see, to be very quick with vacuum. Any ideas on
how to speed vacuum up?
Thanks,
Rich

pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [SQL] Limit doesn't work with select unions
Next
From: "KC"
Date:
Subject: modifying query results with a regex?