Re: Performance problems with arithmetic operators

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: mark(at)commsecure(dot)com(dot)au
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance problems with arithmetic operators
Date: 2001-09-19 14:15:20
Message-ID: 3BA8A878.965A4839@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Has anyone else experienced serious performance problems when using arithmetic
> expressions in queries?
...
> a and b are numeric(10, 3)

numeric() is implemented with binary coded decimal representation, which
is substantially slower than direct processor supported math involving
just ints and floats. Try testing this with different types to see what
happens.

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2001-09-19 14:15:27 Re: Major change to CVS effective immediately ...
Previous Message Marc G. Fournier 2001-09-19 14:14:44 Re: Major change to CVS effective immediately ...