On Thu, Jun 17, 2004 at 09:09:08AM -0700, Ron Snyder wrote: > > Looking at the SQL that is generated, I have two immediate thoughts: > 1) why is the length of token defined as char(200) if we're only using the > lowest 40 bits of the sha1 as the token in the database; When I reduced the > size to match the size of the field for Mysql, my processing time dropped > quite significantly (what took anywhere from 5-12 minutes is now taking > about 1.75 minutes). > 2) why is token a char instead of a bytea? I hacked SQL.pm to record the > actual SQL being executed, and it looks like there are binary values being > inserted. http://www.php-editors.com/postgres_manual/p_datatype-binary.html > > I'll poke around with bytea, next. >
Opps, this is a bug, the bayes_pg.sql files haven't gotten an update for the latest database format. Can you please file a bug so I don't forget to update the files. Michael
