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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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
