Postgresql – Transfer table ownership
In Postgres, when a table owner, say "xxx" tries to transfer the table ownership to user "yyy", he is getting error ERROR: must be member of role "yyy" When I searched further, it can be fixed in two ways. As…
Ubuntu – How to improve PostgreSQL query performance when there are millions of records
We are trying to query millions of rows of data from 1 table (14 columns) in under 2 seconds if possible. This table is composed of more than 10 million records and is growing exponentially as live data is being…