It is too early for any first hand information on the 7900.
Amazon is showing a ship date of May 1 at $450.
The SD500 is shown to be available now, but I have not seen any reviews of any type. It is priced at $500.
If you look at the specifications, these two cameras are going to be competing head to head:
http://www.dpreview.com/reviews/compare_post.asp?method=sidebyside&cameras=canon_sd500%2Cnikon_cp7900&show=all
...
..
.
Has anyone used this camera yet?
How does it compare to the CANON POWERSHOT SD500?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic