It might vary between databases, but in MySQL you could do something
:select => "DATE_FORMAT('%m/%Y') as month_year,COUNT(posts.id) as
:group => "month_year"
:order => "month_year"
That's just off the top of my head, but the idea is to use a GROUP BY
clause on month.