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

help / color / mirror / Atom feed
From: Jeremy Haile <jhaile@fastmail.fm>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Chad Wagner <chad.wagner@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
Date: Wed, 17 Jan 2007 13:55:07 -0500
Message-ID: <1169060107.24972.1169765759@webmail.messagingengine.com> (raw)
In-Reply-To: <1169058911.9586.46.camel@state.g2switchworks.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>
	<1169050746.9586.44.camel@state.g2switchworks.com>
	<1169051281.3778.1169737659@webmail.messagingengine.com>
	<1169058911.9586.46.camel@state.g2switchworks.com>

> Also, look at the thread going by about index bloat by 4x.  You'll
> likely want to reindex after a vacuum full since vacuum full doesn't
> reclaim space in indexes and in fact often bloats indexes.

Thanks for the pointer.  That thread might indeed apply to my situation.
 I'm going to reindex the the table tonight.

Jeremy Haile



view thread (21+ messages)  latest in thread

Message-ID: <1169060107.24972.1169765759@webmail.messagingengine.com>
Permalink:  ../1169060107.24972.1169765759@webmail.messagingengine.com/
Also on:    postgresql.org/message-id/1169060107.24972.1169765759@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, smarlowe@g2switchworks.com, chad.wagner@gmail.com, tgl@sss.pgh.pa.us
  Subject: Re: PG8.2.1 choosing slow seqscan over idx scan
  In-Reply-To: <1169060107.24972.1169765759@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