RE: Stuck spins in current

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Stuck spins in current
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D3331@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на Stuck spins in current  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Ответы Re: Stuck spins in current  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "Vadim Mikheev" <vmikheev@sectorbase.com> writes:
> > Anyway, deadlock in my tests are very correlated with new log file
> > creation - something probably is still wrong...
> 
> Well, if you can reproduce it easily, seems like you could 
> get in there and verify or disprove my theory about where
> the deadlock is.

You were right - deadlock disappeared.

BTW, I've got ~320tps with 50 clients inserting (int4, text[1-256])
records into 50 tables (-B 16384, wal_buffers = 256) on Ultra10
with 512Mb RAM, IDE (clients run on the same host as server).

Vadim


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: elog with automatic file, line, and function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Stuck spins in current