Re: Queries taking a very long time

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