Thanks for the information . Seems when running select query [with variations ] for terabyte of data , somehow system memory consumption jumps to 8GB ..
 
Is it possible to suggest some equation like this ; For eg 
select a,b,c from table ;
 
Row_memory_usage = Total_rows_in_the_table * row page size * some variable part + some kb's for temporary usage or something similar to this .
 
I am debugging the disk cache and paging related areas . Any inputs for the above query will be highly appreciateable .

--- On Wed, 8/31/11, Alexey Kovyazin <ak@...> wrote:


From: Alexey Kovyazin <ak@...>
Subject: Re: [firebird-support] amount of memory being consumed
To: firebird-support@yahoogroups.com
Date: Wednesday, August 31, 2011, 1:38 PM


 



Hello,

> Can we get an idea of the amount of memory being consumed by category,
> for instance, the amount used to store the results of the sub-query,
> the amount consumed by intermediate joint results, the amount used by
> the sort, the amount used by the grouping and aggregation. The more
> detail the better of course, but I understand there may be a limit to
> how much detail we can have available.
>

You can use MON$ tables in 2.1 and 2.5 versions of Firebird to get some
information about memory consumption.
Though if you would explain why you are looking for such information,
you would get more useful answers.

Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)

[Non-text portions of this message have been removed]








[Non-text portions of this message have been removed]