| From: | Postgres <postgres(at)weblynk(dot)com> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Vacuum takes more than 1 hr |
| Date: | 1999-10-25 10:52:18 |
| Message-ID: | 001001bf1ed7$01dc9b20$9befaace@usedcars.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Byrnes | 1999-10-25 16:03:55 | [INTERFACES] Re: LIKE clause |
| Previous Message | Oleg Bartunov | 1999-10-25 09:02:50 | Re: [SQL] Limit doesn't work with select unions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KC | 1999-10-25 14:28:46 | modifying query results with a regex? |
| Previous Message | Oleg Bartunov | 1999-10-25 09:02:50 | Re: [SQL] Limit doesn't work with select unions |