Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group