Hide Zen home . ... GiST . ... Looks like we're getting new project - CC for GiST. For a long time we planned to implement Concurrency Control for GiST, but real life is rather complex life. ... I have some conception what we need for CC and already found papers by Marcel Kornacker, Kaushik Chakrabarti and, of course, Lehman and Yao. ... extend GiST interface (see papers of Aoki, Kornacker) . choose CC model (locking, granular locking, predicate locking, or may be optimistic ?) . ...
Hide Zen home . ... edit . ... 3. then install some apps using recommendation from iphones.ru . 4. install gtkpod, fuse, sshfs 5. sshfs root@192.168.1.3:/var/mobile/Media /mnt/iphone (here IP address is an address of my iphone) . 6. run gtkpod, edit preferences, mount point (choose iphone) . ... Right-click on Local , save changes, choose Copy selected playlists to Ipod' - this takes a while via wifi . ... Ipod on iphone will not see new files unless you kill -HUP mediaplayer. ...
Hide Zen home . ... Tsearch2 . ... There is a big dynamical storage of documents in external database, which needs to be indexed and searched. ... The requirement to the system is to serve about 100,000 search requests per day with ability to use sophisticated ranking, based on different thingies. ... We tested direct full text searches in database as well as indirect searches using search daemon. ... You need web user in your system and in database for search daemon: . usr/sbin/groupadd web . ...
. Hide Zen home . Pgsql . GiST . GIN . SP-GiST . Tsearch2 . SAI RVO . SAI CAS . SOA . Supernovae . TODO . HomePage . Astronet . Google . Rambler . Yandex . Oddmuse . E-R-E dict . Index . edit . tsearch2 x2013; pages about contrib/tsearch2 (full text search extension for PostgreSQL) . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on EditCluster This page is read-only View other revisions Administration . Last edited 2006-01-25 20:18 UTC by megera (diff) . Search: . Zen, 2003-2007
Hide Zen home . ... Олег Бартунов, научный сотрудник, ГАИШ МГУ . ... Повсеместное распространение интернет, ускорение и унификация доступа к информации и т.п. привело к формулированию концепции киберобщества (информационного общества) как реалистичного сценария постиндустриального общества - новой исторической фазы развития цивилизации, в которой главными продуктами производства являются информация и знания. ... Астрономические данные хранятся бесконечно долго . ... Политика доступа к информации . ...
Hide Zen home . ... Oiginally, multilple-versions in Postgres was because of Time Travel and to avoid having WAL. Time Travel was removed in 1997 (check archives), pg had only committed log (pg_log) with 2bits per transactions for statuses(in-progress, committed,abort) and no WAL. ... Vacuuming without human administration is possible but in any case commit in non-overwriting system requires ~2 data block writes (first - to write changes, second - to write updated xmin/xmax statuses). ...
Hide Zen home . ... Предоставляемые сервисы . ... публичные сервисы . Количество пользователей (по сервисам) . ... пиковая /сек . ... Количество зарегистрированных пользователей (по сервисам) . ... описание . ... среднее время передачи пользователю страницы (сек) . ... оборудование . ... Тип используемого оборудования . ... Мониторинг оборудования . ... тип корпуса (tower, rack mount, количество Units) . ... 0 Comments on itchecklist This page is read-only View other revisions Administration . ...
Hide Zen home . ... GUC variable default_text_search_config defines at initdb time . ... 2. at runtime, if text search configuration doesn't specified, it determined from GUC variable default_text_search_config, if it doesn't defined, then an error is raised. ... Snowball stemmer for danish language pg_catalog | ... Snowball stemmer for dutch language pg_catalog | ... Snowball stemmer for english language pg_catalog | ... Snowball stemmer for finnish language pg_catalog | ... snowball | ... Search: . ...
Hide Zen home . ... test=# SELECT TIMESTAMP WITHOUT TIME ZONE 'epoch' + 1109796233 * INTERVAL '1 second'; ?column? --------------------- 2005-03-02 20:43:53 (1 row) test=# SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 1109796233 * INTERVAL '1 second'; ?column? ------------------------ 2005-03-02 23:43:53+03 (1 row) CREATE OR REPLACE FUNCTION ts2int( timestamp without time zone) RETURNS int AS $$ ... 0 Comments on pgsql tips This page is read-only View other revisions Administration . ...
Hide Zen home . Pgsql . ... SAI RVO . SAI CAS . ... edit . Edit . Point In Time Recovery provides a possibility to use plain file-level commands ( cp , for example) to make online backup of full postgresql cluster (sorry, not per db backup) and be able to restore cluster to specified moment of time. Of course, instead of cp command one can use tar with ssh to backup cluster's files to another machine. Simon Riggs proposal for PITR . ... Zen, 2003-2007 ...
Hide Zen home . ... Index . ... Особенно это хорошо для read-only таблиц, для которых раз сделанная кластеризация (clusterdb, CLUSTER x2026;) сохраняет свои хорошие качества. ... Вот краткая выжимка из документации pg_reorg is an utility program to reorganize tables in PostgreSQL databases. ... Online CLUSTER (ordered by cluster index) * Ordered by specified columns * Online VACUUM FULL (packing rows only) NOTICE: * Only superusers can use the utility. ... Zen, 2003-2007 ...
Hide Zen home . ... Date: Fri, 17 Mar 2006 12:04:04 -0500 (EST) From: Bruce Momjian <pgman@candle.pha.pa.us> To: Peter Eisentraut <peter_e@gmx.net> Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Seperate command-line histories for seperate databases Peter Eisentraut wrote: > Bruce Momjian wrote: > > The psql manual pages for 8.1 now has: > > > \set HISTFILE ~/.psql_history- :DBNAME > > Excellent! ... 0 Comments on 2006-03-17 This page is read-only View other revisions Administration . ...
Hide Zen home . ... dbh ); my $sql = "select pgc,objname, id from ledasn_ell order by id limit 10;"; my $sth=$dbh->prepare($sql) || die "Couldn't prepare \'$sql\' $!\n"; if ( $sth->execute() ) { while ( defined ( my $r=$sth->fetchrow_hashref ) ) { foreach my $key (keys %$r ) { print "$key => $r->{$key} "; } print "\n"; } } $sth->finish if $sth; . ... dbh ); my $sql = "select pgc,objname, id from ledasn_ell where id ~ ? ... Last edited 2006-02-16 09:24 UTC by megera (diff) . ... Zen, 2003-2007 ...
... Pgsql . ... Obtain stem.{c,h} files for Portuguese wget http://snowball.tartarus.org/portuguese/stem.c wget http://snowball.tartarus.org/portuguese/stem.h 2. ... Test it Sample portuguese words with the stemmed forms are available from http://snowball.tartarus.org/portuguese/stemmer.html createdb testdict psql testdict < /usr/local/pgsql/share/contrib/tsearch.sql psql testdict < /usr/local/pgsql/share/contrib/dict_pt.sql psql -d testdict -c "select lexize('pt','bobagem');" lexize --------- {bobag} ....
Hide Zen home . ... ZLine Directory x2013; это специализированная программная платформа для создания справочников различных типов, которые можно использовать как во внутренней сети, так и в интернете. ... ZLine Directory не предназначен для создания обычных универсальных сайтов, зато в своей области x2013; создание интерактивных справочных систем x2013; он умеет все и даже больше. ... В справочниках ZLine Directory также присутствует система учета и контроля доступа к платной информации. ...
. Hide Zen home . Pgsql . GiST . GIN . SP-GiST . Tsearch2 . SAI RVO . SAI CAS . SOA . Supernovae . TODO . HomePage . Astronet . Google . Rambler . Yandex . Oddmuse . E-R-E dict . Index . edit . Zen /~megera/wiki/? . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on InterMap This page is read-only View other revisions Administration . Last edited 2006-07-16 14:16 UTC by megera (diff) . Search: . Zen, 2003-2007
Hide Zen home . ... SAI RVO . SAI CAS . ... Oddmuse . ... Это клон [ http://c2.com/cgi/wiki?WikiEngines Wiki ] . А живет этот клон -> http://emacswiki.wikiwikiweb.de/cgi-bin/oddmuse.pl . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on OddMuse This page is read-only View other revisions Administration . Last edited 2003-06-17 23:05 UTC by OlegBartunov . ... Zen, 2003-2007 ...