An SSD would probably be a good fit for the Snorby database, but it probably would not be cost effective for the databases containing sessions and log data in Sguil and ELSA unless your network has little activity. Databases do gain a fair amount of performance with SSD if they make a fair amount of queries that do not uses indexes well (like full table scans), but if most queries use the indexes properly and the indexes fit in RAM (as configured in the database tuning variables), then there will be very little performance gain. I know the
mysqlperformanceblog.com has run many articles with benchmarks on specific SSD's, and I'm sure there are Postgres benchmarks available. But remember: if the data is already in RAM either via disk caching by the OS or through the database's own index buffer pool, then you probably won't see much improvement.
If you can afford to buy enough SSD to fit the pcap data on, you would see enormous speed boosts in transcript retrieval and session searches, but that would be cost prohibitive for most.