Re: PG8.2.1 choosing slow seqscan over idx scan - Mailing list pgsql-performance

From Jeremy Haile
Subject Re: PG8.2.1 choosing slow seqscan over idx scan
Date
Msg-id 1169047421.26925.1169724395@webmail.messagingengine.com
Whole thread Raw
In response to Re: PG8.2.1 choosing slow seqscan over idx scan  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-performance
> How much memory does the box have
2GB

> Yes, it takes up space
Well, I upped max_fsm_pages to 2000000 because it vacuums were failing
with it set to 1500000.  However, I'm now autovacuuming, which might be
keeping my fsm lower.  I didn't realize that setting it too high had
negative effects, so I'll try to get a better handle on how large this
needs to be.

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Next
From: "Dave Dutcher"
Date:
Subject: Raid 10 or Raid 5 on Dell PowerEdge