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-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
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
2009-02-14
== pg_reorg - кластеризация таблицы в онлайне ! == Всем известно, . . .
2K - last updated 2009-02-14 20:43 UTC by mira.sai.msu.ru
2009-03-14
== CSV output == Надо было сделать подвыборку не всех полей из . . .
1K - last updated 2009-03-14 16:18 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-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-08-12
== Algebra for full-text queries == We introduce *phrase operator* ?[n], or phrase conjuction operator, . . .
4K - last updated 2009-09-08 11:42 UTC by mira.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
CASCurrentServices
By now (Nov 3, 2006) the following WebServices were implemented<BR> * The set of Catalog query . . .
1K - last updated 2006-11-03 20:20 UTC by p57a5cc70.dip0.t-ipconnect.de
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
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
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
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 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
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
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
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
Motivation
The motivation to build CAS (catalog access service) * Any serious VO application requires access to . . .
1K - last updated 2006-03-12 22:35 UTC by megera
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
R pgsql
== R and PostgreSQL == Adapted from http://grass.itc.it/statsgrass/r_and_dbms.html === Installation === . . . dbConnect(PgSQL(), host="localhost", dbname="cas", user="megera") > snquery = dbSendQuery(conn, . . .
1K - last updated 2006-10-03 14:33 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
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
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
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 in Brief
; Tsearch2 configuration: There are four tables in system catalog <pre> =# \d pg_ts_cfg Table "public.pg_ts_cfg" . . .
5K - last updated 2006-03-03 13:42 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
TwoServerSetup
The setup of the infrastructure with one CAS application server (Backend) and one separated dedicated . . . IP of the DB (212.192.x.y), the name of database "cas"", the name of the user "cas_user" and the password . . .
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
XMLCatalog
Here I describe the XML format which I propose for loading new data into CAS. Also I describe the technology . . .
18K - last updated 2006-11-03 19:31 UTC by p57a5cc70.dip0.t-ipconnect.de
astrobigdata
==Астрономия в эпоху Big Data== ===Введение=== Широко известный . . .
39K - last updated 2012-08-14 15:22 UTC by mira.sai.msu.ru
astroinformatika
== Астроинформатика == 3-4 курс * Введение в астроинформатику . . .
1K - last updated 2012-12-03 21:25 UTC by 0895026305.static.corbina.ru
bloom
== Bloom index == contrib/bloom provides signature file based index. Authors: Teodor Sigaev (teodor@sigaev.ru) . . .
4K - last updated 2010-01-14 08:40 UTC by mira.sai.msu.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
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
pg 8 install requirements
<html> <H1><A NAME="INSTALL-REQUIREMENTS">14.2. Требования</A></H1> . . .
10K - last updated 2005-02-15 10:23 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
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
report2009summary
== Краткий научный отчет за 2009 год == == Nature == В 2009 году исследования . . .
20K - last updated 2010-01-15 08:59 UTC by mira.sai.msu.ru
sai-rvo-report2006
== SAI RVO Project Report 2006 == Project participants: * Oleg Bartunov - PI, SAI MSU, Russia * Sergey . . .
2K - last updated 2006-12-01 10:30 UTC by linproxy.mpia-hd.mpg.de
saicas2
== Проект SAI CAS (Catalog Access Services) == Виртуальная Обсерватория . . .
19K - last updated 2006-07-19 09:13 UTC by megera
scidb scientific challenges
== Научные вызовы технологиям СУБД == === Введение === Повсеместное . . .
46K - last updated 2010-04-12 18:22 UTC by ppp91-77-105-142.pppoe.mtu-net.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
sncat proposal
== New supernovae catalogue proposal == <blockquote> '''Note:''' This is a WIP (work in progress) . . .
4K - last updated 2006-03-08 16:59 UTC by megera
snrad queries
== Supernovae radial distribution == Now, we have ''sndist'' function,developed by <b>''Gala''</b> . . .
4K - last updated 2006-06-21 19:54 UTC by megera
soa for astronomy
== Сервисно-ориентированная архитектура для астрономии . . .
22K - last updated 2008-09-13 19:43 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
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
tsearch2dev82
* Does casting to tsvector and to_tsvector should produce the same result (for current configuration) . . .
1K - last updated 2006-01-12 16:46 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
64 pages found.