On Tue, Feb 07, 2006 at 02:41:03 +0000,
Matej Rizman <[EMAIL PROTECTED]> 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?
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
