| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | pgsql-patches <pgsql-patches(at)postgresql(dot)org>, "Ceschia, Marcello" <Marcello(dot)Ceschia(at)medizin(dot)uni-leipzig(dot)de>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data |
| Date: | 2008-04-03 14:14:38 |
| Message-ID: | 29119.1207232078@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> On second thought, expanding AttrNumber to int32, wholesale, might not
> be a good idea,
No, it wouldn't. For one thing it'd be a protocol break --- column
numbers are int16 --- and for another, we'd have terrible performance
problems with such wide rows. Actually rows are supposed to be limited
to ~1600 columns, anyway, because of HeapTupleHeader limitations.
Apparently you've found a path where that restriction isn't enforced
correctly, but I haven't seen the referenced message yet ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-03 14:26:53 | Re: BUG #4079: libpq.dll very slow (unusable) |
| Previous Message | Heikki Linnakangas | 2008-04-03 13:22:34 | Re: [BUGS] BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-03 14:18:56 | Re: actualized SQL/PSM patch |
| Previous Message | Brendan Jurd | 2008-04-03 14:11:51 | Re: psql command aliases support |