During recent tuning of the TPC-C workload, I produced the following
patch to force COPY to leave some space in each data block when it loads
data into heap relations.
Rationale for this was to improve performance of random UPDATE
statements against a table too large to fit in memory. That activit
Am Dienstag, 12. April 2005 01:24 schrieb Simon Riggs:
> Attached patch adds UTF-8 as a synonym for UTF8, so initdb works again
> without needing to specify an encoding, just like it used to.
Well, to redeem myself, the whole thing got screwed up by some mindless
editing during the great encoding
Simon Riggs <[EMAIL PROTECTED]> writes:
> During recent tuning of the TPC-C workload, I produced the following
> patch to force COPY to leave some space in each data block when it loads
> data into heap relations.
This is an amazingly ugly way to do it. Put the info into the Relation
structure in
Simon Riggs wrote:
During recent tuning of the TPC-C workload, I produced the following
patch to force COPY to leave some space in each data block when it loads
data into heap relations.
I can't get too excited about incorporating changes designed solely to
improve performance for the workload of
In SQL that uses 'like' operator, wchareq is used to compare character.
At the head of wchareq, length of character is compared by
using pg_mblen. Therefore, pg_mblen is executed many times, and it
becomes a bottleneck.
This patch makes a short cut, and reduces execution fr
I forgot to attach a patch. I do post once again.
In SQL that uses 'like' operator, wchareq is used to compare characters.
At the head of wchareq, length of (multibyte) character is compared by
using pg_mblen. Therefore, pg_mblen is executed many times, and it
becomes a bottlen
Am Dienstag, 12. April 2005 01:24 schrieb Simon Riggs:
> I have access to a system with locale of UTF-8. cvstip would no longer
> initdb on this system, as a result of recent renaming of UTF-8 to UTF8.
Fixed.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
-
On Wed, 2005-04-13 at 00:00 +1000, Neil Conway wrote:
> Simon Riggs wrote:
> > During recent tuning of the TPC-C workload, I produced the following
> > patch to force COPY to leave some space in each data block when it loads
> > data into heap relations.
>
> I can't get too excited about incorpora
On Tue, 2005-04-12 at 09:56 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > During recent tuning of the TPC-C workload, I produced the following
> > patch to force COPY to leave some space in each data block when it loads
> > data into heap relations.
>
> Put the info into th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I'm still not happy about this. "Joining column is not null" has
> nothing to do with it --- what is at issue is whether there is certain
> to be a match. Since we do not have foreign-key enforcement on the
> system catalog interrelationships, it
10 matches
Mail list logo