Date: Mon, 3 Apr 2000 04:43:19 +0200 From: "Marinos J . Yannikos" <mjy@pobox.com> To: David Greenman <dg@root.com> Cc: questions@freebsd.org Subject: Re: tuning the vm system / disk cache Message-ID: <20000403044319.V31173@TK147108.telekabel.at> In-Reply-To: <200004030209.TAA07259@implode.root.com>; from David Greenman on Sun, Apr 02, 2000 at 07:09:52PM -0700 References: <20000403025556.S31173@TK147108.telekabel.at> <200004030209.TAA07259@implode.root.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sun, Apr 02, 2000 at 07:09:52PM -0700, David Greenman wrote: > I'm sure the system is already caching the entire file - evidence of this > is the 438M of free memory, which the system would directly allocate from in > order to cache the file. The only way I can explain the disk I/O is that there > must be some writes taking place for some reason. You're right (of course). I checked Postgres' data directory and, surprisingly, it writes temporary files for every query. Their filenames begin with "pg_sorttemp", so the GROUP BY clause seems to be the culprit. Shouldn't it be possible to get rid of those disk accesses somehow? These are very short-lived files, softupdates are enabled. -mjy -- ***==> Marinos J. Yannikos <mjy@pobox.com> ***==> http://pobox.com/~mjy To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20000403044319.V31173>