Re: how can i use SELECT to find a substring of a column's - Mailing list pgsql-general

From Dennis Gearon
Subject Re: how can i use SELECT to find a substring of a column's
Date
Msg-id 3F63987C.20709@fireserve.net
Whole thread Raw
In response to Re: how can i use SELECT to find a substring of a column's data?  (Richard Huxton <dev@archonet.com>)
Responses Re: how can i use SELECT to find a substring of a
List pgsql-general
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?


pgsql-general by date:

Previous
From: elein
Date:
Subject: Re: I need examples of stored procedures returning datasets
Next
From: Scott Ribe
Date:
Subject: Re: how can i use SELECT to find a substring of a