[PERFORM] Restore database after drop command

Dear all, I am using Postgres-8.4.2 on Windows system. I have 2 databases in my postgres database ( globedatabase (21GB), urldatabase). I restore globedatabase from a .sql file on yesterday morning.I insert some new data in that database. In the evening, by mistake I issued a *drop database

Re: [PERFORM] Bad query plan

=?KOI8-R?B?5M3J1NLJyiD3wdPJzNjF1w==?= writes: > explain analyze insert into large(id) select id from small where id > not in(select id from large); > [ crummy plan ] > explain analyze insert into large(id) select id from small where not > exists (select id from large l where small.id=l.id); > [ be

[PERFORM] Bad query plan

I have a problem with poor query plan. My PostgreSQL is "PostgreSQL 8.4.8, compiled by Visual C++ build 1400, 32-bit" installed by EnterpriseDB installer on Windows 7 32 bit. Steps to reproduce: Start with fresh installation and execute the following: drop table if exists small; drop table if e