Re: [PERFORM] file system and raid performance

2008-08-05 Thread Fernando Ike
ld be the other > popular choice for the DL-380 that we're using. > Would be interesting also tests with Ext4. Despite of don't consider stable in kernel linux, on the case is possible because the version kernel and assuming that is e2fsprogs is supported. Regards, -- Fernando

Re: [PERFORM] Database size Vs performance degradation

2008-08-03 Thread Fernando Ike
production > system already. One good possibility is use pg8.3 for fix problem. Enable Autovacuum+HOT was won a significant performance compared with 8.2 and minor versions. :) Kind Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog -- Sent via pgsql-performance mailing lis

Re: [PERFORM] Configuration settings (shared_buffers, etc) in Linux: puzzled

2008-01-24 Thread Fernando Ike
; max_stack_depth = 4096 > This configuration is possibility of the PostgreSQL 8.1. But if don't by 8.1, for example: 8.2 or 8.3, follow the talk Greg Smith. :) Best Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog ---(end of broadcast)---

Re: [PERFORM] 8.3rc1 Out of memory when performing update

2008-01-24 Thread Fernando Ike
d this be due to a > poor choice of some configuration parameter, or is there a limit on > how many rows I can update in a single statement? > I believe that it is plataform problem. Because on *nix this limit don't occur. But I don't specialist Windows. Kind Regards, -- Ferna

Re: [PERFORM] 8.3 synchronous_commit

2008-01-21 Thread Fernando Ike
tself, because it doesn't read/write to disk, right? > No. But pgbench local running, it will be concurrency with PostgreSQL. I'm realized some test and really confirm disable *synchronous_commit* performance degrade with CFQ and Deadline. Kind Regards, -- Fernando Ike http:/