Re: too many LWLocks taken - Mailing list pgsql-general

From Alex Vinogradovs
Subject Re: too many LWLocks taken
Date
Msg-id 1207351635.81391.13.camel@localhost
Whole thread Raw
In response to Re: too many LWLocks taken  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: too many LWLocks taken  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Duplicate Key violation on dump&reload using pg_restore
Next
From: Tom Lane
Date:
Subject: Re: too many LWLocks taken