postgre_vs_mongodb.txt

SELECT s.id, s.sha1, f.name
FROM storage s
JOIN file f ON s.id = f.storage_id
WHERE s.count > 0
ORDER by id DESC, name ASC
OFFSET 1000 LIMIT 10

------------------------------

db.file_storage.aggregate([
    {$match: {"count": {$gt: 0}}},
    {$unwind: "$files"},
    {$project: {_id: 1, sha1: 1, "name": "$files.name"}},
    {$sort: {_id: -1, "name": 1}},
    {$skip : 1000},
    {$limit : 10},
])