From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mike Sosteric <mikes(at)athabascau(dot)ca>, Bruno Wolff III <bruno(at)wolff(dot)to>, <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: [SQL] arrays |
Date: | 2002-10-01 07:49:41 |
Message-ID: | Pine.LNX.4.44.0210011037310.661-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
I was wondering why is such a rage against arrays.
I posted 2 very common problems where arrays provide
the only natural (and efficient) fit. (and got no responses)
So it seems to me that:
- Arrays implementation (along with the intarray package) in postgresql
is well performing and stable.
- Some problems shout out for array usage.
- The Array interface is defined in java.sql package.
(I dont know if sql arrays is in some standard but it seems that
Java sees it that way, at least).
- The Array interface is implemented in the official postgresql java
package.
- In some problems replacing arrays according the tradition relational
paradigm would end up in a such a performance degradation, that
some applications would be unusable.
- Oleg and Teodor did a great job in intarray, making array usage
easy and efficient.
Thanx!
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
From | Date | Subject | |
---|---|---|---|
Next Message | dima | 2002-10-01 07:53:30 | Unsubscribe |
Previous Message | Shridhar Daithankar | 2002-10-01 07:37:27 | Re: Vacuum question.. |
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2002-10-01 07:54:49 | Re: Postgresql likes Tuesday... |
Previous Message | Dave Page | 2002-10-01 07:08:58 | Re: [HACKERS] psqlODBC *nix Makefile (new 7.3 open item?) |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Contzen | 2002-10-01 12:18:50 | How slow is distinct - 2nd |
Previous Message | Tom Lane | 2002-09-30 21:26:01 | Re: [SQL] CURRENT_TIMESTAMP |