Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD97C@Herge.rcsinc.local
Whole thread Raw
Responses Re: Hardware/OS recommendations for large databases (  (Mark Kirkwood <markir@paradise.net.nz>)
List 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

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: Mark Kirkwood
Date:
Subject: Re: Hardware/OS recommendations for large databases (