NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit1748555

committed

doc: Fix some whitespace issues

1 parentf755a15 commit1748555Copy full SHA for 1748555

File tree

2 files changed

+35

-39

lines changed

doc/src/sgml
- jit.sgml
- textsearch.sgml

2 files changed

+35

-39

lines changed

`‎doc/src/sgml/jit.sgml‎`

Lines changed: 6 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -149,7 +149,7 @@`
`149`	`149`	`<xref linkend="sql-explain"/> can be used to see whether`
`150`	`150`	`<acronym>JIT</acronym> is used or not. As an example, here is a query that`
`151`	`151`	`is not using <acronym>JIT</acronym>:`
`152`		`- <programlisting>`
	`152`	`+<screen>`
`153`	`153`	`=# EXPLAIN ANALYZE SELECT SUM(relpages) FROM pg_class;`
`154`	`154`	`┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────┐`
`155`	`155`	`│ QUERY PLAN │`
`@@ -160,12 +160,12 @@`
`160`	`160`	`│ Execution Time: 0.365 ms │`
`161`	`161`	`└─────────────────────────────────────────────────────────────────────────────────────────────────────────────┘`
`162`	`162`	`(4 rows)`
`163`		`- </programlisting>`
	`163`	`+</screen>`
`164`	`164`	`Given the cost of the plan, it is entirely reasonable that no`
`165`	`165`	`<acronym>JIT</acronym> was used, the cost of <acronym>JIT</acronym> would`
`166`	`166`	`have been bigger than the savings. Adjusting the cost limits will lead to`
`167`	`167`	`<acronym>JIT</acronym> use:`
`168`		`- <programlisting>`
	`168`	`+<screen>`
`169`	`169`	`=# SET jit_above_cost = 10;`
`170`	`170`	`SET`
`171`	`171`	`=# EXPLAIN ANALYZE SELECT SUM(relpages) FROM pg_class;`
`@@ -185,7 +185,7 @@ SET`
`185`	`185`	`│ Emission Time: 5.048 ms │`
`186`	`186`	`│ Execution Time: 7.416 ms │`
`187`	`187`	`└─────────────────────────────────────────────────────────────────────────────────────────────────────────────┘`
`188`		`- </programlisting>`
	`188`	`+</screen>`
`189`	`189`	`As visible here, <acronym>JIT</acronym> was used, but inlining and`
`190`	`190`	`expensive optimization were not. If <xref`
`191`	`191`	`linkend="guc-jit-optimize-above-cost"/>, <xref`
`@@ -283,15 +283,15 @@ SET`
`283`	`283`	`<function>_PG_jit_provider_init</function>. This function is passed a`
`284`	`284`	`struct that needs to be filled with the callback function pointers for`
`285`	`285`	`individual actions.`
`286`		`-<programlisting>`
	`286`	`+<programlisting>`
`287`	`287`	`struct JitProviderCallbacks`
`288`	`288`	`{`
`289`	`289`	`JitProviderResetAfterErrorCB reset_after_error;`
`290`	`290`	`JitProviderReleaseContextCB release_context;`
`291`	`291`	`JitProviderCompileExprCB compile_expr;`
`292`	`292`	`};`
`293`	`293`	`extern void _PG_jit_provider_init(JitProviderCallbacks *cb);`
`294`		`-</programlisting>`
	`294`	`+</programlisting>`
`295`	`295`	`</para>`
`296`	`296`	`</sect3>`
`297`	`297`	`</sect2>`

`‎doc/src/sgml/textsearch.sgml‎`

Lines changed: 29 additions & 33 deletions

Original file line number	Diff line number	Diff line change
`@@ -1010,41 +1010,37 @@ websearch_to_tsquery(<optional> <replaceable class="parameter">config</replaceab`
`1010`	`1010`	`</para>`
`1011`	`1011`	`<para>`
`1012`	`1012`	`Examples:`
`1013`		`- <screen>`
`1014`		`- select websearch_to_tsquery('english', 'The fat rats');`
	`1013`	`+<screen>`
	`1014`	`+SELECT websearch_to_tsquery('english', 'The fat rats');`
	`1015`	`+ websearch_to_tsquery`
	`1016`	`+----------------------`
	`1017`	`+ 'fat' & 'rat'`
	`1018`	`+(1 row)`
	`1019`	`+`
	`1020`	`+SELECT websearch_to_tsquery('english', '"supernovae stars" -crab');`
`1015`	`1021`	`websearch_to_tsquery`
`1016`		`- -----------------`
`1017`		`- 'fat' & 'rat'`
`1018`		`- (1 row)`
`1019`		`- </screen>`
`1020`		`- <screen>`
`1021`		`- select websearch_to_tsquery('english', '"supernovae stars" -crab');`
`1022`		`- websearch_to_tsquery`
`1023`		`- ----------------------------------`
`1024`		`- 'supernova' <-> 'star' & !'crab'`
`1025`		`- (1 row)`
`1026`		`- </screen>`
`1027`		`- <screen>`
`1028`		`- select websearch_to_tsquery('english', '"sad cat" or "fat rat"');`
`1029`		`- websearch_to_tsquery`
`1030`		`- -----------------------------------`
`1031`		`- 'sad' <-> 'cat' \| 'fat' <-> 'rat'`
`1032`		`- (1 row)`
`1033`		`- </screen>`
`1034`		`- <screen>`
`1035`		`- select websearch_to_tsquery('english', 'signal -"segmentation fault"');`
`1036`		`- websearch_to_tsquery`
`1037`		`- ---------------------------------------`
`1038`		`- 'signal' & !( 'segment' <-> 'fault' )`
`1039`		`- (1 row)`
`1040`		`- </screen>`
`1041`		`- <screen>`
`1042`		`- select websearch_to_tsquery('english', '""" )( dummy \\ query <->');`
	`1022`	`+----------------------------------`
	`1023`	`+ 'supernova' <-> 'star' & !'crab'`
	`1024`	`+(1 row)`
	`1025`	`+`
	`1026`	`+SELECT websearch_to_tsquery('english', '"sad cat" or "fat rat"');`
`1043`	`1027`	`websearch_to_tsquery`
`1044`		`- ----------------------`
`1045`		`- 'dummi' & 'queri'`
`1046`		`- (1 row)`
`1047`		`- </screen>`
	`1028`	`+-----------------------------------`
	`1029`	`+ 'sad' <-> 'cat' \| 'fat' <-> 'rat'`
	`1030`	`+(1 row)`
	`1031`	`+`
	`1032`	`+SELECT websearch_to_tsquery('english', 'signal -"segmentation fault"');`
	`1033`	`+ websearch_to_tsquery`
	`1034`	`+---------------------------------------`
	`1035`	`+ 'signal' & !( 'segment' <-> 'fault' )`
	`1036`	`+(1 row)`
	`1037`	`+`
	`1038`	`+SELECT websearch_to_tsquery('english', '""" )( dummy \\ query <->');`
	`1039`	`+ websearch_to_tsquery`
	`1040`	`+----------------------`
	`1041`	`+ 'dummi' & 'queri'`
	`1042`	`+(1 row)`
	`1043`	`+</screen>`
`1048`	`1044`	`</para>`
`1049`	`1045`	`</sect2>`
`1050`	`1046`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit1748555

File tree

2 files changed

2 files changed

`‎doc/src/sgml/jit.sgml‎`

`‎doc/src/sgml/textsearch.sgml‎`

0 commit comments