postgresqlgeneral.domain.thewild_codata@xxxxxxxxxxxxxxx wrote: > Hi all ! > > Reading through the list of settings returned by "SHOW ALL", I noticed > the "block_size" variable, which defaults to 8192. > > Running on Windows Server, my data directory is on an NTFS partition. > Running CHKDSK on this partition tells me that there are "4096 bytes in > each allocation unit." > > Are these allocation units the same as the "block_size", or does this > only have to do with disk geometry ? > If they are the same, is it important that they match ? It is not necessary they match. It just means that Postgres extends files in 8k chunks while your file system extends them in 4k chunks. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
