| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-24 18:09:36 | Re: View is not using a table index |
| Previous Message | Michael Nolan | 2007-04-24 17:57:31 | WAL files, warm spares and minor versions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-24 18:09:36 | Re: View is not using a table index |
| Previous Message | Dan Shea | 2007-04-24 17:31:19 | Re: View is not using a table index |