pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Crawford <scrawford@pinpointresearch.com>
To: lai yoke hman <lllhman@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Performance benchmarking
Date: Fri, 06 Jul 2007 10:54:31 -0700
Message-ID: <468E81D7.1050208@pinpointresearch.com> (raw)
In-Reply-To: <BAY126-W211263B06A331B366A6CD4A9010@phx.gbl>
References: <BAY126-W211263B06A331B366A6CD4A9010@phx.gbl>

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



view thread (7+ messages)  latest in thread

Message-ID: <468E81D7.1050208@pinpointresearch.com>
Permalink:  ../468E81D7.1050208@pinpointresearch.com/
Also on:    postgresql.org/message-id/468E81D7.1050208@pinpointresearch.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scrawford@pinpointresearch.com, lllhman@hotmail.com
  Subject: Re: Performance benchmarking
  In-Reply-To: <468E81D7.1050208@pinpointresearch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox