Re: extremly low memory usage - Mailing list pgsql-performance

From John A Meinel
Subject Re: extremly low memory usage
Date
Msg-id 43064A06.8020102@arbash-meinel.com
Whole thread Raw
In response to Re: extremly low memory usage  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Responses Re: extremly low memory usage
List pgsql-performance
Jeremiah Jahn wrote:
> Rebuild in progress with just ext3 on the raid array...will see if this
> helps the access times. If it doesn't I'll mess with the stripe size. I
> have REINDEXED, CLUSTERED, tablespaced and cached with 'cat table/index
>
>>/dev/null' none of this seems to have helped, or even increased my
>
> memory usage. argh! The only thing about this new system that I'm
> unfamiliar with is the array setup and LVM, which is why I think that's
> where the issue is. clustering and indexing as well as vacuum etc are
> things that I do and have been aware of for sometime. Perhaps slony is a
> factor, but I really don't see it causing problems on index read speed
> esp. when it's not running.
>
> thanx for your help, I really appreciate it.
> -jj-
>

By the way, how are you measuring memory usage? Can you give the output
of that command, just to make sure you are reading it correctly.

John
=:->


Attachment

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: extremly low memory usage
Next
From: Ron
Date:
Subject: Re: sustained update load of 1-2k/sec