Alex wrote:
> I tried vacuum, the db and tables and did not gain any performance.
Did you try VACUUM only or VACUUM ANALYZE (or even just ANALYZE)?
> I experience this problem on different machines and yet, when i reload
> the date it did speed up things considerably.
It does sound like you haven't ANALYZE'd your data. Try that.
--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
2:30pm up 291 days, 6:04, 9 users, load average: 6.08, 6.02, 6.01