| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | marcin mank <marcin(dot)mank(at)gmail(dot)com> |
| Cc: | Bill Moran <wmoran(at)potentialtech(dot)com>, Eric Schwarzenbach <subscriber(at)blackbrook(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Object-Oriented Database? |
| Date: | 2009-04-27 18:43:29 |
| Message-ID: | 1240857809.14767.13.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2009-04-27 at 20:37 +0200, marcin mank wrote:
> Is there any sane reason to use an array column, besides performance
> (the values can be read in less disk seeks than in a
> table-with-a-foreign-key scenario)?
Yes.
I don't actually talk about array columns in the above but it does
discuss all the ways (except) for an array to deal with that problem. As
I recall the major downside to an array is that you can add or delete an
element, you must update the whole array. Plus you need to use specific
array functions to work with the array versus just a nice join.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Tilton | 2009-04-27 19:03:00 | Noob Q: Is the PG database its own source code backup? |
| Previous Message | Sriganesh Ananth | 2009-04-27 18:40:39 | Postgres 7.3 to 8.1.1 migration: Getting 'No results were returned..' for function calls |