From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | David Link <dlink(at)soundscan(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: DECODE |
Date: | 2001-11-05 16:42:32 |
Message-ID: | web-498956@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
David,
> > I regularly use queries and views that involve 6-9 tables,
> > three UNIONS, and two sub-selects in each UNION ... and still get a
> 2-3
> > second response time on the 500mhz Celeron production machine.
>
> Thanks. Good advice.
> Question: How big are those tables you're joining and uniting? (disk
> size, and number of rows).
I'm not sure about disk size. Some of the tables are reference lists,
with just a few dozen rows. 4 of the tables have at least 1000 rows
each. Nothing large, or I'd use a faster processor.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-05 17:50:16 | Re: problems installing |
Previous Message | Josh Berkus | 2001-11-05 16:38:59 | Re: Book reviews are up |