Postgresql script to dynamicaly denormalize a set of tables

Hi, I went through the requirement and details are quite clear. I would be able to do this as I come with 9+ years of experience in PostgreSQL. Although I am new to freelancer but I can message you my Linkedin profile to be sure. Can you please also tell which version of PostgreSQL you are using right now, as some information schema changes have happened in subsequent versions. Any further queries we can discuss in message.

Hello how are you doing ? I hope you are well, I would like to participate in your project, I offer you my services because I have a great experience in postgresql, I have done several jobs in this network (you can check my profile), I always deliver the work in time and also I give support after having canceled the work in case of any doubt or error or any change. I am generally connected and I would like to talk about some details about your project. I would also like to know how much time you have for the delivery of this work, well anyway if you have any questions or comments you can let me know, I always respond to the messages. Cheers

I'll deliver in time properly

Hi I can make sql(DDL) for denormalized view and empty temporary denormalized table(or materialized view to fill(or clear) data on demand/recreate every XX minutes. An expert on database optimization database optimization skill, this is mainly what I’m doing now - more than half the time, reports, setting up indexes, hints, plans. Rewriting queries, partitioning tables, changing the type of tables (from the heap to something else). Mostly optimization of OLTP (fast transactions) systems, less often for DWH (storefronts). About myself: Oracle/PostGre Senior Developer / Database and Performance Architect Architect of information systems and databases, performance analyst. Development and refactoring of SQL, PLSQL, PgSQL code. Optimization of sql queries or locks. 15 years of experience in PostGre, Oracle.