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

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to estimate size of a row and therefore how much progress this query has made
Date: 2003-02-02 05:34:53
Message-ID: 87wukjqm82.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-02 06:18:13 Re: gp_dump: error in finding the last system oid: ERROR: get_relation_info: Relation 1262 not found
Previous Message Tom Lane 2003-02-02 05:33:42 Re: How to estimate size of a row and therefore how much progress this query has made