Skip site navigation (1) Skip section navigation (2)

Re: Weird issue with planner choosing seq scan

From: Sean Leach <sleach(at)wiggum(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Weird issue with planner choosing seq scan
Date: 2008-02-25 00:05:18
Message-ID: 1865C113-5FE9-4ED4-9472-EA6758D05FA3@wiggum.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Feb 24, 2008, at 4:03 PM, Scott Marlowe wrote:

> The fact that your indexes are bloated but your table is not makes me
> wonder if you're not running a really old version of pgsql that had
> problems with monotonically increasing indexes bloating over time and
> requiring reindexing.
>
> That problem has been (for the most part) solved by some hacking Tom
> Lane did some time back.
>
> 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 :(

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-02-25 00:27:55
Subject: Re: Weird issue with planner choosing seq scan
Previous:From: Scott MarloweDate: 2008-02-25 00:03:48
Subject: Re: Weird issue with planner choosing seq scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group