Re: [PERFORM] Tuning

2007-01-30 Thread John Parnefjord
> What are Oracle and EnterpriseDB recommending for shmmax these days? According to Oracle "set to a value half the size of physical memory". [http://www.oracle.com/technology/tech/linux/validated-configurations/ht ml/vc_dell6850-rhel4-cx500-1_1.html] I've been talking to an Oracle DBA and he sa

[PERFORM] Tuning

2007-01-26 Thread John Parnefjord
Hi! I'm planning to move from mysql to postgresql as I believe the latter performs better when it comes to complex queries. The mysql database that I'm running is about 150 GB in size, with 300 million rows in the largest table. We do quite a lot of statistical analysis on the data which means h