2003-06-19
Потестировал текущую версию [[pg_sphere]]. Подготовил базу географических . . .
2K - last updated 2003-06-19 15:52 UTC by OlegBartunov
2006-03-05
== PostgreSQL: about system attributes - tableoid,oid,ctid == ''tableoid'' is the oid of a table, oid . . .
2K - last updated 2006-03-05 20:53 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
2008-12-30
== Window function in the CVS HEAD (8.4) ! == Window function (SQL 2003) - one of the very interesting . . .
1K - last updated 2008-12-30 20:56 UTC by ppp85-140-157-129.pppoe.mtu-net.ru
2009-03-13
== New cool text search features for 8.4+== * We added support of filtering dictionaries Contrary to . . .
2K - last updated 2009-03-16 16:02 UTC by mira.sai.msu.ru
2009-03-25
== hstore rulez ! == It's pleasantly to see new activity around our contribution [[Hstore]]. See http://archives.postgresql.org/pgsql-hackers/2009-03/msg00940.php . . .
1K - last updated 2009-03-25 04:27 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-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
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
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
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 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
Methodology
==Соглашения для русского перевода сообщений .po файлов== . . .
2K - last updated 2005-01-05 04:28 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
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
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
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
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
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
Tips
* collections.conf should be saved in conf directory * skipwords.{ru,en} - used only for abstract generation . . .
1K - last updated 2004-01-09 18:09 UTC by 213.171.50.82
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 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
adql
===XSLT transformation from ADQL/x to SQL dialects=== by Ivan Zolotuhkin ADQL, which stands for Astronomical . . .
6K - last updated 2005-09-11 18:35 UTC by megera
astronet-zeon
== Репликация Astronet с eol на zeon == Требуется обеспечить реплицирование . . .
9K - last updated 2005-03-11 16:01 UTC by megera
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
configuration
* Никакой предварительной настройки OpenSSL не требуется * . . .
6K - last updated 2005-03-02 16:41 UTC by slynko
count problem
== Почему count(*) медленный ? == Очень кратко: из-за MVCC (многоверсионности). . . .
1K - last updated 2005-04-08 20:32 UTC by megera
gts
== GTS Tips and tricks == *[[Tips]] - read here *[[Fragments]] - что такое фрагменты . . .
4K - last updated 2005-01-29 19:01 UTC by megera
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
libpq
<pre> # ru.po # LIBPQ Translated Messages into the Russian Language (KOI8-R) # # Copyright (c) . . .
24K - last updated 2005-01-13 19:47 UTC by megera
online-backup
Целью данной заметки является демонстрация того, как с . . .
10K - last updated 2005-03-22 09:17 UTC by slynko
pg80-pr-en
November/December 2004 - The PostgreSQL Global Development group has released version 8.0 of the PostgreSQL . . .
5K - last updated 2004-12-14 11:46 UTC by megera
pg80-pr-ru
Ноябрь/Декабрь 2004 - Международная команда разработчиков . . .
9K - last updated 2004-11-18 09:42 UTC by megera
pg91
== Эффективный поиск ближайших соседей и другие новые средства . . .
15K - last updated 2011-04-13 15:35 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 config
<pre> # ru.po # PG_CONFIG Translated Messages into the Russian Language (KOI8-R) # # Copyright . . .
6K - last updated 2005-01-07 17:12 UTC by megera
pg controldata
<pre> # ru.po # PG_CONTROLDATA Translated Messages into the Russian Language (KOI8-R) # # $PostgreSQL: . . .
8K - last updated 2005-01-07 17:47 UTC by megera
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 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
pg resetxlog
<pre> # ru.po # PG_RESETXLOG Translated Messages into the Russian Language (KOI8-R) # # $PostgreSQL: . . .
11K - last updated 2005-01-07 17:14 UTC by megera
pgnpp
== О Национальной СУБД == === О выборе СУБД === Выбор Национальной . . .
15K - last updated 2011-09-10 20:16 UTC by mira.sai.msu.ru
pgsql bitmap index
== Bitmap index == * Bitmap индексы появились в версии 8.1 * Это ''служебные . . .
4K - last updated 2006-03-25 09:42 UTC by megera
pgsql cluster
* [[prerequisites]] - что нам потребуется * [[configuration]] - настройка * . . .
1K - last updated 2005-03-21 18:48 UTC by slynko
pgsql cooking book
== Рецепты PostgreSQL == <html> <div class="admonition-note admonition"> <p class="first . . .
4K - last updated 2005-10-25 15:12 UTC by 83.102.141.18
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 timing
== Как оценить производительность ? == Всех всегда интересует . . .
3K - last updated 2005-04-23 18:56 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 training admin
== Краткий курс администратора PostgreSQL == * Введение ** Краткая . . .
3K - last updated 2007-06-06 15:18 UTC by mira.sai.msu.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
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
prerequisites
== Пререквизиты == Что нам потребуется ? * PostgreSQL версии 8 ( можно . . .
3K - last updated 2006-03-04 07:53 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
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
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
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
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
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
80 pages found.