"Scott Marlowe" wrote:
> You're absolutely right though, we really need to know the value of
> fast performance here.
the main problem is that my customers are used to have their reporting after
few seconds.
They want do have 10 times more data but still have the same speed, which
is, I think, quite impossible.
> If you're running aggregations of numbers used for filling out
> quarterly reports, not so much.
The application is used to analyse products sales behaviour, display charts,
perform comparisons, study progression...
10-40 seconds seems to be a quite good performance.
More than 1 minute will be too slow (meaning they won't pay for that).
I did some test with a 20 millions lines database on a single disk dual core
2GB win XP system (default postgresql config), most of the time is spent in
I/O: 50-100 secs for statements that scan 6 millions of lines, which will
happen. Almost no CPU activity.
So here is the next question: 4 disks RAID10 (did not find a french web host
yet) or 5 disk RAID5 (found at 600euros/month) ?
I don't want to have any RAID issue...
I did not have any problem with my basic RAID1 since many years, and don't
want that to change.