NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit77ce50a

committed

Fix psql lexer to avoid use of backtracking.

Per previous experimentation, backtracking slows down lexing performancesignificantly (by about a third). It's usually pretty easy to avoid, justneed to have rules that accept an incomplete construct and do whatever thelexer would have done otherwise.The backtracking was introduced by the patch that added quoted variablesubstitution. Back-patch to 9.0 where that was added.

1 parent2e95f1f commit77ce50aCopy full SHA for 77ce50a

File tree

1 file changed

+32

-1

lines changed

src/bin/psql
- psqlscan.l

1 file changed

+32

-1

lines changed

`‎src/bin/psql/psqlscan.l`

Lines changed: 32 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -723,6 +723,23 @@ other.`
`723`	`723`	`escape_variable(true);`
`724`	`724`	`}`
`725`	`725`
	`726`	`+/*`
	`727`	`+ * These rules just avoid the need for scanner backup if one of the`
	`728`	`+ * two rules above fails to match completely.`
	`729`	`+ */`
	`730`	`+`
	`731`	`+:'[A-Za-z0-9_]*{`
	`732`	`+/* Throw back everything but the colon */`
	`733`	`+yyless(1);`
	`734`	`+ECHO;`
	`735`	`+}`
	`736`	`+`
	`737`	`+:\"[A-Za-z0-9_]*{`
	`738`	`+/* Throw back everything but the colon */`
	`739`	`+yyless(1);`
	`740`	`+ECHO;`
	`741`	`+}`
	`742`	`+`
`726`	`743`	`/*`
`727`	`744`	`* Back to backend-compatible rules.`
`728`	`745`	`*/`
`@@ -913,7 +930,7 @@ other.`
`913`	`930`	`}`
`914`	`931`	`}`
`915`	`932`
`916`		`-:[A-Za-z0-9_]*{`
	`933`	`+:[A-Za-z0-9_]+{`
`917`	`934`	`/* Possible psql variable substitution */`
`918`	`935`	`if (option_type == OT_VERBATIM)`
`919`	`936`	`ECHO;`
`@@ -960,6 +977,20 @@ other.`
`960`	`977`	`}`
`961`	`978`	`}`
`962`	`979`
	`980`	`+:'[A-Za-z0-9_]*{`
	`981`	`+/* Throw back everything but the colon */`
	`982`	`+yyless(1);`
	`983`	`+ECHO;`
	`984`	`+BEGIN(xslashdefaultarg);`
	`985`	`+}`
	`986`	`+`
	`987`	`+:\"[A-Za-z0-9_]*{`
	`988`	`+/* Throw back everything but the colon */`
	`989`	`+yyless(1);`
	`990`	`+ECHO;`
	`991`	`+BEGIN(xslashdefaultarg);`
	`992`	`+}`
	`993`	`+`
`963`	`994`	`"\|"{`
`964`	`995`	`ECHO;`
`965`	`996`	`if (option_type == OT_FILEPIPE)`

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!

Commit77ce50a

File tree

1 file changed

1 file changed

`‎src/bin/psql/psqlscan.l`

0 commit comments