Re: PG8.2.1 choosing slow seqscan over idx scan

From: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Date: 2007-01-17 15:23:41
Message-ID: 1169047421.26925.1169724395@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2007-01-17 15:57:16 Raid 10 or Raid 5 on Dell PowerEdge
Previous Message Dave Cramer 2007-01-17 15:14:47 Re: PG8.2.1 choosing slow seqscan over idx scan