Mike,
> I recently lost a hard drive and had to re-install, so the PG version
> I am
> using is only about 3 weeks old. However, as I said in my original
> post, I
> have A LOT of data in this database. Brick* implies 1334 tables,
> some of
> which have 2.5M records... All told, I have about 355G of data. I
> don't
> care if it takes DAYS to run queries like this, but I need them to
> finish.
Um, Mike, I think you need *professional* DB tuning/performance help.
Maybe a contract with PostgreSQL Inc. or Bruce Momjian or Red Hat? Or
me, if your budget is limited (but I'm not as good as Bruce or Chris)
-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