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: | Raw Message | Whole Thread | 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 |