Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BFD6C1337BF0 for ; Wed, 13 Oct 2010 10:02:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 86741-03 for ; Wed, 13 Oct 2010 13:02:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 5B1E01337BF3 for ; Wed, 13 Oct 2010 10:02:23 -0300 (ADT) Received: from [192.168.1.6] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu1) with ESMTP (Nemesis) id 0LhziI-1OK0ya1rG6-00mclb; Wed, 13 Oct 2010 15:02:23 +0200 Message-ID: <4CB5ADDD.7020402@2ndquadrant.com> Date: Wed, 13 Oct 2010 09:02:21 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Mladen Gogala CC: pgsql-performance@postgresql.org Subject: Re: Slow count(*) again... 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> <4CB5A223.4070609@2ndquadrant.com> <4CB5A718.6050206@vmsinfo.com> In-Reply-To: <4CB5A718.6050206@vmsinfo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:2x00WbTRsqhZjPIJMpHJ1yPvpxa0/lvuxbfUJ1NJ9wI Rm3V2FqFQH+lRVkprzmpbGhMIy3Y4XhuPC+78vpEMC+qV/E6fS GSqpiuzXXrWWLlxaFH+uptlgj7pwFjq8rJL+ka0MmO54xGUIC5 gqrYARArHljmprTkxu8eI871ufZwP6b2/sQH8C+jsgT0rffQk+ isig6Ua7vVGZuZIybX4WWoRfw5xEoXWKx77MQSd2n4= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/208 X-Sequence-Number: 40627 Mladen Gogala wrote: > I am afraid that my management will not let me use anything that > doesn't exist as a RPM package in the current Red Hat distribution. No > Ubuntu, no Fedora, no manual linking. There will always be that > ominous question: how many other companies are using XFS? From the > business perspective, questions like that make perfect sense. XFS support is available as an optional module starting in RHEL 5.5. In CentOS, you just grab it, so that's what I've been doing. My understanding is that you may have to ask your sales rep to enable access to it under the official RedHat Network channels if you're using a subscription from them. I'm not sure exactly what the support situation is with it, but it's definitely available as an RPM from RedHat. -- 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