Re: memory issue: paging, disk activity, table size - was: optimizing a select statement

Karthik Viswanathan wrote: Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command.

memory issue: paging, disk activity, table size - was: optimizing a select statement

Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command. The activity monitor shows