Search Postgresql Archives

Re: Postgresql performance in production environment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 19/08/07, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:
> Phoenix Kiula wrote:

> There are ways to do this, but if you can't just use timeouts to expire
> from the cache, things can become pretty complicated pretty fast. But
> perhaps you can isolate some kinds of queries that can be cached for <n>
> minutes, and keep the rest without caching?


Thanks. In fact we need caching on a very specific part of our
application, for only three queries which hit the DB hard with
thousands of simultaneous SELECTs.

Do pgmemcache or pgbouncer allow for very specific usage? Both look
way too complex. I don't mind the initial headachy setup and config,
but then I would like the system to hum on its own, and the querying
should be simple and intuitive.

I need a simple mechanism to query the cache, and invalidate a
specific query in the cache when the underlying table is UPDATED so
that the query gets cached afresh when issued later. (And a way to use
this mechanism through PHP or Perl would be splendid).

TIA for any tips!

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux