Re: Performance benchmarking - Mailing list pgsql-admin

From Steve Crawford
Subject Re: Performance benchmarking
Date
Msg-id 468E81D7.1050208@pinpointresearch.com
Whole thread Raw
In response to Performance benchmarking  (lai yoke hman <lllhman@hotmail.com>)
List pgsql-admin
lai yoke hman wrote:
>
> Hello,
> I am an undergraduate of a university in Malaysia, if I want to do performance benchmark on PostgreSQL 8, do I need
toget a license agreement or some sort of thing? 
> Thanks.

Your license, provided without charge, is here:
http://www.postgresql.org/about/licence

As to benchmarking...

Please be sure to read up on the postgresql.conf settings - the default
settings are designed to get the server to start on a reasonably wide
range of platforms. It is assumed that the DBA will update these
settings as appropriate for the platform and workload in use. Failure to
do so will have serious performance implications.

Also be sure you are familiar with VACUUM and ANALYZE and the effect
they have on performance.

Cheers,
Steve

pgsql-admin by date:

Previous
From: Mary Anderson
Date:
Subject: replicating postgresql database to ms-sql database
Next
From: "Kevin Grittner"
Date:
Subject: Re: replicating postgresql database to ms-sql database