![[Home]](/~megera/oddmuse/zen3.gif)
2003-06-19
Потестировал текущую версию [[pg_sphere]]. Подготовил базу географических . . .
2K - last updated 2003-06-19 15:52 UTC by OlegBartunov
2005-02-25
Finally, I got an idea how to make link to actions without namespaces.pl. I decided to get rid namespaces.pl . . .
1K - last updated 2005-02-25 21:08 UTC by megera
2006-02-22
== Music I'm listening now == * Calexico * Giant Sand * Howe Gelb * Andrew Bird * Placebo * Friends of . . .
2K - last updated 2007-02-14 19:24 UTC by megera
2007-12-20
== Supernovae in empty space == Just read [[http://space.newscientist.com/article/dn13100-cosmic-explosion-detonates-in-empty-space.html . . .
1K - last updated 2007-12-20 20:49 UTC by ppp85-140-158-140.pppoe.mtu-net.ru
2009-03-22
== astronet.ru selected stats == <pre> megera@mira:~/app/astronet/logs $>wc astronet-visitors.log . . .
1K - last updated 2009-03-23 20:17 UTC by ppp91-76-237-154.pppoe.mtu-net.ru
2009-05-06
== Return to Moscow from Nepal == 13 hours flight from Kathmandu to Moscow by Qatar, no problem, except . . .
4K - last updated 2009-07-12 15:15 UTC by mira.sai.msu.ru
2009-07-13
== Annapurna 2 == Update: Selected Nepal pictures available on [[http://www.flickr.com/photos/obartunov/sets/72157621843537740/ . . .
1K - last updated 2009-08-11 10:49 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
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
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
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
CAS
== SAI CAS Project == *CAS* stands for ''Catalog Access Services''. It is the set of different interfaces . . .
2K - last updated 2010-01-03 01:00 UTC by 89.208.228.69
1 Comment on DBdesign
=== 1 Comment. === * Oleg: Use plural forms for table names and *_*_map for maps * Oleg: Use SQL (\dt+ . . .
1K - last updated 2006-01-05 14:37 UTC by megera
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
Diglib data types
== Специализированные типы данных для цифровых библиотек . . .
15K - last updated 2007-05-28 21:17 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
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
HomePage
== Попробуем: == === Заголовок === ==== Заголовок 4 ==== Что такое . . .
1K - last updated 2003-06-16 13:05 UTC by OlegBartunov
HowTo
Документация находится [ http://www.sai.msu.su/~megera/oddmuse/org ] . . .
1K - last updated 2003-06-17 23:00 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
InterMap
Zen /~megera/wiki/? . . .
1K - last updated 2006-07-16 14:16 UTC by megera
Links
== Assorted links === See my [http://www.sai.msu.su/~megera/#links IR links] * [http://dblp.uni-trier.de/xml/ . . .
1K - last updated 2005-09-12 21:08 UTC by megera
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
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
README q3c
== Q3C == Idea and realization by Sergey Koposov, Sternberg Astronomical Institute, Moscow University. . . .
4K - last updated 2006-12-04 01:10 UTC by p57a5bb97.dip0.t-ipconnect.de
R pgsql
== R and PostgreSQL == Adapted from http://grass.itc.it/statsgrass/r_and_dbms.html === Installation === . . . host="localhost", dbname="cas", user="megera") > snquery = dbSendQuery(conn, "select . . .
1K - last updated 2006-10-03 14:33 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 SN
== SAI-MSU SN (Supernovae) Research Group == For official information see [[http://www.sai.msu.su/sn/ . . .
1K - last updated 2006-06-12 16:58 UTC by megera
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
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
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
X 2005-02-21
=== 1 Comment. === написал автору, может он чего подскажет. -- megera . . .
1K - last updated 2005-02-21 19:12 UTC by megera
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
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
discovery mp test
== Тестируем Discovery (MP) == <html> <div class="note"> <b>Update:</b>Чтобы . . .
8K - last updated 2006-04-07 14:51 UTC by megera
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
mergejoin
== merge join problem == Two tables (xx -234839 rows), yy - 600 rows) with identical scheme ([[http://www.sai.msu.su/~megera/postgres/files/mergejoin.dump.gz . . .
3K - last updated 2010-02-19 12:58 UTC by mira.sai.msu.ru
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 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
pgsql cluster
* [[prerequisites]] - что нам потребуется * [[configuration]] - настройка * . . .
1K - last updated 2005-03-21 18:48 UTC by slynko
pgsql history
Я написал статью для конференции по корпоративным базам . . .
1K - last updated 2005-04-02 18:39 UTC by megera
pgsql tips
== Короткие и полезные заметки по работе с PostgreSQL == * Как сделать, . . .
16K - last updated 2007-06-12 07:15 UTC by ppp85-140-158-213.pppoe.mtu-net.ru
pgsql tutorial
==Использование PostgreSQL== Предполагается знание основ реляционных . . .
12K - last updated 2007-04-09 16:17 UTC by mira.sai.msu.ru
pgsql tutorial ru
== Сборник пособий по PostgreSQL == Здесь находятся рабочие материалы . . .
1K - last updated 2007-06-05 20:01 UTC by ppp85-140-158-22.pppoe.mtu-net.ru
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
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
scripts
<pre> # ru.po # PGSCRIPTS Translated Messages into the Russian Language (KOI8-R) # # Copyright . . .
23K - last updated 2005-01-07 17:16 UTC by megera
snap sai
=== SAI SNAP proposal === SNAP stands for Supernova / Acceleration Probe projects which aims to solve . . .
3K - last updated 2006-01-26 11:48 UTC by megera
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
sncat research list
== Supernovae catalogue research list == The main purpose of our catalogue is not just maintenance a . . .
2K - last updated 2006-01-22 22:34 UTC by megera
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 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
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
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
73 pages found.
