Diehl,
> Um no, I just need a smaller problem to solve. The database worked
> quite
> well when the problem was half this size.
<snip>
> could do with 60 day's...!" And they are right, if it can be done...
> If it
> can't, I'll tell them and they will understand.
What I'm saying is, based on your description, you need a lot of hand-on
performance tuning help. Someone who knows the pgsql performance
parameters and can experiment with tweaking and tuning to avoid swamping
the memory of the machine(s) you're running on. Because that's what it
sounds like the problem is.
However, that sort of help will take some paid consultant time and
possibly hardware. I think that if you can run a query on 150gb of
data, you can probably run it on 355gb ... you just need some help
performance tuning. But I don't think general advice on a list is gonna
do it, y'know?
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco