Um no, I just need a smaller problem to solve. The database worked quite
well when the problem was half this size. Additionally, I'm processing
back-logged data right now. I've also recently redesigned the database
schema to take advantage of inheritance. This has enabled me to write
larger queries. ;^)
I've been given a very large problem to solve and my management understands
that it is hard. They also understand that this is a development process.
Thanks to the extreme reliability of Linux and PostgresQL, we have been able
to get very useful results so far. It is these initial results which have
driven my management to request that I take on a larger chunk of the
problem. That is what has caused the situation I am in now. Imagine this:
"Well, if 30 day's worth of data was that useful, just think of what we
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.
Thanx for your input,
Mike Diehl,
Network Monitoring Tool Devl.
Sandia National Laboratories.
(505) 284-3137
jdiehl@sandia.gov
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: September 19, 2001 6:36 PM
> To: Diehl, Jeffrey; 'Tom Lane'; darcy@druid.net
> Cc: Diehl, Jeffrey; pgsql-sql@postgresql.org
> Subject: Re: [SQL] Out of free buffers... HELP!
>
>
> 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 information technology josh@agliodbs.com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>