Message-ID: <43064A06.8020102@arbash-meinel.com>
Date: Fri, 19 Aug 2005 16:07:18 -0500
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
MIME-Version: 1.0
To: Jeremiah Jahn <jeremiah@cs.earlham.edu>
Cc: Ron <rjpeace@earthlink.net>,
	postgres performance <pgsql-performance@postgresql.org>
Subject: Re: extremly low memory usage
References: <1124331108.27881.96.camel@bluejay.goodinassociates.com>	
	<EA4219B9-E2B0-4756-ABF2-D84F245FDFB5@torgo.978.org>	
	<1124386761.27881.119.camel@bluejay.goodinassociates.com>	
	<4304CB77.4070403@arbash-meinel.com>	
	<1124470109.27881.152.camel@bluejay.goodinassociates.com>	
	<43061472.2080201@arbash-meinel.com>	
	<6.2.3.4.0.20050819140714.05c181e8@pop.earthlink.net>	
	<43063196.9000001@arbash-meinel.com>
	<1124485299.27881.192.camel@bluejay.goodinassociates.com>
In-Reply-To: <1124485299.27881.192.camel@bluejay.goodinassociates.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig0B481C51B574C85D434A19BC"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig0B481C51B574C85D434A19BC
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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
=:->


--------------enig0B481C51B574C85D434A19BC
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (Darwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDBkoGJdeBCYSNAAMRAkUiAKCAOu6b6h8oee4Tv/WB0VDtVOF2OACfaDp3
Cx9Hw+sPlGNxaw1/tZ8Mxv4=
=IxL1
-----END PGP SIGNATURE-----

--------------enig0B481C51B574C85D434A19BC--