Re: [GENERAL] Block_Size on NTFS

Craig Ringer wrote: > Bruce Momjian wrote: > > postgresqlgeneral.domain.thewild_cod...@spamgourmet.com 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,

Re: [GENERAL] Block_Size on NTFS

postgresqlgeneral.domain.thewild_cod...@spamgourmet.com wrote: > Bruce Momjian - postgresqlgeneral.domain.thewild_cod...@spamgourmet.com a > ?crit : > > postgresqlgeneral.domain.thewild_cod...@spamgourmet.com wrote: > >> Reading through the list of settings returned by "SHOW ALL", I noticed > >>

Re: [GENERAL] Block_Size on NTFS

Bruce Momjian - br...@momjian.us a écrit : postgresqlgeneral.domain.thewild_cod...@spamgourmet.com wrote: 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 partiti

Re: [GENERAL] Block_Size on NTFS

Bruce Momjian wrote: > postgresqlgeneral.domain.thewild_cod...@spamgourmet.com 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 part

Re: [GENERAL] Block_Size on NTFS

postgresqlgeneral.domain.thewild_cod...@spamgourmet.com 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

[GENERAL] Block_Size on NTFS

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