There are lots of good reasons to download PG 7 (just to motivate you):
Referential integrity's been implemented
An annoying "group by" bug that uglified some ACS pages in a non-fatal manner has been fixed.
Lots of small bugs like the one mentioned above have been fixed.
A lot of work was done on the optimizer, on average queries should run faster.
The back end now tracks which backend dirties which blocks, which will lower the number of blocks written at transaction end and fixes a potential database-corrupting race condition.
A new lzText type will allow 32KB text in a 16KB block, which means it will be easy to change bboard and other modules to allow for full TEXTAREA-sized messages
The new PSQL is really nice (the old one was already much more user-friendly than SQL*Plus)
These are the things that come to mind that directly impact our openACS/pg implementation.
If the above doesn't motivate you, what will? :)
Final release is currently scheduled for Sunday, May 1, so you might want to hold off just a few more days.
