Skip site navigation (1) Skip section navigation (2)

Re: Patch: add conversion from pg_wchar to multibyte

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: aekorotkov(at)gmail(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Patch: add conversion from pg_wchar to multibyte
Date: 2012-04-29 12:12:49
Message-ID: 629266b115652881bb7696b80a13fac9.squirrel@webmail.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi Alexander,


Perhaps I'm too early with these tests, but FWIW I reran my earlier test program against three
instances.  (the patches compiled fine, and make check was without problem).

-- 3 instances:
HEAD                 port 6542
trgm_regex           port 6547  HEAD + trgm-regexp patch (22 Nov 2011) [1]
trgm_regex_wchar2mb  port 6549  HEAD + trgm-regexp + wchar2mb patch (23 Apr 2012) [2]

[1] http://archives.postgresql.org/pgsql-hackers/2011-11/msg01297.php
[2] http://archives.postgresql.org/pgsql-hackers/2012-04/msg01095.php

-- table sizes:
  azjunk4  10^4 rows     1 MB
  azjunk5  10^5 rows    11 MB
  azjunk6  10^6 rows   112 MB
  azjunk7  10^7 rows  1116 MB

for table creation/structure, see:
[3] http://archives.postgresql.org/pgsql-hackers/2012-01/msg01094.php

Results for three instances with 4 repetitions per instance are attached.

Although the regexes I chose are somewhat arbitrary, it does show some of the good, the bad and
the ugly of the patch(es).  (Also: I've limited the tests to a range of 'workable' regexps, i.e.
avoiding unbounded regexps)

hth (and thanks, great work!),


Erik Rijkers


Attachment: trgm_regex_test.out.20120429_1300.txt.gz
Description: application/x-gzip (6.5 KB)

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2012-04-29 12:20:15
Subject: Re: default_transaction_isolation = serializable causes crash under Hot Standby
Previous:From: Gokulakannan SomasundaramDate: 2012-04-29 11:50:49
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group