Thanks a lot for your help.
Tom Lane <tgl@sss.pgh.pa.us> writes:
> > The last two columns are actually being populated with nulls. The first three
> > columns are being populated with data. The string in the first column is
> > actually always 12 characters.
>
> Okay, so 4+12+4+4 data bytes, plus header overhead --- is this 7.3 or
> something older? Let's assume older --- 24+32+4 bytes per row, plus
> the null bitmap and alignment padding; say 64 bytes per row.
It's 7.3
> > 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.
>
> Should be finishing pretty darn soon; in fact, I'd venture you already
> had a good bit of data in the table. You don't have much over 6 gig
> accounted for here.
Nope, the table was empty previously. I created it just before the insert.
Hm, I guess I have a bit of a puzzle.
Do OIDs consume space too? This is a INSERT INTO foo () (select ..) style
query so the records get OIDs no? I probably should get in the habit of
creating all my tables without OIDs since I don't use them. I haven't thought
about them previously.
--
greg
