EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Database performance  XML

Forum Index » Standard Server
Author Message
[Post New]31 Aug 2010 06:47:08
    Subject: Database performance
[Up]
kiran_kumar_2

Member

Joined: 3 Mar 2010 09:47:03
Messages: 16
Offline
Hi,
I am using EDB 8.2 .
My production system RAM size is 32GB. OS 2003.
I retrieve 100 rows from single table my database performs very slow operation.

How to change database default settings.

My database default settings are
shared_buffers = 32MB
temp_buffers = 8MB

Is there any other way to increase database performance ?
Please help me in this regard.

Thanks,
Kiran
 
Forum Index » Standard Server
Go to:   
Powered by JForum 2.1.8 © JForum Team