On Wed, Aug 12, 2020 at 8:06 PM Tom Lane wrote:
> Ayub M writes:
> > This is PostgreSQL 11 on AWS, there is a mview query in this OLAP
> database,
> > the tables involved are huge - 50-100m records on average records
> hundreds
> > of columns in most cases. The query runs for a while and then er
On Wed, Aug 12, 2020 at 5:52 PM Ayub M wrote:
>
> This is PostgreSQL 11 on AWS, there is a mview query in this OLAP
> database, the tables involved are huge - 50-100m records on average records
> hundreds of columns in most cases.
>
How many tables and how many partitions each? Can you share an E
Ayub M writes:
> This is PostgreSQL 11 on AWS, there is a mview query in this OLAP database,
> the tables involved are huge - 50-100m records on average records hundreds
> of columns in most cases. The query runs for a while and then errors out
> saying "No space left on device". I could see it ge
This is PostgreSQL 11 on AWS, there is a mview query in this OLAP database,
the tables involved are huge - 50-100m records on average records hundreds
of columns in most cases. The query runs for a while and then errors out
saying "No space left on device". I could see it generating around 500gb of
