How much ram on the VM Server do i need to index 4 milion records.
I am using pgestraier to perform the index
#pgestindex.pl urldb --create n_pattern --"sql="select patternid,url from
n_patern" > pattern.sql
When i use 256 RAM it is very slow and the index stops at 1352000 records
out of 4000000 records but when 512RAM it becomes faster.
Still not sure how to prevent the index from crashing.