| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Michael Robinson <robinson(at)netrinsics(dot)com>, pgsql-hackers(at)hub(dot)org |
| Subject: | Re: [HACKERS] regression bigtest needs very long time |
| Date: | 1999-06-30 15:22:58 |
| Message-ID: | 377A3652.CDD8CFE4@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > The question, though, becomes what percentage of operations on a
> > NUMERIC field are arithmetic, and what percentage are storage/retrieval.
> Good point.
We assume that most data stays inside the database on every query.
That is, one should optimize for comparison/calculation speed, not
formatting speed. If you are comparing a bunch of rows to return one,
you will be much happier if the comparison happens quickly, as opposed
to doing that slowly but formatting the single output value quickly.
An RDBMS can't really try to optimize for the opposite case, since
that isn't how it is usually used...
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Richards | 1999-06-30 17:27:46 | Patches to get number of tuples affected |
| Previous Message | Ross J. Reedstrom | 1999-06-30 15:17:32 | Re: [GENERAL] Postgres Upsizing Tool for MSAccess 97 |