Re: Postgresql on SAN

Yannick Lecaillez wrote:
> Thanks a lot for all people which answer.
>
> I have this "clustering on SAN" problem today and i think it could be
> less harder to implement this today than it was for Oracle in 1993
> (since i can find a lot of work in opensource which could be interesting
> in this project : distributed lock, clustered shared memory, etc ...).
>
> I will try to have a look about all these things btw, i haven't got
> the pretention to suceed to do anything ... Just look and see
> a bit more deeply how it could be hard.
>
> Is there something like a "big picture" about postgres internal ?
> What path is used from the SQL query to the hard-disk files ? About
> the internal locking mechanism ? about the usage of the shared memory ?
> I see there is everything described in the postgres doc but no "big
> picture" which could help me to understand faster ... :(

Have you read the developers FAQ on the developers web page?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073