470,614 Members | 1,412 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

High volume use of postGres


I've been charged with investigating postGIS as a replacement for our current Informix runtime (9.3), which uses the Spatial blade. Currently we use two Sun Sparc/Ultra 80 boxes with 3 CPUS dedicated to Informix.

We use our database to calculate the image files we have within a given area (ST_Union, Intersect and the like).

Originally this company tried Oracle, but, as the Firesign Theater put it, "He's no fun, he fell right over!" ... Informix works well but charges a hefty amount for each runtime CPU.

Our databases are not particularly large -- only about 500,000 rows in the larger ones, but we're running more than a million hits a day, not evenly spread, natch so at peak we need a lot of capacity.

Are there documents on performance of postGres on various platforms that I might be able to get some ideas from ? Such issues as multiple CPU vs single CPU, Operating System -- we're leaning towards Linux of some flavor but also have some Sun servers (not as hefty as our current runtime database servers) -- would be of interest.

Any suggestions from users that have/are really beating up postGIS/postgres would be welcome ! (for instance, cleaning up a busy database, supporting multiple servers, etc.)

Thanks,

Greg Williamson
DBA
GlobeXplorer LLC

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #1
0 1247

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Irmen de Jong | last post: by
12 posts views Thread by Ron Johnson | last post: by
2 posts views Thread by Arsen V. | last post: by
2 posts views Thread by =?Utf-8?B?RGFtZW9u?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.