Re: [PERFORM] Limited Shared Buffer Problem

ork_mem,etc. My recommendation is to go down a little the shmmax and the shared_buffers values. Is very necessary that you have these values so high? Regards -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda

Re: [PERFORM] performance while importing a very large data set in to database

any case that you use it. 3- Then apply A CLUSTER command on the right tables that have these indexes. Regards -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA Centro de Tecnologías de Alm

Re: [PERFORM] Any have tested ZFS like PostgreSQL installation filesystem?

Ivan Voras escribió: Ing . Marcos Luís Ortíz Valmaseda wrote: Regards to all the list. ZFS, the new filesystem developed by the Solaris Development team and ported to FreeBSD too, have many advantages that can do that all sysadmins are questioned about if it is a good filesystem to the

[PERFORM] Any have tested ZFS like PostgreSQL installation filesystem?

PostgreSQL installation fs? Regards. -- - "TIP 4: No hagas 'kill -9' a postmaster" Ing. Marcos Luís Ortíz Valmaseda PostgreSQL System DBA Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD) Universidad de las Ciencias Info