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

Re: View is not using a table index

From: Andreas Kostyrka <andreas(at)kostyrka(dot)org>
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:03:57
Message-ID: 20070424180356.GS4118@andi-lap (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
* Dan Shea <dan(dot)shea(at)ec(dot)gc(dot)ca> [070424 19:33]:
> Version is  PWFPM_DEV=# select version();
>                                                 version
> ------------------------------------------------------------------------
> --------------------------------
>  PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
> 20030502 (Red Hat Linux 3.2.3-20)
> (1 row)
> 
> We used the rpm source from postgresql-7.4-0.5PGDG.
> 
> You make it sound so easy.  Our database size is at 308 GB.  We actually
> have 8.2.3 running and would like to transfer in the future.  We have to
> investigate the best way to do it.

That depends upon your requirements for the uptime.

Andreas

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2007-04-24 18:09:36
Subject: Re: View is not using a table index
Previous:From: Dan SheaDate: 2007-04-24 17:31:19
Subject: Re: View is not using a table index

pgsql-general by date

Next:From: Tom LaneDate: 2007-04-24 18:09:36
Subject: Re: View is not using a table index
Previous:From: Michael NolanDate: 2007-04-24 17:57:31
Subject: WAL files, warm spares and minor versions

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