On Mon, Oct 16, 2006 at 03:08:39AM +0930, Shane Ambler wrote:

You could setup a table in memory to contain known popular data, you could also use this to create a temporary table in memory to speed up multiple intermediate calculations without touching disks.

I'm not sure what this would save. If the table is read-only, there
shouldn't be writes happening. If it's small, and frequently accessed,
it should fit in the buffer cache.

Because it is frequently accessed doesn't mean that it is small - the main point is control over what is cached and a starting point for other options mentioned later.

None of this avoids the cost of query planning, or query execution.

No but you can avoid costly disk access and still have the postgres level of integrity and integration that memcached doesn't offer.

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

Reply via email to