Re: Hardware/OS recommendations for large databases (

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-28 18:10:07
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD97C@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> It certainly makes quite a difference as I measure it:
>
> doing select(1) from a 181000 page table (completely uncached) on my
PIII:
>
> 8.0 : 32 s
> 8.1 : 25 s
>
> Note that the 'fastcount()' function takes 21 s in both cases - so all
> the improvement seems to be from the count overhead reduction.

Are you running windows? There is a big performance improvement in
count(*) on pg 8.0->8.1 on win32 that is not relevant to this debate...

Merlin

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-11-28 21:45:46 Re: Hardware/OS recommendations for large databases (
Previous Message Luke Lonergan 2005-11-28 16:26:21 Re: Hardware/OS recommendations for large databases (