Re: custom function for converting human readable sizes to bytes

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jim Nasby <Jim.Nasby@bluetreble.com>, Corey Huinker <corey.huinker@gmail.com>, Guillaume Lelarge <guillaume@lelarge.info>, PostgreSQL Developers <pgsql-hackers@postgresql.org>

Date: 2015-11-30T17:30:18Z

Lists: pgsql-hackers

Attachments

pg-size-bytes-01.patch (text/x-patch) patch

Hi


> 2. using independent implementation - there is some redundant code, but we
> can support duble insted int, and we can support some additional units.
>

 new patch is based on own implementation - use numeric/bigint calculations

+ regress tests and doc

Regards

Pavel

Commits

Add pg_size_bytes() to parse human-readable size strings.
- 53874c5228fe 9.6.0 landed
Refactor check_functional_grouping() to use get_primary_key_attnos().
- f144f73242ac 9.6.0 cited
Correct comment in GetConflictingVirtualXIDs()
- 1129c2b0ad27 9.6.0 cited
Make extract() do something more reasonable with infinite datetimes.
- 647d87c56ab6 9.6.0 cited
pg_size_pretty: Format negative values similar to positive ones.
- 8a1fab36aba7 9.6.0 cited
pg_size_pretty(numeric)
- 4a2d7ad76f5f 9.2.0 cited