Re: indexer sped up with Posgresql

2001-03-17 Thread Caffeinate The World
--- Maxime Zakharov [EMAIL PROTECTED] wrote: Hi, You can also try to do VACUUM ANALYZE on all tables in mnogosearch database. Or CLUSTER index ON table for indexes contain more one unique value. Both should increase index seeks, but i not yet know what are better, possible VACUUM

Re: indexer sped up with Posgresql

2001-03-12 Thread Alexander Barkov
Thanks! I've added this into pgsql create script. Caffeinate The World wrote: mnogosearch-cvs, postgresql-cvs i just wanted to let everyone who uses postgresql with mnogosearch how i got this incredible speed increase. I had about 500,000 URLs and when i started indexing, it took for

Re: indexer sped up with Posgresql

2001-03-07 Thread Alexander Barkov
Caffeinate The World wrote: mnogosearch-cvs, postgresql-cvs i just wanted to let everyone who uses postgresql with mnogosearch how i got this incredible speed increase. I had about 500,000 URLs and when i started indexing, it took for ever between each URL. per alex's suggestion, i