Re: Enabling and Disabling Sequencial Scan

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Enabling and Disabling Sequencial Scan
Date: 2003-05-31 03:28:46
Message-ID: 20030530212846.26a82109.Robert_Creager@LogicalChaos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 30 May 2003 14:46:12 -0600 (MDT)
"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> said something like:

>
> level cache is. On my machine it's about 800 meg. It's measured in 8k > blocks, so 100,000 * 8k ~ 800 meg. The smaller this is, the more

Any thoughts on how to figure this out (disk buffer size)? For some reason, my system (2xAMD 2800+, 2Gb RAM 2.4.21 - /proc/meminfo) only shows a usage of 88kb of 'Buffers' usage, and that never changes. My 'Cached' usage is 1.7Gb. I've hit the kernel mailing list, and the one response I got said don't worry about it :-(

Cheers,
Rob

--
O_

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-05-31 04:11:26 Re: db growing out of proportion
Previous Message Robert Creager 2003-05-31 03:21:01 Re: db growing out of proportion