On Tue, Feb 07, 2006 at 02:41:03 +0000,
Matej Rizman <matej.rizman@gmail.com> wrote:
>
> Files a_30000.txt and b_30000.txt contain 30000 numbers each.
>
> The last query (SELECT) is executed on my machine in 125ms.
>
> If I load data from files a_100000.txt and b_100000.txt that contain 100000
> numbers each, the last SELECT does not finish in more than ten minutes (the
> real-world sample hasn't finished in more than an hour).
Did you do an ANALYZE after doing the load?
