| From: | Scott Cain <cain(at)cshl(dot)org> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] EXTERNAL storage and substring on long strings |
| Date: | 2003-08-05 15:05:08 |
| Message-ID: | 1060095908.1431.3.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
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(at)cshl(dot)org
GMOD Coordinator (http://www.gmod.org/) 216-392-3087
Cold Spring Harbor Laboratory
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2003-08-05 15:06:22 | Re: Some vacuum & tuning help |
| Previous Message | Scott Cain | 2003-08-05 15:01:19 | Re: [SQL] EXTERNAL storage and substring on long strings |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-05 15:14:51 | Re: Timestamp in PG - 7.1 & 7.2 |
| Previous Message | Scott Cain | 2003-08-05 15:01:19 | Re: [SQL] EXTERNAL storage and substring on long strings |