Обсуждение: PostgreSQL Performance
Hi all Actually I have the Oracle Database. I am searching about others Databases Soluctions. I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory. The size of my actual Database is 5Gb and the it has 300 simultaneous access. The postgreSQL provide a good performance to my application? How I could search about? Thank you very much... []´s Sidnei
Sidnei, You'll find PostGreSql and Oracle to be kindred spirits. Similar, but different at the same time. I find performancevery good, although you'll need to tweak the system memory parameters from the defaults and the postgresql.conffile. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: BASEI, Sidnei R. [mailto:basei@sreb.com.br] Sent: Tuesday, January 11, 2005 3:48 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] PostgreSQL Performance Hi all Actually I have the Oracle Database. I am searching about others Databases Soluctions. I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory. The size of my actual Database is 5Gb and the it has 300 simultaneous access. The postgreSQL provide a good performance to my application? How I could search about? Thank you very much... []´s Sidnei ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
Sidnei, In principle, yes, postgres can do quite well (we use 2 CPU boxes with 2 gigs of RAM for most of our production servers),but a lot would depened on what sort of use your database gets -- all read and bulk updates ? Or lots of updates? Are the queries complex ? etc., etc. How fast are the disk drives, and how many of them are ? If you give people a bit more information you'll get more useful answers. Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: BASEI, Sidnei R. [mailto:basei@sreb.com.br] Sent: Tue 1/11/2005 12:48 PM To: pgsql-admin@postgresql.org Cc: Subject: [ADMIN] PostgreSQL Performance Hi all Actually I have the Oracle Database. I am searching about others Databases Soluctions. I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory. The size of my actual Database is 5Gb and the it has 300 simultaneous access. The postgreSQL provide a good performance to my application? How I could search about? Thank you very much... []´s Sidnei ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend