Re: illustra Server always run out of swap space

Seth Grimes (grimes@magnet.com) wrote: : I have to disagree. Vacuuming the database will free up disk space but : shouldn't affect memory usage. that is right :).. although i have had a problem were the database had not been vacuumed for a little while.. and queries began to eat up alot of memory and take upwards of 20 minutes for a simple select on a one row table... tech support told me that a vacuum might help. basically what was happening is i had removed a bunch of rows (they remain in the database until a vacuum)... for some reason these removed fields began to interfere with the normal running of the query... :Increasing the number of locks and : buffers will increase the amount of memory allocated to DB server : processes and can make the swapping problem worse unless it manages to : get transactions to complete faster, increasing throughput of DB server : processes. I'd try running with fewer DB server (miserver) procs. and : allocating less memory to each of them. i should have said increasing/decreasing.. as alot depends on the number of server processes that are running... all in all you are more correct than i was bf