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

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "Bryan White" <bryan(at)arcamax(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "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 15:36:56
Message-ID: 008401bfc65f$0f383d80$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I have set index_scan off for tomorrow morning's run. I will let you know
> what happens.

I think my problem is fixed. By disabling index scan while creating the
cursors and then turning it back on again for the small query that occurs in
my inner loop the performance has returned to normal (It may infact be
better then before).

Thanks a bunch.
Bryan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Samuel A. Mullen 2000-05-25 15:46:20 startup script
Previous Message Bryan White 2000-05-25 15:31:41 Re: PG 7.0 is 2.5 times slower running a big report