Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: gsoc, text ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 28 Topic 9625 of 10389
Post > Topic >>

Re: gsoc, text search selectivity and dllist enhancments

by tgl@[EMAIL PROTECTED] (Tom Lane) Jul 4, 2008 at 11:53 AM

"Heikki Lin****angas" <heikki@[EMAIL PROTECTED]
> writes:
> Tom Lane wrote:
>> The data structure I'd suggest is a simple array of pointers
>> to the underlying hash table entries.  Since you have a predetermined
>> maximum number of lexemes to track, you can just palloc the array once
>> --- you don't need the expansibility properties of a list. 

> The number of lexemes isn't predetermined. It's 2 * (longest tsvector 
> seen so far), and we don't know beforehand how long the longest tsvector
is.

Hmm, I had just assumed without looking too closely that it was stats
target times a fudge factor.  What is the rationale for doing it as
above?  I don't think I like the idea of the limit varying over the
course of the scan --- that means that lexemes in different places
in the input will have significantly different probabilities of
surviving to the final result.

			regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 28 Posts in Topic:
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-03 15:25:44 
Re: gsoc, text search selectivity and dllist enhancments
heikki@[EMAIL PROTECTED]   2008-07-04 10:32:32 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-04 11:53:56 
Re: gsoc, text search selectivity and dllist enhancments
heikki@[EMAIL PROTECTED]   2008-07-04 22:20:08 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-06 11:43:20 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-07 11:58:45 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-07 23:53:48 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-09 00:33:48 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-08 18:43:19 
Re: gsoc, text search selectivity and dllist enhancments
alvherre@[EMAIL PROTECTED  2008-07-10 16:27:31 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-10 22:32:26 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-10 17:02:36 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-10 23:26:35 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-10 18:19:36 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-11 08:18:25 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-10 16:37:28 
Re: gsoc, text search selectivity and dllist enhancments
oleg@[EMAIL PROTECTED] (  2008-07-14 11:47:17 
Re: gsoc, text search selectivity and dllist enhancments
rlippan@[EMAIL PROTECTED]  2008-07-14 07:51:36 
Re: gsoc, text search selectivity and dllist enhancments
oleg@[EMAIL PROTECTED] (  2008-07-14 16:38:30 
Re: gsoc, text search selectivity and dllist enhancments
oleg@[EMAIL PROTECTED] (  2008-07-11 03:12:48 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-11 08:23:05 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-11 02:30:26 
Re: gsoc, text search selectivity and dllist enhancments
j.urbanski@[EMAIL PROTECT  2008-07-11 17:31:00 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-13 20:54:19 
Re: gsoc, text search selectivity and dllist enhancments
alvherre@[EMAIL PROTECTED  2008-07-13 23:52:43 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-14 00:02:39 
Re: gsoc, text search selectivity and dllist enhancments
alvherre@[EMAIL PROTECTED  2008-07-14 01:01:20 
Re: gsoc, text search selectivity and dllist enhancments
tgl@[EMAIL PROTECTED] (T  2008-07-14 01:06:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 19:18:39 CDT 2008.