Re: [GENERAL] Memcached for Database server

2011-05-22 Thread Craig Ringer
On 20/05/11 17:33, Adarsh Sharma wrote: Craig Ringer wrote: category_id Record_id fields 7821 {Village:adasrpur, SOI:media, Heading:CM dies Yes , but slight modification , I want Village, SOI Heading as column names and adasrpur,media and CM dies their values as

Re: [GENERAL] Memcached for Database server

2011-05-20 Thread Craig Ringer
On 20/05/11 13:00, Adarsh Sharma wrote: Thanks Craig, I spend some time on Memcahced and your explaination also helps. I think it is used only for applications where load is very high users issue read only queries to the database. Er, yes. You can't really cache queries that write to the

Re: [GENERAL] Memcached for Database server

2011-05-20 Thread Craig Ringer
Please reply to the list, not directly to me. My reply follows. On 20/05/11 14:47, Adarsh Sharma wrote: But Sometimes when I got stucked , I have no other option. Like I stucked from the past 4 days to solve the attached problem. Sure. Sometimes you get stuck, and that's what mailing lists

Re: [GENERAL] Memcached for Database server

2011-05-18 Thread Tatsuo Ishii
How do you handle statements that rely on current_timestamp, random(), etc? What about if their reliance is via a function? Is that just an understood limitation of the cache, that it'll cache even queries that don't really make sense to cache? Probably we should cache the result of a query

Re: [GENERAL] Memcached for Database server

2011-05-18 Thread satoshi . nagayasu
Hi, 2011/5/18 Tatsuo Ishii is...@postgresql.org: How do you handle statements that rely on current_timestamp, random(), etc? What about if their reliance is via a function? Is that just an understood limitation of the cache, that it'll cache even queries that don't really make sense to cache?

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Craig Ringer
On 05/17/2011 01:38 PM, Satoshi Nagayasu wrote: Hi, 2011/05/17 14:31, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Craig Ringer
On 05/17/2011 01:31 PM, Adarsh Sharma wrote: At what stage we need memcached what is the purpose of using it. You might not need it. Depends on the nature of your app, its performance requirements, how strict it is about always getting consistent current data, and how much money you have

Re: [GENERAL] Memcached for Database server

2011-05-17 Thread Cédric Villemain
2011/5/17 Craig Ringer cr...@postnewspapers.com.au: On 05/17/2011 01:38 PM, Satoshi Nagayasu wrote: Hi, 2011/05/17 14:31, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I

[GENERAL] Memcached for Database server

2011-05-16 Thread Adarsh Sharma
Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB and it's not the OLTP just a simple OLAP where data is fetched and stored in some meaningful

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Rick Genter
On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB and it's not the OLTP just a simple

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Adarsh Sharma
Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB and it's not the

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Satoshi Nagayasu
Hi, 2011/05/17 14:31, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have

Re: [GENERAL] Memcached for Database server

2011-05-16 Thread Rick Genter
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote: Rick Genter wrote: On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote: Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production