On Fri, 27 Jun 2003, Matthew Hixson wrote:
> On Friday, June 27, 2003, at 01:17 PM, Jord Tanner wrote:
> > I've heard anecdotally that Linux has troubles if the swap space is
> > less
> > than the RAM size. I note that you have 6G of RAM, but only 2G of swap.
>
> I've heard that too, but it does
> I've heard that too, but it doesn't seem to make much sense
> to me. If
> you get to the point where your machine is _needing_ 2GB of swap then
> something has gone horribly wrong (or you just need more RAM in the
> machine) and it will just crawl until the kernel kills off whatever
> proce
> The "used" figure in Top doesn't really tell you anything,
> since it includes
> the kernel buffer which tries to take up all available
> memory. If you
> actually look at the list of processes, I think you'll find
> that you're only
> using 1-2% of memory for applications.
>
> I'm not su
On Friday, June 27, 2003, at 01:17 PM, Jord Tanner wrote:
On Fri, 2003-06-27 at 12:09, Patrick Hatcher wrote:
I have 6gig Ram box. I've set my shmmax to 307200. The database
starts up fine without any issues. As soon as a query is ran
or a FTP process to the server is done, the used me
On Fri, 2003-06-27 at 12:09, Patrick Hatcher wrote:
> I have 6gig Ram box. I've set my shmmax to 307200. The database
> starts up fine without any issues. As soon as a query is ran
> or a FTP process to the server is done, the used memory shoots up and
> appears to never be released.
I
Thank you
Patrick Hatcher
"scott.marlowe
Shared buffer is now set to 20,000 as suggested. So far so good.
As far as shmmax, it really is my ignorance of Linux. We are going to play
around with this number. Is there a suggested amount since I have
my effective_cache_size = 625000 (or does one have nothing to do with the
other)
Thanks a
Patrick,
> Sorry for posting an obvious Linux question, but have any of you
> encountered this and how have you fixed it.
> I have 6gig Ram box. I've set my shmmax to 307200. The database
> starts up fine without any issues. As soon as a query is ran
> or a FTP process to the server is do
This is actually normal. Look at the amount cached: 6257620K. That's
6.2Gig of cache. Linux is using only 6517776k - 6257620k of memory, the
rest is just acting as kernel cache. If anything tries to allocate a bit
of memory, linux will flush enough cache to give the memory to the
applicatio
Sorry for posting an obvious Linux question, but have any of you
encountered this and how have you fixed it.
I have 6gig Ram box. I've set my shmmax to 307200. The database
starts up fine without any issues. As soon as a query is ran
or a FTP process to the server is done, the used memory
Bruno,
> I will have to manage more or less 10.000 products with more or less 2-3
> options by products and more or less 40 options-groups.
>
> Do you think that this query will be hard for PostgreSQL (currently
> 7.2.1 but I will migrate to 7.3.2 when going in production environment)
> ?
> How ca
Hello,
I've a performance question that I would like to ask you :
I have to design a DB that will manage products, and I'm adding the
product's options management.
A box can be red or yellow, or with black rubber or with white rubber,
for example.
So I have a product (the box) and two options gr
On Fri, 27 Jun 2003 11:10:58 +0200, Andre Schubert <[EMAIL PROTECTED]>
wrote:
>Once a month we delete the all data of the oldest month.
>And after that a vacuum full verbose analyze is performed.
>Could this cause reordering of the data ?
I may be wrong, but I think VACUUM FULL starts taking tuple
On Fri, 27 Jun 2003 10:43:01 +0200
Manfred Koizar <[EMAIL PROTECTED]> wrote:
> On Fri, 27 Jun 2003 08:07:35 +0200, Andre Schubert
> <[EMAIL PROTECTED]> wrote:
> >Traffic data are inserted every 5 minutes with the actual datetime
> >of the transaction, thatswhy the table should be physically order
On Fri, 27 Jun 2003 08:07:35 +0200, Andre Schubert
<[EMAIL PROTECTED]> wrote:
>Traffic data are inserted every 5 minutes with the actual datetime
>of the transaction, thatswhy the table should be physically order by time_stamp.
So I'd expect a correlation of nearly 1. Why do your statistics show
15 matches
Mail list logo
