Re: [ADMIN] tsvector limitations

2011-06-15 Thread Oleg Bartunov
_ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql

Re: [ADMIN] tuning tips, speed problem

2009-01-16 Thread Oleg Bartunov
off - end show all Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [ADMIN] [GENERAL] PostgreSQL Cache

2008-09-29 Thread Oleg Bartunov
is to reboot the whole server. -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [ADMIN] full-text search question

2008-06-18 Thread Oleg Bartunov
above by searching only a part of the URL? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: [EMAIL

Re: [ADMIN] tsearch2 dictionary for statute cites

2008-06-04 Thread Oleg Bartunov
than to create the tsvector. There's no problem with that, is there? -Kevin Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
)--- TIP 5: don't forget to increase your free space map settings Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: On 12/8/06, Oleg Bartunov oleg@sai.msu.su wrote: You need to read documentation ! rank_cd accepts the same args as rank() function. Dear Oleg, Could you please elaborate a bit more if time permits. our application is old and it was working fine

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
: On 12/8/06, Oleg Bartunov oleg@sai.msu.su wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: On 12/8/06, Oleg Bartunov oleg@sai.msu.su wrote: You need to read documentation ! rank_cd accepts the same args as rank() function. Dear Oleg, Could you please elaborate a bit more

Re: [ADMIN] tsearch2 problem rank_cd() (possibly) crashing postgres

2006-12-08 Thread Oleg Bartunov
On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: On 12/8/06, Oleg Bartunov oleg@sai.msu.su wrote: On Fri, 8 Dec 2006, Rajesh Kumar Mallah wrote: Dear Oleg, In local development server. the old functions still exists in postgresql catalogs. But probably they are missing in the newer

Re: [ADMIN] Show tables query

2006-04-02 Thread Oleg Bartunov
-END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg

Re: [ADMIN] Full Text Indexing Using Tsearch2-Module

2006-01-23 Thread Oleg Bartunov
+-+ 1 | many| 'mani':1 (1 row) Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
? Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
7.4.5 still available then read docs and try patch and you should get good dump, or reinstall tsearch2 stuff. There are OIDs stored in tsearch2 config tables for me work fine thank 2005/4/26, Oleg Bartunov oleg@sai.msu.su: How did you migrate to 8.0 ? Have you read about regprocedure patch from http

Re: [ADMIN] cache lookup failed for function 8044889

2005-04-26 Thread Oleg Bartunov
according to the procedure indicated in the documentation of 8.0.2 , but I have not read the documentation of the patch of the tsearch, but my others functions make in pl/pgsql make for me work fine thank 2005/4/26, Oleg Bartunov oleg@sai.msu.su: How did you migrate to 8.0 ? Have you read about

Re: [ADMIN] Vacuum full on a big table

2005-03-17 Thread Oleg Bartunov
---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow

[ADMIN] slow count() was: tsearch2 poor performance

2004-10-03 Thread Oleg Bartunov
select count(body) from txt where fts_index @@ to_tsquery('oil') limit 1000; Didn't get result after 10 minutes :( Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [ADMIN] [HACKERS] slow count() was: tsearch2 poor performance

2004-10-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

Re: [ADMIN] tsearch2 poor performance

2004-09-29 Thread Oleg Bartunov
---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [ADMIN] tsearch2 poor performance

2004-09-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

Re: [ADMIN] Documents storage

2004-08-17 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: [ADMIN] Documents storage

2004-08-17 Thread Oleg Bartunov
On Wed, 18 Aug 2004, Gaetano Mendola wrote: Oleg Bartunov wrote: On Tue, 17 Aug 2004, Gaetano Mendola wrote: Hi all, where I work some times we need to find our documents searching for a couple of words. I was thinking to use the tsearch2. Shall I use OpenFTS? Do you have any

Re: [ADMIN] Tsearch1 problem

2004-06-07 Thread Oleg Bartunov
This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !# Regards, Oleg _ Oleg Bartunov, sci.researcher

Re: [GENERAL] [ADMIN] Restoring a Databases that features tserach2

2004-04-22 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

Re: [ADMIN] PGfs Codebase? even old version????

2004-04-18 Thread Oleg Bartunov
, http://www.linuxjournal.com/article.php?sid=1383 Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED

Re: [ADMIN] Cache loolup failed problems with tsearch following

2004-03-24 Thread Oleg Bartunov
/globalobjects.sql psql cms /var/lib/pgsql/backups/extra.sql psql cms /var/lib/pgsql/backups/tsearch2.sql psql -e cms /var/lib/pgsql/backups/db_schema_new.sql errors 21 pg_restore -N -a -d cms /var/lib/pgsql/backups/2004-03-16-23-10-cms_241103.dmp errors2 21 -Original Message- From: Oleg

Re: [ADMIN] Cache loolup failed problems with tsearch following

2004-03-23 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: [ADMIN] Tsearch1 problem

2004-02-24 Thread Oleg Bartunov
On Tue, 24 Feb 2004, Sam Barnett-Cormack wrote: On Tue, 24 Feb 2004, Oleg Bartunov wrote: On Tue, 24 Feb 2004, Rajesh Kumar Mallah wrote: Greetings, The function txt2txtidx of tsearch1 crashes the backend in my installation when it is called with a text where

Re: [ADMIN] Tsearch1 problem

2004-02-24 Thread Oleg Bartunov
On Tue, 24 Feb 2004, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED] writes: Also, I run test on 7.3.3 Everything is ok. I see your version of postgresql is outdated (you may upgrade at least to 7.3.5 !) and most suspicious is the version of your compiler 2.96 ! There was at least one

Re: [ADMIN] co existance of tsearch V1 and V2 in same database.

2004-02-13 Thread Oleg Bartunov
On Fri, 13 Feb 2004, Rajesh Kumar Mallah wrote: Oleg Bartunov wrote: On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote: Greetings, Can tsearch V1 and V2 exist in the same database simultaneously? I have read in past that its difficult , but is it possible for the desperate

Re: [ADMIN] co existance of tsearch V1 and V2 in same database.

2004-02-10 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

Re: [ADMIN] Business Objects and Postgresql

2004-01-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 of broadcast

Re: [ADMIN] plpgsql: Bush becomes a null, can not execute null query

2003-08-28 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: [ADMIN] contrib/tsearch - word order

2003-06-23 Thread Oleg Bartunov
: Have you searched our list archives? http://archives.postgresql.org Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

Re: [ADMIN] contrib/tsearch crashing postgresql 7.3 Stable

2002-12-10 Thread Oleg Bartunov
of this and comment on solution i would be grateful. Otherwise 7.3 has been an amazing xperience till now. regds mallah. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical

Re: [ADMIN] array character types

2002-10-31 Thread Oleg Bartunov
appreciated. Thank you, Jodi Kanter ___ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED] Regards, Oleg _ Oleg

[ADMIN] pre-alpha release of OpenFTS (perl version) is available for testing

2002-02-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

Re: [HACKERS] [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Oleg Bartunov
On Wed, 30 Jan 2002, Dave Page wrote: -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 17:58 To: Oleg Bartunov Cc: [EMAIL PROTECTED]; Pgsql Hackers Subject: Re: [HACKERS] [ADMIN] postgresql under Windows is slow Oleg Bartunov [EMAIL

Re: [HACKERS] [ADMIN] postgresql under Windows is slow

2002-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

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Oleg Bartunov
On Thu, 31 Jan 2002, Andy Ruhl wrote: On Wed, 30 Jan 2002, Oleg Bartunov wrote: anybody has an experience how is stable postgresql under Windows system ? I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed by very bad performance. Are there something I could tune ? I

[ADMIN] postgresql under Windows is slow

2002-01-30 Thread Oleg Bartunov
/sec. 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: [ADMIN] Please help me

2001-07-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

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-11-10 Thread Oleg Bartunov
making Perl and Postgres like each other :) Jimi Thompson L3 communications "It's the same thing we do every night, Pinky." _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institu

[ADMIN] Re: [Mason] High load postgres-driven Web sites

2000-03-14 Thread Oleg Bartunov
etizen.com.au/mailman/listinfo/mason _ 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: [ADMIN] When postgres will be faster?

1999-11-30 Thread Oleg Bartunov
On Tue, 30 Nov 1999 [EMAIL PROTECTED] wrote: Date: Tue, 30 Nov 1999 18:11:36 +0300 (MSK) From: [EMAIL PROTECTED] To: Oleg Bartunov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], Marcin Mazurek - Multinet SA - Poznan [EMAIL PROTECTED] Subject: Re: [ADMIN] When postgres

Re: [ADMIN] When postgres will be faster?

1999-11-29 Thread Oleg Bartunov
://www.multinet.pl/ _ 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

Re: [ADMIN] Monitoring Database Sessions

1999-10-12 Thread Oleg Bartunov
peaks to developers as well. The log may not. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma _____ Oleg Bartunov, sci.researcher, hostma

Re: [ADMIN] cyrillic

1999-07-09 Thread Oleg Bartunov
comset.net -- _ 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: [ADMIN] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Oleg Bartunov
.5 version : timesheet= select version(); version -- PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3 (1 row)

Re: [ADMIN] XOpenDisplay Problem?

1999-06-02 Thread Oleg Bartunov
not solve the problem. thanks Brent _ 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: [ADMIN] Getting table structure from script

1999-05-27 Thread Oleg Bartunov
script Hello. Is there any way to get table structure from perl script (for instance using Pg). I need it very much, but now have to use copy/paste algorythm :) Andrey Novikov _ Oleg Bartunov, sci.researcher, hostmaster of

Re: seperate swap drive, was Re: [ADMIN] Speed problem

1998-11-05 Thread Oleg Bartunov
resql}.org _ 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