X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 50E02D1B4F6 for ; Mon, 6 Oct 2003 18:26:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 25267-01 for ; Mon, 6 Oct 2003 15:26:13 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id EBA8DD1B52E for ; Mon, 6 Oct 2003 15:26:11 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h96IQAhn029924; Mon, 6 Oct 2003 14:26:11 -0400 (EDT) To: Neil Conway Cc: Andrew Sullivan , PostgreSQL Performance Subject: Re: reindex/vacuum locking/performance? In-reply-to: <1065464069.473.31.camel@tokyo> References: <60d6de9fah.fsf@dev6.int.libertyrms.info> <20031004152241.GL580@libertyrms.info> <1065396767.466.12.camel@tokyo> <15813.1065397428@sss.pgh.pa.us> <1065397835.471.17.camel@tokyo> <1065464069.473.31.camel@tokyo> Comments: In-reply-to Neil Conway message dated "Mon, 06 Oct 2003 14:14:29 -0400" Date: Mon, 06 Oct 2003 14:26:10 -0400 Message-ID: <29923.1065464770@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/186 X-Sequence-Number: 3934 Neil Conway writes: > On Sun, 2003-10-05 at 19:50, Neil Conway wrote: > I was hoping you'd reply to this, Tom -- you were referring to O_DIRECT, > right? Not necessarily --- as you point out, it's not clear that O_DIRECT would help us. What would be way cool is something similar to what James Rogers was talking about: a way to tell the kernel not to promote this page all the way to the top of its LRU list. I'm not sure that *any* Unixen have such an API, let alone one that's common across more than one platform :-( regards, tom lane