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

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -