Re: PG 7.0 is 2.5 times slower running a big report

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: PG 7.0 is 2.5 times slower running a big report
Дата
Msg-id Pine.BSF.4.21.0005242253580.243-100000@thelab.hub.org
обсуждение исходный текст
Ответ на Re: PG 7.0 is 2.5 times slower running a big report  ("Bryan White" <bryan@arcamax.com>)
Список pgsql-general
I might have missed it, but did you submit the EXPLAIN results of the
query you are attempting, as Tom Lane requested?

On Wed, 24 May 2000, Bryan White wrote:

> > Try putting 'nofsync' in your pg_options.
>
> I am already starting the postmaster with -o -F which I believe has the same
> effect.  Besides this process does not alter the database so there shold be
> nothing to sync.
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


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

Предыдущее
От: "Bryan White"
Дата:
Сообщение: Re: PG 7.0 is 2.5 times slower running a big report
Следующее
От: "Bryan White"
Дата:
Сообщение: Re: PG 7.0 is 2.5 times slower running a big report