From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
---|---|
To: | Oliver Kohll <oliver(at)agilebase(dot)co(dot)uk> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Interconnected views |
Date: | 2023-06-02 17:58:43 |
Message-ID: | CAKt_ZfszK56ZEEELCXYzUzVhgDyLCSOOfSoOc2nja9R3pOVmCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 2, 2023, 09:36 Oliver Kohll <oliver(at)agilebase(dot)co(dot)uk> wrote:
> 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.?
>
In Ledgersmb, we did this and also same with functions. We used versioned
scripts, database schema change management tools, and reload utilities as
well as Pgtap for testing.
>
> 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/
>
Yeah, I have always been impressed by Postgres here too.
>
> Oliver
>
> --
> See us at the Bath Digital Festival <https://techspark.co/bdf/>, 12th July
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Carlson | 2023-06-02 18:36:25 | custom background worker task for \copy? |
Previous Message | Kirk Wolak | 2023-06-02 14:57:06 | Re: Adding SHOW CREATE TABLE |