what could cause inserts getting queued up and db locking??

Поиск
Список
Период
Сортировка
От Brian Maguire
Тема what could cause inserts getting queued up and db locking??
Дата
Msg-id 4BAFBB6B9CC46F41B2AD7D9F4BBAF7850DE169@vt-pe2550-001.vantage.vantage.com
обсуждение исходный текст
Ответы Re: what could cause inserts getting queued up and db locking??
Список pgsql-general
Background Info:

I have a table with a approx 2.5 million rows.  The table often gets 200-300 inserts per second.  We are see that the
database(7.4.1 Red Hat Enterprise ED 4 way Xeon) will periodically lock up all of a sudden and force the database to
queueup hundreds of queries.  The database comes to complete halt until eventually it clears itself out.  There is
otherdatabase activity going on but the above activity represents 75% of the frequency of the queries.  The table
describedabove has few reads as we try to restrict reads.  We have it set so it does one read every 20 seconds
collectingall of the newest data in the last 20 seconds and moves it to a reporting table.   

What could cause the database to lock up and queue up all the queries?



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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: How to connect with postmaster through TCP socket
Следующее
От: Miles Keaton
Дата:
Сообщение: list fieldnames in table? (from PHP)