Skip site navigation (1) Skip section navigation (2)

Re: random slow query

From: Mike Ivanov <mikei(at)activestate(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Sean Ma <seanxma(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: random slow query
Date: 2009-06-30 19:10:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Scott Marlowe wrote:
> Close, but it'll use that memory for cache. Large buffers are not
> typical in linux, large kernel caches are.
OK, we're talking about different things. You're right.

> If that tutorial says that, then that tutorial is wrong.  I'm guessing
> what that tutorial is talking about, and what top is saying are two
> very different things though.
Then it is an amazingly common misconception. I guess it first appeared 
in some book and then reproduced by zillion blogs. Essentially this is 
what Goolgle brings you on 'swap cache' query.

Thanks for clearing that out.

>>>  It's normal, and shouldn't worry anybody.  In fact it's a good sign
>>> that you're not using way too much memory for any one process
>> It says exactly the opposite.

This time I agree :-)


In response to

pgsql-performance by date

Next:From: Scott CareyDate: 2009-06-30 20:08:12
Subject: Re: random slow query
Previous:From: Jean-David BeyerDate: 2009-06-30 19:06:05
Subject: Re: random slow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group