Re: how can i use SELECT to find a substring of a column's

Richard Huxton wrote:

>You'll really need to run some tests. If there are lots of updates your
>biggest problem will be disk I/O - plenty of fast SCSI disks and a raid
>controller with battery-backed write cache will help there. The performance
>list is the place to get more details.
>If you do lots of reading but few updates, then plenty of RAM is good.
>
>
What's this about battery backud up write caches? In the disk sub system
or in the main system memory architecture? Can it be added to the PC
platform? How does the OS know when it reboots to not wipe that cache
and how to assign it to the correct processes in Postgres?