If I want to count the records in a table which is more efficient as records scale? ie:
count = from(p in Post, select: count(p.id))
posts = from(p in Post, select: p.id) count = length(posts)
Allowing postgres to do the calculations or elixir? Is there any notable difference?