On Tue, Feb 07, 2006 at 02:41:03 +0000,
Matej Rizman <matej(dot)rizman(at)gmail(dot)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?
In response to
pgsql-bugs by date
|Next:||From: Matej Rizman||Date: 2006-02-08 19:03:46|
|Subject: Re: BUG #2243: Postgresql fails to finish some queries|
|Previous:||From: Kalador Tech Support||Date: 2006-02-08 17:52:33|
|Subject: Re: BUG #2236: extremely slow to get unescaped bytea data|