Re: [PERFORM] Extreme high load averages

2003-07-07 Thread scott.marlowe
On Sun, 6 Jul 2003, Martin Foster wrote: Shridhar Daithankar wrote: It gives hint to psotgresql how much file system cache is available in the system. You have 1GB memory and your application requirement does not exceed 400MB. So OS can use roughly 600MB for file system cache.

Re: [PERFORM] PostgreSQL vs. MySQL

2003-07-07 Thread scott.marlowe
On Mon, 7 Jul 2003, Brian Tarbox wrote: Oddly enough, the particular application in question will have an extremely small user base...perhaps a few simultainous users at most. As to the testing, I neglected to say early in this thread that my manager instructed me _not_ to do further

Re: [PERFORM] Moving postgresql.conf tunables into 2003...

2003-07-07 Thread Chris Travers
Matthew Nuzum wrote: I'm highly resistant to/disappointed in this attitude and firmly believe that there are well understood algorithms that DBAs use to diagnose and solve performance problems. It's only a black art because it hasn't been documented. Performance tuning isn't voodoo, it's