Re: UdmSearch: Somewhat off-topic: bad performance using Postgres

2000-06-05 Thread Alexander Barkov
- Original Message - From: Alain TESIO [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 05, 2000 4:12 AM Subject: Re: UdmSearch: Somewhat off-topic: bad performance using Postgres I've noticed that indexing becomes teriibly slow when using postgres

Re: UdmSearch: Somewhat off-topic: bad performance using Postgres

2000-06-04 Thread Alain TESIO
I've noticed that indexing becomes teriibly slow when using postgres as the backend (regardless of version), versus MySQL... anybody know why? Is it because PG supports transactions and more stuff than MySQL? I have noticed the same for another similar job. PostgreSQL has nice features,

Re: UdmSearch: Somewhat off-topic: bad performance using Postgres

2000-06-04 Thread The Hermit Hacker
okay, several questions here, first one being what version of PostgreSQL are you using? What hardware are you running on? I'm running UDMSearch 3.0.17 with PostgreSQL v7.0 on a Dual-PIII with 512Meg of RAM, with the databases sitting on an 18gig SCSI-3 hard drive ... I'm running in crc-multi