PostgreSQL to use as much RAM as it
requires without swapping.
What can I do to force the system to allow PostgreSQL to do this?
Regards,
Kevin Schroeder
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
- Original Message -
From: "Matt Casters" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
It looks to me like you are using no (device or file) swap at all, and
have 1.3G of real memory free,
t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
It looks to me like you are using no (device or file) swap at all, and
have 1.3G of real memory free, so could in fact give Postgres more of it
:-)
Indee
Stange" <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 19, 2005 7:51 AM
Subject: Re: [PERFORM] Swapping on Solaris
Mark Kirkwood wrote:
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really h
r PostgreSQL to be swapped unless that free
memory is Solaris caching files in RAM.
Kevin
- Original Message -
From: "Greg Spiegelberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, Januar
Maybe, I'm just seeing a problem where none exists. I ran sar -w 3 100 and
I actually did not see any swap activity despite the fact that I've got
500+MB of swap file being used.
Kevin
- Original Message -
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kev
--
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 9:30 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I suspect that the memory is being used to cache files as well
used, 2988840k
available
Kevin
- Original Message -
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may
al Message -
From: "Matt Clark" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 1:01 PM
Subject: Re: [PERFORM] Swapping on Solaris
This page may be of use:
http://www.serverworldmagazine.com/monthly/2003/02/solaris
That would be something that I'd like to see. Being new to PostgreSQL some
of the basics of tuning the database were a little hard to find. The reason
people go with MySQL is because it's fast and easy to use. That's why I had
been using it for years. Then when a problem came along and I couldn
My goodness people!! If you are just going to bash people who are trying to
learn PostgreSQL then you have no chance of ever getting new people using
it! Cut out this crap and do what this list is meant to do, which is, I'm
assuming, helping people figure out why their installations aren't runnin
11 matches
Mail list logo