2003-06-19
Потестировал текущую версию [[pg_sphere]]. Подготовил базу географических . . .
2K - last updated 2003-06-19 15:52 UTC by OlegBartunov
2003-06-22
Looks like we're getting new project - CC for GiST. For a long time we planned to implement Concurrency . . .
1K - last updated 2003-06-22 14:40 UTC by OlegBartunov
2006-05-24
== Generation of random test data == I need to generate data for testing of multicolumn GiST indices, . . .
1K - last updated 2006-05-24 20:30 UTC by megera
2008-03-18
== Capital letters in smartphones == I was so dumb, I didn't know how to input capital letters in smartphones . . .
1K - last updated 2008-03-20 11:11 UTC by mira.sai.msu.ru
2008-06-14
== Some news == It was very nice to knew that Yahoo China uses PostgreSQL and even more - it widely uses . . .
1K - last updated 2008-06-14 17:02 UTC by ppp85-140-157-233.pppoe.mtu-net.ru
2009-01-11
== Развитие СУБД PostgreSQL в 2008 году == Олег Бартунов, Федор Сигаев . . .
10K - last updated 2009-01-14 15:24 UTC by mira.sai.msu.ru
2009-11-25
==K-nn search in PostgreSQL== *Update:* Download [[http://www.sai.msu.su/~megera/postgres/files/spots.dump.gz . . .
4K - last updated 2010-02-12 20:18 UTC by ppp91-77-104-184.pppoe.mtu-net.ru
2010-10-03
== Опыт участия в разработке открытой СУБД PostgreSQL == Олег Бартунов . . .
8K - last updated 2010-10-04 17:35 UTC by ppp85-141-216-161.pppoe.mtu-net.ru
ADT
* [http://www.unipi.gr/faculty/ytheod/pubs/talks/ADBIS2002_theodoridis.pdf cR-tree] - node splitting . . .
1K - last updated 2005-10-15 13:40 UTC by megera
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
Bench
;Scripts: * [http://www.sai.msu.su/~megera/postgres/gist/pg_sphere/bench/gentst.pl gentst.pl] - data . . .
2K - last updated 2003-07-31 08:58 UTC by OlegBartunov
Categories
* [[Pgsql]] * [[GiST]] - The Generalized Search Tree * [[Tsearch2]] - Full-text search in PostgreSQL . . .
1K - last updated 2007-05-04 15:57 UTC by mira.sai.msu.ru
Comments
Список стандартных сочетаний и их перевод. В дальнейшем . . .
4K - last updated 2005-01-21 14:26 UTC by megera
Cookbook contents
== Подробное оглавление == === Глава 1: Администрирование === . . .
2K - last updated 2005-10-25 15:17 UTC by 83.102.141.18
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
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
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
Discussion and docs about GiST based contrib modules for [http://www.postgresl.org PostgreSQL]. See [http://www.sai.msu.su/~megera/postgres/gist . . .
2K - last updated 2010-01-13 13:51 UTC by mira.sai.msu.ru
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
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
HomePage
== Попробуем: == === Заголовок === ==== Заголовок 4 ==== Что такое . . .
1K - last updated 2003-06-16 13:05 UTC by OlegBartunov
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
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
OpenFTSUpgrade
Problem: Upgrade mailing list archive (http://fts.postgresql.org) running OpenFTS based on tsearch v2 . . .
3K - last updated 2003-06-19 17:57 UTC by OlegBartunov
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
Pgsql Glossary
Глоссарий по терминам PostgreSQL. * ОБЩИЕ ТЕРМИНЫ ** Хранилище . . .
4K - last updated 2007-06-11 10:19 UTC by ppp85-140-156-113.pppoe.mtu-net.ru
PosGIS and Grass
== Visualising GiST index geometry with PostGIS and GRASS GIS == === Author === * Bernhard Hoefle <bernhard.hoefle@uibk.ac.at>, . . .
3K - last updated 2006-01-20 08:28 UTC by megera
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
Rtree Index
It's interesting to see partitioning of GiST tree. Using gevel contrib module it's easy task. * Download . . .
3K - last updated 2005-06-23 12:48 UTC by megera
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
SiteMap
'''Contact me ( oleg@sai.msu.su ) for editor access !''' * [[Pgsql]] - general PostgreSQL pages * [[Tsearch2]] . . .
1K - last updated 2008-06-19 13:04 UTC by mira.sai.msu.ru
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
SphereLinks
Some links: See also [[SkyPixelization]] for Q3C method of indexing large spherical data. * [http://www.cs.purdue.edu/homes/aref/dbsystems_files/SP-GiST/ . . .
2K - last updated 2005-02-26 10:05 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
Teodor
http://www.sai.msu.su/~megera/postgres/gist/Sigaev-small.jpg <br> А это [http://www.sigaev.ru . . .
1K - last updated 2005-02-21 01:59 UTC by megera
Tsearch2
== Tsearch V2 - full text extension for PostgreSQL == [http://www.postgresql.org/docs/current/static/textsearch.html . . .
3K - last updated 2009-03-13 19:48 UTC by ppp85-141-216-204.pppoe.mtu-net.ru
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 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
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
conf2007
== List of conferences 2007 == This is a list of conferences in 2007 year * [http://www.rit2007.ru/ RIT . . .
2K - last updated 2007-06-29 13:58 UTC by mira.sai.msu.ru
grantideas
== VO == * terabyte databases * integration with existing applications via PLASTIC * registry * fts for . . .
1K - last updated 2007-08-08 18:40 UTC by ppp85-140-159-234.pppoe.mtu-net.ru
intarray
<pre> This is an implementation of RD-tree data structure using GiST interface of PostgreSQL. It . . .
5K - last updated 2005-01-27 13:58 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
knngist
== knngist - contrib module for k-nearest neighbourhood search == *Update:* See [[2009-11-25]] for recent . . .
11K - last updated 2010-02-07 15:48 UTC by mira.sai.msu.ru
knngist rit2011
== Эффективный поиск ближайших соседей в PostgreSQL == Абстракт . . .
7K - last updated 2011-04-26 19:48 UTC by mira.sai.msu.ru
online-backup
Целью данной заметки является демонстрация того, как с . . .
10K - last updated 2005-03-22 09:17 UTC by slynko
pg91
== Эффективный поиск ближайших соседей и другие новые средства . . .
15K - last updated 2011-04-13 15:35 UTC by mira.sai.msu.ru
pg 2011
== Исследование алгоритмов поиска слабо-структурированной . . .
87K - last updated 2011-09-18 20:26 UTC by mira.sai.msu.ru
pg ctl
Prolems: * unregister <pre> # ru.po # PG_CTL Translated Messages into the Russian Language (KOI8-R) . . .
18K - last updated 2005-01-13 19:26 UTC by megera
pg sphere
pgSphere provides spherical data types, functions and operators for PostgreSQL. This project is hosted . . .
1K - last updated 2005-03-08 22:21 UTC by megera
pgnpp
== О Национальной СУБД == === О выборе СУБД === Выбор Национальной . . .
15K - last updated 2011-09-10 20:16 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
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
report2010
== Отчет о работе за 2010 год == Схематичное перечисление: * . . .
13K - last updated 2010-12-12 14:35 UTC by mira.sai.msu.ru
rffi4
4.1.Фундаментальная научная проблема, на решение которой . . .
55K - last updated 2005-09-18 16:11 UTC by megera
saicas2
== Проект SAI CAS (Catalog Access Services) == Виртуальная Обсерватория . . .
19K - last updated 2006-07-19 09:13 UTC by megera
scidb.ru-about
== Scidb.ru == === Введение === Во многих областях науки происходит . . .
44K - last updated 2010-04-10 21:31 UTC by mira.sai.msu.ru
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
todo2011
== Список проектов на 2011 год == Список проектов, которые мы . . .
2K - last updated 2010-12-14 16:41 UTC by mira.sai.msu.ru
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
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
vo intro
== Виртуальная Обсерватория для "чайников" == === Введение . . .
6K - last updated 2007-01-18 06:16 UTC by megera
83 pages found.