Re: Performance benchmarking

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: lai yoke hman <lllhman(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Performance benchmarking
Date: 2007-07-06 17:54:31
Message-ID: 468E81D7.1050208@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 to get 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2007-07-06 18:15:40 Re: replicating postgresql database to ms-sql database
Previous Message Mary Anderson 2007-07-06 17:48:48 replicating postgresql database to ms-sql database