Can't reproduce it here, either in HEAD or 8.4. Sure you have a clean build with no local modifications? The outright-incorrect last plan
Sure, just checkout'ed sources. And it's reproduced on current HEAD right now. More info: postgresql.conf changes: shared_buffers=128MB temp_buffers=16MB work_mem=16MB maintenance_work_mem=256MB effective_cache_size=1024MB autovacuum=on log_destination=syslog % pg_config --configure '--enable-depend' '--enable-cassert' '--enable-debug' '--with-perl' 'CFLAGS=-O0' % gcc -v Using built-in specs. Target: i386-undermydesk-freebsd Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 4.2.1 20070719 [FreeBSD] % uname -a FreeBSD XXX.XXX 8.0-RELEASE-p1 FreeBSD 8.0-RELEASE-p1 #1: Fri Dec 11 19:03:49 MSK 2009 teo...@xxx.xxx:/usr/obj/usr/src/sys/XOR i386 With gcc version 4.4.3 bug is reproduces too. Could you point me a starting point of investigation? -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers