Locking

Поиск
Список
Период
Сортировка
От Simon Attwell
Тема Locking
Дата
Msg-id 20010216134006.G32644@binc.net
обсуждение исходный текст
Ответы Re: Locking  (Peter Eisentraut <peter_e@gmx.net>)
Re: Locking  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
How does postgresql deal with locking when one has a large select query running
on a > 700,000 row table, when there are inserts pending for that table.

I have an application that does a _lot_ of inserts, and a frontend that
makes large long laborious select queries on the same tables.

MySQL has the INSERT DELAYED which allows batch processing of inserts and
allows clients to receive and instant "OK" when doing inserts.

    - Simon

--
Simon Attwell
Systems Engineer
Berbee
5520 Research Park Drive
Madison, WI 53711
attwell@berbee.com

Berbee... putting the E in business.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PHP4 Persistent Connection
Следующее
От: Jie Liang
Дата:
Сообщение: Re: [ADMIN] Re: what means "INSERT xxx yyy" ?