Re: [GENERAL] Queries taking a very long time

2004-01-08 Thread Richard Huxton
On Thursday 08 January 2004 16:15, Eric Freeman wrote: Please try not to post in html > 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

Re: [GENERAL] Queries taking a very long time

2004-01-08 Thread Marc G. Fournier
On Thu, 8 Jan 2004, Eric Freeman wrote: > > Hi, > > 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 r

[GENERAL] Queries taking a very long time

2004-01-08 Thread Eric Freeman
Hi, 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 hou