Re: [PERFORM] Free PostgreSQL Training, Philadelphia, Oct 30

2004-10-27 Thread D'Arcy J.M. Cain
On Wed, 13 Oct 2004 12:21:27 -0400 (EDT) Aaron Mulder <[EMAIL PROTECTED]> wrote: > All, > My company (Chariot Solutions) is sponsoring a day of free > PostgreSQL training by Bruce Momjian (one of the core PostgreSQL > developers). The day is split into 2 sessions (plus a Q&A session): Is th

Re: [PERFORM] Sequential Scan with LIMIT

2004-10-27 Thread Jaime Casanova
--- John Meinel <[EMAIL PROTECTED]> escribió: > Jaime Casanova wrote: > [...] > >> > >>I'm not sure. They all return the same > information. > > > > > > of course, both queries will return the same but > > that's just because you forced it. > > > > LIMIT and DISTINCT are different things so th

Re: [PERFORM] different io elevators in linux

2004-10-27 Thread Mark Wong
On Mon, Oct 25, 2004 at 10:09:17AM -0700, Josh Berkus wrote: > Bjorn, > > > I haven't read much FAQs but has anyone done some benchmarks with > > different io schedulers in linux with postgresql? > > According to OSDL, using the "deadline" scheduler sometimes results in a > roughly 5% boost to p