Re: Gist indexes on int arrays

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Gist indexes on int arrays
Дата
Msg-id 87llzukgql.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: Gist indexes on int arrays  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-sql
Oleg Bartunov <oleg@sai.msu.su> writes:

> On Tue, 4 Mar 2003, Greg Stark wrote:
> 
> > > > db=# CREATE INDEX cache_gist_idx on cache using gist ( foo_id , attribute_set gist__int_ops);
> >
> > There are 1,161,435 records, with 384 distinct values of foo_id. The number of
> > records per value of foo_id ranges from 1 to 11,474.
> 
> hmm, not so much. We might be interested to play with the data.
> How big would be compressed archive of your data, so we could download
> it and use as test data.

The -Fc archive is 20M. But I have to get permission from the client.

It's nearly 5h now. Surely something is wrong?

postgres 30176 92.2 21.4 77124 55092 ?       R    11:08 247:48 postgres: postgres slo [local] CREATE INDEX

This is 7.3 btw, would I have better success with CVS?

-- 
greg



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: Forcing query to use an index
Следующее
От: Tomasz Myrta
Дата:
Сообщение: Re: LIMIT and SUBQUERIES