Re: Performance problem with query

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Performance problem with query
Дата
Msg-id b42b73150607130620o4b93fd6cw8a066b34bb0b5633@mail.gmail.com
обсуждение исходный текст
Ответ на Performance problem with query  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
Список pgsql-general
On 7/13/06, Christian Rengstl
<Christian.Rengstl@klinik.uni-regensburg.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
millionlines 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

В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: getting function argument names from psql?
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: getting function argument names from psql?