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

From Scott Cain
Subject Re: [SQL] EXTERNAL storage and substring on long strings
Date
Msg-id 1060095908.1431.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: [SQL] EXTERNAL storage and substring on long strings  (Scott Cain <cain@cshl.org>)
Responses Re: [SQL] EXTERNAL storage and substring on long strings  (Joe Conway <mail@joeconway.com>)
List pgsql-performance
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is
109M.

Scott

On Tue, 2003-08-05 at 11:01, Scott Cain wrote:
> Joe,
>
> Good idea, since I may not get around to profiling it this week.  I
> created a dump of the data set I was working with.  It is available at
> http://www.gmod.org/string_dump.bz2
>
> Thanks,
> Scott
>
>
> On Mon, 2003-08-04 at 16:29, Joe Conway wrote:
> > Is there a sample table schema and dataset available (external-storage
> > case) that we can play with?
> >
> > Joe
--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain@cshl.org
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory


pgsql-performance by date:

Previous
From: Scott Cain
Date:
Subject: Re: [SQL] EXTERNAL storage and substring on long strings
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Some vacuum & tuning help