rosser on Reddit: Lessons Learned From Scaling To 1 Billion Pageviews A Month

Comment on Reddit: Lessons Learned From Scaling To 1 Billion Pageviews A Month parent

It's still relatively new functionality, so I wouldn't expect to see it in wide use, but we're currently trying it out in a limited, point-solution kind of role. (We're a Postgres-mostly shop already.)

So far, everything's working as well as I'd have expected from something released by the PostgreSQL community.

yummyfajitas 13y

The functionality was always there:

    CREATE TABLE kvstore (
        key VARCHAR(128) NOT NULL UNIQUE,
        value VARCHAR(128) NOT NULL
     );

Or are you referring to hstore?

rosser 13y

I'm talking about the JSON-specific functionality, which tends to make doing JSON-based, document-oriented, key-value-ish things in PostgreSQL significantly better, easier, faster, whatever-er.

ketralnis 13y

And this is how reddit does it, reddit doesn't use hstore.

Comments