Christoper Petrilli, over at PENSIERI DI UN LUNATICO MINORE discusses the inherent challenges of using the PostgreSQL DBMS in what is traditionally Oracle-dominated territory, tables with hundreds of millions of rows.

While not the DBA for the project, I am the SA for a new system at work where we've settled on Postgres for storage of several hundred gigabytes of new data (lots of inserts) daily. From an operational perspective, I'm going to try and learn as much as possible from our DB guy, so that we can monitor the DB for performance and signs of stress or bottlenecks.

I think that we'll probably see advantages since we're using 64-bit Linux (AMD Opteron) with SAN storage, instead of a standard Intel box with internal drives. The blazing-fast SAN disk I/O with cacheing should help things considerably. Or, at least that's the plan.