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(dot)GC551(at)svana(dot)org> Benjamin Weaver
<benjamin(dot)weaver(at)classics(dot)oxford(dot)ac(dot)uk>, pgsql-general(at)postgresql(dot)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(at)svana(dot)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(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk
phone: (0)1865 288260