Re: View is not using a table index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Shea <dan(dot)shea(at)ec(dot)gc(dot)ca>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: View is not using a table index
Date: 2007-04-24 18:09:36
Message-ID: 6365.1177438176@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Dan Shea <dan(dot)shea(at)ec(dot)gc(dot)ca> writes:
> You make it sound so easy. Our database size is at 308 GB.

Well, if you can't update major versions that's understandable; that's
why we're still maintaining the old branches. But there is no excuse
for not running a reasonably recent sub-release within your branch.
Read the release notes, and consider what you will say if one of the
several data-loss-causing bugs that were fixed long ago eats your DB:
http://developer.postgresql.org/pgdocs/postgres/release.html

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2007-04-24 18:16:03 Re: WAL files, warm spares and minor versions
Previous Message Andreas Kostyrka 2007-04-24 18:03:57 Re: View is not using a table index

Browse pgsql-performance by date

  From Date Subject
Next Message Carlos Moreno 2007-04-24 21:13:59 Re: View is not using a table index
Previous Message Andreas Kostyrka 2007-04-24 18:03:57 Re: View is not using a table index