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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

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