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/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate