pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Cain <cain@cshl.org>
To: Joe Conway <mail@joeconway.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] EXTERNAL storage and substring on long strings
Date: 05 Aug 2003 11:05:08 -0400
Message-ID: <1060095908.1431.3.camel@localhost.localdomain> (raw)
In-Reply-To: <1060095679.1430.1.camel@localhost.localdomain>
References: <1059679600.1429.41.camel@localhost.localdomain>
	<3F297CBA.1080703@joeconway.com>
	<1059686498.7505.558.camel@haggis>
	<1060010735.1433.26.camel@localhost.localdomain>
	<3574.1060012423@sss.pgh.pa.us>
	<1060014341.1434.53.camel@localhost.localdomain>
	<3F2EC244.9040107@joeconway.com>
	<1060095679.1430.1.camel@localhost.localdomain>

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




view thread (31+ messages)  latest in thread

Message-ID: <1060095908.1431.3.camel@localhost.localdomain>
Permalink:  ../1060095908.1431.3.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1060095908.1431.3.camel@localhost.localdomain

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: cain@cshl.org, mail@joeconway.com, tgl@sss.pgh.pa.us, pgsql-performance@postgresql.org
  Subject: Re: [SQL] EXTERNAL storage and substring on long strings
  In-Reply-To: <1060095908.1431.3.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox