SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 06:33 PM
| ||||
| ||||
 Postgresql over a SAN We're evaluating to install a SAN (Storage Area Network) and to use it as storage area for our Postgresql server. Did anybody already make this? Problems, performance issues, tips? The db server is mainly used as backend to several heavy loaded web servers. The version of Postgresql is 8.1 and OS is linux with kernel 2.6. The server will be connected to the SAN using a 4Gb fibre channel link. Thank you in advance, Denis ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-09-2008, 06:33 PM
| |||
| |||
| Re: Postgresql over a SAN Denis Gasparin wrote: > We're evaluating to install a SAN (Storage Area Network) and to use it > as storage area for our Postgresql server. > > Did anybody already make this? Problems, performance issues, tips? We use a SAN with HP EVA boxes for our PostgreSQL servers and we have not encountered any irregularities so far. None of our databases are very big or under heavy load though. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
|
04-09-2008, 06:33 PM
| ||||
| ||||
| Re: Postgresql over a SAN At one point I used a SAN with a 380GB postgresql database. There were no issues. Great benefit? We were able to keep a hot standby servers in case the main server went down. In that case we would just shutdown the primary server, and start the standby one. - Ericson Smith W3matter LLC http://www.w3matter.com On 7/26/07, Albe Laurenz <all@adv.magwien.gv.at> wrote: > Denis Gasparin wrote: > > We're evaluating to install a SAN (Storage Area Network) and to use it > > as storage area for our Postgresql server. > > > > Did anybody already make this? Problems, performance issues, tips? > > We use a SAN with HP EVA boxes for our PostgreSQL servers and we have > not encountered any irregularities so far. None of our databases > are very big or under heavy load though. > > Yours, > Laurenz Albe > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ |
Linear Mode
