Postgres Pro
Downloads
Home   >   mailing lists

Re: 64-bit API for large object - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: 64-bit API for large object
Date
Msg-id 20120829.102527.1464651829973099388.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: 64-bit API for large object  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: 64-bit API for large object
List pgsql-hackers
Tree view 
Correct me if I am wrong.

After expanding large object API to 64-bit, the max size of a large
object will be 8TB(assuming 8KB default BLKSZ).

large object max size = pageno(int32) * LOBLKSIZE                      = (2^32-1) * (BLCKSZ / 4)                  =
(2^32-1)* (8192/4)                  = 8TB
 

I just want to confirm my calculation is correct.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: "default deny" for roles
Next
From: Andrew Dunstan
Date:
Subject: Re: "default deny" for roles