Re: Performance problem with query

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance problem with query
Date: 2006-07-13 13:20:51
Message-ID: b42b73150607130620o4b93fd6cw8a066b34bb0b5633@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/13/06, Christian Rengstl
<Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> wrote:
> Good morning list,
>
> the following query takes about 15 to 20 minutes for around 2 million lines in the file myfile.txt, but with 8 million lines it takes around 5 hours and i just don't understand why there is such a huge discrepancy in performance.

on the surface it doesn't make sense, can you post an explain analyze?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-07-13 13:22:56 Re: getting function argument names from psql?
Previous Message David Fetter 2006-07-13 13:16:00 Re: getting function argument names from psql?