Re: EXTERNAL storage and substring on long strings

Поиск
Список
Период
Сортировка
От Scott Cain
Тема Re: EXTERNAL storage and substring on long strings
Дата
Msg-id 1059685870.1429.73.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: EXTERNAL storage and substring on long strings  (Joe Conway <mail@joeconway.com>)
Список pgsql-performance
Joe,

I'm working on the comparison--I think the best way to do it is to
reload the original data into a new database and compare them, so it
will take a while.

I have tuned postgresql.conf according to the page that everybody around
here seems to cite. I'll probably post back tomorrow with another set of
results.

Also, the perl script that did several queries used lengths of 5000,
10,000 and 40,000 because those are the typical lengths I would use
(occasionally shorter).

Thanks,
Scott

On Thu, 2003-07-31 at 16:49, Joe Conway wrote:
> Scott Cain wrote:
> > So it is possible that if I had a fast scsi drive, the performance might
> > be better?
>
> Faster drives are always better ;-)
>
> Did you try the comparison with shorter substrings? Also, maybe not
> related to your specific question, but have you tuned any other
> postgresql.conf settings?
>
> Joe
>
>
--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain@cshl.org
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Odd performance results
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: EXTERNAL storage and substring on long strings