I don't think there's a show in Sept. So, I'd say 1-2 days would be enough, depending on how much you want to shop! You can spend half a day at the quilt museum for sure. I spent several hours at the Hancock's of Paducah store. There are lots of other quilt-related things described here
https://www.paducah.travel/blog/post...ucah-kentucky/