long running delete - Mailing list pgsql-admin

From Mark Steben
Subject long running delete
Date
Msg-id CADyzmyxozipWz7B54MXkRED7vMf5Xya41BqorDgFcbvNgHzrVQ@mail.gmail.com
Whole thread Raw
Responses Re: [MASSMAIL]long running delete  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
List pgsql-admin
Good morning,

We have been running a delete for nearly 24 hours now.  I would like to verify that it is either doing what it is supposed to do or 'spinning its wheels'.  

We are running postgres 9.2.12.

The delete statement is not waiting on any other transaction.

I have run straces on the pid and I see lots of 'reads, lseeks, and an occasional semop.  I have also looked in the base directory at the file matched by the oid of the table (as defined in pg_class) and have seen no change in size.

Is there somewhere else I can verify that work is / is not being done?  Perhaps looking for something else in strace?

Thanks for your time.

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089

t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





pgsql-admin by date:

Previous
From: Alex Stanier
Date:
Subject: Re: Changing column order through dump and restore
Next
From: "Gilberto Castillo"
Date:
Subject: Re: [MASSMAIL]long running delete