| 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_
| 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 |