| From: | Oliver Kohll <oliver(at)agilebase(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Interconnected views |
| Date: | 2023-06-02 13:36:22 |
| Message-ID: | CAMS=m5LPq4wPY+ym=J36D0mXAdrxO9J6xenvGaEuOJyR4wezSA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Just wondering, does anyone else create apps which might not have 'big'
data, but quite complex arrangements of views joining to each other?
If so, do you have scripts to aid refactoring them e.g. drop/recreate/test
them in the right order etc.?
I'm really impressed with the way Postgres handles these multi-layered
views. Some of our explain analyze outputs could fill a book each! Tools
like Depesz' can be very useful. Sometimes a little tweaking or a judicious
index is necessary, but the performance is very reliable and scalable.
Blog post about it here:
https://blog.agilebase.co.uk/2023/05/21/refactoring-sql-views/
Oliver
--
See us at the Bath Digital Festival <https://techspark.co/bdf/>, 12th July
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirk Wolak | 2023-06-02 14:57:06 | Re: Adding SHOW CREATE TABLE |
| Previous Message | Jonathan S. Katz | 2023-06-02 12:14:45 | Re: Pg 16: will pg_dump & pg_restore be faster? |