Windows has a "system managed size" option for pagefile size, which seems to lack precise documentation.
What exactly does Windows do when you choose this?
Does it simply select default min and max sizes, or does it do something fancier?
Does windows shrink the pagefile and grow it later (with annoying dialogs)?
It does exactly what it says on the tin: the OS manages the size of the pagefile, which can shrink or grow dynamically. The lower and upper bounds are 1x your RAM size and 3x your RAM size or 4 GB (whichever is larger) as explained more elaborately here. The pro is that you don't have to worry about sizing your pagefile, the con is that your pagefile can become fragmented.
Where it is useful is in exactly the situation it's designed to avoid: sizing your pagefile. You can set it to System Managed and check in every several minutes (via a script), recording the smallest and largest sizes it uses over a typical usage period of a month or so. You should then have a very good idea how large to manually set your pagefile to be.
Near the end of this article, Mark Russinovich briefly discusses system-managed pagefile sizes:
The rest of the article is well worth reading, and does talk a bit more about what happens when Windows grows the pagefile.
In my own experience, system-managed pagefile is the best option to take in the vast majority of cases.
The general rule for system managed pagefile is: the operating system will create a page file that is one and a half times the amount of RAM that is installed in your computer.
However you rarely need the size of the pagefile be determined by system because nowadays computers RAM is more than adequate. A system managed page file with its shrinking and growing is subject to heavy fragmentation.
This KB article addresses the issue and explains how to calculate the page file size: How to determine the appropriate page file size for 64-bit versions of Windows Server 2003 or Windows XP.
Setting to a fixed size pagefile is worth considering. Additionally, it prevents this problem: The page file size may become alternately too small or too large when you start Windows Server 2008 or Windows Vista if there is no available free disk space, and the page file size is managed by the system
It handles sorting out the size of the pagefile. In the past I've set that when the available drive space is substantial. If you have the room why not let the system have as much as it needs?
I ussually set the size of the pagefile manually at about twice the size of the RAM Memory so the system won't take too much I/O time with excessive growing and shrinking of this file.
Here is a video with David Solomon, one of the MS uber-engineers.
This video will answer your questions and also tell you more then you'd ever want to know about Windows memory management.
There is a section about sizing your pagefile:
http://www.microsoft.com/emea/spotlight/sessionh.aspx?videoid=64
It works on a dynamic basis. It sets a typical upper level for the amount of RAM you have installed, which it extends as needed.