I haven't got any numbers (or a USB stick I can test with at the moment)
but USB is going to be a bottleneck for read and write performance.
Unless you're accessing very small amounts of data or running small
queries, I would expect performance to be pretty poor.
If your data set is so small, why do you need a full RDBMS instead of
flat data/text files or SQLite? If you're not concerned about disk
media failure, why do you need a transactional DB? It seems like
putting a deadbolt on a screen door.
It might work just great for your device, of course, but I would not
expect it to scale well at all.
--
Brandon Aiken
CS/IT Systems Engineer
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of AgentM
Sent: Wednesday, August 30, 2006 1:21 PM
To: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL on system with root as only user
On Aug 30, 2006, at 12:03 , Brandon Aiken wrote:
> Unless it's a read-only database, I would never recommend using flash
> media for an RDBMS.
Well, it's an embedded device, so you can pretty much be certain that
it's not storing sales information. If the flash goes belly up, then
the device has failed anyway, so the lost info is the least of the
problems.
>
> Unless it's a small database, I would never recommend using USB as a
> storage interface for an RDBMS.
Why? Could you provide more details?
I would be interested in any performance numbers anyone has collected.
-M
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster