Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> I forgot to mention that the test db was created this way:
> - on the live db do a pg_dump TAL > dump
> - copy dump file to test database server
> - on the test db do a createdb TEST; psql TEST < dump
> This way the two dbs will have the schemas no?
You would think they'd be the same ...
Are both servers the same version of Postgres? (And which version would
that be, exactly?) Does EXPLAIN of the problem query show the same
results on both?
regards, tom lane