On Thu, 13 Jun 2002, Tony Carter wrote:
> My test box is Linux 1ghz Celeron 25MB Ram, 7200rpm IDE drive. I know I
> need SCSI but is there any tuning I can do to speed this up?
Get at least another drive and put the logs there.
This will only help you with inserts.
To speedup selects you need faster drives, RAID or more memory.
Don't forget to do a vacuum analyze daily and also a vacuum full once in a
while (depending on how many records you delete).