Re: [SQL] 2 million+ entries

On Wed, 25 Aug 1999, G. Anthony Reina wrote:

> That's fantastic! How much did that set you back? Are there any special
> quirks about using Postgres on a multiple processor, multiple disk
> system?

Oops. To answer your second question. No. None whatsoever. The multi-disk
array is handled by the RAID controller. To the OS it appears to be a
gigantic disk. The RAID controller also has hardware cache so it can do
nifty things like queue a large number of simultaneous requests and
elevator sort them for seek efficiency. The machine also has a large
amount of RAM.

If you really need high performance, I've done nifty things like putting
indexes on different disks. Postgres does not seem to have a problem with
tables which have been physically moved and replace with symbolic links. I
don't know how well it would handle DROP queries, but I'm not in the habit
of dropping 10Gb tables very often.

-Michael