Fedora 9 comes with two drivers that can be used in /etc/X11/xorg.conf to support your Nvidia card.
Although these two drivers work, they have their limitations. It is best to install the Nvidia driver from Nvidia.com. You can either build the source from Nvidia's Driver Website, or use Livna.org to install a binary kernel module.
Livna's Binary Nvidia Driver
rpm -ivh http://rpm.livna.org/livna-release-9.rpm
Next, install the Nvidia kernel module and all of it's dependencies:
sudo yum install kmod-nvidia
Then, use the nvidia-xconfig script to configure /etc/X11/xorg.conf. This will configure /etc/X11/xorg.conf with the 'nvidia' driver and it's options.
Finally, reboot your system. You should see the Nvidia driver loading during boot. If you have any X errors, check /var/log/Xorg.log. If you want to tweak your driver, OpenGL or display settings, use nvidia-settings.