Re: Advice request: Postgresql setup for flash memories. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Advice request: Postgresql setup for flash memories.
Date
Msg-id 12001.1156715116@sss.pgh.pa.us
Whole thread Raw
In response to Advice request: Postgresql setup for flash memories.  (Enrique Arizón <e_arizon_benito@yahoo.com>)
Responses Re: Advice request: Postgresql setup for flash memories.  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
=?iso-8859-1?q?Enrique=20Ariz=F3n?= <e_arizon_benito@yahoo.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.

            regards, tom lane

pgsql-admin by date:

Previous
From: Enrique Arizón
Date:
Subject: Advice request: Postgresql setup for flash memories.
Next
From: "Gera Mel Handumon"
Date:
Subject: duplicate records after restore