Tom Lane wrote:
Dan Shea <[EMAIL PROTECTED]> 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 rec
Dan Shea <[EMAIL PROTECTED]> 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 you
* Dan Shea <[EMAIL PROTECTED]> [070424 19:33]:
> Version is PWFPM_DEV=# select version();
> version
>
>
> PostgreSQL 7.4 on i686-pc-linux-gnu,
: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 11:42 AM
To: Shea,Dan [NCR]
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] View is not using a table index
Dan Shea wrote:
> We have a table which we want to normalize and use the same SQL to
> perform selects u
Dan Shea wrote:
We have a table which we want to normalize and use the same SQL to
perform selects using a view.
The old table had 3 columns in it's index
(region_id,wx_element,valid_time).
The new table meteocode_elmts has a similar index but the region_id is a
reference to another table reg
We have a table which we want to normalize and use the same SQL to
perform selects using a view.
The old table had 3 columns in it's index
(region_id,wx_element,valid_time).
The new table meteocode_elmts has a similar index but the region_id is a
reference to another table region_lookup and wx_e
