[BUGS] Bug in optimizer

2004-05-04 Thread Timo Nentwig
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Your bug report form on the web doesn't work. This is very slow: SELECT urls.id FROM urls WHERE ( urls.id <> ALL (SELECT html.urlid FROM html) ); ...while this is quite fast: SELECT urls.id FROM urls WHERE ( NOT (EXISTS (SELECT html.

[BUGS] Killing the backends

2004-05-04 Thread Helvio Hild
SELECT int8in(8); OVER psql do: llamados=> SELECT int8in(8); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: F

Re: [BUGS] [GENERAL] cache lookup of relation 165058647 failed

2004-05-04 Thread Sean Chittenden
[Renames thread from "The Pepsi Challenge" to "The PostgreSQL Challenge"] But, I am suspecting that it's a race condition with the new background writer code. Why? Have you demonstrated that the failure does not occur in 7.4? What other operations have been added to HEAD that would allow for s