Optimizing Memory-Areas

From: Chris Neubauer <water.world_at_gmx.de>
Date: Mon, 24 Sep 2001 09:49:02 +0200
Message-ID: <9omogu$do0ag$1@ID-76747.news.dfncis.de>

Hi,

I have a database, about 30 gigabyte of data. There are very large tables, and a typical 'select' joins three or four of them, the resulting number of rows varies between 1 and 10,000, not very much. What are recommendable values for the parameters sort_area_size and hash_area_size? At the moment they are at 6 MB / 3 MB, but I assume that is not enough. Are there other parameters which possibly slow down the performance?

Here the answering times for equal queries resulting in 31 rows ... 0.5 seconds
3000 rows ... 80 seconds

The different number of rows is the result of a different date range. Especially the last value seems much to high resp. to slow.

Thanks,
Sebastian Received on Mon Sep 24 2001 - 02:49:02 CDT