[EMAIL PROTECTED] wrote:
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
