Commitd54b299

Nikita Glukhov

committed

Add GUC jsonb_sort_field_values

1 parentcd87628 commitd54b299Copy full SHA for d54b299

File tree

+13

-3

lines changed

+13

-3

lines changed

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -31,8 +31,6 @@`
`31`	`31`	`#include"utils/memutils.h"`
`32`	`32`	`#include"utils/varlena.h"`
`33`	`33`
`34`		`-#defineJSONB_SORTED_VALUES 1`
`35`		`-`
`36`	`34`	`/*`
`37`	`35`	`* Maximum number of elements in an array (or key/value pairs in an object).`
`38`	`36`	`* This is limited by two things: the size of the JEntry array must fit`
`@@ -140,6 +138,7 @@ static JsonbValue fillCompressedJsonbValue(CompressedJsonb cjb,`
`140`	`138`	`uint32offset,JsonValue*result);`
`141`	`139`	`staticJsonbContainerjsonbzDecompress(JsonContainerjc);`
`142`	`140`
	`141`	`+booljsonb_sort_field_values= true;/* GUC */`
`143`	`142`
`144`	`143`	`JsonValue*`
`145`	`144`	`JsonValueUnpackBinary(constJsonValue*jbv)`
`@@ -1959,7 +1958,7 @@ convertJsonbObject(StringInfo buffer, JEntry pheader, const JsonbValue val, in`
`1959`	`1958`	`uint32header;`
`1960`	`1959`	`intnPairs=val->val.object.nPairs;`
`1961`	`1960`	`intreserved_size;`
`1962`		`-boolsorted_values=JSONB_SORTED_VALUES&&nPairs>1;`
	`1961`	`+boolsorted_values=jsonb_sort_field_values&&nPairs>1;`
`1963`	`1962`	`struct`
`1964`	`1963`	`{`
`1965`	`1964`	`intsize;`

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -90,6 +90,7 @@`
`90`	`90`	`#include"utils/bytea.h"`
`91`	`91`	`#include"utils/float.h"`
`92`	`92`	`#include"utils/guc_tables.h"`
	`93`	`+#include"utils/jsonb.h"`
`93`	`94`	`#include"utils/memutils.h"`
`94`	`95`	`#include"utils/pg_locale.h"`
`95`	`96`	`#include"utils/pg_lsn.h"`
`@@ -2036,6 +2037,15 @@ static struct config_bool ConfigureNamesBool[] =`
`2036`	`2037`	`NULL,NULL,NULL`
`2037`	`2038`	`},`
`2038`	`2039`
	`2040`	`+{`
	`2041`	`+{"jsonb_sort_field_values",PGC_USERSET,DEVELOPER_OPTIONS,`
	`2042`	`+gettext_noop("Use special binary jsonb format for objects when their field values sorted by length."),`
	`2043`	`+},`
	`2044`	`+&jsonb_sort_field_values,`
	`2045`	`+true,`
	`2046`	`+NULL,NULL,NULL`
	`2047`	`+},`
	`2048`	`+`
`2039`	`2049`	`/* End-of-list marker */`
`2040`	`2050`	`{`
`2041`	`2051`	`{NULL,0,0,NULL,NULL},NULL, false,NULL,NULL,NULL`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -413,5 +413,6 @@ extern void JsonbHashScalarValueExtended(const JsonbValue *scalarVal,`
`413`	`413`	`externintreserveFromBuffer(StringInfobuffer,intlen);`
`414`	`414`	`externvoidappendToBuffer(StringInfobuffer,constvoid*data,intlen);`
`415`	`415`
	`416`	`+externbooljsonb_sort_field_values;/* GUC */`
`416`	`417`
`417`	`418`	`#endif/* __JSONB_H__ */`

Comments

(0)