Thanks, I will look at the site you sent me and purchase some hardware. Then I will run some benchmarks.
Kind regards, Alexander. ----- Original Message ----- From: "Shridhar Daithankar" <[EMAIL PROTECTED]> To: "Alexander Priem" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 11:33 AM Subject: Re: [PERFORM] Tuning PostgreSQL > Hi Alexander , > > On 21 Jul 2003 at 11:23, Alexander Priem wrote: > > So the memory settings I specified are pretty much OK? > > As of now yes, You need to test with these settings and make sure that they > perform as per your requirement. That tweaking will always be there... > > > What would be good guidelines for setting effective_cache_size, noatime ? > > I suggest you look at > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html. > > That should help you. > > > I use ext3 filesystem, which probably is not the best performer, is it? > > No. You also need to check ext2, reiser and XFS. There is no agreement between > users as in what works best. You need to benchmark and decide. > > > I will set the WAL on a separate drive. What do I need to change in the conf > > files to achive this? > > No. You need to shutdown postgresql server process and symlink WAL and clog > directories in postgresql database cluster to another place. That should do it. > > HTH > > Bye > Shridhar > > -- > Meade's Maxim: Always remember that you are absolutely unique, just like everyone else. > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
