Adobe and Apple have worked closely together… All Adobe CC and CS6 products are compatible, but a few products require updates to the latest builds to work properly. Adobe Photoshop® CS5, CS4 and CS3 were also tested with Mac OS X Mavericks and there are currently no major issues known.
Notably After Effects requires an update (CC, CS6) to be compatible. If you see any weirdness, please let us know.
Update: If you see a message about “Adobe Creative Cloud” (the management/desktop sync app) being incompatible with Mavericks, you’ll need to reinstall it. [Via Keith Lang & Fergus Hammond]