Re: [HACKERS] cost_index()

2014-10-27 Thread Teodor Sigaev
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

[HACKERS] btree_gin and ranges

2014-10-22 Thread Teodor Sigaev
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

[HACKERS] speedup tidbitmap patch: cache page

2014-10-22 Thread Teodor Sigaev
: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

Re: [HACKERS] btree_gin and ranges

2014-10-22 Thread Teodor Sigaev
, 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

[HACKERS] speedup tidbitmap patch: hash BlockNumber

2014-10-22 Thread 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

[HACKERS] compress method for spgist

2014-10-22 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-08 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-08 Thread Teodor Sigaev
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

[HACKERS] Wraparound limits

2014-08-07 Thread Teodor Sigaev
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

[HACKERS] jsonb access operators inefficiency

2014-05-30 Thread Teodor Sigaev
, 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

Re: [HACKERS] SP-GiST bug.

2014-05-30 Thread Teodor Sigaev
. 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

Re: [HACKERS] SP-GiST bug.

2014-05-30 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb access operators inefficiency

2014-05-30 Thread Teodor Sigaev
. 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

Re: [HACKERS] jsonb access operators inefficiency

2014-05-30 Thread Teodor Sigaev
() 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

Re: [HACKERS] jsonb access operators inefficiency

2014-05-30 Thread Teodor Sigaev
, 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

[HACKERS] json/jsonb inconsistence

2014-05-29 Thread Teodor Sigaev
: [... 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

[HACKERS] json/jsonb inconsistence - 2

2014-05-29 Thread Teodor Sigaev
() 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

Re: [HACKERS] json/jsonb inconsistence

2014-05-29 Thread Teodor Sigaev
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

Re: [HACKERS] SP-GiST bug.

2014-05-29 Thread 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

Re: [HACKERS] json/jsonb inconsistence - 2

2014-05-29 Thread Teodor Sigaev
'{\\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

[HACKERS] SP-GiST bug.

2014-05-20 Thread Teodor Sigaev
. 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

Re: [HACKERS] jsonb and nested hstore

2014-03-06 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-03-06 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-03-04 Thread 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

Re: [HACKERS] jsonb and nested hstore

2014-03-04 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-03-04 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-03-04 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-03-04 Thread Teodor Sigaev
]'::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

Re: [HACKERS] jsonb and nested hstore

2014-02-28 Thread Teodor Sigaev
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

Re: [HACKERS] jsonb and nested hstore

2014-02-05 Thread Teodor Sigaev
. :) 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

[HACKERS] coredump of 9.3.2

2013-12-10 Thread Teodor Sigaev
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

[HACKERS] GIN bugs in master branch

2013-11-12 Thread 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

[HACKERS] SP-GiST bug and fix

2013-10-31 Thread 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

Re: [HACKERS] SPGist triple parity concept doesn't work

2013-06-14 Thread Teodor Sigaev
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

Re: [HACKERS] SPGist triple parity concept doesn't work

2013-06-11 Thread Teodor Sigaev
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

Re: [HACKERS] SPGist triple parity concept doesn't work

2013-06-10 Thread Teodor Sigaev
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

Re: [HACKERS] psql bug

2012-05-18 Thread 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

Re: [HACKERS] psql bug

2012-05-17 Thread Teodor Sigaev
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

Re: [HACKERS] psql bug

2012-05-17 Thread Teodor Sigaev
); } 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

[HACKERS] psql bug

2012-05-16 Thread Teodor Sigaev
(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

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

2011-12-13 Thread Teodor Sigaev
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

[HACKERS] ERROR: MergeAppend child's targetlist doesn't match MergeAppend

2011-11-08 Thread Teodor Sigaev
, 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

Re: [HACKERS] ERROR: MergeAppend child's targetlist doesn't match MergeAppend

2011-11-08 Thread Teodor Sigaev
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

Re: [HACKERS] Understanding GIN posting trees

2011-07-15 Thread Teodor Sigaev
:) -- 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

Re: [HACKERS] Understanding GIN posting trees

2011-07-14 Thread Teodor Sigaev
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

Re: [HACKERS] Cube Index Size

2011-06-02 Thread Teodor Sigaev
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

Re: [HACKERS] vacuum and row type

2011-06-02 Thread Teodor Sigaev
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

Re: [HACKERS] vacuum and row type

2011-06-02 Thread 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

[HACKERS] vacuum and row type

2011-06-01 Thread Teodor Sigaev
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

Re: [HACKERS] Cube Index Size

2011-06-01 Thread 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

Re: [HACKERS] GSoC 2011: Fast GiST index build

2011-05-06 Thread Teodor Sigaev
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

Re: [HACKERS] GSoC 2011: Fast GiST index build

2011-05-05 Thread Teodor Sigaev
== 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

