No. Costs for touching the index were computed by the amcostestimate
function; this code is solely about estimating costs for touching the
heap.
I see. Thank you.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW
for existing range types: int4, int8, numeric,
date and timestamp with and without time zone.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
btree_gin_range-1.patch.gz
Description: GNU
:Execution time: 195.381 ms
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
tbm_cachepage-1.patch.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers
, but what
about with already existed operator classes?
The documentation describes btree-gin as providing GIN operator
classes that implement B-tree equivalent behavior, but now the
behavior diverges.
Anyway GIN couldn't be used for ORDER BY clause.
--
Teodor Sigaev
= off;
# explain analyze select * from t where i = 0;
without patch: Execution time: 2427.692 ms
with patch:Execution time: 2319.376 ms
# explain analyze select * from t where i = 100 and i= 100;
without patch: Execution time: 524.441 ms
with patch:Execution time: 504.478 ms
--
Teodor
not a geometer. They are.
Attached patch provides support of optional compress method for SP-GiST.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
spgist_compress_method-1.patch.gz
8 bytes
(actually, it will be a varlena header!)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
string collection
instead of JEntry array, JEntry array will be placed at the end of
object/array. so, pg_lzcompress will find repeatable 4-byte pieces in
first 1024 bytes of jsonb.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http
FirstNormalTransactionId)
xidWarnLimit -= FirstNormalTransactionId;
Why does it use '-' instead of '+' if variable FirstNormalTransactionId? In
this case it is easy to get xidStopLimit xidWrapLimit or xidWarnLimit
xidStopLimit...
Thank you.
--
Teodor Sigaev E-mail
, for example.
Attached patch uses that functions instead of sequentual loop over object/array.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
jsonb_access.patch.gz
Description: Unix tar
.
this patch doesn't break on-disk compatibility, although index recreation is
recommended.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
spgist_textproc.patch.gz
Description: Unix tar archive
If we bump the system catalog version, pg_upgrade can mark those indexes
as invalid and output a script to reindex them.
Between 9.3 - 9.4 catalog version is changed anyway.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http
.
I believe that StringInfo-data is palloc'ed, it means it's MAXALIGNed.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
()
appendStringInfoSpaces(jtext, VARHDRSZ);
}
char*
formStringInfoVarlena()
{
SET_VARSIZE(jtext-data, jtext-len);
return jtext-data;
}
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent
, that's easy way to prevent extra
copying.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
: [...
Looks like random parse rules.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
() is a escape_to_json().
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
inconsistent. It's been the subject of some discussion on -hackers previously,
IIRC. I actually referred to this difference in my talk at pgCon last Friday.
I see, and I wasn't on your talk :( I'm playing around jsquery and now trying to
implement UTF escapes there.
--
Teodor Sigaev
to
distinguish the case of zero-length string from that of a dummy label
for a pushed-down allTheSame tuple.
Actually, we do this: if allTheSame is true then nodes have a dummy labels.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
'{\\u}'::text[];
text
-
{\\u}
%) I'm crazy about that. Suppose, we shouldn't worry about array type,
just make output the same for json/jsonb
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent
.
Original data is too big to send in e-mail list or even send link, and the bug
caused not in root page as in example above.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
a string.
That's possible to introduce GUC variable for i/o functions which will control
old bug-to-bug behavior. IMHO, this is much better option that stopping hstore
development or split hstore to two branches.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
facilities for manipulating json available in
every programming language. The same is not true of hstore.
It's true for perl. Syntax of hstore is close to hash/array syntax and it's easy
serialize/deserialize hstore to/from perl. Syntax of hstore was inspired by perl.
--
Teodor Sigaev
,
internal, int2, internal, internal),
+ FUNCTION4 gin_consistent_hstore(internal, int2,
internal, int4, internal, internal),
+ STORAGE text;
--
Teodor Sigaev E-mail: teo...@sigaev.ru
of
numeric_cmp() instead of comparing text representation. This inconsistent will
be fixed.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers
Do we have function to trim right zeros in numeric?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
On Tue, Mar 4, 2014 at 2:44 AM, Teodor Sigaev teo...@sigaev.ru wrote:
Do we have function to trim right zeros in numeric?
Fixed, pushed to github
(https://github.com/feodor/postgres/tree/jsonb_and_hstore). Now it used
hash_numeric to index numeric value. As I can see, it provides needed
]'::hstore;
?column?
--
f
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
such dirty tricks.
Will be:
if ((*it)-type == JB_FLAG_ARRAY (*it)-state == jbi_start)
A bit slower and I don't feel that switch is more worse. But I don't insist.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW
.
:) commented
+Datum
+jsonb_typeof(PG_FUNCTION_ARGS)
+{
...
+}
Hm, shouldn't that be in jsonfuncs.c?
No idea, i don't have an objection
send/recv for hstore is fixed too. Should I make new version of patch? Right now
it's placed on github. May be Andrew wants to change something?
--
Teodor
t
WHERE (
CASE
WHEN a%2 IN (SELECT c FROM tt) THEN a
END IN (SELECT c FROM tt)
);
I suppose, the problem is connected to hashed subplan, but I'm not very familiar
with executor. And this affects all supported versions of pgsql.
--
Teodor Sigaev
*)(page) != ((void *)0 ||
(ExceptionalCondition(!(((const void*)(page) != ((void *)0))),
(FailedAssertion), gindatapage.c, 51), 0, (char *) ((char *) (page) +
((PageHeader) (page))-pd_special) ) )-flags (1 0) )), File:
gindatapage.c, Line: 51)
--
Teodor Sigaev
access and
throws an error if ConditionalLockBuffer() fails. But I missed that
checkpointer process could take a share lock on buffer to write it on disk.
Attached patch just intoduces retrying during index creation.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
to do this research).
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
spgist_deadlock-1.patch.gz
Description: Unix tar archive
--
Sent via pgsql-hackers mailing list (pgsql-hackers
size of index, b)
doesn't solve Greg's point.
We definetly need new idea of locking protocol and I'll return to this problem
at autumn (sorry, I havn't time in summer to do this research).
--
Teodor Sigaev E-mail: teo...@sigaev.ru
That would work fine as long as the invariant is maintained accurately.
However, there are at least two cases where the existing code fails to
maintain the invariant:
Hmm. Didn't catch that during development.
Thoughts?
Give me some time to play around it. Will think.
--
Teodor Sigaev
. Although, suppose, it could be a reason for other cryptic bugs.
I didn't test this solution on other OSes, but, suppose, it will work.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via
lane
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
);
}
and add it around system() call. Next:
% export EDITOR=echo
% psql postgres
0x0 - 0x409620
SET
Timing is on.
psql (9.2beta1)
Type help for help.
postgres=# \e
0x409620 - 0x409620
/tmp/psql.edit.7997.sql
0x0 - 0x409620
postgres=#
--
Teodor Sigaev E-mail: teo
(0x80106a000)
libncurses.so.8 = /lib/libncurses.so.8 (0x80128d000)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
with NOT NULL columns. If not, this code could be
removed/commented/ifdefed.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
,
numsortkeys * sizeof(AttrNumber)) != 0)
elog(ERROR, MergeAppend child's targetlist doesn't match
MergeAppend);
Although I think, that more accurate check will repeat work done in
prepare_sort_from_pathkeys().
--
Teodor Sigaev E-mail: teo...@sigaev.ru
be good), but barring objection I'll push forward with doing
it this way.
Thank you, your patch fixes original query too.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers
:)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
and trees allows to do that by
scanning a leafs pages.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
Can we figure out some information about index i.e. whet is the height
of index tree, how many values are placed in one leaf node and one non
leaf level node?
http://www.sigaev.ru/cvsweb/cvsweb.cgi/gevel/
--
Teodor Sigaev E-mail: teo...@sigaev.ru
search_graph order by path;' at file
src/test/regress/sql/with.sql. get_sort_group_operators() is called from
addTargetToSortList() and fails.
It seems to me that anonymous composite type could force us to teach
vacuum/analyze code to fallback to simpler analyze algorithm.
--
Teodor Sigaev
the work each time we
Agree
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
refactoring. std_typanalyze()
should be a bit clever to dig possibility of comparison or
compute_scalar_stats() should switch to compute_minimal_stats() if underlying
functions fail with such error.
Obviously, workaround is a adding dummy comparison function for points.
--
Teodor Sigaev
significant improvements.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
be able to change root then new path could be looked as
new_root-new_page-234 because old root could be splitted to old_root_page and
new_page.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
== InvalidBlockNumber)
/*
* end of chain and still didn't found parent, It's very-very
* rare situation when root splited
*/
break;
--
Teodor Sigaev E-mail: teo...@sigaev.ru
, and add a separate gbt_num_distance routine that only handles the
KNNDistance case.
Done
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
builtin_knngist_contrib_btree_gist-0.12.gz
Description
rather busy now and will be accessible only after
January, 10.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
builtin_knngist_contrib_btree_gist-0.9.gz
Description: Unix tar archive
the locks on them in the middle, and we're only talking about setting a
single flag, so it should make no difference.
Agree with that
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via
and tree become correct again,
although it needs to repair invalid pointers. The same situation with b-tree:
WAL replay repairs incomplete split before any other processing.
Or do I miss something important?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
).
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
don't think we're planning on any AMs
being both amoptionalkey and amcanorderbyop.
Agree.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql
it: you can not ORDER BY over non-orderable data type. That
check just make diagnostic earlier.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql
.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
of airplanes and
helicopters :)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
is built. So,
op_in_opfamily/get_op_opfamily_strategy/get_op_opfamily_properties and friends
will accept extra argument pointing to interested role.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
, but I don't think that's good
decision.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
on a the ORDER BY col OP constant case, which
Hmm, interesting idea. To be more general, amcanorder (without byop suffix)
could be eliminated too.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
of op_in_opfamily/get_op_opfamily_strategy but it will be
needed to check actual role of operator later.
Basing on this comparison, I think, that 2) is worse and 3) is better.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
- If one operation could be used for both usage type then it will be good to
distinguish them in consistent method. New version requires to use
different strategy number for each usage type.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
- even for for ordinary
search, GiST will choose child page with minimal distance.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers
, and slightly reworked to be more clear.
Attached patch is based on your patch.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
gincostestimate-0.24.gz
Description: Unix tar archive
--
Sent via
on 32bit from 27MB (3399 blocks) to 13MB (1564 blocks)
on 64bit from 55MB to cca 27MB.
Good results. But, I think, there are more places in ispell to use
hold_memory():
- affixes and affix tree
- regis (REGex for ISpell, regis.c)
--
Teodor Sigaev E-mail: teo
MemoryContextDelete of the whole
memory context would.
repalloc() will not work too. Such implementation should have possibility to
debug memory allocation/management by using some kind of red-zones or
CLOBBER_FREED_MEMORY/MEMORY_CONTEXT_CHECKING
--
Teodor Sigaev
function)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
information has
been changed from pg_class table to meta-page of index. Statistics data is
cached in Relation-rd_amcache to prevent frequent read of meta-page.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http
processing the request.
The connection to the server was lost. Attempting reset: Failed.
!?
Log:
TRAP: FailedAssertion(!(edata-elevel == 20), File: elog.c, Line: 1280)
8.4.4 haves essentially the same bug.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Anyone working on make contrib/pg_trgm mutibyte encoding aware? If
not, I'm interested in the work.
It's already multibyte safe since 8.4
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
effective_cache_size=1024MB
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
in in host name (similarly to '-' character).
I'm not sure about backpatching, because it could break existing search
configuration.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru
of index scan.
Am I miss something or misunderstand?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
I found something strange with merge join. Let there are two table
Sorry, postgresql's version is 8.4 from today CVS
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql
a starting point of investigation?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
However, that does make it even uglier to have category shoehorned in as
part of a different field. Back to wanting 5-key syscaches ...
Sigh.
I see your point. May be it's better to introduce new system table? pg_amorderop
to store ordering operations for index.
--
Teodor Sigaev
are converted into calling macroses.
For compatibility, we could rename SearchSysCache into SearchSysCacheSomething
and provide SearchSysCache function for old code.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http
... if nentry is greater than maxint/2, then i += 2
* step will overflow, no?
Agree, so
for (i = step - 1; i nentry i = 0; i += step 1 /* *2 */)
Also, rb_free is removed per Tom's comment. Can I commit the patch?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Hey, but rb_freefunc is still there ...
It will be reintroduced when ts_stat will be rewrited to use rbtree
One very minor quibble: please make the $PostgreSQL$ lines be just that
(i.e. remove everything between the : to the terminating $, keeping the
latter)
ok
--
Teodor Sigaev
(accum=0xbfbfd5e4, heapptr=0x28711af4,
attnum=1, entries=0x2ac77068, nentry=6) at ginbulk.c:202
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
rbtree-0.12.gz
Description: Unix tar archive
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
idin_rbtree_idx ON links2 USING gin (idin);
CREATE INDEX
Time: 1864013.526 ms
rbtest=# CREATE INDEX idout_rbtree_idx ON links2 USING gin (idout);
CREATE INDEX
Time: 1661200.454 ms
--
Teodor Sigaev E-mail: teo...@sigaev.ru
/rbtree_test) are made with v0.10
which is differ from 0.11 only by comments around ginInsertRecordBA()
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
rbtree-0.11.gz
Description: Unix tar archive
:1A,2B '::tsvector @@ to_tsquery('java:A | java:B');
vs.
'java:1A,2B '::tsvector @@ to_tsquery('java:AB')
?
they look equivalent. Are they?
Yes, but second one should be more efficient.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Can you rename RED and BLACK to RBRED and RBBLACK?
Yes, of course, done.
Any objections to commit?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
rbtree-0.9.gz
Description: Unix tar
on version 0.7 from Mark (thank you for review!)
I removed EAAollocate() function and improved comments in ginInsertEntry().
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
rbtree-0.8.gz
comments.
4. It would be nice if you could do a better job conforming to project
indentation style.
Did pgindent.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
rbtree-0.6.gz
Description
Would it be OK if I went through here and hacked on the comments and
sent this back to you?
Feel free to edit the patch.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql
source of random numbers you might base it on erand48 like geqo
has done.
Thank you to the point.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql
of index like all other
indexes.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
README.bloom:
contrib/bloom provides signature file based index.
Authors: Teodor Sigaev (teo...@sigaev.ru) and Oleg Bartunov (o...@sai.msu.su)
Notes: This is a *working* prototype, which can be finishing up to production
in case of interest. Particularly, it misses wal support, because
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
-0.6.gz - contrib/pg_trgm, like above,patch
provides - distance between strings
Patch set sill requires rbtree patch and point_ops patch (with Robert's changes)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
suggestions, so I am attaching an updated version of the patch as well
Agree with your changes. Suppose, there is no objection to commit it?
--
Teodor Sigaev E-mail: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via
really don't know which is better, but I'd like to hear
some other opinions...
knngist uses that implementation of rb-tree. One more candidate is a ts_stat
which now uses unbalanced binary tree.
--
Teodor Sigaev E-mail: teo...@sigaev.ru
201 - 300 of 812 matches
Mail list logo