Low cost way to host a large table yet keep the performance scalable?
Posted
by
Leo Liang
on Stack Overflow
See other posts from Stack Overflow
or by Leo Liang
Published on 2012-11-29T21:14:30Z
Indexed on
2012/11/29
23:05 UTC
Read the original article
Hit count: 277
I have a growing table storing time series data, 500M entries now, and 200K new records every day. The total size is around 15GB for now.
My clients are querying the table via a PHP script mostly, and the size of the result set is around 10K records (not very large).
select * from T where timestamp > X and timestamp < Y and additionFilters
And I want this operation cheap.
Currently my table is hosting in Postgres 7, on a single 16G memory Box, and I would love to see some good suggestion for me to host this in low cost and also allow me to scale up for performance if needed.
The table serves:
1. Query: 90%
2. Insert: 9.9%
2. Update: 0.1% <-- very rare.
© Stack Overflow or respective owner
