Skip site navigation (1) Skip section navigation (2)

Re: Advice request: Postgresql setup for flash memories.

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Enrique Arizón <e_arizon_benito(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Advice request: Postgresql setup for flash memories.
Date: 2006-08-28 15:59:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Sun, 2006-08-27 at 16:45, Tom Lane wrote:
> =?iso-8859-1?q?Enrique=20Ariz=F3n?= <e_arizon_benito(at)yahoo(dot)com> writes:
> >  since flash memory hardware is dropping prices at
> > high rate I was planning to test how Postgresql runs
> > in such hardware.
> This is probably a bad idea, unless the number-of-write-cycles
> limitation of flash memory has gone away while I wasn't looking.
> PG is pretty piggy as far as rewriting disk pages goes, especially
> for the WAL files.

Note that most flash memory controllers randomize the accesses across
the media to prevent / slow this problem.  So, it's critical that IF one
has a pg store on a flash device that it have a controller that spreads
writes around.  Without that, your flash memory will fail fairly soon.

In response to

pgsql-admin by date

Next:From: Thomas GallaDate: 2006-08-28 22:25:02
Subject: Help about types please
Previous:From: Gera Mel HandumonDate: 2006-08-28 06:21:09
Subject: duplicate records after restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group