Sorry, forget to attach file.
Oleg On Sat, 25 May 2002, Oleg Bartunov wrote: > Hi, > > we've got rather strange problem with updating and GiST indices. > Below is a test run: > > drop table tst; > create table tst ( a int[], i int ); > copy tst from stdin; > ........ > \. > create index tsti on tst using gist (a); > vacuum full analyze; > > > test=# update tst set i = i+10 where a && '{3,4}'; > UPDATE 3267 > test=# set enable_indexscan=off; > SET VARIABLE > test=# update tst set i = i+10 where a && '{3,4}'; > UPDATE 4060 > test=# select count(*) from tst where a && '{3,4}'; > count > ------- > 4060 > (1 row) > > test=# select version(); > version > --------------------------------------------------------------- > PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3 > (1 row) > > enabling gist indices cause some rows doesn't updating ! > Please find attached test sql script (need to install contrib/intarray module) > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
test.sql.gz
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])