"Ross J. Reedstrom" wrote:
>
> Hmm, I've pulled the appropriate file from CVS, now. Seems that v102
> has most the indices, so Stephan's request of example queries is the only
> way we're going to be able to help.
>
> Hmm, on third look, I've grovelled through the PHP for ACID 0.9.6b11
> (since that was in the snort CVS) and I see that ACID creates some tables,
> as well, one of which is missing an index that MySQL gets:
Also, do they run VACUUM ANALYZE after filling the table ?
PostgreSQL could choose very poor plans without it.
-------------
Hannu