Обсуждение: scheduler
Hi Which scheduler is recommended for a box that is dedicated to running postgres? I've asked google and found no answers. -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
> Which scheduler is recommended for a box that is dedicated to running > postgres? > > I've asked google and found no answers. Is it the OS itself? -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare
Hi >> Which scheduler is recommended for a box that is dedicated to running >> postgres? >> >> I've asked google and found no answers. > > Is it the OS itself? Yes, in linux. I've found that cfq or deadline is best, but I haven't seen anyone try a benchmark -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
On Tue, 22 Jan 2008, Adrian Moisey wrote: > Hi > >>> Which scheduler is recommended for a box that is dedicated to running >>> postgres? >>> >>> I've asked google and found no answers. >> >> Is it the OS itself? > > Yes, in linux. I've found that cfq or deadline is best, but I haven't seen > anyone try a benchmark it also depends on your hardware. if you have a good battery-backed cache on your I/O system you may be best off with 'none' (or simple elevator, I don't remember the exact name) the more complexity in your I/O that the kernek oesn't know about, the less likely it is to make the right decision. David Lang
Deadline works best for us. The new AS is getting better, but last we tried there were issues with it. - Luke > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of > Adrian Moisey > Sent: Monday, January 21, 2008 11:01 PM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] scheduler > > Hi > > Which scheduler is recommended for a box that is dedicated to > running postgres? > > I've asked google and found no answers. > > -- > Adrian Moisey > System Administrator | CareerJunction | Your Future Starts Here. > Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za > Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 > 21 686 6842 > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >