postgresql - Very simple in memory storage -
i need simple storage keep data, before added postgresql. currently, have web application collects data clients. data not important. application collects 50 kb of data (simple string) 1 client. collect 2gb data per hour. data not needed asap , it's nothing if lost. there existing solution store in memory while (~ 1 hour), , write in postgresql. don't need query in way. can use redis, probably, redis complex task. can write myself, tool must handle many requests store data (maybe 100 per second) , existing solution may better.
thanks, dmitry
if not plan work data operatively why want store in memory? may create unlogged
table , store data in table.
look @ documentation details:
unlogged
if specified, table created unlogged table. data written unlogged tables not written write-ahead log, makes them considerably faster ordinary tables. however, not crash-safe: unlogged table automatically truncated after crash or unclean shutdown. contents of unlogged table not replicated standby servers. indexes created on unlogged table automatically unlogged well; however, unlogged gist indexes not supported , cannot created on unlogged table.
Comments
Post a Comment