Re: [PERFORM] Query performance problem in 8.0.0beta1

2004-08-29 Thread Russell Smith
Hi, I assume you have reposted because you have just signed up to the list. If this is the case, can you please read the archives or replies to your original post about this question. It did make it onto the archives and myself and others did reply with a few ideas and questions. If you could

[PERFORM] Query performance problem in 8.0.0beta1

2004-08-29 Thread Stefano Bonnin
Hi, I have just installed 8.0.0beta1 and I noticed that some query are slower than 7.4.2 queries.   After a FULL VACUUM ANALYZE   ***With 7.4.2***   explain analyze SELECT count(*) FROM "SNS_DATA" WHERE "Data_Arrivo_Campione" BETWEEN '2004-01-01 00:00:00' AND '2004-01-31 23:59:59' AND "Cod_Pa