Make a post static? Not sticky, static…

I was wondering if it possible to make a post static without a cache plugin.

I don’t mean a sticky post that stays on the top of a page.

What I would like to do if possible is to make a post static, as in it will not query the database upon display.

Is this possible without having to install a cache plugin. It would be nice if something like this could be done on a post by post basis. That way if you had a popular post on Digg, or Reddit, it wouldn’t impact the site as much.

Just curious.