Re: SQL slower when running for the second time

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: SQL slower when running for the second time
Дата
Msg-id 1062622143.7341.388.camel@haggis
обсуждение исходный текст
Ответ на SQL slower when running for the second time  (Rhaoni Chiu Pereira <rhaoni@sistemica.info>)
Список pgsql-performance
On Wed, 2003-09-03 at 14:15, Rhaoni Chiu Pereira wrote:
> Hi List,
>
>    I trying to increase performance in my PostgreSQL but there is something
> wrong.    when I run this SQL for the first time it takes 1 min. 40 seconds to
> return, but when I run it for the second time it takes more than 2 minutes, and
> I should retunr faster than the first time.
>
> Does anyone have a advice ?

Is it a query or insert/update?

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Vanity, my favorite sin."
     Larry/John/Satan, "The Devil's Advocate"


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [ADMIN] SQL slower when running for the second time
Следующее
От: Rhaoni Chiu Pereira
Дата:
Сообщение: Re: [ADMIN] SQL slower when running for the second time