Re: BUG #2243: Postgresql fails to finish some queries

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Matej Rizman <matej(dot)rizman(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2243: Postgresql fails to finish some queries
Date: 2006-02-08 18:46:04
Message-ID: 20060208184604.GA9206@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matej Rizman 2006-02-08 19:03:46 Re: BUG #2243: Postgresql fails to finish some queries
Previous Message Kalador Tech Support 2006-02-08 17:52:33 Re: BUG #2236: extremely slow to get unescaped bytea data