X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0E88952A87 for ; Mon, 18 Jul 2005 03:32:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03671-08 for ; Mon, 18 Jul 2005 06:32:32 +0000 (GMT) Received: from mail1.cc.huji.ac.il (mail1.cc.huji.ac.il [132.64.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 90A7E52806 for ; Mon, 18 Jul 2005 03:32:30 -0300 (ADT) Received: from mail1.cc.huji.ac.il (localhost [127.0.0.1]) by mail1.cc.huji.ac.il (Postfix) with SMTP id AB3821E80DB; Mon, 18 Jul 2005 09:32:28 +0300 (IDT) Received: by mail1.cc.huji.ac.il (Postfix, from userid 31998) id A481E1E80DE; Mon, 18 Jul 2005 09:32:28 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail1.cc.huji.ac.il (Postfix) with ESMTP id 3D67A1E80DB; Mon, 18 Jul 2005 09:32:28 +0300 (IDT) Message-ID: <42DB4DE2.6090304@mail.jct.ac.il> Date: Mon, 18 Jul 2005 09:36:18 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Tsirkin Evgeny , Michael Fuhr , pgsql-admin@postgresql.org Subject: Re: caching table/query References: <42DA3A4C.3080009@mail.jct.ac.il> <20050717140655.GA9637@winnie.fuhr.org> <42DA7226.5070808@mail.jct.ac.il> <28088.1121615607@sss.pgh.pa.us> In-Reply-To: <28088.1121615607@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.798 from Sun Jul 17 15:38:07 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/117 X-Sequence-Number: 18173 Well i guess that there are cases where that is not so.However i understand that postgres does not have any way accept the automatic. Tom Lane wrote: >Tsirkin Evgeny writes: > > >>What i realy want is to say to postgres that the particular >>table should be cached . >> >> > >Adopting the position that you are smarter than an automatic >optimization algorithm is generally a good way to achieve less >performance, not more. >