Re: Interconnected views - Mailing list pgsql-general

From Chris Travers
Subject Re: Interconnected views
Date
Msg-id CAKt_ZfszK56ZEEELCXYzUzVhgDyLCSOOfSoOc2nja9R3pOVmCQ@mail.gmail.com
Whole thread Raw
In response to Interconnected views  (Oliver Kohll <oliver@agilebase.co.uk>)
List pgsql-general


On Fri, Jun 2, 2023, 09:36 Oliver Kohll <oliver@agilebase.co.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.


Yeah, I have always been impressed by Postgres here too.

Oliver

--
See us at the Bath Digital Festival, 12th July

pgsql-general by date:

Previous
From: Oliver Kohll
Date:
Subject: Interconnected views
Next
From: Joe Carlson
Date:
Subject: custom background worker task for \copy?