Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: numeric

How much slower are numerics?

The general knowledge is that numerics are slower than integers/float, but offer precision and ranges that are better.

While I understand what is slow, I don't really know how much slower numerics are. So let's test it.

Continue reading How much slower are numerics?

Posted on 2014-12-062014-12-07|Tags benchmark, float, index, integer, numeric, performace, postgresql|8 Comments on How much slower are numerics?

Waiting for 9.5 – Add generate_series(numeric, numeric).

On 11th of November, Fujii Masao committed patch:

Add generate_series(numeric, numeric).
 
Платон Малюгин
Reviewed by Michael Paquier, Ali Akbar and Marti Raudsepp

Continue reading Waiting for 9.5 – Add generate_series(numeric, numeric).

Posted on 2014-11-232019-05-15|Tags generate_series, numeric, pg95, postgresql, waiting|

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Are there limits to partition counts? 556 views | 2 comments
  • How to run some tasks without user intervention, at specific times? 517 views | 0 comments
  • Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time 176 views | 0 comments
  • Explaining the unexplainable – part 3 175 views | 0 comments
  • Explaining the unexplainable – part 2 155 views | 0 comments
  • Major-version upgrading with minimal downtime 153 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 145 views | 0 comments
  • Why is UPSERT so complicated? 102 views | 0 comments
  • How much RAM is PostgreSQL using? 80 views | 0 comments
  • Why I’m not fan of uuid datatype 80 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact