I have a pretty clear idea of when I’m going to drink something when I buy it.
About 50% of my collection consists of Bordeaux and Rioja, which I buy at 3-7 years old when I can find them for good prices, and then hold until they are about 12-20 (my preferred drinking window for most of these wines). So there’s a lot of them in the house but they are a relatively small fraction of our drinking
About 20% of my collection consists of California Syrah and Sauternes, both of which have no secondary market and so I can buy ready-to-drink, mature wines as needed on WineBid. These therefore tend to have a short residence time in my house - up to 2 years, with a small amount of Syrah that I buy young to age.
Between these two is Zinfandel and old vine field blends, about 10%. I tend to prefer these with a few years of bottle age on them, but some I will hold on to for a decade or more.
About 5% of my collection consists of mostly aromatic whites, which represent about 50% of our drinking because we absolutely tear through them. My spouse’s preferred wines, too. This is mostly young Riesling, Sauvignon Blanc, Albarino, a bit of Gruner and Gewurz, etc. These wines last no more than a few months in the house and it’s hard to keep them in stock.
The remaining 15% is a mixed bag of everything else, which is hard to generalize about.
My spouse and I also have about a dozen daily drinkers at a time sitting on a bar cart, separate from the “cellar” (wine fridge), which are free-for-all bottles. Our rule is that they have to cost less than $30 and cannot be bought with the intention of aging.
The part that is hardest for me to incorporate into all of this is the wine I get from work or from other industry friends, which tends to accumulate faster than I’d like and gets in the way of my system!