From: | Rickard Sjöström <rickard(dot)sjostrom(at)bluebottle(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Performance on views |
Date: | 2007-03-30 11:19:30 |
Message-ID: | 1175253570.460cf2427984c@mail.bluebottle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi!
I've probably missed somthing but here is my problem.
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.
Example:
--------------------------------------------
>From view, the slow one:
SELECT * from my_view WHERE date > 2007-03-01
and to speed it up I just copy the view defintion and inserts some "date > ...", like this.
SELECT *
FROM (select * from my_table where data > 2007-03-01) mt,
my JOIN someother on mt.id=smoeother.id
etc,...
--------------------------------------------
The thing here is that I limit the query before joining with other data.
Did I get through with my problem?
Any ideas how I can speed up my views?
Is there something I can tell the database in order to speed up?
Is this a known issue with views?
/Rickard
----------------------------------------------------------------------
Click to lower your debt and consolidate your monthly expenses
http://tags.bluebottle.com/fc/CAaCMPJklAkSFsDVLmOtm1fwWle86ZFg/
From | Date | Subject | |
---|---|---|---|
Next Message | Sorin N. Ciolofan | 2007-03-30 13:20:09 | Re: ERROR: out of shared memory |
Previous Message | Simon Riggs | 2007-03-30 11:16:34 | Re: trying to run PITR recovery |