Re: EXTERNAL storage and substring on long strings - Mailing list pgsql-performance

From Joe Conway
Subject Re: EXTERNAL storage and substring on long strings
Date
Msg-id 3F2980DD.5010608@joeconway.com
Whole thread Raw
In response to EXTERNAL storage and substring on long strings  (Scott Cain <cain@cshl.org>)
Responses Re: EXTERNAL storage and substring on long strings
List pgsql-performance
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




pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXTERNAL storage and substring on long strings
Next
From: Tom Lane
Date:
Subject: Re: EXTERNAL storage and substring on long strings