Re: Performance problem on delete from for 10k rows.

From: Rod Taylor
Subject: Re: Performance problem on delete from for 10k rows.
Date: ,
Msg-id: 1110930627.1132.196.camel@home
(view: Whole thread, Raw)
In response to: Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface  (David Gagnon)
List: pgsql-performance


>  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:

From: Tom Lane
Date:
Subject: Re: One tuple per transaction
From: Greg Stark
Date:
Subject: Re: cpu_tuple_cost