# Active record is not releaed used memory

**URL:** <https://www.ruby-forum.com/t/active-record-is-not-releaed-used-memory/188768>\
**Category:** Rails\
**Created:** [May 18, 2010, 8:53am UTC](https://www.ruby-forum.com/t/active-record-is-not-releaed-used-memory/188768 "2010-05-18T08:53:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmanivannancse](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/8491ac/32.png) [@jmanivannancse](https://www.ruby-forum.com/u/jmanivannancse)\
**Post date:** [May 18, 2010, 8:53am UTC](https://www.ruby-forum.com/t/active-record-is-not-releaed-used-memory/188768/1 "2010-05-18T08:53:35Z")

</div>

I have tried small ruby program like

require ‘rubygems’  
require ‘postgres’  
db = PGconn.connect(‘localhost’, 5432, ‘’, ‘’, ‘prdjnj’,‘postgres’,  
‘postgres’)  
res=db.exec(“select \* from users limit 300000”)  
res.clear  
puts “After clear result object”  
a=1  
while a!=2  
end

Before running this program,Initial free memory is 640MB  
The query(“select \* from users limit 300000”) execution taken the time  
is upto 110MB when i run this program … So free memory is reduced from  
640MB to 530MB…Now used memory is 110MB that released after the  
execution of the query ie program reached the while conditions

I have followed same scenario in Rail’s active\_record instead of  
PGconn…

@users=User.all(:limit=\>300000)  
@users.clear  
puts “After clear result object”

Here Used memory is not released even after execute the query and clear  
resulting object…Memory is released well when i use PGconn… but its  
not working in active\_record

Please instruct me how to release used memory in Rail’s active\_record