| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Fixed width rows faster? |
| Date: | 2004-03-07 13:42:41 |
| Message-ID: | Pine.LNX.4.44.0403071439040.13979-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, 6 Mar 2004, Andrew Sullivan wrote:
> > places is to ensure that the column can be indexed. Postgres, it seems,
> > refuses to insert a string that is longer than some value into an
> > indexed column, and I'll rather have such errors flagged while inserting
>
> Care to provide some details of this? It sure sounds like a bug to
> me, if it's true. I've never run into anything like this, though.
There is a limit of the size of values that can be indexed. I think it's
8k or something (a block I assume). Something for someone with an itch to
fix in the future.
The error however comes when you try to insert the value. Doing a reindex
will not change the length of the value and will always work.
--
/Dennis Björklund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2004-03-07 14:49:07 | Re: Fixed width rows faster? |
| Previous Message | David Teran | 2004-03-07 11:42:22 | speeding up a select with C function? |