HPE Community
Operating System - HP-UX
1753666 Members
6269 Online
108799 Solutions
New Discussion юеВ

Block size of file system for BLOB column type

 
Marcelo De Florio_1
Frequent Advisor

тАО03-20-2002 07:49 AM

тАО03-20-2002 07:49 AM

Block size of file system for BLOB column type


What is the max block size for file system in HP-UX 11.0 ?

MDF
Marcelo De Florio
0 Kudos
Reply
3 REPLIES 3
A. Clay Stephenson
Acclaimed Contributor

тАО03-20-2002 08:08 AM

тАО03-20-2002 08:08 AM

Re: Block size of file system for BLOB column type

Hi:

For vxfs, it's 8K; for hfs it's 64K. On vxfs filesystems (which you should be using), blocksize is essentially unimportant as far as performance is concerned. Vxfs likes to write in 64K chunks so it is more important to match your lvol stripe size to 64K.
If it ain't broke, I can fix that.
0 Kudos
Reply
S.K. Chan
Honored Contributor

тАО03-20-2002 08:17 AM

тАО03-20-2002 08:17 AM

Re: Block size of file system for BLOB column type

64K for HFS
8K for JFS
0 Kudos
Reply
Andreas D. Skjervold
Honored Contributor

тАО03-20-2002 01:42 PM

тАО03-20-2002 01:42 PM

Re: Block size of file system for BLOB column type

Hi

If this BLOB column is in a Oracle database, your maximum database blocksize is 32K.

What blocksize the filesystem operates with is of less importance (if not no importance) as during tablespace creation the fixed db blocks are created of continous filesystem blocks and will be used as such for the tablespaces lifetime.

rgds
Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.