On Thu, 2005-01-20 at 06:58, Troyston Campano wrote: > I guess what I am concerned about *is* running on a production server more > than a test server. Basically, I'd be taking a couple applications that are > running on the Oracle database instance, building a Postgresql instance, and > migrating them to that postgresql database instance. I'm just wondering > whether it's a bad idea to run them on the same server machine in a > production environment. (So instead of having 10 applications running on > Oracle on ServerComputerA...build a new postgresql instance on > ServerComputerA that lives along with Oracle and migrating 3 of the > applications to Postgresql. Have you got a spare machine you can do the testing on at first? That will allow you to throw big nasty queries at the server and tune it first, before putting postgresql on the production box. I'd recommend reading the tuning document from varlena: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html And experimenting with various settings on a test box first. My first PostgreSQL server way back when was running 6.5.2 or so on my P-II-300 workstation with 128 Megs of ram sitting under my desk, and it ran quite well, well enough we used it as our development / staging server for almost a year. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
