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

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Performance problem on delete from for 10k rows.
Дата
Msg-id 1110930627.1132.196.camel@home
обсуждение исходный текст
Ответ на Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface  (David Gagnon <dgagnon@siunik.com>)
Список 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 по дате отправления:

Предыдущее
От: David Brown
Дата:
Сообщение: Re: cpu_tuple_cost
Следующее
От: Tom Lane
Дата:
Сообщение: Re: One tuple per transaction