pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Advice request: Postgresql setup for flash memories.
3+ messages / 3 participants
[nested] [flat]

* Advice request: Postgresql setup for flash memories.
@ 2006-08-27 21:07 Enrique Arizón <e_arizon_benito@yahoo.com>
  2006-08-27 21:45 ` Re: Advice request: Postgresql setup for flash memories. Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Enrique Arizón @ 2006-08-27 21:07 UTC (permalink / raw)
  To: pgsql-admin

Hello,

 since flash memory hardware is dropping prices at
high rate I was planning to test how Postgresql runs
in such hardware.

 For all I have read, main difference between Hard
disc storage and flash memory is that of seek time,
beeing flash memory card seek time much faster since
it lacks mechanical parts. My intution says that such
fact must have depth inpact on how databases "tunning
parameters" are setup.

 Anyone has any experience in "tunning" Postgresql for
Flash memories.


 Thanks in advance for any help, hint or link.

 Enrique



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Advice request: Postgresql setup for flash memories.
  2006-08-27 21:07 Advice request: Postgresql setup for flash memories. Enrique Arizón <e_arizon_benito@yahoo.com>
@ 2006-08-27 21:45 ` Tom Lane <tgl@sss.pgh.pa.us>
  2006-08-28 15:59   ` Re: Advice request: Postgresql setup for flash memories. Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2006-08-27 21:45 UTC (permalink / raw)
  To: Enrique Arizón <e_arizon_benito@yahoo.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Advice request: Postgresql setup for flash memories.
  2006-08-27 21:07 Advice request: Postgresql setup for flash memories. Enrique Arizón <e_arizon_benito@yahoo.com>
  2006-08-27 21:45 ` Re: Advice request: Postgresql setup for flash memories. Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-08-28 15:59   ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2006-08-28 15:59 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Enrique Arizón <e_arizon_benito@yahoo.com>; pgsql-admin

On Sun, 2006-08-27 at 16:45, Tom Lane wrote:
> =?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.

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-08-28 15:59 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-27 21:07 Advice request: Postgresql setup for flash memories. Enrique Arizón <e_arizon_benito@yahoo.com>
2006-08-27 21:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-08-28 15:59   ` Scott Marlowe <smarlowe@g2switchworks.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox