Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Queries taking a very long time
- From: "Eric Freeman" <ejf7(at)hotmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Queries taking a very long time
- Date: Thu, 08 Jan 2004 09:15:32 -0700
- Message-id: <BAY99-F161EOALf9inV000305d9@hotmail.com> <text/plain>
<html><div style='background-color:'><DIV class=RTE> <P>Hi,</P> <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? Can I go into the data directory and delete some files? </P> <P>This is on a developmental database so losing some data isn't extremely critical but I would like to know what data I'm losing if I lose data other than just the table. There hasn't been any activity on the database since I started trying to drop the table. <BR><BR></P></DIV></div><br clear=all><hr> <a href="http://g.msn.com/8HMAENUS/2749??PS=";>Make your home warm and cozy this winter with tips from MSN House & Home. </a> </html>
- Follow-Ups:
- Re: Queries taking a very long time
- From: Richard Huxton
- Re: Queries taking a very long time
- From: Marc G. Fournier
- Re: Queries taking a very long time
- Prev by Date: RedHat install question.
- Next by Date: Re: Queries taking a very long time
- Previous by thread: RedHat install question.
- Next by thread: Re: Queries taking a very long time
- Indexes: