pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAdvice 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>
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:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Enrique Arizón <e_arizon_benito@yahoo.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-28 15:59 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
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