3 ms·
I err.. never thought I'd be talking about this seriously. We (3 companies ago) used to use postgresql databases backed by a huge netapp filer. Performance wa
by dijit 10y ago
I err.. never thought I'd be talking about this seriously.
We (3 companies ago) used to use postgresql databases backed by a huge netapp filer.
Performance was as you would expect, horrible but tolderable. Why was it tolerable? Because high availability was more important than performance at the time and native HA wasn't in PostgreSQL yet. (8.1 had just come out)
The first DBA ever on staff was an absurdly knowledgable guy (and paid handsomely for being so knowledgeable) and his first and strongest recommendation was, in this order:
1) Upgrade to the latest PostgreSQL to get a better vacuum implementation.
2) Get the data off the filer.
I highly advise against it unless your application caches tremendously well.