On Fri, Jul 08, 2005 at 03:06:29PM -0400, Stephen Bowman wrote:
>
> This is on a Xeon 3ghz with 2gb of RAM. There are 2 SCSI U/320 disks.
>
> For the variables, I have everything defaulted except for:
>
> shared_buffers = 2
> effective_cache_size = 68916
>
> I just added random_page_cost=3
On 7/8/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 08, 2005 at 12:04:07PM -0400, Stephen Bowman wrote:
> >
> > Clearly it needs to use the index =)
>
> Indeed -- now to figure out why the estimates for index scans are
> so high. The row count estimates are almost spot-on, so that's
On Fri, Jul 08, 2005 at 12:04:07PM -0400, Stephen Bowman wrote:
>
> Clearly it needs to use the index =)
Indeed -- now to figure out why the estimates for index scans are
so high. The row count estimates are almost spot-on, so that's not
it. What are your settings for the following configuration
On 7/8/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 08, 2005 at 11:11:46AM -0400, Stephen Bowman wrote:
> >
> > SCANS=# explain select * from nessus_results where scan_id = 55;
> >QUERY PLAN
> > ---
On Fri, Jul 08, 2005 at 11:11:46AM -0400, Stephen Bowman wrote:
>
> SCANS=# explain select * from nessus_results where scan_id = 55;
>QUERY PLAN
> -
> Seq Scan o
