1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
PostgreSQL Multiple Precision Arithmetic
========================================
pgmp_ is a PostgreSQL_ extension to add the GMP_ data types and functions
directly into the database.
.. _pgmp: https://dvarrazzo.github.io/pgmp/
.. _PostgreSQL: https://www.postgresql.org
.. _GMP: https://www.gmplib.org
The extension adds the types `mpz` (arbitrary size integers) and `mpq`
(arbitrary precision rationals) to PostgreSQL and exposes to the database all
the functions available in the GMP library for these data types, allowing:
- higher performance arithmetic on integers respect to the `!numeric` data
type
- a rational data type for absolute precision storage and arithmetic
- using specialized functions to deal with prime numbers, random numbers,
factorization directly into the database.
Here you can find a more detailed `list of goals <goals.html>`__ for this
extension.
See the `performance <performance.html>`__ page for comparison tests between
GMP data types and PostgreSQL builtins.
`[Ab]using PostgreSQL to calculate pi <pi.html>`__, a pgmp demo showing how to
generate millions of digits of :math:`\pi` using PL/pgSQL and Python to run
concurrent backends.
The library is released under
`LGPL License <https://www.opensource.org/licenses/lgpl-3.0>`__.
References
----------
- Homepage: https://dvarrazzo.github.io/pgmp/
- Project page: https://github.com/dvarrazzo/pgmp/
- Download: https://pgxn.org/dist/pgmp/
Documentation
-------------
.. toctree::
:maxdepth: 2
install
mpz
mpq
misc
news
Indices and tables
------------------
* :ref:`genindex`
* :ref:`search`
..
* :ref:`modindex`
..
To Do List
----------
.. todolist::
|
