From: Greg Smith <greg@2ndquadrant.com>
To: Dan Harris <fbsd@drivefaster.net>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Slow count(*) again...
Date: Wed, 13 Oct 2010 08:12:19 -0400
Message-ID: <4CB5A223.4070609@2ndquadrant.com> (raw)
In-Reply-To: <4CB495A7.6010700@drivefaster.net>
References: <201010091626.18636.neil.whelchel@gmail.com>
<4CB11CC7.8070300@vmsinfo.com>
<4CB167CA.9070109@postnewspapers.com.au>
<4CB1F46E.80205@vmsinfo.com>
<90E30938-1E5E-4DCA-A1FB-AEECEB76A70D@richrelevance.com>
<4CB48127.6090200@drivefaster.net>
<8BE535FE-F9DB-4CBC-A932-EB4F07905698@richrelevance.com>
<4CB495A7.6010700@drivefaster.net>
Dan Harris wrote:
> I'm not sure how to figure out what version of XFS we're on.. but it's
> Linux kernel 2.6.24-24 x86_64 on Ubuntu Server 8.04.3. Postgres
> version 8.3
There's the kernel side support that matches your kernel, as well as the
xfsprogs package. The latter is where a lot of distributions haven't
kept up with upstream changes, and where I suspect the defragmenter bug
you ran into is located at.
Hardy ships with 2.9.4-2: http://packages.ubuntu.com/hardy/xfsprogs
The work incorporating a more stable XFS into RHEL started with xfsprogs
3.0.1-6 going into Fedora 11, and 3.1.X would represent a current
release. So your Ubuntu kernel is two major improvement releases
behind, 3.0 and 3.1 were the upgrades to xfsprogs where things really
got going again making that code modern and solid. Ubuntu Lucid
switched to 3.1.0, RHEL6 will probably ship 3.1.0 too.
--
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book
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-performance@postgresql.org
Cc: greg@2ndquadrant.com, fbsd@drivefaster.net
Subject: Re: Slow count(*) again...
In-Reply-To: <4CB5A223.4070609@2ndquadrant.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