[PERFORM] pgCluster and postgres 8.1

2006-03-09 Thread Javier Somoza
    Hi all !     I wanna test my system performance when using pgCluster.     I'm using postgreSQL 8.1.0 and i've downloaded pgcluster-1.5.0rc7     and pgcluster-1.5.0rc7-patch.     Do i need to recompile postgreSQL with the patch?     Can i use pgcluster-1.5 with t

Re: [PERFORM] fsync and battery-backed caches

2006-02-28 Thread Javier Somoza
    Ups sorry. Actually, you can't assume that a BBU means you can safely disable full-page-writes. Depending on the controller, it's still possible to end up with partially written pages. BTW, if your mailer makes doing so convenient, it would be nice to trim down your .signature;

[PERFORM] vacuum, analyze and reindex

2006-02-28 Thread Javier Somoza
    Hi all     I've a question about vacuuming, ...     Vacuum: cleans out obsolete and deleted registers...     Analyze:  update statistics for the planner     Reindex:  rebuild indexes     I think the correct order to perform the database

[PERFORM] Different disks for xlogs and data

2006-02-28 Thread Javier Somoza
Hi, is interesting to do it when using RAID 1+0? Thx

Re: [PERFORM] fsync and battery-backed caches

2006-02-28 Thread Javier Somoza
/static/wal.html If it is unclear, please let us know. Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL PROTECTED] Panda Software Buenos Aires, 12 48001 BILBAO - ESPAÑA Teléfono: 902 24 365 4 Fax:  94 424 46 97 http://www.pandasoftware.es Panda Software, una de las principales compañías

[PERFORM] Setting the shared buffers

2006-02-27 Thread Javier Somoza
    Hi,     How should i set this configuration? Depending on the memory?     And then is it necessary to perform a benchmarking test?     What did you do?     Thx!     Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL

Re: [PERFORM] wal sync method

2006-02-27 Thread Javier Somoza
using RAID-10 (JFS filesystem), 2xXEON, 4 Gb RAM. I've tried to switch to open_sync which seems to work faster than default fdatasync, but is it crash-safe? Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL PROTECTED] Panda Software Buenos Aires, 12 48001 BILBAO - ESPAÑA Telé

[PERFORM] fsync and battery-backed caches

2006-02-27 Thread Javier Somoza
    Hi all     Is it secure to disable fsync havin battery-backed disk cache?         Thx Javier Somoza Oficina de Dirección Estratégica mailto:[EMAIL PROTECTED] Panda Software Buenos Aires, 12 48001 BILBAO - ESPAÑA Teléfono: 902 24 365 4 Fax:  94 424 46 97