On Mon, Jun 25, 2018 at 1:21 PM, Vikas Sharma <shavi...@gmail.com> wrote:
> Hi All, > > I am looking for advice in a issue where two materialized views are being > refreshed concurrently and dbsize has grown to 150gb from 4gb in two days. > > We use two materialized views to keep processed data for faster query > results for a search function. Earlier materialized views were refreshed > not concurrently and all was good on DB. > Where is the space going? Does it show up in psql with \l+ ? Does is show up in \dm+ ? Does it only show up using OS tools in the data directory? Which subdirectory of the data directory? Cheers, Jeff