Re: [PERFORM] can't handle large number of INSERT/UPDATEs

2004-10-27 Thread Matt Clark
and certainly anyone who's been around a computer more than a week or two knows which direction in and out are customarily seen from. regards, tom lane Apparently not whoever wrote the man page that everyone copied ;-) Interesting. I checked this on several machines. They actually

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 QA session): Is there

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 they behave and are

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