I have couple of tables and some views based on them. One of the view is the UNION of 3 views. Earlier fetching the data from that view was faster but all of the sudden its taking time. Ex :- fetching of 3-5 records with only 4-5 columns are taking 5-6 seconds. If anyone is expert in this please connect with me.
6 freelancers are bidding on average ₹632/hour for this job
PostgreSql needs to maintain clear space and should not contain duplicate indexes. Need to look into the datatype which the view consists of and maintain the view accordingly.