Re: [HACKERS] Accounting for toast in query planner. (gin/gist indexes).

2011-12-01 Thread jesper
Jesper Krogh jes...@krogh.cc writes: I have currently hit a problem which I dug into finding the cause for, in particular, searching in GIN indices seems in some situations to un-fairly favor Sequential Scans. Googling a bit I found this page:

Re: [HACKERS] Accounting for toast in query planner. (gin/gist indexes).

2011-12-01 Thread Tom Lane
jes...@krogh.cc writes: Secondly I could bump the default cost of ts_match_vq/ts_match_qv a bit up, since the cost of doing that computation is probably not as cheap as a ordinary boolean function. Actually, you could try bumping their costs up by more than a bit. It's a tad unfair to blame

[HACKERS] Accounting for toast in query planner. (gin/gist indexes).

2011-11-30 Thread Jesper Krogh
Hi list. I have currently hit a problem which I dug into finding the cause for, in particular, searching in GIN indices seems in some situations to un-fairly favor Sequential Scans. Googling a bit I found this page: http://postgis.refractions.net/docs/ch06.html#id2635817 Describing the excact

Re: [HACKERS] Accounting for toast in query planner. (gin/gist indexes).

2011-11-30 Thread Tom Lane
Jesper Krogh jes...@krogh.cc writes: I have currently hit a problem which I dug into finding the cause for, in particular, searching in GIN indices seems in some situations to un-fairly favor Sequential Scans. Googling a bit I found this page: