Re: too many LWLocks taken
От | Alex Vinogradovs |
---|---|
Тема | Re: too many LWLocks taken |
Дата | |
Msg-id | 1207351635.81391.13.camel@localhost обсуждение исходный текст |
Ответ на | Re: too many LWLocks taken (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: too many LWLocks taken
|
Список | pgsql-general |
Version is 8.2.5 running on FreeBSD 6.2. I can try upgrading to 8.2.7, if you think that would help. I don't think I can make a test case. Database had been up for a year now, with about 2 thousand inherited tables (partitioning) and about 2B rows in all tables... On Fri, 2008-04-04 at 18:58 -0400, Tom Lane wrote: > Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes: > > I've got a pretty large database, and since certain time > > it started giving me "too many LWLocks taken" when running > > some batch inserts... Any parameter can be ajusted ? > > Oh really? That's a bug, not something you need to adjust a parameter > for. Can you put together a self-contained test case? What PG > version is this? > > regards, tom lane
В списке pgsql-general по дате отправления: