[HACKERS] tsearch2 patch for 7.4.1

2003-11-20 Thread Oleg Bartunov
(www.startsiden.no). Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007

Re: [HACKERS] tsearch2 patch for 7.4.1

2003-11-21 Thread Oleg Bartunov
module with new ispell dictionary builtin. Oleg Hannu Krosing wrote: Tom Lane kirjutas N, 20.11.2003 kell 17:18: Oleg Bartunov [EMAIL PROTECTED] writes: we have a patch for contrib/tsearch2 we'd like to commit for 7.4.1. Is it ok ? We added support for compound words using ispell

Re: [HACKERS] tsearch2 patch for 7.4.1

2003-11-21 Thread Oleg Bartunov
On Fri, 21 Nov 2003, Andreas Joseph Krogh wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 21 November 2003 09:42, Oleg Bartunov wrote: On Fri, 21 Nov 2003, Teodor Sigaev wrote: No problem, dictionary with support of compounds will be avaliable as separate contrib module

Re: [HACKERS] Commercial binary support?

2003-11-23 Thread Oleg Bartunov
if requested, what's so special about it? -- Nigel Andrews Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet

[HACKERS] regexp incompatibilites 7.3 and 7.4

2003-11-24 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] regexp incompatibilites 7.3 and 7.4

2003-11-24 Thread Oleg Bartunov
On Mon, 24 Nov 2003, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED] writes: seems for regexp which works in 7.3 is failing in 7.4. Is't possible to configure pgsql to be compatible with 7.3 regexp ? SET regex_flavor TO extended; aha, thanks a lot www=# select 'problem' ~ '^\\p

[HACKERS] support of compound words in contrib/tsearch2

2003-11-27 Thread Oleg Bartunov
dictionary * Skip too long words from indexing (throw NOTICE instead of ERROR). Documentation for new feature will be added later. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

Re: [HACKERS] Call for pg_dump testing

2003-12-07 Thread Oleg Bartunov
: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

[HACKERS] OpenFTS-perl-0.35 released

2003-12-05 Thread Oleg Bartunov
(sponsored by ABC Startsiden) * use ranking function from contrib/tsearch2 OpenFTS Web site - http://openfts.sourceforge.net/ Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

Re: [HACKERS] Composite GiST indexes?

2004-01-05 Thread Oleg Bartunov
://www.sai.msu.su/~megera/postgres/gist/tsearch/V2 Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [HACKERS] Composite GiST indexes?

2004-01-05 Thread Oleg Bartunov
using... install contrib/btree_gist Chris ---(end of broadcast)--- TIP 8: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, sci.researcher

[HACKERS] Announce: Search PostgreSQL related resources

2004-01-05 Thread Oleg Bartunov
Foundation for Basic Research and Delta-Soft LLC. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http

Re: [HACKERS] [GENERAL] Announce: Search PostgreSQL related resources

2004-01-09 Thread Oleg Bartunov
On Tue, 6 Jan 2004, Rajesh Kumar Mallah wrote: Hi, Could you please tell how the did you mean feature was implemented when the serach term has a typo. it's based on trigrams similarity and words statistics. The search engine is good . Regds mallah. Oleg Bartunov wrote: Hi

Re: [HACKERS] docs on tsearch2

2004-03-03 Thread Oleg Bartunov
of broadcast)---TIP 8: explain analyze is your friend Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet

Re: [HACKERS] GiST future

2004-04-02 Thread Oleg Bartunov
: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Oleg Bartunov
of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet

[HACKERS] contrib/trgm beta release

2004-04-24 Thread Oleg Bartunov
http://www.sai.msu.su/~megera/postgres/gist/ We plan to add some features in may day. Your comments and suggestions are welcome. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

Re: [HACKERS] Subtle pg_dump problem...

2004-05-12 Thread Oleg Bartunov
On Wed, 12 May 2004, Christopher Kings-Lynne wrote: Did you guys find any solution to this in the end? Not yet. Could you send me a simple test suite ? I'm not experienced with schema and don't know how to load tsearch2 into specific schema. Oleg Chris Oleg Bartunov wrote

Re: [HACKERS] Subtle pg_dump problem...

2004-05-12 Thread Oleg Bartunov
to this in the end? Chris Oleg Bartunov wrote: Thanks Christopher, we'll look into the issue. Oleg On Fri, 7 May 2004, Christopher Kings-Lynne wrote: I have a table with a tsearch2 index on it. Now, I have all the tsearch2 stuff installed into a 'contrib' schema. I have had to change

Re: [HACKERS] Subtle pg_dump problem...

2004-05-13 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] Subtle pg_dump problem...

2004-05-12 Thread Oleg Bartunov
://www.postgresql.org/docs/faqs/FAQ.html Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http

Re: [HACKERS] Subtle pg_dump problem...

2004-05-12 Thread Oleg Bartunov
to [EMAIL PROTECTED]) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone

Re: [HACKERS] Subtle pg_dump problem...

2004-05-12 Thread Oleg Bartunov
it in another, dumping separate data. Could pg_dump be enough smart to set search_path properly ? Chris Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

Re: [HACKERS] Subtle pg_dump problem...

2004-05-07 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] Aggregation question

2004-05-08 Thread Oleg Bartunov
this an how to aggregate it? Thanks Dilip Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED

[HACKERS] new version of contrib/pg_trgm is available !

2004-05-14 Thread Oleg Bartunov
statistics. Documentation kindly provided by Christopher Kings-Lynne is available from http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster

[HACKERS] new version of tsearch2 introduction is available

2004-05-14 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] [GENERAL] New PostgreSQL Website : advocacy.postgresql.org

2002-10-02 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] [GENERAL] New PostgreSQL Website : advocacy.postgresql.org

2002-10-02 Thread Oleg Bartunov
On Wed, 2 Oct 2002, Vince Vielhaber wrote: On Wed, 2 Oct 2002, Oleg Bartunov wrote: On Wed, 2 Oct 2002, Vince Vielhaber wrote: On Wed, 2 Oct 2002, Justin Clift wrote: Hi Oleg, It's supposed to show roughly where everyone is. Based mostly on Vince's map from

[HACKERS] DBD::PG - any works to be compatile with 7.3 ?

2002-10-02 Thread Oleg Bartunov
Any news about new DBD::Pg ? It's a stopper for many projects based on perl interface to use 7.3. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

[HACKERS] any experience with IA-64

2002-10-04 Thread Oleg Bartunov
I, probably, will have a chance to work with postgres on Linux IA-64. Is there any optimization for postgresql ? Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [HACKERS] Current CVS is broken

2002-10-22 Thread Oleg Bartunov
-a FreeBSD xor 4.6-STABLE FreeBSD 4.6-STABLE #2: Tue Jun 18 20:48:48 MSD 2002 teodor@xor:/usr/src/sys/compile/XOR i386 Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [HACKERS] Another bug in tsearch?

2002-11-05 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end

[HACKERS] float4 problem

2002-11-20 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] [GENERAL] FreeBSD, Linux: select, select count(*) performance

2002-11-27 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] 7.4 Wishlist

2002-11-30 Thread Oleg Bartunov
)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster

Re: [HACKERS] tsearch thoughts

2002-12-01 Thread Oleg Bartunov
)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Oleg Bartunov
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote: Oleg Bartunov [EMAIL PROTECTED] wrote: Please, tell us postgresql version. Did you reinstall tsearch after upgrading ? Test-suite (data, sql) demonstrated the problem would be nice. pgsql 7.3, about 700mb text database with product

Re: [HACKERS] Backend crash with tsearch

2002-12-03 Thread Oleg Bartunov
commands go to [EMAIL PROTECTED] Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su

[HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-19 Thread Oleg Bartunov
Small fix in documentation and some examples of usage. Please, apply to 7.3 and current CVS Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [HACKERS] [OpenFTS-general] relor and relkov

2003-01-31 Thread Oleg Bartunov
On Fri, 31 Jan 2003, Caffeinate The World wrote: --- Oleg Bartunov [EMAIL PROTECTED] wrote: On Fri, 31 Jan 2003, Caffeinate The World wrote: But, we need help to create good documentation for tsearch ! This is main stopper for releasing of tsearch. I am currently using

Re: [HACKERS] [OpenFTS-general] relor and relkov

2003-01-31 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] [OpenFTS-general] relor and relkov

2003-01-31 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

[HACKERS] new version of btree_gist

2003-02-05 Thread Oleg Bartunov
/btree_gist.tar.gz Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095

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

2003-02-05 Thread Oleg Bartunov
with examples for beginners and advanced users. We plan to work on new version of OpenFTS after releasing contrib/tsearch. Download it from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch.tar.gz It should works with 7.3 and current CVS. Any comments please send to Oleg Bartunov

Re: [HACKERS] Brain dump: btree collapsing

2003-02-28 Thread Oleg Bartunov
)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet

Re: [HACKERS] [GENERAL] Alpha-2 of contrib/tsearch

2003-03-05 Thread Oleg Bartunov
compile problem on Solaris 2 Add search by weight of lexem. Readme: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/README-V2.txt Tar: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch.tar.gz We still need a documentation... Any comments please send to Oleg Bartunov

Re: [HACKERS] string || NULL ambiguity

2003-03-19 Thread Oleg Bartunov
On Wed, 19 Mar 2003, Alvaro Herrera wrote: On Wed, Mar 19, 2003 at 10:26:05PM +0300, Oleg Bartunov wrote: we have a little problem in new version of tsearch we're currently working. We've implemented concatenation operation for txtidx type and treat concatenation with NULL as NULL

Re: [HACKERS] Schemas: status report, call for developers

2002-04-30 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] Schemas: status report, call for developers

2002-05-02 Thread Oleg Bartunov
On Wed, 1 May 2002, Jeffrey W. Baker wrote: On Tue, Apr 30, 2002 at 09:41:47PM +0300, Oleg Bartunov wrote: I think DBD::Pg driver very much depends on system tables. Hope, Jeffrey (current maintainer) is online. These changes may break DBD::Pg. What is the expected time of this release

[HACKERS] strange explain

2002-05-13 Thread Oleg Bartunov
. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095

Re: [HACKERS] strange explain

2002-05-13 Thread Oleg Bartunov
Thanks Tom, On Mon, 13 May 2002, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED] writes: tour=# explain analyze select * from tours where ( operator_id in (2,3,4,5,7) and type_id = 2 ) or ( operator_id = 8 and type_id=4 ); Index Scan using type_idx

Re: [HACKERS] strange explain

2002-05-13 Thread Oleg Bartunov
= 3); NOTICE: QUERY PLAN: Index Scan using type_idx, type_idx, type_idx, type_idx, type_idx, type_idx on tours (cost=0.00..12.25 rows=1 width=1091) (actual time=0.27..0.27 rows=0 loops=1) Total runtime: 0.44 msec EXPLAIN On Mon, 13 May 2002, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED

[HACKERS] 7.2.2 ?

2002-05-14 Thread Oleg Bartunov
We have one patch for contrib/rtree_gist ( thanks Chris Hodgson for spotting bug and test suite ). Should we submit patch for 7.2.2 and 7.3 ? Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet

[HACKERS] strange update problem with 7.2.1

2002-05-25 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end

Re: [HACKERS] strange update problem with 7.2.1

2002-05-25 Thread Oleg Bartunov
Sorry, forget to attach file. Oleg On Sat, 25 May 2002, Oleg Bartunov wrote: Hi, we've got rather strange problem with updating and GiST indices. Below is a test run: drop table tst; create table tst ( a int[], i int ); copy tst from stdin; \. create index tsti on tst

Re: [HACKERS] strange update problem with 7.2.1

2002-05-25 Thread Oleg Bartunov
On Sat, 25 May 2002, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED] writes: test=# update tst set i = i+10 where a '{3,4}'; UPDATE 3267 test=# set enable_indexscan=off; SET VARIABLE test=# update tst set i = i+10 where a '{3,4}'; UPDATE 4060 I get the same in current

Re: [HACKERS] strange update problem with 7.2.1

2002-05-26 Thread Oleg Bartunov
cvs (sorry, but I'll have a possibility to check it on current cvs only tomorrow). Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

[HACKERS] Two smart guys are looking for contracts :-)

2002-05-27 Thread Oleg Bartunov
web sites) Some information is available from http://www.xware.ru/, http://www.sai.msu.su/~megera/postgres/gist/ Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [HACKERS] strange update problem with 7.2.1

2002-05-28 Thread Oleg Bartunov
? regards, tom lane Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http

Re: [HACKERS] Null values in indexes

2002-05-30 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] GOODS - a sensational public domain database backend

2002-06-03 Thread Oleg Bartunov
)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL

[HACKERS] patch for contrib/intarray (7.2 and 7.3)

2002-06-03 Thread Oleg Bartunov
and suggestion. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007

[HACKERS] patch for contrib/intarray (7.2 and 7.3) (fwd)

2002-06-06 Thread Oleg Bartunov
Patch to contrib/intarray is attached to this message. Please apply it to 7.2 and CVS Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-20 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] Postgres idea list

2002-06-26 Thread Oleg Bartunov
)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia

[HACKERS] english doc for tree module

2002-06-30 Thread Oleg Bartunov
Machine translation with my minor edition is available from http://www.sai.msu.su/~megera/postgres/gist/tree/README.tree.english Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg

Re: [HACKERS] Translated README.tree in tree.tar.gz

2002-07-01 Thread Oleg Bartunov
Essig wrote: Oleg, Attached is my latest version. When something was unclear to me, I took the liberty to substitute what I thought it meant. George --- Oleg Bartunov [EMAIL PROTECTED] wrote: Thanks George, I've edit it a little bit, but still it's incomplete and looks wacky

Re: [HACKERS] urgent needed

2002-07-12 Thread Oleg Bartunov
://adv2.email.it/cgi-bin/foclick.cgi?mid=657d=12-7 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Regards, Oleg _ Oleg

Re: [HACKERS] GiST Indexing

2002-07-17 Thread Oleg Bartunov
command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

Re: [HACKERS] contrib/fulltextindex

2002-07-22 Thread Oleg Bartunov
://www.postgresql.org/users-lounge/docs/faq.html Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http

Re: [HACKERS] Weird manual page

2002-07-30 Thread Oleg Bartunov
it with Postgres documentation. --- Oleg Bartunov wrote: On Tue, 30 Jul 2002, Tom Lane wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: What's with this manual page? http://candle.pha.pa.us/main/writings

Re: [HACKERS] Weird manual page

2002-07-30 Thread Oleg Bartunov
] so that your message can get through to the mailing list cleanly Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet

[HACKERS] Please, apply ltree patch

2002-07-31 Thread Oleg Bartunov
.tar.gz Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939

Re: [HACKERS] Trimming the Fat, Part Deux ...

2002-08-01 Thread Oleg Bartunov
it needs many changes and testing to be 7.3 compliant. Jeffrey, wake up :-) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia

Re: [HACKERS] Module Portability

2002-08-01 Thread Oleg Bartunov
tree to a new path. Nice. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su

[HACKERS] fate of CLUSTER command ?

2002-08-03 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

Re: [HACKERS] fate of CLUSTER command ?

2002-08-03 Thread Oleg Bartunov
On Sat, 3 Aug 2002, Alvaro Herrera wrote: Oleg Bartunov dijo: I just tried CLUSTER command at fts.postgresql.org to cluster fts index and got very visual performance win. Unfortunately I had to restore permissions and recreate other indices by hand. So, I'm interested what's a future

Re: [HACKERS] fate of CLUSTER command ?

2002-08-04 Thread Oleg Bartunov
On Sat, 3 Aug 2002, Bruce Momjian wrote: Oleg Bartunov wrote: I just tried CLUSTER command at fts.postgresql.org to cluster fts index and got very visual performance win. Unfortunately I had to restore permissions and recreate other indices by hand. So, I'm interested what's a future

Re: [HACKERS] fate of CLUSTER command ?

2002-08-04 Thread Oleg Bartunov
Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16

[HACKERS] db partial dumping with pg_dump

2002-08-13 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP

Re: [HACKERS] db partial dumping with pg_dump

2002-08-13 Thread Oleg Bartunov
On 13 Aug 2002, Rod Taylor wrote: On Tue, 2002-08-13 at 07:49, Oleg Bartunov wrote: We have a patch for pg_dump which adds a possibility to dump a part of table, for example: dump Top.Science.Astronomy heirarchy from dmoz catalog pg_dump -d -t dmoz -w select * from dmoz where path

[HACKERS] OpenFTS 0.33 Release

2002-08-13 Thread Oleg Bartunov
, your questions and comments are welcome. Please, use openfts-general mailing list [EMAIL PROTECTED] We are looking for documentation manager ! Please, contact Oleg Bartunov [EMAIL PROTECTED] if you're willing to join the OpenFTS project. Regards, Oleg

Re: [HACKERS] db partial dumping with pg_dump

2002-08-13 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: [HACKERS] tsearch bug in 7.2.1?

2002-08-15 Thread Oleg Bartunov
' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095

Re: [HACKERS] tsearch bug in 7.2.1?

2002-08-16 Thread Oleg Bartunov
currently) 4. combination of 2 and 3 Ideally, we want to inform middleware all these cases. Oleg On Thu, 15 Aug 2002, Ross J. Reedstrom wrote: On Thu, Aug 15, 2002 at 11:59:20AM +0300, Oleg Bartunov wrote: tsearch has compiled-in stop-list, it's currently just not flexible as OpenFTS

Re: [HACKERS] pg_restore and user defined types, several other

2002-08-16 Thread Oleg Bartunov
of the box. Best regards, Mario Weilguni ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Regards, Oleg _ Oleg

Re: [HACKERS] tsearch bug in 7.2.1?

2002-08-16 Thread Oleg Bartunov
]]On Behalf Of Ross J. Reedstrom Sent: Friday, 16 August 2002 4:59 AM To: Oleg Bartunov Cc: Christopher Kings-Lynne; Hackers Subject: Re: [HACKERS] tsearch bug in 7.2.1? On Thu, Aug 15, 2002 at 11:59:20AM +0300, Oleg Bartunov wrote: tsearch has compiled-in stop-list, it's currently

Re: [HACKERS] Theoretical XML ltree Question

2002-08-22 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast

Re: Release of v7.2.2 (Was: Re: [HACKERS] @(#)Mordred Labs ad...)

2002-08-22 Thread Oleg Bartunov
, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

[HACKERS] README.tsearch.diff for CVS

2002-08-29 Thread Oleg Bartunov
Bruce, please apply small patch for README.tsearch. I've documented space usage and using CLUSTER command Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

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

2002-09-02 Thread Oleg Bartunov
/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 Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [HACKERS] tsearch stop words

2002-09-02 Thread Oleg Bartunov
unregister YourEmailAddressHere to [EMAIL PROTECTED]) Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED

Re: [HACKERS] tsearch stop words

2002-09-02 Thread Oleg Bartunov
',0,0,131}, {'s',0,0,156}, How do I figure out the actual word it's matching? Chris -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED]] Sent: Monday, 2 September 2002 5:33 PM To: Christopher Kings-Lynne Cc: Hackers Subject: Re: [HACKERS] tsearch stop

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Oleg Bartunov
enough arguments to use snowball stemmers in tsearch also. Interesting that no one has reported this before. :-) Thanks Cristopher for his persistence. Martin Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [HACKERS] contrib/tsearch

2002-09-06 Thread Oleg Bartunov
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher Kings-Lynne Sent: Friday, 6 September 2002 12:20 PM To: Christopher Kings-Lynne; Oleg Bartunov Cc: Hackers; [EMAIL PROTECTED] Subject: Re: [HACKERS] contrib/tsearch Looking at the list

Re: [HACKERS] contrib/tsearch

2002-09-06 Thread Oleg Bartunov
. But he already has many assignments regarding our main project. Are there one smart programmer ? Chris Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute

Re: [HACKERS] contrib/tsearch

2002-09-06 Thread Oleg Bartunov
_ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end

  1   2   3   4   5   6   7   8   9   10   >