My condolences, James. Pets aren't just pets; they're family.
One of the hardest days of my and my father's life was putting down our Doberman. In hindsight, we made the right decision at the right time. When it's time, it's time. The most important thing is the pet's comfort, not our own comfort IMO.