Re: [HACKERS] tsearch2 patch for 7.4.1

2003-11-21 Thread Teodor Sigaev
---(end of broadcast)--- TIP 8: explain analyze is your friend -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[HACKERS] about explain analyze

2003-11-27 Thread Teodor Sigaev
- PostgreSQL 7.4 on i386-unknown-freebsd5.1, compiled by GCC gcc (GCC) 3.2.2 [FreeBSD] 20030205 (release) (1 row) -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet

Re: [HACKERS] about explain analyze

2003-11-28 Thread Teodor Sigaev
runtime: 0.047 ms (2 rows) Several thousands? Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: Explain analyze takes 3 times more time for execution. Why? Measurement overhead. It would seem your platform has a particularly slow version of gettimeofday() though ... I've never noticed

Re: [HACKERS] about explain analyze

2003-11-28 Thread Teodor Sigaev
... If you mean rows in Seq Scan than gettimeofday was called (52936+1)*2. Huge value :( Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: How many times is gettimeofday called? Twice per plan node visit, if you are doing EXPLAIN ANALYZE. (The number of visits is one more than the number

Re: [HACKERS] Searching for substring with tsearch(1/2)

2003-12-09 Thread Teodor Sigaev
is a bulk upload. 2 If word is frequent then query with 'IN (select * from func()) may works slow... -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] Searching for substring with tsearch(1/2)

2003-12-09 Thread Teodor Sigaev
dictionary, which can define language and normalize word... Look at default_russian configuration of tsearch2 and read more about tsearch2. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1

Re: [HACKERS] [ADMIN] Full textsearch gist (fwd)

2003-12-09 Thread Teodor Sigaev
stat('select TSVECTOR from TABLE') order by ndoc desc, nentry desc, word; Where TSVECTOR is name of column of tsvector type and TABLE is a table with that column. Warn: it works very slow. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end

Re: [HACKERS] Searching for substring with tsearch(1/2)

2003-12-10 Thread Teodor Sigaev
on textdate (or some other suitable datum) 2 If word is frequent then query with 'IN (select * from func()) may works slow... if it is often too slow then creating a temp table and doing a plain join may be faster. Table structure as indidx decrease this problem. -- Teodor Sigaev

Re: [HACKERS] Searching for substring with tsearch(1/2)

2003-12-10 Thread Teodor Sigaev
(super-imposed) signatures of childs. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere

[HACKERS] Concurrence GiST

2003-12-30 Thread Teodor Sigaev
it? -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Multicolumn Indexing using R-Tree

2004-02-03 Thread Teodor Sigaev
can I solve this problem ? Is it a limitation of PostgreSQL or the R-Tree concept ? Thank you in advance. Márcio Caetano. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Teodor Sigaev

Re: [HACKERS] Concurrence GiST

2004-02-16 Thread Teodor Sigaev
be quiet. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] operator for user-defined types

2004-03-25 Thread Teodor Sigaev
-than' one. Is it? -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] GIST code doesn't build on strict 64-bit machines

2004-03-29 Thread Teodor Sigaev
to support this. Its only union and picksplit user-defined methods in contrib modules. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [HACKERS] GIST code doesn't build on strict 64-bit machines

2004-03-29 Thread Teodor Sigaev
*entryvec, int *size) Datum picksplit(int32 n, GISTENTRY *entryvec, GIST_SPLITVEC *v) It seems to me that first case is clearer. Of course, I change all contrib modules to new interface. What do you think? -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: [HACKERS] GIST code doesn't build on strict 64-bit machines

2004-03-30 Thread Teodor Sigaev
Ok, I just commited changes, pls, check it on HPPA. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[HACKERS] Please, applay patch to current CVS

2002-10-02 Thread Teodor Sigaev
This is small README fix for contrib/intarray. Thank you. -- Teodor Sigaev [EMAIL PROTECTED] intarray_patch.gz Description: application/gzip ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Current CVS - something broken in contrib

2002-10-15 Thread Teodor Sigaev
95.07% 93.65% psql postmaster doesn't take a CPU time... -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] Current CVS is broken

2002-10-22 Thread Teodor Sigaev
:/usr/src/sys/compile/XOR i386 -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Current CVS has strange parser for float type

2002-10-19 Thread Teodor Sigaev
Peter Eisentraut wrote: Teodor Sigaev writes: wow=# select 5.3::float; ERROR: Bad float8 input format '5.3' Does it accept '5,4'::float? Yes, it accepted '5,4'::float format. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] integer array, push and pop

2002-10-22 Thread Teodor Sigaev
---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Teodor Sigaev [EMAIL PROTECTED

Re: [HACKERS] contrib/ltree patches

2002-11-27 Thread Teodor Sigaev
) It seems to me that it's mistake. ISALNUM shoud define correct character in name of node (level). Try to test with incorrect ltree value 'a..b'. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] contrib/ltree patches

2002-11-27 Thread Teodor Sigaev
prepare cumulative patch. Nevertheless, we have no chance to insert this to 7.3 release :(. Only for 7.3.1 or even 7.4. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] tsearch thoughts

2002-12-02 Thread Teodor Sigaev
REATE INDEX my_idx ON test USING gist(txt2txtidx(a)) may decreas performance :( 2 OpenFTS. We wanted that txtidx works with OpenFTS. And adding dictionaries, txt2txtidx, trigger, type mquery_txt etc was an experiment. -- Teodor Sigaev [EMAIL PROTECTED] ---(end

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Teodor Sigaev
in __libc_start_main () from /lib/i686/libc.so.6 Magnus ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Teodor Sigaev
Teodor Sigaev wrote: Does it crashed? # select txt2txtidx('Can - Live 1971-77'); Line txtidx.c:366 : lemm = lemmatize(token, lenlemm, type); lemmatize() is defined in morph.c. Did you use another modules for postgresql? It seems to me that we see a name conflict. Function lemmatize

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Teodor Sigaev
. Just only full reinstall (with initdb and rm -rf /usr/local/pgsql) postgresql... Can you give me login on you computer for a several hours? -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

[HACKERS] Please, apply patch of tsearch for current CVS 7.3.1

2002-12-04 Thread Teodor Sigaev
with it. So you tsearch guys will have to work it out :) -- Teodor Sigaev [EMAIL PROTECTED] tsearch_patch.gz Description: application/gzip ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] contrib/ltree patches

2002-12-05 Thread Teodor Sigaev
@@ { if (i != 0) { - *ptr = NODE_DELIMITER; + *ptr = '.'; ptr++; } if (curqlevel-numvar) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

[HACKERS] Please, apply patch for 7.3.1 and current CVS

2002-12-12 Thread Teodor Sigaev
This patch fixes minor bugs in dictionary generator in contrib/tsearch (contrib/tsearch/makedict/makedict.pl) Thank you. -- Teodor Sigaev [EMAIL PROTECTED] tsearch_patch.gz Description: application/gzip ---(end of broadcast)--- TIP 4: Don't

[HACKERS] Please apply patch

2003-02-07 Thread Teodor Sigaev
for 7.4 Thank you. -- Teodor Sigaev [EMAIL PROTECTED] ltree_73.patch.gz Description: application/gzip ltree_74.patch.gz Description: application/gzip ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Alpha version of contrib/tsearch is available for testing

2003-02-07 Thread Teodor Sigaev
/postgres/gist/tsearch/V2/tsearch.tar.gz It should works with 7.3 and current CVS. Any comments please send to Oleg Bartunov ([EMAIL PROTECTED]) and Teodor Sigaev ( [EMAIL PROTECTED] ). I'm going to vacation until March, so don't fill my mailbox :-) Regards, Oleg

[HACKERS] Q about InsertIndexResult

2003-02-12 Thread Teodor Sigaev
But in all this places returned value doesn't used, just pfree'ed (except ./access/heap/tuptoaster.c where it's checked with NULL). Q: why? why isn't it a bool value? Is there some idea which I havn't see? -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] Q about InsertIndexResult

2003-02-12 Thread Teodor Sigaev
that there was some other piece of information that the index AM should return, we'd have to change right back to returning a struct... Agreed. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once

[HACKERS] Alpha-2 of contrib/tsearch

2003-02-20 Thread Teodor Sigaev
to Oleg Bartunov ([EMAIL PROTECTED]) and Teodor Sigaev ( [EMAIL PROTECTED] ). -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] btree_gist, gint4_union

2003-03-03 Thread Teodor Sigaev
a bug? Must be 'internal'. It's not a bug :) because this function is GiST interface member and itsn't any nessesarity to call it by hand. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] GIST_LEAF vs. leaf_key; gist?entryinit

