> Do not use 3.0 with PostgreSQL. It's known to have problems. Actually,
> the problem you're seeing might be DBD::Pg related. Did you possibly
> just install a new version? Make sure you are using the version listed
> in sql/README.bayes.

I haven't noticed anything out of the ordinary after I made the switch to SQL 
bayes,
that is, after I created a few indexes to help.

DBD::Pg is version 1.21. I haven't messed around with Perl settings or packages 
lately
to cause this. More than likely I've just now hit upon the bug described in 
this earlier
version of DBD::Pg in sql/README.bayes for some reason. But what is it about 
just lately
that's causing bayes to fail? Is it a record in a table that somehow was 
inserted that's
causing all subsequent lookups to fail?

> There is custom PostgreSQL support in 3.1, which just had RC1 released,
> you can try that one. It works very well and is 7-27x faster than the
> code in 3.0.

I read about the custom PostgreSQL support in the new SA and am very excited to 
hear
about it. I've been following some of the discussion about the problems with 
Postgres
support in 3.0 early on.

I'd would much rather wait until the production release of 3.1 -- and can live 
without
bayes for a while -- than running a RC in production.

Andre Nicholson

Reply via email to