On Sat, 2003-11-01 at 20:58, Mark Wong wrote:
> I don't remember making a conscious decision between the number and integer
> database type.  Is that a significant oversight on my part?

Numerics do exact math with support for arbitrary numbers.  Unlike
Oracle, PostgreSQL does not retype NUMBER to a faster type internally
(like int).

You may find a good sized improvement (possibly as much as 15%) by
switching to integer as it will both reduce CPU load and storage
requirements.

In response to

• Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5 at 2003-11-02 01:58:07 from Mark Wong

Responses

• Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5 at 2003-11-17 23:04:47 from Mark Wong

pgsql-hackers by date

Next:	From: Markus Bertheau	Date: 2003-11-02 17:01:47
	Subject: TODO item psql schema completion already implemented
Previous:	From: Manfred Spraul	Date: 2003-11-02 11:06:03
	Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5