in our installation we like to increase the main buffers.
We like to increase them to a size at which the main buffers
and the temp buffers are greater (128GB) than the swap
Sybase IQ does not accept this configuration as it requires
at least the same swap space as buffers are configured.
From my point of view I do not understand this limitation of
Why do the server wants to swap out data from the main store
when it can get non dirty pages every time again from the
For us it makes no sense to write the data to swap area
which already exist in the (permanent) main store.
Even writing the (few) dirty pages back to main store would
not be a big afford in comparison of writing the buffers to
Do I misunderstand the storage management?
Why can't we configure "no swap" usage?
Thanks for answers.
Subject: more buffer than swap
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 20 Jul 2011 05:38:32 -0700
X-Trace: forums-1-dub 1311165512 10.22.241.41 (20 Jul 2011 05:38:32 -0700)
X-Original-Trace: 20 Jul 2011 05:38:32 -0700, 10.22.241.41
Xref: forums-1-dub sybase.public.iq:4395
Article PK: 246535