Nik Putnam <nputnam(at)spinon(dot)berkeley(dot)edu> writes:
> I tried this out to see if it would speed up *my* query too.
> The query went much faster, but gave different results!
> [nputnam(at)spinon ~]$ setenv PGOPTIONS "-fh"
> [nputnam(at)spinon ~]$ psql -e expression < query.sql
> gives 15 rows of output in 1s.
> [nputnam(at)spinon ~]$ unsetenv PGOPTIONS
> [nputnam(at)spinon ~]$ psql -e expression < query.sql
> gives 289 rows of output in 51s
> The slow one is giving the right answer.
> Why might they be different?
That would be a bug, without question. Can you provide a repeatable
test case?
regards, tom lane