Re: explosion of tiny tables representing multiple

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