Where is locking done?

Поиск
Список
Период
Сортировка
От Lawrence M. Kagan
Тема Where is locking done?
Дата
Msg-id 973buv$lil$1@news.tht.net
обсуждение исходный текст
Список pgsql-hackers
Here's my dillema:

We are currently building a site with multiple machines to run our website 
and client sites as well.  I would like to run the postgres binary on 2 
machines concurrently to assist in load balancing.  $PGDATA will be kept on 
a RAID 1+0.    I need to know where postgres does it's row & table locking. If it's done in memory, I've got some
problems! If it's done at or near 
 
the $PGDATA directory (which sounds like bad performance decision) that 
would be piece of cake.    Any advice or ideas on this issue would be 
GREATLY appreciated.

Thanks in advance!!

Larry


-- 
Lawrence M. Kagan
Allied Infosystems, Inc.
E-mail:    larry@alliedinfosystems.com
Web:       www.alliedinfo.com
Phone:     (954) 647-4600
Toll-free: (877) WEB-5888


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: CommitDelay performance improvement
Следующее
От: Jeff Duffy
Дата:
Сообщение: Re: PostgreSQL JDBC