2005-03-14
накидать данные для игр <pre> List of relations Schema | Name | Type | Owner . . .
2K - last updated 2007-06-13 23:55 UTC by ppp85-140-158-166.pppoe.mtu-net.ru
2005-10-27
== How to batch-forward a bunch of emails, (requires Pine) == [http://www.gmailforums.com/index.php?showtopic=30 . . .
2K - last updated 2005-10-27 06:39 UTC by megera
2006-01-02
Debugging cgi from command line (this is what I just recall): <pre> REQUEST_METHOD=GET QUERY_STRING="no=8638" . . .
1K - last updated 2006-01-02 18:25 UTC by megera
2006-02-23
== Taggerati for www.astronet.ru == I want to show keywords from www.astronet.ru using fonts depending . . .
2K - last updated 2006-02-23 15:37 UTC by megera
2007-04-26
== testing gin on TEXT == Found pretty bad time of creating gin index :) CVS HEAD with non-modified postgresql.conf . . .
2K - last updated 2007-04-26 07:17 UTC by mira.sai.msu.ru
2007-06-11
== PostgreSQL MVCC == Oiginally, multilple-versions in Postgres was because of Time Travel and to avoid . . .
2K - last updated 2007-06-11 13:03 UTC by mira.sai.msu.ru
2007-10-07
== KeepAlive or not KeepAlive ? == After some readings and experiments with Apache 1.3X configurations . . .
1K - last updated 2007-10-07 13:07 UTC by mira.sai.msu.ru
2008-10-04
== Find documents for specific token type == Someone asked us about how to find documents, which contain . . .
2K - last updated 2008-10-04 11:01 UTC by mira.sai.msu.ru
2009-01-11
== Развитие СУБД PostgreSQL в 2008 году == Олег Бартунов, Федор Сигаев . . .
10K - last updated 2009-01-14 15:24 UTC by mira.sai.msu.ru
2009-03-21
== Google does semantic search == Search google for ''Apparent magnitude of jupiter'' and you'll get . . .
1K - last updated 2009-05-16 21:15 UTC by ppp91-77-33-195.pppoe.mtu-net.ru
2009-03-24
== GIN fastupdate committed ! == Tom Lane just committed GIN fastupdate patch to the CVS HEAD. We spent . . .
2K - last updated 2009-03-25 04:20 UTC by mira.sai.msu.ru
2009-04-03
== Red-Black Tree experiments == [[http://en.wikipedia.org/wiki/Red_black_tree| Red-Black tree]] will . . .
3K - last updated 2010-02-03 16:43 UTC by mira.sai.msu.ru
2009-06-21
<pre> tail /etc/modprobe.d/blacklist ############ I dont' want usb audio !!! blacklist snd_usb_audio . . .
1K - last updated 2009-06-21 00:47 UTC by mira.sai.msu.ru
2009-07-27
== Rb-tree and GIN again ! == Yesterday I again was beaten by GIN problem (PostgreSQL 8.4) with sorted . . .
2K - last updated 2009-11-20 10:36 UTC by toulouse.jfg-networks.net
2010-01-12
== What keywords are in text == The problem: Find what keywords are in text. We have papers and kw (keywords). . . .
2K - last updated 2010-01-12 21:23 UTC by mira.sai.msu.ru
2010-10-03
== Опыт участия в разработке открытой СУБД PostgreSQL == Олег Бартунов . . .
8K - last updated 2010-10-04 17:35 UTC by ppp85-141-216-161.pppoe.mtu-net.ru
Abstract
PostgreSQL: the best DBMS solution for astronomy and astrophysics. ----- We consider PostgreSQL, an open-source . . .
2K - last updated 2003-07-17 19:04 UTC by chil
AstroChallengesDB
== Astronomical Databases Challenges == Modern astronomy undergoes a big change due to a new possibilities . . .
5K - last updated 2007-04-23 06:59 UTC by mira.sai.msu.ru
CASInstall
Instruction to install CAS: Prerequisites: * J2SDK 6.0 (J2SDK 1.4 and 5.0 will NOT work) * Apache Tomcat . . .
6K - last updated 2010-01-03 01:02 UTC by 89.208.228.69
1 Comment on sncat design
=== 1 Comment. === == How to load sn data == Я загружаю данные так: <pre> createdb . . .
2K - last updated 2006-02-15 23:25 UTC by megera
Delta About
= Компания "Дельта-Софт" = Наша компания состоит из группы . . .
4K - last updated 2005-02-21 01:19 UTC by megera
Delta Services
Основной особенностью нашей компании является то, что мы . . .
3K - last updated 2003-07-25 13:42 UTC by OlegBartunov
Diglib data types
== Специализированные типы данных для цифровых библиотек . . .
15K - last updated 2007-05-28 21:17 UTC by mira.sai.msu.ru
F502
<pre> 2.1. 02-07-90222 2.2. Bartunov Oleg Sergeevich 2.3. The development of Russian 'Astronet' . . .
2K - last updated 2004-01-08 16:32 UTC by megera
FTS Notes
== FTS Notes == These are the notes on PostgreSQL Full-Text Search engine. '''Notice''': Read my [[Tsearch2_83_changes]] . . .
7K - last updated 2008-05-02 13:27 UTC by mira.sai.msu.ru
FTS Todo
== FTS TODO == Features: * Prefix search - * Substring search - could be realized with special dictionary. . . .
1K - last updated 2007-06-04 08:52 UTC by mira.sai.msu.ru
GTSearch
== GTSearch == Some notes about Generic search engine. * [[gts_crawler]] - internet crawler * [[gts_indexer]] . . .
1K - last updated 2005-05-13 15:23 UTC by megera
Gendict
== Gendict - tsearch2 dictionary templates generator == This modules generates template for tsearch2 . . .
9K - last updated 2007-05-05 20:49 UTC by mira.sai.msu.ru
GetCovers
== GetCovers - see what did you find == Function ''get_covers(tsvector,query)'' marks extents (from ''tsvector'' . . .
1K - last updated 2006-02-11 22:08 UTC by megera
Gevel
== Gevel == '''Gevel''' contrib module provides several functions useful for analyzing GIN and GiST indexes. . . .
8K - last updated 2015-11-16 15:32 UTC by bb6b2f1e.virtua.com.br
GiST Algo
== GiST README == === Introduction === GiST stands for *Generalized Search Tree*. It was introduced in . . .
8K - last updated 2005-09-15 18:39 UTC by megera
GiST Concurrency Recovery
== GiST Concurrency & Recovery support in PostgreSQL == *UPDATES* ! We have submitted all changes . . .
6K - last updated 2005-09-08 11:35 UTC by megera
GiST internals
== GiST internals == === GiST internal interface === GiST interface to database is conformed to PostgreSQL . . .
4K - last updated 2005-11-03 17:38 UTC by megera
Gin
==Gin for PostgreSQL== <html> <div class="note"> Gin was sponsored by jfg://networks (http://www.jfg-networks.com/) . . .
6K - last updated 2008-04-04 12:26 UTC by mira.sai.msu.ru
GinFastUpdate
== GIN Fast Update == The idea of GIN fast update is to accumulate new index rows in separate location . . .
4K - last updated 2008-09-04 11:49 UTC by mira.sai.msu.ru
GinTest
== Test results of Generalized Inverted Index == '''Gin''' stands for generalized inverted index (not . . .
4K - last updated 2006-11-10 18:47 UTC by megera
GinTestUpdate
== Testing GIN update performance == For integer arrays GIN is 10x slower than GiST on '''update'''. . . .
4K - last updated 2008-08-26 09:51 UTC by mira.sai.msu.ru
Global service design
The global design of the system: There are 3 main components: * The database * The backend * The frontend . . .
3K - last updated 2006-03-23 15:31 UTC by megera
Hstore
== Hstore - contrib module for storing (key,value) pairs == [http://www.sai.msu.su/~megera/oddmuse/index.cgi?Hstore . . .
5K - last updated 2013-05-22 21:24 UTC by 137.122.64.68
IAU2006
==Development of SAI Catalog Access Services== We present the results of the development of Sternberg . . .
3K - last updated 2006-06-02 13:23 UTC by megera
LedaTips
== Leda Tips == * Get ''LIKE'' make use index for non-C locale <pre> cas=# create index design_idx . . .
2K - last updated 2006-02-28 14:51 UTC by megera
Lyra
== Lyra - high-precision multi-band photometric all sky survey == === Technical description === The goal . . .
15K - last updated 2009-11-15 08:08 UTC by toulouse.jfg-networks.net
MpegSlideShow
=== The problem === You have a bunch of jpg's and want to create slideshow with some music in background, . . .
1K - last updated 2005-03-08 14:40 UTC by megera
NewExtentsBasedRanking
== Extents based ranking for tsearch2 == * <b>Extent</b> is a ''shortest'' and ''non-nested'' . . .
6K - last updated 2007-09-11 07:16 UTC by mira.sai.msu.ru
OddMuse
Это клон [ http://c2.com/cgi/wiki?WikiEngines Wiki ] А живет этот клон -> http://emacswiki.wikiwikiweb.de/cgi-bin/oddmuse.pl . . .
1K - last updated 2003-06-17 23:05 UTC by OlegBartunov
OverBlogFts
== OverBlog full text search project == === Introduction === There is a big ''dynamical'' storage of . . .
3K - last updated 2006-04-21 21:43 UTC by megera
Pgsql
= PostgreSQL pages = * [[GiST]] - Generalized Search Tree forPostgreSQL. More information is available . . .
3K - last updated 2009-10-03 21:17 UTC by mira.sai.msu.ru
ReadmeTrgm
== trgm - Trigram matching for PostgreSQL == ----- === Introduction === This module is sponsored by Delta-Soft . . .
6K - last updated 2007-07-01 19:09 UTC by ppp85-140-157-147.pppoe.mtu-net.ru
SAI-VO-About
== About SAI VO development group == === in English === <html> <pre> Title: Informational . . .
5K - last updated 2006-05-27 14:38 UTC by megera
SAICASTODO
== General == * Collecting more catalogues -- right now I would like to have catalogues like 2DF, RC3 . . .
3K - last updated 2007-02-09 00:44 UTC by ioa-guest16.ast.cam.ac.uk
SideBar
<html> <script type="text/javascript"> function sh (id) { whichpost = document.getElementById(id); . . .
1K - last updated 2011-10-07 20:40 UTC by 95-28-123-154.broadband.corbina.ru
SkyPixelization
== Indexing the sky with PostgreSQL == === The Challenge === Scalable indexing of very big sky catalogues . . .
11K - last updated 2021-11-15 03:09 UTC by obartunov
SphereCube
http://www.cv.nrao.edu/fits/traffic/sciastrofits/saf.93/saf.9302 From: fred at manono.span (Fred Patt . . .
11K - last updated 2005-02-26 15:46 UTC by megera
TODO
== PostgreSQL TODO == Time is approximated and estimated for two of us Short list of todo items we plan . . .
5K - last updated 2011-05-27 22:35 UTC by toulouse.jfg-networks.net
Thesaurus dictionary
== Thesaurus dictionary == Status: [http://archives.postgresql.org/pgsql-committers/2006-05/msg00391.php . . .
6K - last updated 2006-10-26 14:48 UTC by megera
Tsearch2WhatsNew
==Tsearch2 - full text search extension for PostgreSQL== This document describes the new features introduced . . .
6K - last updated 2006-07-04 12:45 UTC by megera
Tsearch 84
== Tsearch for PostgreSQL 8.4 == From our [[TODO]] list: * DONE: Wildcard search ( a*b ) using permuted . . .
2K - last updated 2009-03-14 12:03 UTC by mira.sai.msu.ru
Tsearch V2 Notes
== Miscelaneous tsearch v2 notes by authors== === Tsearch2 Tips === ; tsquery concatenations tsquery . . .
19K - last updated 2007-04-09 12:27 UTC by mira.sai.msu.ru
Tsearch V2 Readme
== Tsearch2 - full text search extension for PostgreSQL == [http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/Tsearch_V2_Readme.html . . .
9K - last updated 2006-11-09 06:16 UTC by megera
Tsearch V2 compound words
== Support for compound words == This work was sponsored by [http://www.startsiden.no ABC Startsiden]. . . .
7K - last updated 2009-08-12 13:12 UTC by mira.sai.msu.ru
Tsearch V2 internals
== Tsearch2 internals == What is a GiST-based FTS index ? It's realized as a RD-tree with bit signatures . . .
4K - last updated 2007-05-12 22:06 UTC by mira.sai.msu.ru
Tycho
We're very interested in performance testing of pg_sphere, especially when we experiment with index contstructions. . . .
7K - last updated 2005-03-08 22:24 UTC by megera
UserCatalogs
Here I propose the SQL script creating the DB structure for the user's catalogues. To properly understand . . .
2K - last updated 2006-11-03 20:24 UTC by p57a5cc70.dip0.t-ipconnect.de
ZLine Dir all
Список "коммерческих" документов о ZLine ; ZLine Directory : [[ZLineDirectory]] . . .
1K - last updated 2005-05-31 06:04 UTC by user06.psiline.ru
astrobigdata
==Астрономия в эпоху Big Data== ===Введение=== Широко известный . . .
39K - last updated 2012-08-14 15:22 UTC by mira.sai.msu.ru
astronet2008
== Сервисно-ориентированная архитектура фундаментальной . . .
24K - last updated 2007-08-12 13:04 UTC by mira.sai.msu.ru
astronet2009
== Идеи для гранта РФФИ на 2009-2011 гг. == === Почему PostgreSQL ? === * . . .
79K - last updated 2008-09-18 14:41 UTC by mira.sai.msu.ru
big data
== BIG DATA == Наверное каждый из нас сталкивался с ситуацией, . . .
21K - last updated 2011-09-18 20:17 UTC by mira.sai.msu.ru
btree gin
== contrib/btree_gin == <pre> Teodor Sigaev and Oleg Bartunov <!-- $PostgreSQL: pgsql/doc/src/sgml/btree-gin.sgml,v . . .
2K - last updated 2010-01-14 08:59 UTC by mira.sai.msu.ru
eee901
== my eee901 === 1. I use original Xandros 2. I have to add 'xset r' to enable key repetion under X 3. . . .
1K - last updated 2008-09-11 15:12 UTC by mira.sai.msu.ru
initdb
<pre> # ru.po # INITDB Translated Messages into the Russian Language (KOI8-R) # # Copyright (c) . . .
21K - last updated 2005-01-07 17:24 UTC by megera
intarray tutorial
== Intarray tutorials by Achilleus Mantzios == <pre> Arrays in postgresql are sometimes a good . . .
4K - last updated 2005-11-02 22:02 UTC by megera
ivoa wg
== Assorted notes about VO (Virtual Observatory) == VO с технологической точки зрения . . .
39K - last updated 2010-04-02 11:37 UTC by mira.sai.msu.ru
pg 2011
== Исследование алгоритмов поиска слабо-структурированной . . .
87K - last updated 2011-09-18 20:26 UTC by mira.sai.msu.ru
pg 8 admin
<html> <h1>III. Админинстрирование сервера</h1> <p>В . . .
6K - last updated 2005-02-09 14:15 UTC by kuzma
pg dump
<pre> # ru.po # PG_DUMP Translated Messages into the Russian Language (KOI8-R) # # Copyright (c) . . .
66K - last updated 2005-01-07 17:06 UTC by megera
pgnpp
== О Национальной СУБД == === О выборе СУБД === Выбор Национальной . . .
15K - last updated 2011-09-10 20:16 UTC by mira.sai.msu.ru
pgsql tips
== Короткие и полезные заметки по работе с PostgreSQL == * Как сделать, . . .
16K - last updated 2007-06-12 07:15 UTC by ppp85-140-158-213.pppoe.mtu-net.ru
pgsql tools
== Assorted list of tools for PostgreSQL == * [http://pgfouine.projects.postgresql.org pgfouine] - log . . .
2K - last updated 2007-06-19 01:51 UTC by ppp85-140-159-9.pppoe.mtu-net.ru
pgsql tutorial
==Использование PostgreSQL== Предполагается знание основ реляционных . . .
12K - last updated 2007-04-09 16:17 UTC by mira.sai.msu.ru
pgweb cfg
== This is an example configuration == Short description: # create new ''default'' configuration 'pg'. . . .
5K - last updated 2006-12-21 18:25 UTC by megera
psql
<pre> # ru.po # PSQL Translated Messages into the Russian Language (KOI8-R) # # Copyright (c) 2001-2004 . . .
92K - last updated 2005-01-13 19:37 UTC by megera
rbtree test
== Rbtree testings == gin index utilizes maintenance_work_mem for bulk insert to gin index (CREATE INDEX . . .
6K - last updated 2010-02-04 16:14 UTC by mira.sai.msu.ru
relation features
== Реляционная модель == В статье Кодда (1970) были сформулированы . . .
2K - last updated 2005-03-24 13:03 UTC by megera
report2009
== Отчет о проделанной работе за 2009 год == == Nature == Текст для . . .
4K - last updated 2010-01-14 12:25 UTC by mira.sai.msu.ru
report2009summary
== Краткий научный отчет за 2009 год == == Nature == В 2009 году исследования . . .
20K - last updated 2010-01-15 08:59 UTC by mira.sai.msu.ru
rtdb
== Real-Time Database Engine for Geo-Spatial data == Всемерное проникновение информационных . . .
6K - last updated 2012-02-20 20:25 UTC by 95-28-7-182.broadband.corbina.ru
sai-rvo-report1
== SAI RVO Project Report 2005 == Russian Virtual Observatory was founded in 2002. However there was . . .
3K - last updated 2005-09-26 11:47 UTC by megera
savepoints
<html> <div align="justify"> Джошуа Д. Дрейк: Оригинал на <a href="http://www.devx.com/dbzone/Article/22119" . . .
11K - last updated 2005-01-26 14:02 UTC by megera
sci data bib
Специальное издание "Data, data everywhere", The Economist, Feb 25th 2010 http://www.economist.com/node/15557443 . . .
6K - last updated 2011-08-22 13:08 UTC by mira.sai.msu.ru
scidb.ru-about
== Scidb.ru == === Введение === Во многих областях науки происходит . . .
44K - last updated 2010-04-10 21:31 UTC by mira.sai.msu.ru
sncat design
== SAI SN catalogue design == * [http://mira.sai.msu.su/~megera/sn/sncat/design Development version] . . .
8K - last updated 2006-04-25 20:11 UTC by megera
socionetInstall
Server msk.socionet.ru ( /home/astronet/app/www ) Testing postgreSQL 8.2.3: about 530tps with fsync=0, . . .
13K - last updated 2007-06-09 05:59 UTC by mira.sai.msu.ru
spgist dev
== SP-GiST for hackers == SP-GiST is an abbreviation of space-partitioned GiST - the search tree, which . . .
10K - last updated 2011-10-07 16:23 UTC by mira.sai.msu.ru
todo
== TODO items == Our [[TODO|new TODO]] list === PostgreSQL === Participants: * [http://www.sai.msu.su/~megera/ . . .
12K - last updated 2008-04-17 13:15 UTC by 85.113.152.130
tp search doc
Check [[tp_search_en]] for explanation of fts technique implemented in this project. === Configuration . . .
12K - last updated 2005-11-02 06:57 UTC by megera
tp search en
== FTS with most maximum completeness and relevancy algorithm using tsearch2 == === The Theory === The . . .
6K - last updated 2005-10-26 15:47 UTC by megera
tprewriter
== tprewriter - sophisticated query rewriter for tsearch2 == This module was designed specially for travelpost . . .
5K - last updated 2005-11-02 07:14 UTC by megera
tsearch-v2-intro
== Tsearch2 - Introduction == [http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html . . .
42K - last updated 2006-10-24 06:37 UTC by megera
tsearch2slides
= Gentle introduction to the Full Text Search with Tsearch2 = * Modern information systems are all database . . .
26K - last updated 2006-11-12 05:40 UTC by megera
wildspeed
== WildSpeed - fast wildcard search for LIKE operator == Wildspeed extension provides [[Gin|GIN]] index . . .
5K - last updated 2018-10-11 10:02 UTC by 93.174.131.141
101 pages found.