Re: [PERFORM] Opteron/FreeBSD/PostgreSQL performance poor

2006-07-07 Thread andy rost
Hi Merlin, Thanks for the input. Please see below ... Merlin Moncure wrote: On 7/5/06, andy rost <[EMAIL PROTECTED]> wrote: fsync = on # turns forced synchronization have you tried turning this off and measuring performance? No, not yet. We'

Re: [PERFORM] Opteron/FreeBSD/PostgreSQL performance poor

2006-07-07 Thread andy rost
es in excess of 5 may hamper performance). Thanks again ... Andy Mark Kirkwood wrote: andy rost wrote: effective_cache_size = 27462# typically 8KB each This seems like it might be a little low... How much memory do you have in the system? Then again, with your shared_me

Re: [PERFORM] Opteron/FreeBSD/PostgreSQL performance poor

2006-07-05 Thread andy rost
Hi Stephen, Thanks for your input. My follow ups are interleaved below ... Stephen Frost wrote: * andy rost ([EMAIL PROTECTED]) wrote: We're in the process of porting from Informix 9.4 to PostgreSQL 8.1.3. Our PostgreSQL server is an AMD Opteron Dual Core 275 with two 2.2 Ghz 6

[PERFORM] Opteron/FreeBSD/PostgreSQL performance poor

2006-07-05 Thread andy rost
We're in the process of porting from Informix 9.4 to PostgreSQL 8.1.3. Our PostgreSQL server is an AMD Opteron Dual Core 275 with two 2.2 Ghz 64-bit processors. There are two internal drives and an external enclosure containing 14 drives (configured as 7 pairs of mirrored drives - four pairs fo