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

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Sean Leach <sleach@wiggum.com>
Cc: Stephen Denne <Stephen.Denne@datamail.co.nz>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Weird issue with planner choosing seq scan
Date: Sun, 24 Feb 2008 18:27:55 -0600
Message-ID: <dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.com> (raw)
In-Reply-To: <1865C113-5FE9-4ED4-9472-EA6758D05FA3@wiggum.com>
References: <F836C829-D69F-4FA3-966C-002E715BF26F@wiggum.com>
	<5289.1203875431@sss.pgh.pa.us>
	<7ECB45D8-33ED-45FC-A0DA-D3DE25B6CC8E@wiggum.com>
	<6253.1203880225@sss.pgh.pa.us>
	<F0238EBA67824444BC1CB4700960CB4804B0C70B@dmpeints002.isotach.com>
	<7EA909F9-92E9-4B36-9476-59A0A14A1F86@wiggum.com>
	<dcc563d10802241603gf3a1cfdx538a585c5c8528e4@mail.gmail.com>
	<1865C113-5FE9-4ED4-9472-EA6758D05FA3@wiggum.com>

On Sun, Feb 24, 2008 at 6:05 PM, Sean Leach <sleach@wiggum.com> wrote:

>  On Feb 24, 2008, at 4:03 PM, Scott Marlowe wrote:
>
>  >
>  > What version pgsql is this?  If it's pre 8.0 it might be worth looking
>  > into migrating for performance and maintenance reasons.
>
>  It's the latest 8.3.0 release :(

Urg.  Then I wonder how your indexes are bloating but your table is
not...  you got autovac running?  No weird lock issues?  It's a side
issue right now since the table is showing as non-bloated (unless
you've got a long running transaction and that number is WAY off from
your vacuum)



view thread (17+ messages)  latest in thread

Message-ID: <dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.com>
Permalink:  ../dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.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: scott.marlowe@gmail.com, sleach@wiggum.com, Stephen.Denne@datamail.co.nz
  Subject: Re: Weird issue with planner choosing seq scan
  In-Reply-To: <dcc563d10802241627g6d30808erf1006b3ffe6e1d08@mail.gmail.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