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: 2007-03-30 16:14:22
Message-ID: 20418.1175271262@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-03-30 16:40:09 Re: trying to run PITR recovery
Previous Message Simon Riggs 2007-03-30 15:34:51 Re: trying to run PITR recovery