PostgreSQL admins? - DPChallenge Forums

07/28/2007 03:59:41 PM · #1

Anyone know how I can be sure that VACUUM FULL is done?

It's shrunk the db by 4GB, but I still see an Exclusive lock on it. I'm a dummny and didn't look to see if it was like that before.

This is the query I used to find the exclusive lock.

select pg_stat_activity.datname,pg_class.relname,pg_locks.transaction, pg_locks.mode, pg_locks.granted,pg_stat_activity.usename,substr(pg_stat_activity.current_query,1,30), pg_stat_activity.query_start, age(now(),pg_stat_activity.query_start) as "age", pg_stat_activity.procpid from pg_stat_activity,pg_locks left outer join pg_class on (pg_locks.relation = pg_class.oid) where pg_locks.pid=pg_stat_activity.procpid order by query_start;

However, PGAdmin is not showing any lock at all, so which do I believe? Is there a command that I can simply find any admin processes running?

Thanks :)

07/28/2007 04:32:45 PM · #2

Anybody? Yeah, maybe a little too work related for a Saturday afternoon :)

Dantzr

Pentax K-x

07/28/2007 04:55:36 PM · #3

Originally posted by wavelength:

Anyone know how I can be sure that VACUUM FULL is done?

I don't know, Steve! I think I would probably empty the bag!

Sorry... couldn't resist. Wisah I could help, but other than the word "vacuum", I am one heavily lost puppy!!

Good luck!

Nikon AF-S NIKKOR 24-70mm f/2.8G ED

07/28/2007 05:32:38 PM · #4

Hmm, JP would know. He's a smartie. I might just PM him.

alfresco

Nikon D700

07/28/2007 07:20:52 PM · #5

Sorry-JP's-a-mysql-type-at-best-bump :(

smurfguy

Canon EOS-5D Mark II

Canon EF 24-70mm f/2.8L USM

07/28/2007 07:53:06 PM · #6

Originally posted by alfresco:

Sorry-JP's-a-mysql-type-at-best-bump :(

Ditto

07/28/2007 08:04:32 PM · #7

Damn.

Thanks Guys!

I just started watching drive space. When it started ticking up instead of down, I figgered it was fully done ;)

Lozza

07/28/2007 08:33:34 PM · #8

Not sure, but try installing Webmin for a second opinion. There's a module there for PostgreSQL.

07/28/2007 10:05:03 PM · #9

Originally posted by Lozza:

Not sure, but try installing Webmin for a second opinion. There's a module there for PostgreSQL.

Thanks, but I can't install anything to these servers. Well, technically I can, but that's a big no-no.