can I
completely refresh the database session and run the delete command on the
table?
Regards
Mitu
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: April 29, 2015 6:40 PM
To: Mitu Verma; 'pgsql-general@postgresql.org' (pgsql-general@postgresql.
On 4/29/15 12:32 AM, Mitu Verma wrote:
This script first does the indexing then it deletes the entries from the
table. Now issue is that this script is taking lot of time and has
acquired some locks also. Nor sure if it is happening due to indexing or
what.
Mixing DDL with bulk DML operations i
Mitu Verma wrote:
> I have killed the script, but still the query is showing in pg_stat and
> pg_locks.
>
> Please help me how to clear the pg_locks from the transaction it is already
> holding, if there is
> something in PostgreSQL which can clear the pg_stat and pg_locks?
[...]
> fm_db_Serve
Hi,
I have killed the script, but still the query is showing in pg_stat and
pg_locks.
Please help me how to clear the pg_locks from the transaction it is already
holding, if there is something in PostgreSQL which can clear the pg_stat and
pg_locks?
root@s3bgwa31 # ps -efa| grep -i 28223
postgr
