Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performance on views
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Rickard Sjöström <rickard(dot)sjostrom(at)bluebottle(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Performance on views
- Date: Fri, 30 Mar 2007 12:14:22 -0400
Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?= <rickard(dot)sjostrom(at)bluebottle(dot)com> writes: > I have a view that is really slow and I ca easily work around the slowness by bypassing the view and query the real table directly. Let's see the exact definition of the view and EXPLAIN ANALYZE results for doing it both ways. Also, what PG version is this? regards, tom lane
- References:
- Performance on views
- From: Rickard Sjöström
- Performance on views
- Prev by Date: Re: trying to run PITR recovery
- Next by Date: Re: trying to run PITR recovery
- Previous by thread: Performance on views
- Next by thread: plpgsql function return array
- Indexes: