Sawada Masahiko
sawad****@gmail*****
2015年 2月 25日 (水) 20:36:02 JST
On Tue, Feb 24, 2015 at 3:32 PM, Beena Emerson <memis****@gmail*****> wrote: > Hello, > > When a column is indexed by the pg_bigm index, it limits the size of the > column to 44,739,241 Bytes. Similarly, the pg_trgm index also limits the > column size to 238,609,291 Bytes. > > Attempts to insert larger data results in an error. The attached patch > updates the pg_bigm_en-1.1.html file to list this limitation. > > The corresponding Japanese file would also have to be updated to reflect > this update. > Thank you for the patch! @@ -82,6 +83,9 @@ For example, x.y is 1.1 and YYYYMMDD is 20131122 if the file of the version 1.1 <tr><td>Similarity search</td> <td nowrap>Supported</td> <td>Supported (version 1.1 or later)</td></tr> +<tr><td>Maximum indexed column size</td> + <td nowrap>238,609,291 Bytes</td> + <td>44,739,241 Bytes</td></tr> Why is td tag used with "nowrap", but another one is not used? I think "nowrap" is needed for pg_bigm column. And I think it's good to add size with MB unit for easily imaging. e.g., 238,609,291 Bytes(228MB) The attached v2 patch include above fixes and corresponding Japaneses file changes. Please review its English part. Regards, ------- Sawada Masahiko -------------- next part -------------- $B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B... $B%U%!%$%kL>(B: add_limitation_v2.patch $B7?(B: text/x-patch $B%5%$%:(B: 4369 $B%P%$%H(B $B ＠ bL@(B: $BL5$7(B다운로드
Fork