From: asif ali <asif_icrossing@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL does not works.......
Date: Wed, 6 Dec 2006 16:19:26 -0800 (PST)
Message-ID: <325721.59076.qm@web58411.mail.re3.yahoo.com> (raw)
In-Reply-To: <1165443208.3243.17.camel@state.g2switchworks.com>
Thanks Scott,
It worked!!!
We killed an old idle running transaction, now everything is fine..
Thanks Again
asif ali
icrossing inc
Scott Marlowe <smarlowe@g2switchworks.com> wrote: On Wed, 2006-12-06 at 15:53, asif ali wrote:
> Thanks Everybody for helping me out.
> I checked "pg_stat_activity"/pg_locks, but do not see any activity on
> the table.
> How to find a old running transaction...
> I saw this link, but it did not help..
> http://archives.postgresql.org/pgsql-hackers/2005-02/msg00760.php
Sometimes just using top or ps will show you.
on linux you can run top and then hit c for show command line and look
for ones that are IDLE
Or, try ps:
ps axw|grep postgres
On my machine normally:
2408 ? S 0:00 /usr/local/pgsql/bin/postmaster -p 5432 -D /home/postgres/data
2615 ? S 0:00 postgres: stats buffer process
2616 ? S 0:00 postgres: stats collector process
2857 ? S 0:00 postgres: writer process
2858 ? S 0:00 postgres: stats buffer process
2859 ? S 0:00 postgres: stats collector process
But with an idle transaction:
2408 ? S 0:00 /usr/local/pgsql/bin/postmaster -p 5432 -D /home/postgres/data
2615 ? S 0:00 postgres: stats buffer process
2616 ? S 0:00 postgres: stats collector process
2857 ? S 0:00 postgres: writer process
2858 ? S 0:00 postgres: stats buffer process
2859 ? S 0:00 postgres: stats collector process
8679 ? S 0:00 postgres: smarlowe test [local] idle in transaction
Thar she blows!
Also, you can restart the database and vacuum it then too. Of course,
don't do that during regular business hours...
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real people who know.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: asif_icrossing@yahoo.com
Subject: Re: VACUUM FULL does not works.......
In-Reply-To: <325721.59076.qm@web58411.mail.re3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox