Re: How to improve db performance with $7K?
От | Mohan, Ross |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | CC74E7E10A8A054798B6611BD1FEF4D307966B99@vamail01.thexchange.com обсуждение исходный текст |
Ответ на | How to improve db performance with $7K? (Steve Poe <spoe@sfnet.cc>) |
Список | pgsql-performance |
right, the oracle system uses a second "low latency" bus to manage locking information (at the block level) via a distributed lock manager. (but this is slightly different albeit related to a clustered file system and OS-managed locking, eg) -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Dawid Kuroczko Sent: Wednesday, April 20, 2005 4:56 AM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] How to improve db performance with $7K? On 4/19/05, Mohan, Ross <RMohan@arbinet.com> wrote: > Clustered file systems is the first/best example that > comes to mind. Host A and Host B can both request from diskfarm, eg. Something like a Global File System? http://www.redhat.com/software/rha/gfs/ (I believe some other company did develop it some time in the past; hmm, probably the guys doing LVM stuff?). Anyway the idea is that two machines have same filesystem mounted and they share it. The locking I believe is handled bycommunication between computers using "host to host" SCSI commands. I never used it, I've only heard about it from a friend who used to work with it in CERN. Regards, Dawid ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
В списке pgsql-performance по дате отправления: