From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | mark(at)mark(dot)mielke(dot)cc |
Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Gregory Maxwell <gmaxwell(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Reducing the overhead of NUMERIC data |
Date: | 2005-11-04 18:54:04 |
Message-ID: | 16543.1131130444@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
mark(at)mark(dot)mielke(dot)cc writes:
> I read "the backend is by and large an ASCII, null-terminated-string
> engine" with "we use UTF-8 [for varlena strings?]" as, a lot of the
> code assumes varlena strings are '\0' terminated, and an assumption
> on my part, that the varlena strings are not stored in the backend
> with a '\0' terminator, therefore, they require being copied out,
> terminated with a '\0', before they can be used?
There are places where we have to do that, the worst from a performance
viewpoint being in string comparison --- we have to null-terminate both
values before we can pass them to strcoll().
One of the large bits that would have to be done before we could even
contemplate using UCS2/UCS4 is getting rid of our dependence on strcoll,
since its API is null-terminated-string.
> How much effort (past discussions that I've missed from a decade ago?
> hehe) has been put into determining whether a zero-copy architecture,
> or really, a minimum copy architecture, would address some of these
> bottlenecks? Am I dreaming? :-)
We've already done it in places, for instance the new implementation
of "virtual tuples" in TupleTableSlots eliminates a lot of copying
of pass-by-reference values.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Otto Hirr | 2005-11-04 19:06:15 | Re: [OT] somebody could explain this? |
Previous Message | Dann Corbit | 2005-11-04 18:41:28 | Re: [PERFORM] insert performance for win32 |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-11-04 19:11:27 | Re: Reducing the overhead of NUMERIC data |
Previous Message | Bruce Momjian | 2005-11-04 18:16:51 | Re: AIX FAQ addition |