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 [EMAIL PROTECTED] > -----Original Message----- > From: Josh Berkus [mailto:[EMAIL PROTECTED]] > Sent: September 19, 2001 6:36 PM > To: Diehl, Jeffrey; 'Tom Lane'; [EMAIL PROTECTED] > Cc: Diehl, Jeffrey; [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
