Re: BUG #17302: gist index prevents insertion of some data

2021-12-01 Thread Komяpa
On Thu, Dec 2, 2021 at 1:14 AM Tom Lane wrote: > Alexander Korotkov writes: > > I think losing precision in the gist penalty is generally OK. Thus, > > it shouldn't be a problem to round a very small value as zero. > > Check. > > > Probably, we could even tolerate overflow in the gist penalty.

Re: BUG #17302: gist index prevents insertion of some data

2021-12-01 Thread Tom Lane
Alexander Korotkov writes: > I think losing precision in the gist penalty is generally OK. Thus, > it shouldn't be a problem to round a very small value as zero. Check. > Probably, we could even tolerate overflow in the gist penalty. As long as overflow -> infinity, yeah I think so. Seems lik

Re: BUG #17302: gist index prevents insertion of some data

2021-12-01 Thread Alexander Korotkov
On Sun, Nov 28, 2021 at 9:07 PM PG Bug reporting form wrote: > The last statement in the following sequence of queries: > CREATE TABLE point_tbl (f1 point); > CREATE INDEX gpointind ON point_tbl USING gist (f1); > INSERT INTO point_tbl SELECT '(0,0)'::point FROM generate_series(1, 1000) > g; > INS