2003-03-03 Thread Teodor Sigaev
, dentry-key, r, page, offsetNumber, dentry-bytes, FALSE); Isn't the call missing the isNull parameter? -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [HACKERS] GiST: Bad newtup On Exit From gistSplit() ?

2003-03-03 Thread Teodor Sigaev
=0x82adf88) at postgres.c:897 #11 0x081619f0 in PostgresMain (argc=4, argv=0x82960c0, username=0x82966c0 postgres) at postgres.c:2013 #12 0x08110625 in main (argc=4, argv=0xbc14) at main.c:235 -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

[HACKERS] Current CVS compile problem

2003-03-17 Thread Teodor Sigaev
Hi! xor% uname -a FreeBSD xor 5.0-RELEASE FreeBSD 5.0-RELEASE #7: Thu Mar 6 21:53:07 MSK 2003 [EMAIL PROTECTED]:/usr/src/sys/i386/compile/XOR i386 xor% gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.2.1 [FreeBSD] 20021119 (release)

Re: [HACKERS] [SQL] A bug in gistPageAddItem()/gist_tuple_replacekey() ??? (fwd)

2002-04-18 Thread Teodor Sigaev
conveinced that it was indeed fixed... Anyone knows otherwise? Thanks a lot! Dima ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast

Re: [HACKERS] strange update problem with 7.2.1

2002-05-26 Thread Teodor Sigaev
, Tom. You give me a direction for looking. Attached patch fix the problem with broken state. Please apply it for 7.2.2 and current cvs (sorry, but I'll have a possibility to check it on current cvs only tomorrow). -- Teodor Sigaev [EMAIL PROTECTED] patch_gistupdate.gz Description: GNU Zip

Re: [HACKERS] strange update problem with 7.2.1

2002-05-27 Thread Teodor Sigaev
Tested it with current CVS. It works. Oleg Bartunov wrote: Just tested with 7.2.1. It works. We have one more patch (for rtree_gist) to submit before 7.2.2 release. Oleg On Sun, 26 May 2002, Teodor Sigaev wrote: Yeah, but the update case is inserting more entries into the index

Re: [HACKERS] strange update problem with 7.2.1

2002-05-27 Thread Teodor Sigaev
Oleg Bartunov wrote: Just tested with 7.2.1. It works. We have one more patch (for rtree_gist) to submit before 7.2.2 release. Attached patch fix a bug with creating index. Bug was reported by Chris Hodgson [EMAIL PROTECTED]. Please, apply it for 7.2.2 and current CVS. -- Teodor Sigaev

Re: [HACKERS] strange update problem with 7.2.1

2002-05-27 Thread Teodor Sigaev
Sorry, forgot a patch... Teodor Sigaev wrote: Oleg Bartunov wrote: Just tested with 7.2.1. It works. We have one more patch (for rtree_gist) to submit before 7.2.2 release. Attached patch fix a bug with creating index. Bug was reported by Chris Hodgson [EMAIL PROTECTED]. Please

Re: [HACKERS] strange update problem with 7.2.1

2002-05-28 Thread Teodor Sigaev
Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: Yeah, but the update case is inserting more entries into the index. I'm wondering if that causes the index scan's state to get corrupted so that it misses scanning some entries. Thank you, Tom. You give me a direction for looking

Re: [HACKERS] strange update problem with 7.2.1

2002-05-28 Thread Teodor Sigaev
Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: Hmm, is this patch really correct? Removing the gistadjscans() call from gistSplit seems wrong to me --- won't that miss reporting splits on leaf pages? Or does this not matter for some reason? gistadjscans() is moving

Re: [HACKERS] contrib/ltree for 7.2 or 7.3 ?

2002-07-30 Thread Teodor Sigaev
command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[HACKERS] Query parser?

2002-07-31 Thread Teodor Sigaev
Is it normal behaviour? Its seems to me that isn't.. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[HACKERS] Please, apply another patch to contrib/ltree

2002-08-09 Thread Teodor Sigaev
Fixed very stupid but important bug: mixing calls of some founctions from contrib/tsearch and contrib/ltree :) -- Teodor Sigaev [EMAIL PROTECTED] patch_ltree.gz Description: application/gzip ---(end of broadcast)--- TIP 6: Have you searched

[HACKERS] Please, apply patch for contrib/tsearch

2002-08-13 Thread Teodor Sigaev
CHANGES: August 13, 2002 Use parser of OpenFTS v0.33. -- Teodor Sigaev [EMAIL PROTECTED] tsearch_patch.gz Description: application/gzip ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Please, apply patch for contrib/tsearch

