News for hackers. Stuff that matters.
Re:Implementing State Machines in PostgreSQL by bluejekyll on Monday July 31, 2017 @11:39AM (#14892962)
> IMO migrating between databases should always require a lot of rewriting. If it doesn't, you're most likely underutilizing the features provided by your database.

Very likely true. But when you get locked into Oracle and it makes it nearly impossible to move because of the features your relying on, has a big effect on shaping your perspective on this.

> The application I'm using this in has > 1 billion rows and we frequently re-compute the state of all our entities across the entire data set in batches after we make changes to our logic.

That is very impressive. Mind sharing the rate of change across all of those rows?

Also, I'm curious. Is this all that DB instance does? Or is it responsible for other data as well?

Re:Implementing State Machines in PostgreSQL by felixge on Monday July 31, 2017 @11:56AM (#14893090)
> But when you get locked into Oracle and it makes it nearly impossible to move because of the features your relying on, has a big effect on shaping your perspective on this.

I hear you. Picking a database is major decision and shouldn't be made lightly. That being said, I hear a lot of companies are successfully migrating from Oracle to Postgres these days. And in fact, this application was actually migrated from Couchbase to Postgres, but that's a story for another day perhaps :).

> That is very impressive. Mind sharing the rate of change across all of those rows?

Nowadays its about 5 million inserts / day with peak rates of 150 inserts / sec. Not too crazy, but it adds up over time :).

> Also, I'm curious. Is this all that DB instance does? Or is it responsible for other data as well?

It does a few other things, but this is the main workload.

Re:Implementing State Machines in PostgreSQL by cwyers on Monday July 31, 2017 @11:51AM (#14893053)
The only thing worse than paying through the nose for Oracle is paying through the nose for Oracle and treating it like a really expensive version of MySQL/Postgres. If you're paying for it, might as well get some value for your money and use those features.