Re: which ext3 fs type should I use for postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 15 May 2008, david@xxxxxxx wrote:
IIRC postgres likes to do 1M/file, which isn't very largeas far as the -T setting goes.

ITYF it's actually 1GB/file.

think twice about this. ext2/3 get slow when they fill up (they have fragmentation problems when free space gets too small), this 5% that only root can use also serves as a buffer against that as well.

It makes sense to me that the usage pattern of Postgres would be much less susceptible to causing fragmentation than normal filesystem usage. Has anyone actually tested this and found out?

Matthew

--
Isn't "Microsoft Works" something of a contradiction?


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux