Re: PostgreSQL FAQ

[ CC'ed to docs. Hope that is OK.]

These are excellent points. I have merged items 3.5 and 3.6 as you
suggested. They clearly should have been one item.

As far as disk computation, you are correct also. I improperly
estimated the size of integers in that file. I have created a more
typical file of one integer and one 20-char length string and used that
in the example. I also changed the text to say "up to five times"
rather than "six times". My new example shows roughly three times
increase so I think "up to five times" is much more accurate.

I have updated CVS and the web page so you can see my exact changes.
Thanks for the assistance.

---------------------------------------------------------------------------

Viktor Vislobokov wrote:

Hello Bruce!

At first, I'm sorry my bad English.

I'm like PostgreSQL and I want to make little contribution to
this great work.
I translated PostgreSQL FAQ in Russian. My translation
based on PostgreSQL 7.2 distribution for RawHide Linux (Red Hat clone).
Can I send it to you, that you place it into official distribution?
I'm not professional translator, but I try to make quality
translation.

After translation process, I have some questions and I
want to discuss it with you.

What you think about 3.5 and 3.6 questions?
I think, answers are duplicate. May be need
merge it?

I read answer at question 4.6.
I not agree with it, because the data is incorrect.

You are talking about 300,000 lines, 2 integer at line
and 2.4Mb total size in order text file. But

2.4*1024*1024
------------- = 8 bytes at line
300,000

Let line containts two integers

65535 22767

In this case - 10 digits plus space plus end line character = 12 bytes

However, PostgreSQL INT type can store 4th bytes interger, i.e.
any integer from 0 to 0xFFFFFFFF in hex and from 0 to 4294967295 in
decimal.Thus, if a line in text file contains, for example

4294967295 4294967295

total size of this line will be 22 bytes!

Finally, result is strongly depends of integer's values!
IMHO, If numbers will be large, database size can be even LESS
text file size.

With best wishes, Victor Vislobokov
Perm, Russia

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026