Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem on delete from for 10k rows. - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Performance problem on delete from for 10k rows.
Date
Msg-id 1110930627.1132.196.camel@home
Whole thread Raw
In response to Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface  (David Gagnon <dgagnon@siunik.com>)
List pgsql-performance
Tree view 
>  I get this problem on my dev (Windows/7.4/Cygwin) environment.  But now
> I see that it's also have this problem on my production env.  Yes I
> tought I was maybe just a cygwin/Windows problem .. apparently not :-((((

Care to try again with logging enabled on the PostgreSQL side within the
development environment?

log_statement = true
log_duration = true
log_connections = on

Then run it via Java and from pgAdminIII and send us the two log
snippets as attachments?

Thanks.
--

pgsql-performance by date:

Previous
From: David Brown
Date:
Subject: Re: cpu_tuple_cost
Next
From: Tom Lane
Date:
Subject: Re: One tuple per transaction