Skip site navigation (1) Skip section navigation (2)

Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Mark Wong <markw(at)osdl(dot)org>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>,OSDL - DB General <osdldbt-general(at)lists(dot)sourceforge(dot)net>
Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5
Date: 2003-11-02 12:25:38
Message-ID: 1067775937.571.8.camel@jester (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group