Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 408BE9FB61C for ; Fri, 6 Jul 2007 14:54:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 07212-06 for ; Fri, 6 Jul 2007 14:54:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id 6C0469FB5C2 for ; Fri, 6 Jul 2007 14:54:33 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 1744AE00EC84; Fri, 6 Jul 2007 10:54:32 -0700 (PDT) Message-ID: <468E81D7.1050208@pinpointresearch.com> Date: Fri, 06 Jul 2007 10:54:31 -0700 From: Steve Crawford User-Agent: Thunderbird 1.5.0.10 (X11/20060911) MIME-Version: 1.0 To: lai yoke hman CC: pgsql-admin@postgresql.org Subject: Re: Performance benchmarking References: In-Reply-To: Content-Type: text/plain; charset=Big5 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/64 X-Sequence-Number: 26045 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