2003-06-16
сегодня был фиговый день. Горло болело. Разбирался с Wiki, . . .
1K - last updated 2003-06-17 15:14 UTC by OlegBartunov
2003-06-19
Потестировал текущую версию [[pg_sphere]]. Подготовил базу географических . . .
2K - last updated 2003-06-19 15:52 UTC by OlegBartunov
2006-02-16
== Simple perl script to query sn database == Very generic perl script, lets name ''getsn.pl'' :) <pre> . . .
3K - last updated 2006-02-16 09:24 UTC by megera
2006-03-17
== Separate command-line histories for psql == <pre> Date: Fri, 17 Mar 2006 12:04:04 -0500 (EST) . . .
1K - last updated 2006-03-17 17:07 UTC by megera
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-11-06
[http://www.databasecolumn.com/ DataBase Column] - блог известных спецов в области . . .
1K - last updated 2007-11-06 18:24 UTC by mira.sai.msu.ru
2008-08-26
== MapReduce and PostgreSQL == Yesterday I was informed about AsterDB (asterdata.com), also PostgreSQL . . .
1K - last updated 2008-08-26 07:09 UTC by mira.sai.msu.ru
2009-02-14
== pg_reorg - кластеризация таблицы в онлайне ! == Всем известно, . . .
2K - last updated 2009-02-14 20:43 UTC by mira.sai.msu.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-07-21
== HadoopDB == Very interesting announcement [[http://dbmsmusings.blogspot.com/2009/07/announcing-release-of-hadoopdb-longer.html . . .
1K - last updated 2009-07-22 15:20 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
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
Astronet
Описание переноса астронета с eol на amon - файловое хранилище . . .
1K - last updated 2003-07-23 18:48 UTC by torus.sai.msu.ru
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
CASDB
== Notes to CAS server DB design == === Phase II by Sega === The wordy description of the DB: 1) Our . . .
5K - last updated 2006-11-03 19:29 UTC by p57a5cc70.dip0.t-ipconnect.de
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 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
DB
== DB References == === XA interface === * [http://www.jroller.com/page/pyrasun/20040105#xa_exposed XA . . .
1K - last updated 2005-12-21 21:24 UTC by megera
DBdesign
This notes were born during the discussion in SAI on Jan 2, 2006. == Notes to CAS server DB design == . . .
2K - last updated 2006-01-07 13:21 UTC by megera
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
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
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
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
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
LoadingSDSS
Input Data: * The set of SQL scripts defining the SDSS schema * The set of CSV files of some sample data . . .
5K - last updated 2006-05-25 23:32 UTC by dslb-084-056-238-179.pools.arcor-ip.net
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
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 === . . .
1K - last updated 2006-10-03 14:33 UTC by megera
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
SAI RVO
== SAI VO Development == === Current Projects ==== * [[CAS]] - SAI CAS Project ( [http://vo.astronet.ru/cas/ . . .
2K - last updated 2007-08-16 09:50 UTC by mira.sai.msu.ru
SandBox
Тренируйтесь сколько угодно: = Заголовок = == Чуть меньше . . .
1K - last updated 2003-06-19 04:30 UTC by OlegBartunov
SciDB
== Система управления сверхбольшими базами научных данных . . .
35K - last updated 2009-10-12 04:15 UTC by ppp91-77-33-166.pppoe.mtu-net.ru
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
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
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
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 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
TwoServerSetup
The setup of the infrastructure with one CAS application server (Backend) and one separated dedicated . . .
2K - last updated 2006-03-04 04:22 UTC by dslb-084-057-242-053.pools.arcor-ip.net
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 GTSearch
== GTSearch: платформа для создания специализированных и вертикальных . . .
27K - last updated 2005-05-08 10:29 UTC by user06.psiline.ru
ZLine GTSearch choose Delta
Если вам надоело, что на введенное в поисковую строку слово, . . .
6K - last updated 2005-05-31 13:21 UTC by irish.sai.msu.ru
astrobigdata
==Астрономия в эпоху Big Data== ===Введение=== Широко известный . . .
39K - last updated 2012-08-14 15:22 UTC by mira.sai.msu.ru
astrodictadd
На этой страничке копятся добавления к астрономическому . . .
1K - last updated 2007-03-28 04:47 UTC by mira.sai.msu.ru
astronet-zeon
== Репликация Astronet с eol на zeon == Требуется обеспечить реплицирование . . .
9K - last updated 2005-03-11 16:01 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
astronet internals
== Внутренности Астронета == 1. Вот так получаем основные . . .
1K - last updated 2010-02-22 00:23 UTC by mira.sai.msu.ru
astronomy vs astrology
В 2011 году была у нас статью [http://www.astronet.ru/db/msg/1250539 Астрономия, . . .
3K - last updated 2013-12-24 19:14 UTC by bunnyhop
big data
== BIG DATA == Наверное каждый из нас сталкивался с ситуацией, . . .
21K - last updated 2011-09-18 20:17 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
configuration
* Никакой предварительной настройки OpenSSL не требуется * . . .
6K - last updated 2005-03-02 16:41 UTC by slynko
discovery mp test
== Тестируем Discovery (MP) == <html> <div class="note"> <b>Update:</b>Чтобы . . .
8K - last updated 2006-04-07 14:51 UTC by megera
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
<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
itchecklist
==IT-checklist== Список вопросов, необходимых для технологического . . .
11K - last updated 2007-10-08 14:22 UTC by mira.sai.msu.ru
ivoa wg
== Assorted notes about VO (Virtual Observatory) == VO с технологической точки зрения . . .
39K - last updated 2010-04-02 11:37 UTC by mira.sai.msu.ru
online-backup
Целью данной заметки является демонстрация того, как с . . .
10K - last updated 2005-03-22 09:17 UTC by slynko
pg 2011
== Исследование алгоритмов поиска слабо-структурированной . . .
87K - last updated 2011-09-18 20:26 UTC by mira.sai.msu.ru
pg 8 installation
<html> <H1><A></A>Глава 14. Инструкции по установке</H1> . . .
2K - last updated 2005-02-11 11:48 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
pgdb
Национальная СУБД (НСУБД) должна основываться на свободно . . .
5K - last updated 2011-01-26 19:39 UTC by 93-80-70-250.broadband.corbina.ru
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 pitr
== PITR example == Point In Time Recovery provides a possibility to use plain file-level commands ( ''cp'', . . .
1K - last updated 2005-03-22 14:53 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 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
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
q3c adass abstract
*Authors*: Koposov Sergey, Bartunov Oleg *Title*: New indexing concept for very big astronomical catalogues . . .
2K - last updated 2005-07-05 21:26 UTC by megera
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
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-nano
== Приложение SciDB для нанотехнологии == === Наименование проектa . . .
11K - last updated 2010-11-30 15:15 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
scidb scientific challenges
== Научные вызовы технологиям СУБД == === Введение === Повсеместное . . .
46K - last updated 2010-04-12 18:22 UTC by ppp91-77-105-142.pppoe.mtu-net.ru
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
shron
== Центр данных МГУ == Данная записка предлагается как обоснование . . .
17K - last updated 2010-01-31 19:33 UTC by mira.sai.msu.ru
sncat README
== SAI Supernovae Catalog README == This catalogue is an export version of [http://www.sai.msu.su/sn/sncat/ . . .
2K - last updated 2006-05-25 10:01 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
sncatupdate
== How to restrict access ?== It's easy. For example, restrict access to ''sncatupdate.cgi'' * Apache's . . .
1K - last updated 2006-04-25 21:25 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
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
ts changes
== Summary of changes == patch v. 0.58 === TEXT SEARCH CONFIGURATION === 1. GUC variable default_text_search_config . . .
6K - last updated 2007-07-26 08:39 UTC by mira.sai.msu.ru
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
tsearchd
== tsearchd - full text search daemon for PostgreSQL == This is a tsearch2 daemon ( for PostgreSQL 8.1.X . . .
3K - last updated 2006-01-19 19:12 UTC by megera
unaccent
== Unaccent == This module provides unaccent text search dictionary and function to remove accents from . . .
2K - last updated 2009-03-16 15:55 UTC by mira.sai.msu.ru
111 pages found.