PostgreSQL alternative to "Oracle Real Application Cluster"
От | Hubert Fröhlich |
---|---|
Тема | PostgreSQL alternative to "Oracle Real Application Cluster" |
Дата | |
Msg-id | 3EF03C9D.8050908@bvv.bayern.de обсуждение исходный текст |
Ответы |
Re: PostgreSQL alternative to "Oracle Real Application
Re: PostgreSQL alternative to "Oracle Real Application Re: PostgreSQL alternative to "Oracle Real Application Cluster" |
Список | pgsql-general |
Hello list I am working with PostgreSQL for the Bavarian Cadastral Administration. We want to update our WWW online services so that they can use more data. For that reason we want to set up an archive of geographical data (ca. 400GB vector data and - maybe also 4 TB of raster data) manily used for http services, i.e. the focus is on read operations. (although we have to do also some kind of replication from primary storage ) The system should be highly performant and highly available. The use is designed mainly for OpenGIS standardized WWW applications on geographical data such as UMN MapServer ( > several 100000 web hits for geographical data alone). Yet it is not quite clear if we put the raster data simply in a file system or (as BLOBs) into a database. We use a lot of OpenSource software, not only PostgreSQL. Using OpenSource software is a major column of our IT strategy. Now we have got a proposal for hard- and software for this machine which is based mainly on the concept of the "Oracle Real Application Cluster" on RedHat Linux boxes & file servers. The concept is said to offer big performance - but this concept does not fit into our IT strategy very well. We are a bit cautious concerning promises, as Oracle Real Application Cluster seems to be some kind of "black box" and we do not know HOW it really works. What we would like to have is some alternative concept which allows us to use PostgreSQL on a powerful hardware to get highly performant and higly available database access on our terabytes. a) Does PostgreSQL have some features using a clustered hardware? b) If no, what could be an alternative hardware concept ? Can anybody give me some advice or some hints to somebody who could help us a bit further, some web page ... Any help will be greatly appreciated. Thanks a lot. Yours, Hubert -- ------------------------------------------------------------------------------- Dr.-Ing. Hubert Fröhlich Bezirksfinanzdirektion München Alexandrastr. 3, D-80538 München, GERMANY Tel. :+49 (0)89 / 2190 - 2980 Fax :+49 (0)89 / 2190 - 2459 hubert.froehlich@bvv.bayern.de
В списке pgsql-general по дате отправления: