Search Postgresql Archives

Re: SELECT Query on DB table preventing inserts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Aug 30, 2011 at 13:52, Daniel Verite <daniel@xxxxxxxxxxxxxxxx> wrote:
>        Dan Scott wrote:
>
>> the insert process is unable to insert new rows into the database
>
> You should probably provide the error message on insert or otherwise describe
> how it's not working. Normally reading does not unintentionally prevent
> writing in a concurrent session.

I've investigated a little further and it seems that they don't really
'fail'. Just start taking significantly longer to insert, and the
messages start backing up and eventually stop being sent because
they're not being acknowledged. I can see a few "WARNING:  pgstat wait
timeout" messages around the time that this is happening in the
syslog.

Thanks,

Dan

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux