Re: How to estimate size of a row and therefore how much progress this query has made

Tom Lane <tgl@sss.pgh.pa.us> writes:

> > So far it's inserted quite a bit of data: [8.5 Gig]
>
> > I think it'll insert a total of 107,535,604 records.

Sorry, I found the problem. I was overflowing Emacs's integer datatype doing
my calculations for how many rows to expect. Postgres's analyze had the
correct answer. It's actually going to insert more than that, 375,971,060
records.

So that makes it 24G of data which won't fit on the partition.

I'll have to look for another way to do this.

Thanks again for your help.


--
greg