From owner-freebsd-performance@FreeBSD.ORG Wed Sep 30 18:09:50 2009 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3E37F1065670 for ; Wed, 30 Sep 2009 18:09:50 +0000 (UTC) (envelope-from vilmos.gyorgy@gmail.com) Received: from mail-ew0-f209.google.com (mail-ew0-f209.google.com [209.85.219.209]) by mx1.freebsd.org (Postfix) with ESMTP id C1B1A8FC0A for ; Wed, 30 Sep 2009 18:09:49 +0000 (UTC) Received: by ewy5 with SMTP id 5so802128ewy.36 for ; Wed, 30 Sep 2009 11:09:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=PxIDZcwds64lti/r7lkkLj2xz60+HjgEfRQk7vpftUw=; b=qVJQIwhzFZi6c8XRxuchvTNrNHbig0ws5DqwMs4F+bx4g0x5ANHm1ugKqY51OIyDLy Zi38endMlW9Im7nZumI1DtvtyUL9Ace5XoTpyF15EkCQMc6HVB0TOVDejFE76UeeLX1M czn3GwGmWXXCW7OShOAxoIFMmgv9lB3PhlFl0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=yGesDgY4LqrvkhENZV7mmQjd3va9aqdwS5Svw1WZOa2SmLsrs6uNXddK+zpZu8Kr54 BWr/J2kKnWjiEGl7e4Wx1qlwle/CxlHwNbzm8Rn+THZkf8gji9cunGtVv1oOd/licSEO QeHVwofltkTZIrEdMu/iXjPZEFhzAbrQLborc= MIME-Version: 1.0 Received: by 10.216.35.193 with SMTP id u43mr26616wea.113.1254334187771; Wed, 30 Sep 2009 11:09:47 -0700 (PDT) In-Reply-To: References: Date: Wed, 30 Sep 2009 20:09:47 +0200 Message-ID: From: =?ISO-8859-1?Q?Gy=F6rgy_Vilmos?= To: Francisco Reyes X-Mailman-Approved-At: Wed, 30 Sep 2009 19:52:42 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-performance@freebsd.org Subject: Re: Performance evaluation of PostgreSQL's historic releases X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 30 Sep 2009 18:09:50 -0000 2009/9/29 Francisco Reyes > Gy=F6rgy Vilmos writes: > > I've done a benchmark of recent versions of PostgreSQL's last five major >> releases to see how performance has changed during the past years from >> version to version. >> > > Thanks! > Very interesting. > Did you share it with the Postgresql list yet? > I think they would find it very interesting. > > Any plans on doing simmilar tests with data that does not fit in memory? > Also could you share what settings were used for postgres? Where any > defaults changed? Effective memory, shared_buffers, etc... any of them > adjusted for the machine's memory? > I've updated the article with the used config. With this machine everything would fit in memory (72G disk versus 128 G RAM :). Of course I could artificially limit it... --=20 http://suckit.blog.hu/