Unless it's a read-only database, I would never recommend using flash media for an RDBMS.
Unless it's a small database, I would never recommend using USB as a storage interface for an RDBMS. -- Brandon Aiken CS/IT Systems Engineer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AgentM Sent: Wednesday, August 30, 2006 10:42 AM To: PostgreSQL General ML Subject: Re: [GENERAL] PostgreSQL on system with root as only user On Aug 30, 2006, at 9:01 , Chris Mair wrote: > > If you know what you're doing and you want to disable that > feature you need to recompile from source and disable the > uid checks in src/backend/main/main.c. > > Unless you're working in the embedded space or some such thing, > I don't think it's a good idea, anyway. Has anyone actually used PostgreSQL on an embedded system? I am genuinely curious. How about db performance from a flash drive? -M ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
