Postgres Pro
Downloads
Home   >   mailing lists

Re: DB size growing exponentially when materialized view refreshedconcurrently (postgres 9.6) - Mailing list pgsql-general

From Jeff Janes
Subject Re: DB size growing exponentially when materialized view refreshedconcurrently (postgres 9.6)
Date
Msg-id CAMkU=1ytWhxpngzPGTXa08OXS2K8UoM_ErVdmy7TreVyuZNQkA@mail.gmail.com
Whole thread Raw
In response to DB size growing exponentially when materialized view refreshedconcurrently (postgres 9.6)  (Vikas Sharma <shavikas@gmail.com>)
List pgsql-general
Tree view


On Mon, Jun 25, 2018 at 1:21 PM, Vikas Sharma <shavikas@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

pgsql-general by date:

Previous
From: Anthony DeBarros
Date:
Subject: PLPython Setup issue with EDB Windows Installer
Next
From: Tim Cross
Date:
Subject: Re: Using COPY to import large xml file