From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
---|---|
To: | postgresql performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Cost of INSERT rules |
Date: | 2009-01-15 18:34:16 |
Message-ID: | 20090115183416.GA24656@nibiru.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi folks,
I really like the idea of exclusively using views as interfaces
to the applications (each app has its own view, tuned for the
app's access patterns). So, in my model, of course inserts and
updates also happen through views, also more complex operations
could be triggered through view writes.
But for some strange reason, my apps seem to produce high load
on the server. So either I'm just too stupid for proper schema
design or the view approach is really slow.
What exactly does happen behind the scenes if I update some
row in a view ? Does it end up in an full view query before
doing the update ?
cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service - http://www.metux.de/
---------------------------------------------------------------------
Please visit the OpenSource QM Taskforce:
http://wiki.metux.de/public/OpenSource_QM_Taskforce
Patches / Fixes for a lot dozens of packages in dozens of versions:
http://patches.metux.de/
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-David Beyer | 2009-01-15 19:22:14 | Re: understanding postgres issues/bottlenecks |
Previous Message | A. Kretschmer | 2009-01-15 11:06:01 | Re: row-specific conditions possible? |