In article <47CFAD1F.7080801@xxxxxxxxxxxx>, Richard Huxton <dev@xxxxxxxxxxxx> wrote: % Some people used to suggest that a larger blocksize helped with specific % disk systems & disk block sizes. This means changing the setting in one % of the header files and recompiling. It also means your database files % aren't compatible with a normally-compiled version of PostgreSQL. I've % not seen anyone mention it recently, so maybe it's just not worth the % trouble any more. I suspect there's just not much to say about it. It makes good sense to match the database block size to the filesystem block size, particularly if the filesystem blocks are larger than 8k. It's not exactly a lot of trouble to set it up, assuming you compile the database yourself anyway, and it allows the database to do a better job of I/O management. -- Patrick TJ McPhee North York Canada ptjm@xxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
