Re: cpu_tuple_cost - Mailing list pgsql-performance

From Greg Stark
Subject Re: cpu_tuple_cost
Date
Msg-id 874qfblhqb.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: cpu_tuple_cost  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-performance
"Magnus Hagander" <mha@sollentuna.net> writes:

> What about the cache memory on the disk? Even IDE disks have some 8Mb
> cache today, which makes a lot of difference for fairly short scans.
> Even if it's just read cache. That'll bring the speed of random access
> down to a 1=1 relationship with sequential access, assuming all fits in
> the cache.

8MB cache is really insignificant compared to the hundreds or thousands of
megabytes the OS would be using to cache. You could just add the 8MB to your
effective_cache_size (except it's not really 100% effective since it would
contain some of the same blocks as the OS cache).

--
greg

pgsql-performance by date:

Previous
From: David Gagnon
Date:
Subject: Re: Performance problem on delete from for 10k rows. May
Next
From: Daniel Crisan
Date:
Subject: multi-column index