Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance on views - Mailing list pgsql-admin

From Tom Lane
Subject Re: Performance on views
Date
Msg-id 20418.1175271262@sss.pgh.pa.us
Whole thread Raw
In response to Performance on views  (Rickard Sjöström <rickard.sjostrom@bluebottle.com>)
Responses PG does not use my index  (Rickard Sjöström <rickard.sjostrom@bluebottle.com>)
List pgsql-admin
Tree view 
Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?= <rickard.sjostrom@bluebottle.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
tabledirectly. 

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

pgsql-admin by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: trying to run PITR recovery
Next
From: Tom Lane
Date:
Subject: Re: trying to run PITR recovery