X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7180F9FC784 for ; Sun, 27 Aug 2006 18:08:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 76271-04 for ; Sun, 27 Aug 2006 21:07:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30402.mail.mud.yahoo.com (web30402.mail.mud.yahoo.com [68.142.200.105]) by postgresql.org (Postfix) with SMTP id B51DA9FC780 for ; Sun, 27 Aug 2006 18:07:52 -0300 (ADT) Received: (qmail 80781 invoked by uid 60001); 27 Aug 2006 21:07:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=5W7qFigAg7yFUM03U+sLfymD3xOVrAZdv98q/TC45xsUnplrZztosX9hoaGxfNLRK7sB8f5Cj6zgMEvlqOgFDdfSERvrWSAlTuomnv+H37Awl6uprmzzUNKEuU0TgRQ0E3hLIrxOIuH4pDaxHBK+59awCW1WINdAzuJphPChhYE= ; Message-ID: <20060827210751.80779.qmail@web30402.mail.mud.yahoo.com> Received: from [85.48.193.112] by web30402.mail.mud.yahoo.com via HTTP; Sun, 27 Aug 2006 23:07:51 CEST Date: Sun, 27 Aug 2006 23:07:51 +0200 (CEST) From: =?iso-8859-1?q?Enrique=20Ariz=F3n?= Subject: Advice request: Postgresql setup for flash memories. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200608/306 X-Sequence-Number: 22849 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