2002-08-13 Thread Teodor Sigaev
to current CVS, of course. Sorry -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] tsearch bug in 7.2.1?

2002-08-16 Thread Teodor Sigaev
subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] contrib/ intarray, ltree, intagg broken(?) by array

2002-09-09 Thread Teodor Sigaev
, it solves the problem. -- Teodor Sigaev [EMAIL PROTECTED] intarray_patch.gz Description: application/gzip ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] contrib/tsearch

2002-09-09 Thread Teodor Sigaev
TABLE_DICT_END dict/russian_stemming.dct: TABLE_DICT_START ru_RU.KOI8-R, NULL, NULL, ru_RUKOI8R_stem, ru_RUKOI8R_is_stopword, NULL TABLE_DICT_END So english stemmer defines is lexem stop or not after stemming, but russian before. -- Teodor

[HACKERS] Current CVS is broken

2002-09-20 Thread Teodor Sigaev
integer from pointer without a cast copy.c:1130: too many arguments to function `coerce_type_constraints' -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

Re: [HACKERS] First version of multi-key index support for GiST

2001-05-31 Thread Teodor Sigaev
://fts.postgresql.org/db/mw/msg.html?mid=118707). This is our oversight. -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] GiST index on data types that require compression

2001-05-25 Thread Teodor Sigaev
the opclass needed? So, may by add to pg_opclass two fields? bool is_varlena_key bool is_lossy_compress Then index_formtuple must look at is_varlena_key and 'with (islossy)' could be determined automatically by view at used ops. -- Teodor Sigaev [EMAIL PROTECTED

Re: [HACKERS] GiST index on data types that require compression

2001-05-25 Thread Teodor Sigaev
function which return size of key or index_formtuple must looks at GISTENTRY.bytes( Note: A lot of currrent implementation of GiST modules don't set value GISTENTRY.bytes ). Or fields in pg_opclass: int len_key bool is_lossy_compress if len_key==-1 then key is varlena type. -- Teodor Sigaev [EMAIL

[HACKERS] Current CVS is broken

2001-08-21 Thread Teodor Sigaev
2001 teodor@xor:/usr/src/sys/compile/XOR i386 -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Current CVS: compilation error

2001-10-01 Thread Teodor Sigaev
--- 23,29 #include errno.h #ifdef HAVE_SYS_SEM_H + #include sys/types.h #include sys/sem.h #endif -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [HACKERS] btree_gist regression test busted?

2001-10-03 Thread Teodor Sigaev
(1 row) --- 34,39 select count(*) from tstmp where t '2001-05-29 08:33:09+04'; count --- ! 66 (1 row) -- Teodor Sigaev [EMAIL PROTECTED] patch_btreesql.gz ---(end of broadcast)--- TIP 6: Have you

[HACKERS] Patch for fixing a few memory leaks

2001-10-04 Thread Teodor Sigaev
of sequence search on library name. Any suggestion? -- Teodor Sigaev [EMAIL PROTECTED] patch_dfmgr.gz ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Patch for fixing a few memory leaks

2001-10-05 Thread Teodor Sigaev
7.170 total 2. Patched gist.c % time psql wow sql.cmd psql wow sql.cmd 0.02s user 0.00s system 2% cpu 0.699 total We can see that calling fmgr_info for 7 times may be very expensive. -- Teodor Sigaev [EMAIL PROTECTED] ugly_patch.gz ---(end of broadcast

Re: [HACKERS] Proposed new create command, CREATE OPERATOR CLASS

2001-10-25 Thread Teodor Sigaev
. So I maked operator ~~ only for postgres can use index access for operator @@. There is no any difficulties to adding index support for operator ~~. The same things is with contrib/tsearch module. But I think that there is not any other necessity in presence ~~. -- Teodor Sigaev [EMAIL

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Teodor Sigaev
. :( -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Teodor Sigaev
It's my mistake, the problem is with locale, I'll send patch as soon as, but I can't see tsearch in contrib directory (in contrib/README tsearch exists) in current cvs. :( Ok now, I got. Please apply attached patch for contrib/tsearch. -- Teodor Sigaev [EMAIL PROTECTED

Re: [HACKERS] contrib/tree/README.tree

2002-03-26 Thread Teodor Sigaev
* ' ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Teodor Sigaev [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through

[HACKERS] Bug or feature in 7.3?

2002-03-29 Thread Teodor Sigaev
Hello. Some example: compile and install contrib/tsearch module and now: wow=# create table foo (bar txtidx); CREATE wow=# \d foo Table foo Column | Type | Modifiers ++--- bar| txtidx | not null Why field 'bar' has modifier 'not null'? -- Teodor

Re: [HACKERS] yet another contrib module

2004-05-31 Thread Teodor Sigaev
7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end

Re: [HACKERS] New btree_gist code has a few problems

2004-06-01 Thread Teodor Sigaev
, e=0x40110cd8, tinfo=0x7afff594) at btree_utils_var.c:220 [ gdb gets confused here, possibly stack is smashed ] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Teodor

Re: [HACKERS] New btree_gist code has a few problems

2004-06-03 Thread Teodor Sigaev
I tried running 'make installcheck' in contrib just now, and didn't get past btree_gist :-( Fix and test on Alpha box. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your

[HACKERS] Optimizer and function returning setof int4

2004-09-28 Thread Teodor Sigaev
of results. It seems to me this information may be helpful for query optimizer, so, is there way to say it to optimizer? -- Teodor Sigaev E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget

[HACKERS] GiST concurrency

2005-06-21 Thread Teodor Sigaev
); return RecPtr; } -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] GiST concurrency

2005-06-21 Thread Teodor Sigaev
. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] GiST rtree logic is not right

2005-06-23 Thread Teodor Sigaev
into the core --- but the case for it would be stronger if it worked correctly ... -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast

Re: [HACKERS] contrib/rtree_gist into core system?

2005-06-27 Thread Teodor Sigaev
We can make r-tree as contrib module and then we will have example of index in contrib... By integrating the opclasses needed to replace R-tree, we can start down the path to deprecating and eventually removing R-tree. -- Teodor Sigaev E-mail: [EMAIL

Re: [HACKERS] contrib/rtree_gist into core system?

2005-06-27 Thread Teodor Sigaev
'' in Generalized Search Trees, 1997, Paul M. Aoki, http://www.sai.msu.su/~megera/postgres/gist/papers/csd-97-950.pdf -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru

Re: [HACKERS] contrib/rtree_gist into core system?

2005-06-27 Thread Teodor Sigaev
algoritm 1 simple sorting for ordered domain( btree_gist, ltree ) 2 several variations of Guttmans algorithm (tsearch2, intarray, seg, cube) 3 linear picksplit for rtree_gist (http://www.sai.msu.su/~megera/postgres/gist/papers/nsplitLN.ps.gz). -- Teodor Sigaev E

Re: [HACKERS] contrib/rtree_gist into core system?

2005-06-27 Thread Teodor Sigaev
FYI, compress and decompress methods may be trivial. For GiST you still need 7 support functions + the operator function, some of which aren't exactly simple to implement, the picksplit for instance. -- Teodor Sigaev E-mail: [EMAIL PROTECTED

[HACKERS] GiST concurrency commited

2005-06-27 Thread Teodor Sigaev
framework, becouse it is about heap pages. I suspect trap occurs while concurrent vacuum, but I am not sure. PS My concurrency testing scripts: http://www.sigaev.ru/gist/ concur.pl - generator of SQL statements concur.sh - simple wrapper about concur.pl which reinit db, makes db and table. -- Teodor

Re: [HACKERS] tsearch2 vs core?

2005-06-27 Thread Teodor Sigaev
multibyte encoding and has problems with UTF :(. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast)--- TIP 5: Have you checked

Re: [HACKERS] contrib/rtree_gist into core system?

2005-06-28 Thread Teodor Sigaev
are unique the the later keys will not be compared ;) 2. About rtree interface: it's possible to write GiST-RTree layer compatibility interface. User's interface will just copied from RTree, and layer will translate it to GiST interface. -- Teodor Sigaev E-mail

Re: [HACKERS] GiST concurrency commited

2005-06-29 Thread Teodor Sigaev
feature freeze), if you don't find the cause beforehand. It's definitly bug in a vaccum code, I got the same trap without any GiST indexes (to reproduce, just comment out 'create index' command in my script). -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: [HACKERS] GiST concurrency commited

2005-06-29 Thread Teodor Sigaev
Sorry, fixed. Qingqing Zhou wrote: Teodor Sigaev [EMAIL PROTECTED] writes concur.pl - generator of SQL statements retrieving it is forbidden ... Regards, Qingqing ---(end of broadcast)--- TIP 7: don't forget to increase your free space

[HACKERS] GiST notice

2005-07-06 Thread Teodor Sigaev
, Line: 2766) LOG: server process (PID 15847) was terminated by signal 6 It's definitly bug in a vaccum code, I got the same trap without any GiST indexes (to reproduce, just comment out 'create index' command in my script). -- Teodor Sigaev E-mail: [EMAIL

Re: [HACKERS] GiST memory usage

2005-08-15 Thread Teodor Sigaev
in the contrib/rtree_gist) ? 8.1 pgsql has short lived memory context during index creation which resets after every insert. 8.0 hasn't this feature, so user-defined function (GiST interfface) should carefully clean memory. -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-22 Thread Teodor Sigaev
In other words ... if you can test this ... HELP!!! I'll run tests. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-23 Thread Teodor Sigaev
SQL statements without any failure. Tests runs on two boxes: PIII/1133MHz adn Quad Xeon/500MHz and works with four threads. Further I'm going to increase concurrency up to 12 parallel threads. PS GiST passed this tests too. -- Teodor Sigaev E-mail: [EMAIL

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-24 Thread Teodor Sigaev
Further I'm going to increase concurrency up to 12 parallel threads. All is ok, test is passed with approximatly 40 millions statements -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-25 Thread Teodor Sigaev
was wrote to test GiST concurrency. I suspect it's needed to make some changes in generator to increase number of updates and vacuums for your goal. -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-26 Thread Teodor Sigaev
http://archives.postgresql.org/pgsql-patches/2005-08/msg00304.php Could you perhaps test this patch as well, while you already have a setup for testing parallel vacuums under big loads ? I didn't find any problem with your patch during testing with 1e8 statements... -- Teodor Sigaev

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-26 Thread Teodor Sigaev
Finded problem in GiST isn't too simple to resolve. I'm working on it. The problem is about update query... Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: http://www.sigaev.ru/gist/concur.pl http://www.sigaev.ru/gist/concur.sh BTW, these scripts seem to indicate that there's

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-30 Thread Teodor Sigaev
Fixed in 8.0, 7.4 and 7.3 branches. Tom Lane wrote: Teodor Sigaev [EMAIL PROTECTED] writes: http://www.sigaev.ru/gist/concur.pl http://www.sigaev.ru/gist/concur.sh BTW, these scripts seem to indicate that there's a GIST or contrib/intarray problem in the 8.0 branch. I was trying to use

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-30 Thread Teodor Sigaev
a from wow where a @ '{1,2,3}' and not a @ '{101}'; After update query select must not find any rows, but it did. The problem was in GiST code and so any GiST idexes was affected. Can you say more about your trouble? -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: VACUUM/t_ctid bug (was Re: [HACKERS] GiST concurrency commited)

2005-08-30 Thread Teodor Sigaev
test suite or more information I'm helpless. How often do updates/inserts of table and/or ltree column occurs? Vacuum? Might this be somehow related to the intarray bugs? No, except case when you update your table something like to: update tbl set ltreefield=... where ltreefield ...; -- Teodor

Re: [HACKERS] Testing for a shared library

2005-09-07 Thread Teodor Sigaev
---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast

[HACKERS] PL/PGSQL and drop/create table

2005-09-07 Thread Teodor Sigaev
into variables After reconnecting to database all is ok. Is it supposed behaviour? -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast

[HACKERS] Interesting optimizer's supposition in 8.1

2005-10-05 Thread Teodor Sigaev
) Filter: (fts @@ '''foo'''::tsquery) Why planner suppose that t 'table' will return 1000 rows? Obviosly that function returns only one value because of itsn't marked as 'returns setof'. -- Teodor Sigaev E-mail: [EMAIL PROTECTED

Re: [HACKERS] tsearch2 's access method?

2005-10-20 Thread Teodor Sigaev
in pgsql) can store tree likes to R-tree or B-tree (with some limitations, such as now pgsql's GiST doesn't support order). -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru

[HACKERS] REL8_1_STABLE and HEAD

2005-11-07 Thread Teodor Sigaev
Hi! 8.1 had been tagged, may I develope/commit new tsearch2 code in HEAD branch? -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ ---(end of broadcast

  1   2   3   4   5   6   7   8   9   >