Re: [PERFORM] Simple machine-killing query!

2004-10-21 Thread Victor Ciurus
Well guys, Your replies have been more than helpful to me, showing me both the learning stuff I still have to get in my mind about real SQL and the wonder called PostgreSQL and a very good solution from Tom Lane (thanks a lot sir!)! Indeed, changing mem_sort and other server parmeters along with

[PERFORM] Simple machine-killing query!

2004-10-21 Thread Victor Ciurus
Hi all, I'm writing this because I've reached the limit of my imagination and patience! So here is it... 2 tables: 1 containing 27 million variable lenght, alpha-numeric records (strings) in 1 (one) field. (10 - 145 char lenght per record) 1 containing 2.5 million variable lenght, alpha-numeric r