Commit529db99

committed

Avoid overflow in cost_sort when work_mem exceeds 1Gb.

1 parent6e3cc20 commit529db99Copy full SHA for 529db99

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -49,7 +49,7 @@`
`49`	`49`	`* Portions Copyright (c) 1994, Regents of the University of California`
`50`	`50`	`*`
`51`	`51`	`* IDENTIFICATION`
`52`		`- * $PostgreSQL: pgsql/src/backend/optimizer/path/costsize.c,v 1.134 2004/08/2905:06:43 momjian Exp $`
	`52`	`+ * $PostgreSQL: pgsql/src/backend/optimizer/path/costsize.c,v 1.135 2004/10/23 00:05:27 tgl Exp $`
`53`	`53`	`*`
`54`	`54`	`*-------------------------------------------------------------------------`
`55`	`55`	`*/`
`@@ -566,7 +566,7 @@ cost_sort(Path path, Query root,`
`566`	`566`	`if (nbytes>work_mem_bytes)`
`567`	`567`	`{`
`568`	`568`	`doublenpages=ceil(nbytes /BLCKSZ);`
`569`		`-doublenruns=nbytes /(work_mem_bytes*2);`
	`569`	`+doublenruns=(nbytes /work_mem_bytes)*0.5;`
`570`	`570`	`doublelog_runs=ceil(LOG6(nruns));`
`571`	`571`	`doublenpageaccesses;`
`572`	`572`

Comments

(0)