What is the best time to take Lyrica so one can sleep with bulging discs in lower spine?

I would prefer to only take this medication at night, as it makes me very drowsy during the day and i am on targin 30 in am 40 in pm and panamax 2 x 4 a day. Bulging disc started suddenly and I have two, L2/L3, L4/L5, and this pain is worse then 3 lots of pancreatitis and a whipple procedure for cancer.