| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Bryan White <bryan(at)arcamax(dot)com> |
| Cc: | Joseph Shraibman <jks(at)selectacast(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG 7.0 is 2.5 times slower running a big report |
| Date: | 2000-05-25 01:54:20 |
| Message-ID: | Pine.BSF.4.21.0005242253580.243-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2000-05-25 02:05:10 | Re: Migrating from mysql. |
| Previous Message | Bryan White | 2000-05-25 01:37:46 | Re: PG 7.0 is 2.5 times slower running a big report |