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 74D89529AD for ; Wed, 20 Jul 2005 03:16:24 -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 83847-07 for ; Wed, 20 Jul 2005 06:16:15 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id B6E6D52968 for ; Wed, 20 Jul 2005 03:16:13 -0300 (ADT) Received: (qmail 28849 invoked from network); 20 Jul 2005 06:16:13 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 20 Jul 2005 06:16:13 -0000 Message-ID: <42DDEC2C.9050009@metatrontech.com> Date: Tue, 19 Jul 2005 23:16:12 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tsirkin Evgeny Cc: Tom Lane , 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> <42DB4DE2.6090304@mail.jct.ac.il> In-Reply-To: <42DB4DE2.6090304@mail.jct.ac.il> Content-Type: multipart/mixed; boundary="------------050405040806020207080506" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.069 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/186 X-Sequence-Number: 18242 This is a multi-part message in MIME format. --------------050405040806020207080506 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Tsirkin Evgeny wrote: > > 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. Largely true. There may be ways of forcing a from-memory query once the system is in place, but I am not sure that this is always what you want, it would not be pretty, and might have some real performance issues. My suggestion is that you wait until your system is in operation and then look first for general tuning help before you even consider trying to impliment a memory-cached table in your application. Just for the record, I can think of at least one way of hacking this on, but it seems like it should be an absolutely last resort rather than a first impulse. PostgreSQL can do this, but you probably don't want it to. Best Wishes, Chris Travers --------------050405040806020207080506 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com x-mozilla-html:FALSE version:2.1 end:vcard --------------050405040806020207080506--