News for hackers. Stuff that matters.

A comment on Amazon Redshift - What You Need To Know. Parent comment

Re:Amazon Redshift - What You Need To Know by saurik on Sunday September 29, 2013 @09:11PM (#6467271)
As mentioned by sargun (who was irritatingly downvoted by someone) the difference is that PostgreSQL uses the MVCC concurrency model, which allows you to do quite complex queries concurrently with other people making writes to the database, but comes at the cost that there is no longer any objective count of the rows in a given table: the number of rows is related to which transactions are considered live at any given moment.

http://wiki.postgresql.org/wiki/Slow_Counting

[ Parent | on HN ]
Re:Amazon Redshift - What You Need To Know by kungfooey on Sunday September 29, 2013 @09:27PM (#6467318)
In my case, this was inadvertently a good comparison. Most of the "ad-hoc" queries we're doing are AVG, SUM, or similar operations that require scanning the entire table.

I may try to edit this post to compare those operations, as it may be more meaningful.

Thanks for posting the link. TIL.

[ Parent | on HN ]