Re: explosion of tiny tables representing multiple - Mailing list pgsql-general

From Benjamin Weaver
Subject Re: explosion of tiny tables representing multiple
Date
Msg-id 20061103202525.819C812002@webmail217.herald.ox.ac.uk
Whole thread Raw
In response to Re: explosion of tiny tables representing multiple fields--Is this necessary?  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: explosion of tiny tables representing multiple  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Dear Martijn,

Wow, didn't know about arrays.  Did lots of sql, but, as I think about it,
that was 7 years ago, and we didn't know about arrays then

Are their performance problems with arrays?  We will not likely be working
with more than 50,000 - 100,000 records.

Ben


In message <20061103172212.GC551@svana.org> Benjamin Weaver
<benjamin.weaver@classics.oxford.ac.uk>, pgsql-general@postgresql.org writes:
> On Thu, Nov 02, 2006 at 04:36:49PM +0000, Benjamin Weaver wrote:
> > Dear PostGreSQL experts,
> >
> >
> > I am working with text objects. A text object will have lots of fields
that
> > are potentially multiple. There may be more than one author, more than one
> > modern editor, more than one edition number, etc.
>
> Have you considered using arrays?
>
> Have a nice day,
> --
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to
litigate.

--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society,
Oxford
email:  benjamin.weaver@classics.ox.ac.uk
phone:  (0)1865 288260


pgsql-general by date:

Previous
From: "Anonymous"
Date:
Subject: Re: How to get joins to work
Next
From: stig erikson
Date:
Subject: opening a channel between two postgreSQL-servers?