| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Eric Freeman" <ejf7(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Queries taking a very long time |
| Date: | 2004-01-08 16:52:05 |
| Message-ID: | 200401081652.06077.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 08 January 2004 16:15, Eric Freeman wrote:
Please try not to post in html
> <P>I'm using version 7.3.3. I do a lot of modification to some of the
> tables in my database. There's a table that I didn't run vacuum on for a
> while and I ran some big queries on it. It was taking a long time so I
> aborted the query and tried running a vacuum on the table. It ran for
> around 48 hours before I aborted that. I decided to just drop the table and
> re-create it since that seems like it would be the fastest thing. It's been
> running the drop table command for almost 24 hours now. Is there any way to
> speed this process up?
What's the issue - CPU saturated? Disk saturated? system swapping?
Possibly your best bet is to copy the data out of the table, TRUNCATE it then
recreate it.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-08 17:05:48 | Re: 7.3.3 drop table takes very long time |
| Previous Message | Eric Freeman | 2004-01-08 16:43:02 | 7.3.3 drop table takes very long time |