Re: PG 7.0 is 2.5 times slower running a big report - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: PG 7.0 is 2.5 times slower running a big report
Date
Msg-id Pine.BSF.4.21.0005242253580.243-100000@thelab.hub.org
Whole thread Raw
In response to Re: PG 7.0 is 2.5 times slower running a big report  ("Bryan White" <bryan@arcamax.com>)
List 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 by date:

Previous
From: "Bryan White"
Date:
Subject: Re: PG 7.0 is 2.5 times slower running a big report
Next
From: "Bryan White"
Date:
Subject: Re: PG 7.0 is 2.5 times slower running a big report