Re: gsoc, text search selectivity and dllist enhancments

Поиск
Список
Период
Сортировка
Искать
От
Heikki Linnakangas
Тема
Re: gsoc, text search selectivity and dllist enhancments
Дата
Msg-id
486DD210.9030400@enterprisedb.com
Ответ на
Список
Дерево обсуждения
gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Josh Berkus <josh@agliodbs.com>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Alvaro Herrera <alvherre@commandprompt.com>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Oleg Bartunov <oleg@sai.msu.su>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Jan Urbański <j.urbanski@students.mimuw.edu.pl>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Alvaro Herrera <alvherre@commandprompt.com>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Alvaro Herrera <alvherre@commandprompt.com>
Re: gsoc, text search selectivity and dllist enhancments Tom Lane <tgl@sss.pgh.pa.us>
Re: gsoc, text search selectivity and dllist enhancments Oleg Bartunov <oleg@sai.msu.su>
Re: gsoc, text search selectivity and dllist enhancments Rudolf Lippan <rlippan@remotelinux.com>
Re: gsoc, text search selectivity and dllist enhancments Oleg Bartunov <oleg@sai.msu.su>
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.

repalloc()ing shouldn't be a problem, though.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления
От: Tom Raney
Дата:
От: Gregory Stark
Дата:
Сообщение: Re: the un-vacuumable table
FAQ