pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jeremy Haile <jhaile@fastmail.fm>
To: pgsql-performance@postgresql.org
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Date: Wed, 17 Jan 2007 10:23:41 -0500
Message-ID: <1169047421.26925.1169724395@webmail.messagingengine.com> (raw)
In-Reply-To: <44BC14E1-2CBF-465A-AD6E-443687BBB98D@fastcrypt.com>
References: <1168982580.8275.1169588211@webmail.messagingengine.com>
	<26412.1168983547@sss.pgh.pa.us>
	<1168986053.16393.1169598917@webmail.messagingengine.com>
	<81961ff50701161444l3f932755m5a6e15ad2d948130@mail.gmail.com>
	<1169002739.19758.1169636285@webmail.messagingengine.com>
	<1169012767.6271.7.camel@localhost.localdomain>
	<1169044649.19974.1169715743@webmail.messagingengine.com>
	<44BC14E1-2CBF-465A-AD6E-443687BBB98D@fastcrypt.com>

> 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.



view thread (21+ messages)  latest in thread

Message-ID: <1169047421.26925.1169724395@webmail.messagingengine.com>
Permalink:  ../1169047421.26925.1169724395@webmail.messagingengine.com/
Also on:    postgresql.org/message-id/1169047421.26925.1169724395@webmail.messagingengine.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jhaile@fastmail.fm
  Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
  In-Reply-To: <1169047421.26925.1169724395@webmail.messagingengine.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox