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 

improve performance in PostgreSQL  XML

Forum Index » Tuning and Migration Wizard
Author Message
[Post New]16 Apr 2009 04:09:38
    Subject: improve performance in PostgreSQL
[Up]
Lumena_R

New member

Joined: 16 Apr 2009 03:43:12
Messages: 1
Offline
I'm using windows as OS and I use PostgreSQL 8.1 for database.
is there any solution for me to improve performance n how to test and benchmark the result?
thx for all...

regards,
rinto(Indonesia)
[Post New]20 Apr 2009 05:49:23
    Subject: Re:improve performance in PostgreSQL
[Up]
Usman_S

Member

Joined: 4 Feb 2009 04:22:54
Messages: 20
Offline
Performance:
Performance tuning in PostgreSQL mostly involves modifying postgresql.conf file and updating the memory related parameters according to your needs. This information is available in official documentation as well as google 'PostgreSQL performance' will also return several useful articles. Of course, you can always utilize EnterpriseDB Tuning Wizard to fine tune your PostgreSQL installation.

Benchmarking:
You can use BenchmarkSQL to benchmark PostgreSQL. Find out about it at http://pgfoundry.org/projects/benchmarksql/

Post your comments if you require more detailed resources/links.

Regards,

/Uzi

This message was edited 1 time. Last update was at 20 Apr 2009 05:55:35
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team