point as a vector, this is equivalent to scaling the object's size and distance from the origin by the length of the vector, and rotating it coun- terclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scaling the ob- ject's size and distance from the origin down by the length of the vector, and rotating it clock- wise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

point as a vector, this is equiva- lent to scaling the object's size and distance from the origin by the length of the vector, and rotating it counterclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scal- ing the object's size and distance from the origin down by the length of the vector, and rotating it clockwise around the origin by the vector's angle from 'foo' setweight ( vector tsvector, weight "char" ) → tsvector 303 Functions and Operators Function Description Example(s) Assigns the specified weight to each element of the vector. setweight('fat:2

point as a vector, this is equivalent to scaling the object's size and distance from the origin by the length of the vector, and rotating it coun- terclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scaling the ob- ject's size and distance from the origin down by the length of the vector, and rotating it clock- wise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

point as a vector, this is equivalent to scaling the object's size and distance from the origin by the length of the vector, and rotating it coun- terclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scaling the ob- ject's size and distance from the origin down by the length of the vector, and rotating it clock- wise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. 304 Functions and Operators Function Description

point as a vector, this is equivalent to scaling the object's size and distance from the origin by the length of the vector, and rotating it coun- terclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scaling the ob- ject's size and distance from the origin down by the length of the vector, and rotating it clock- wise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

point as a vector, this is equiva- lent to scaling the object's size and distance from the origin by the length of the vector, and rotating it counterclockwise around the origin by the vector's angle from If one interprets the second point as a vector, this is equivalent to scal- ing the object's size and distance from the origin down by the length of the vector, and 284 Functions and Operators Operator Operator Description Example(s) rotating it clockwise around the origin by the vector's angle from the x axis. Available for point, box,a path, circle. path '((0,0),(1,0),(1,1))' / point '(2.0,0)' → ((0,0)

point as a vector, this is equiva- lent to scaling the object's size and distance from the origin by the length of the vector, and rotating it counterclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scal- ing the object's size and distance from the origin down by the length of the vector, and rotating it clockwise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

point as a vector, this is equiva- lent to scaling the object's size and distance from the origin by the length of the vector, and rotating it counterclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scal- ing the object's size and distance from the origin down by the length of the vector, and rotating it clockwise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

point as a vector, this is equivalent to scaling the object's size and distance from the origin by the length of the vector, and rotating it coun- terclockwise around the origin by the vector's angle from point as a vector, this is equivalent to scaling the ob- ject's size and distance from the origin down by the length of the vector, and rotating it clock- wise around the origin by the vector's angle from querytree('foo & ! bar'::tsquery) → 'foo' setweight ( vector tsvector, weight "char" ) → tsvector Assigns the specified weight to each element of the vector. setweight('fat:2,4 cat:3 rat:5B'::tsvector, 'A')

• select * from tbl where x=? and y=1; -- use partial index. • select * from tbl where ts_vector && ts_query? order by ? offset ? limit ?; • use rum idx instead gin; 2016Postgres中国用户大会 防止雪崩 • truncate instead delete all data 2016Postgres中国用户大会 稳定性与性能建议 • ddl in xact; • ts_vector or array instead string(a,b,c,d,...) . xx like '%a%' • 递归查询一定要有跳出递归的条件 • 估值计算，HLL代替count(distinct