If your database is that large look into changing the search engine otherwise your only choice is to delete posts or move hosting.