On Jan 23, 2008 1:57 PM, Guy Rouillier <guyr-ml1@xxxxxxxxxxxxx> wrote: > Scott Marlowe wrote: > > I assume you're talking about solid state drives? They have their > > uses, but for most use cases, having plenty of RAM in your server will > > be a better way to spend your money. For certain high throughput, > > relatively small databases (i.e. transactional work) the SSD can be > > quite useful. > > Unless somebody has changes some physics recently, I'm not understanding > the recent discussions of SSD in the general press. Flash has a limited > number of writes before it becomes unreliable. On good quality consumer Actually, I was referring to all SSD systems, some of which are based on flash memory, some on DRAM, sometimes backed by hard drives. There's always a use case for a given piece of tech. ---------------------------(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