Postgres Pro
Downloads
Home   >   mailing lists

Block_Size on NTFS - Mailing list pgsql-general

From postgresqlgeneral.domain.thewild_codata@spamgourmet.com
Subject Block_Size on NTFS
Date
Msg-id 4A2E1575.2000908@codata.eu
Whole thread Raw
Responses Re: Block_Size on NTFS
List pgsql-general
Tree view 
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 ?

Thanks for your help !

Regards,
--
Arnaud Lesauvage

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: Can postgresql store its data on raw device now?
Next
From: "Marc Mamin"
Date:
Subject: Text search without dictionary ?