Database Performance

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

Hi Kiran,

Is this related to GridSQL, or just using EnterpriseDB Advanced Server? If it has nothing to do with GridSQL, you have posted in the wrong forum and will get more help elsewhere.

Regards,

Mason

Hi Mason,

Thanks for your reply.

I am using Enterprise DB Advanced Server 8.2 .

Please help me.

Thanks,
Kiran

Hi Kiran,

I retrieve 100 rows from single table my database performs very slow operation.

In PostgreSQL, performance depends on various aspects, with limited information its hard to discuss on this issue.

How to change database default settings.

Settings can be changed in three ways
a) Session- Level - Changing in the edb-psql terminel for that particular session
eg:- edb=# set temp_buffer to '2MB';

b) Database Level
eg:- edb=# alter database <dbname> set <parameter> to <value>;

c) Cluster Level - Edit the postgresql.conf file and change the parameter as per the requirement.

My database default settings are
shared_buffers = 32MB
temp_buffers = 8MB
Is there any other way to increase database performance ?

Temp_buffers is used for temporary tables, shared_buffers is not only the one to tune to get the better performance. Proper information on the Database Server will help in suggesting further.