Re: [HACKERS] knngist - 0.8

2011-03-01 Thread Teodor Sigaev
, 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

Re: [HACKERS] knngist - 0.8

2010-12-28 Thread Teodor Sigaev
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

Re: [HACKERS] GiST insert algorithm rewrite

2010-11-17 Thread Teodor Sigaev
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

Re: [HACKERS] GiST insert algorithm rewrite

2010-11-17 Thread Teodor Sigaev
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

Re: [HACKERS] GiST insert algorithm rewrite

2010-11-16 Thread Teodor Sigaev
). -- 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

Re: [HACKERS] knngist questions

2010-11-12 Thread Teodor Sigaev
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

Re: [HACKERS] knngist - 0.8

2010-11-12 Thread Teodor Sigaev
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

Re: [HACKERS] gist DatumGetPointer returns pointer to corrupted data

2010-10-22 Thread Teodor Sigaev
. -- 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

Re: [HACKERS] knngist - 0.8

2010-10-22 Thread Teodor Sigaev
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

Re: [HACKERS] knngist - 0.8

2010-10-19 Thread Teodor Sigaev
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

Re: [HACKERS] knngist - 0.8

2010-10-19 Thread Teodor Sigaev
, 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

Re: [HACKERS] knngist - 0.8

2010-10-19 Thread Teodor Sigaev
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

Re: [HACKERS] knngist - 0.8

2010-10-15 Thread Teodor Sigaev
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

Re: [HACKERS] knngist - 0.8

2010-09-13 Thread Teodor Sigaev
- 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

Re: [HACKERS] proposal: tsearch dictionary initialization hook

2010-09-07 Thread Teodor Sigaev
. -- 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

Re: [HACKERS] knngist - 0.8

2010-09-07 Thread Teodor Sigaev
- 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

Re: [HACKERS] gincostestimate

2010-09-07 Thread Teodor Sigaev
, 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

Re: [HACKERS] patch: tsearch - some memory diet

2010-09-07 Thread Teodor Sigaev
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

Re: [HACKERS] patch: tsearch - some memory diet

2010-09-07 Thread Teodor Sigaev
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

[HACKERS] knngist - 0.8

2010-07-22 Thread 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

[HACKERS] gincostestimate

2010-07-02 Thread Teodor Sigaev
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

[HACKERS] PlPython bug in 9.0/8.4.4

2010-06-08 Thread Teodor Sigaev
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

Re: [HACKERS] pg_trgm

2010-05-27 Thread Teodor Sigaev
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

[HACKERS] Choosing between seqscan and bitmap scan

2010-04-29 Thread Teodor Sigaev
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

[HACKERS] Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2010-02-26 Thread Teodor Sigaev
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

[HACKERS] Merge join and index scan strangeness

2010-02-19 Thread Teodor Sigaev
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

Re: [HACKERS] Merge join and index scan strangeness

2010-02-19 Thread Teodor Sigaev
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

Fwd: Re: [HACKERS] Merge join and index scan strangeness

2010-02-19 Thread Teodor Sigaev
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

Re: [HACKERS] knngist patch support

2010-02-13 Thread Teodor Sigaev
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

Re: [HACKERS] knngist patch support

2010-02-13 Thread 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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-10 Thread Teodor Sigaev
... 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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-10 Thread Teodor Sigaev
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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-09 Thread 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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-08 Thread Teodor Sigaev
-- 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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-05 Thread Teodor Sigaev
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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-04 Thread Teodor Sigaev
/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

Re: [HACKERS] building tsquery directly in memory (avoid makepol)

2010-02-04 Thread Teodor Sigaev
: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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-03 Thread Teodor Sigaev
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

Re: [HACKERS] [CFReview] Red-Black Tree

2010-02-02 Thread Teodor Sigaev
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

Re: [HACKERS] Red-black tree for GIN

2010-01-24 Thread Teodor Sigaev
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

Re: [HACKERS] Red-black tree for GIN

2010-01-24 Thread Teodor Sigaev
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

Re: [HACKERS] Bloom index

2010-01-18 Thread Teodor Sigaev
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

Re: [HACKERS] Bloom index

2010-01-18 Thread Teodor Sigaev
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

[HACKERS] Bloom index

2010-01-13 Thread Teodor Sigaev
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

Re: [HACKERS] Bloom index

2010-01-13 Thread Teodor Sigaev
-- 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

Re: [HACKERS] KNNGiST for knn-search (WIP)

2010-01-12 Thread Teodor Sigaev
-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

Re: [HACKERS] point_ops for GiST

2010-01-11 Thread Teodor Sigaev
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

Re: [HACKERS] Red-black tree for GIN

2010-01-11 Thread Teodor Sigaev
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

<    1   2   3   4   5   6   7   8   9   >