Comment on Reddit: Lessons Learned From Scaling To 1 Billion Pageviews A MonthparentComments−Shorel13yIn the case of Postgres, it has indexable json and hstore datatypes that enable the use of a table as a key-value store.And, it has good performance when compared to MongoDB: http://thebuild.com/presentations/pg-as-nosql-pgday-fosdem-2...So in this case, it is using Postgres as intended by the datatype designers.May be you are thinking of the Ruby Rails ORMs.−asdasf13yI didn't mean people using hstore, I mean people having relational data, putting it in tables like you would with a normal relational model, but just not using foreign keys and joins because they mistakenly think "joins are slow".
Comments
In the case of Postgres, it has indexable json and hstore datatypes that enable the use of a table as a key-value store.
And, it has good performance when compared to MongoDB: http://thebuild.com/presentations/pg-as-nosql-pgday-fosdem-2...
So in this case, it is using Postgres as intended by the datatype designers.
May be you are thinking of the Ruby Rails ORMs.
I didn't mean people using hstore, I mean people having relational data, putting it in tables like you would with a normal relational model, but just not using foreign keys and joins because they mistakenly think "joins are slow".