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 B984352B5C for ; Sun, 17 Jul 2005 07:56:50 -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 59652-04 for ; Sun, 17 Jul 2005 10:56:42 +0000 (GMT) Received: from mail3.cc.huji.ac.il (real-outmail.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id C3D6952B5A for ; Sun, 17 Jul 2005 07:56:38 -0300 (ADT) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id 81A2081756; Sun, 17 Jul 2005 13:56:38 +0300 (IDT) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id 765658175D; Sun, 17 Jul 2005 13:56:38 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id 26BB081756 for ; Sun, 17 Jul 2005 13:56:38 +0300 (IDT) Message-ID: <42DA3A4C.3080009@mail.jct.ac.il> Date: Sun, 17 Jul 2005 14:00:28 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: caching table/query Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.797 from Sat Jul 16 23:42:48 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/112 X-Sequence-Number: 18168 Hi list! I have several pretty little tables (~300 - 400 records) which are queried very frequently. I would like to make postrgres be aware of this and do a in memory cache for it . (It have to be inside postgres - can't use any special tools for it) What is the way to do it? Thanks Evgeny