Re: [HACKERS] Cube extension kNN support

Do you have any benchmarks ? On Mon, Sep 23, 2013 at 3:38 AM, Stas Kelvich wrote: > Hello, hackers. > > Here is the patch that introduces kNN search for cubes with euclidean, > taxicab and chebyshev distances. > > Following distance operators introduced: > > <#> taxicab distance > <-> euclidean

Re: [HACKERS] WIP: Rework access method interface

On Fri, Sep 11, 2015 at 4:22 PM, Alexander Korotkov < a.korot...@postgrespro.ru> wrote: > On Mon, Sep 7, 2015 at 9:17 PM, Petr Jelinek wrote: > >> On 2015-09-04 16:26, Alexander Korotkov wrote: >> >>> >>> Attached patch is implementing this. It doesn't pretend to be fully >>> correct implementati

Re: [HACKERS][PROPOSAL] Covering + unique indexes.

On Tue, Sep 15, 2015 at 12:44 AM, Jim Nasby wrote: > On 9/14/15 1:50 PM, Thomas Munro wrote: > >> CREATE [UNIQUE {ON FIRST {COLUMN | n_unique_column COLUMNS}} >> INDEX ON >> table_name (column_name1, column_name2 ...); >> >> >> I would use the first (si

Re: [HACKERS] No Issue Tracker - Say it Ain't So!

On Tue, Sep 29, 2015 at 6:36 PM, Andrew Dunstan wrote: > > > On 09/29/2015 10:55 AM, Steve Crawford wrote: > >> On Tue, Sep 29, 2015 at 7:16 AM, David Fetter > da...@fetter.org>> wrote: >> >> ...What we're not fine with is depending on a proprietary system, no >> matter what type of licen

Re: [HACKERS] No Issue Tracker - Say it Ain't So!

On Tue, Sep 29, 2015 at 5:55 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On Tue, Sep 29, 2015 at 7:16 AM, David Fetter wrote: > >> ...What we're not fine with is depending on a proprietary system, no >> matter what type of license, as infrastructure... >> >> > Exactly. Which is

Re: [HACKERS] No Issue Tracker - Say it Ain't So!]

On Mon, Oct 5, 2015 at 3:08 AM, Nathan Wagner wrote: > On Sun, Oct 04, 2015 at 04:30:49PM -0700, Josh Berkus wrote: > > That would be the key part, wouldn't it? Nice that you have [code to > > store and parse email messages]. > > Yeah. It actually made most of the work pretty easy. It's availa

Re: [HACKERS] bugs and bug tracking

On Thu, Oct 8, 2015 at 8:11 PM, Nathan Wagner wrote: > On Wed, Oct 07, 2015 at 03:06:50PM -0400, Stephen Frost wrote: > > * Nathan Wagner (nw...@hydaspes.if.org) wrote: > > > I have added full text searching to my tracker. I only index the first > > > 50 KB of each message. There's apparently a

Re: [HACKERS] Postgres service stops when I kill client backend on Windows

On Mon, Oct 12, 2015 at 4:42 PM, Dmitry Vasilyev wrote: > Hello, Amit! > > On Пн, 2015-10-12 at 11:25 +0530, Amit Kapila wrote: > > On Sun, Oct 11, 2015 at 9:12 PM, Tom Lane wrote: > > > > Magnus Hagander writes: > > > On Sun, Oct 11, 2015 at 5:22 PM, Tom Lane wrote: > > >> I'm a bit suspiciou

Re: [HACKERS] Did the "Full-text search in PostgreSQL in milliseconds" patches land?

On Thu, Oct 29, 2015 at 5:31 PM, Colin 't Hart wrote: > Hi, > > I've been reading > > wiki.postgresql.org/images/2/25/Full-text_search_in_PostgreSQL_in_milliseconds-extended-version.pdf > with interest and am wondering if these patches ever made it in to the > "official" version of Postgresql? >

Re: [HACKERS] [PATCH] we have added support for box type in SP-GiST index

On Sat, Oct 31, 2015 at 9:49 PM, Alexander Lebedev wrote: > Hello, Hacker. > > * [PATCH] add a box index to sp-gist > > We have extended sp-gist with an index that keeps track of boxes > > We have used ideas underlying sp-gist range implementation to > represent 2D boxes as points in 4D spa

Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

On Thu, Nov 5, 2015 at 9:36 AM, Pavel Stehule wrote: > Hi > > I had talk about possibility to implement PL/SQL packages in Postgres. > > The package concept is coming from ADA language and it is partially > foreign/redundant element in SQL world. Oracle needs it for modularization, > because sche

Re: [HACKERS] PgNext: CFP

it: https://www.postgresqlconference.org/talk_types Sincerely, JD Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia In

Re: [HACKERS] TS: Limited cover density ranking

ith unpatched server, is there a way to register the new functions in the system catalog without reinitializing the cluster? Best regards luben -- Luben Karavelov Regards, Oleg _ Oleg Bartunov, Researc

[HACKERS] NULL's support in SP-GiST

dex scan. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495

Re: [HACKERS] CUDA Sorting

. I've never seen a PostgreSQL server capable of running CUDA, and I don't expect that to change. That sounds like: "I think there is a world market for maybe five computers." - IBM Chairman Thomas Watson, 1943 Regards Gaetano Mendola Regards, O

Re: [HACKERS] Selectivity estimation for intarray

Any chance to have this patch in 9.5 ? Many intarray users will be happy. On Wed, Apr 29, 2015 at 1:48 PM, Alexander Korotkov wrote: > Hackers, > > currently built-in &&, @>, <@ array operators have selectivity estimations > while same operator in intarray contrib haven't them. Problem is that >

Re: [HACKERS] Collations and Replication; Next Steps

We use ICU with postgres for many years in our mchar extension, which provides case-insensitive text data type for popular russian financial system. I don't know if we may ask ICU to give us special BSD-compatible license ?

Re: [HACKERS] Collations and Replication; Next Steps

On Thu, Sep 18, 2014 at 1:09 PM, Peter Geoghegan wrote: > On Wed, Sep 17, 2014 at 9:06 PM, Oleg Bartunov > wrote: > > We use ICU with postgres for many years in our mchar extension, which > > provides case-insensitive text data type for popular russian financial > >

Re: [HACKERS] Collations and Replication; Next Steps

On Thu, Sep 18, 2014 at 3:25 PM, Martijn van Oosterhout wrote: > On Thu, Sep 18, 2014 at 01:35:10PM +0900, Tatsuo Ishii wrote: > > In my understanding PostgreSQL's manual MUST include the ICU license > > term (this is not a problem). What I am not so sure is, any software > > uses PostgreSQL als

Re: [HACKERS] Collation-aware comparisons in GIN opclasses

On Mon, Sep 29, 2014 at 11:48 AM, Heikki Linnakangas < hlinnakan...@vmware.com> wrote: > On 09/15/2014 06:28 PM, Alexander Korotkov wrote: > >> Hackers, >> >> some GIN opclasses uses collation-aware comparisons while they don't need >> to do especially collation-aware comparison. Examples are text

Re: [HACKERS] GIN pageinspect functions

On Tue, Oct 7, 2014 at 9:03 PM, Heikki Linnakangas wrote: > Some time ago, when debugging a GIN bug, I wrote these pageinspect > functions to inspect GIN indexes. They were very useful; we should add them. > May be we can merge it with contrib/gevel, which we use many years for development and d

Re: [HACKERS] GIN pageinspect functions

On Tue, Oct 7, 2014 at 9:56 PM, Heikki Linnakangas wrote: > On 10/07/2014 08:36 PM, Oleg Bartunov wrote: > >> On Tue, Oct 7, 2014 at 9:03 PM, Heikki Linnakangas < >> hlinnakan...@vmware.com> >> wrote: >> >> Some time ago, when debugging a GIN bug,

Re: [HACKERS] WIP: Access method extendability

On Tue, Oct 28, 2014 at 7:57 PM, Simon Riggs wrote: > On 28 October 2014 14:53, Robert Haas wrote: > > On Tue, Oct 28, 2014 at 10:22 AM, Simon Riggs > wrote: > >> Or put it another way, it will be easier to write new index AMs > >> because we'll be able to skip the WAL part until we know we wan

[HACKERS] new full text search configurations

I checked new snowball site http://snowballstem.org/ and found several new stemmers appeared (as external contributions): - Irish and Czech - Object Pascal codegenerator for Snowball - Two stemmers

Re: [HACKERS] Disabling an index temporarily

On Sun, Dec 13, 2015 at 1:16 AM, Jaime Casanova < jaime.casan...@2ndquadrant.com> wrote: > indexrelid = 'indexname'::regclass; This works, but might bloat system catalog.

Re: [HACKERS] WIP: bloom filter in Hash Joins with batches

Tomas, have you seen http://www.postgresql.org/message-id/4b4dd67f.9010...@sigaev.ru I have very limited internet connection (no graphics) , so I may miss something Oleg On Wed, Dec 16, 2015 at 4:15 AM, Tomas Vondra wrote: > Hi, > > while working on the Hash Join improvements, I've been repeat

Re: [HACKERS] Patch: fix lock contention for HASHHDR.mutex

On Wed, Dec 30, 2015 at 5:44 PM, Andres Freund wrote: > On 2015-12-30 11:37:19 -0300, Alvaro Herrera wrote: > > Aleksander Alekseev wrote: > > > > > Here is a funny thing - benchmark results I shared 22.12.2015 are wrong > > > because I forgot to run `make clean` after changing lwlock.h (autotool

[HACKERS] strange behaviour of psql \e command

Recently, I noticed, that psql's \e command doesn't worked for me complaining 'error opening file'. I did research and found that following setting in joe's (if I choose editor as joe) configuraton causes the problem: -exask ^KX always confirms file name That worked for decades :), so I'

Re: [HACKERS] GiST seems to drop left-branch leaf tuples

ng! regards, Yeb Havinga Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.s

[HACKERS] ERROR: could not identify an equality operator for type box

#x27;::box = ' (43.6038,48.8664536),(1.3620777,1.44327)'::box; ?column? -- t (1 row) ^ What does it means ? Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of Astro

Re: [HACKERS] ERROR: could not identify an equality operator for type box

Ok, casting to ::text solves the problem, but still I think we need to fix it in the right way Oleg On Sat, 4 Dec 2010, Oleg Bartunov wrote: Hi there, create table qq (b box); CREATE TABLE select count(*), b from qq group by b; ERROR: could not identify an equality operator for type box

Re: [HACKERS] knngist - 0.8

lane Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495

Re: [HACKERS] knngist - 0.8

On Sat, 4 Dec 2010, Greg Stark wrote: On Sat, Dec 4, 2010 at 6:07 PM, Oleg Bartunov wrote: We'll sync contrib/btree_gist with current API. Also, we're thinking about distance for ltree, boxes, circles. I'm not sure about polygons, though. So, we'll have rather complete

[HACKERS] plperlu problem with utf8

Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hackers mailing list

Re: [HACKERS] plperlu problem with utf8

: On 12/08/2010 10:13 AM, Oleg Bartunov wrote: Hi there, below is the problem, which I don't have when running in shell. The database is in UTF-8 encoding. CREATE OR REPLACE FUNCTION url_decode(Vkw varchar) RETURNS varchar AS $$ use strict; use URI::Escape; return uri_unescape

Re: [HACKERS] plperlu problem with utf8

On Wed, 8 Dec 2010, David E. Wheeler wrote: On Dec 8, 2010, at 8:13 AM, Oleg Bartunov wrote: adding utf8::decode($_[0]) solves the problem: knn=# CREATE OR REPLACE FUNCTION url_decode(Vkw varchar) RETURNS varchar AS $$ use strict; use URI::Escape; utf8::decode($_[0]); return

Re: [HACKERS] Extensions, patch v16

. It makes figuring out what to upgrade extremely difficult. Learning from that, PGXN requires version numbers for all extensions. Best, David Regards, Oleg _ Oleg Bartunov, Research Scientist, Head o

Re: [HACKERS] hstores in pl/python

f just hstore->dict, which sucks. Cheers, Jan Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o..

Re: [HACKERS] hstores in pl/python

Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-

Re: [HACKERS] hstores in pl/python

ld be very nice. cheers andrew Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.

Re: [HACKERS] hstores in pl/python

On Tue, 14 Dec 2010, Robert Haas wrote: On Tue, Dec 14, 2010 at 12:25 PM, Oleg Bartunov wrote: Just wondering about JSON, are there anyone who signed already to work on JSON or it's just a theoretical discussions ? If so, I agree, having JSON properly implemented and simple wrapper for h

[HACKERS] Happy New Year !

ww.flickr.com/photos/obartunov/sets/72157622740300156/with/4078835652/ Slideshow if you have flash available: http://www.flickr.com/photos/obartunov/sets/72157622740300156/show/ _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.ast

Re: [HACKERS] rbtree test data

On Tue, 2 Feb 2010, Robert Haas wrote: On Sat, Jan 30, 2010 at 1:12 AM, Oleg Bartunov wrote: I made available test data I used on http://www.sai.msu.su/~megera/wiki/2009-07-27, so anyone can reproduce my results. You can download data http://www.sai.msu.su/~megera/postgres/files/links2.sql.gz

Re: [HACKERS] [CFReview] Red-Black Tree

l we understand that. Robert, Mark described the test he did http://archives.postgresql.org/pgsql-hackers/2010-01/msg02927.php Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet

Re: [HACKERS] [CFReview] Red-Black Tree

rds, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-

Re: [HACKERS] [CFReview] Red-Black Tree

7.php Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/

Re: [HACKERS] [CFReview] Red-Black Tree

atch applied. ATB, Mark. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495

[HACKERS] Knngist for 8.5

took this into account. In regard to the knngist patch I want to claim, that I and Teodor are here and willing to answer any questions. Oleg PS. I changed subject not to interfere with other topics. On Sun, 7 Feb 2010, Robert Haas wrote: 2010/2/7 Oleg Bartunov : On Sun, 7 Feb 2010, Robert

Re: [HACKERS] damage control mode

We have a week to get review and do possible required pre-commit changes. Mark, you can download test data for knngist from http://www.sai.msu.su/~megera/wiki/2009-11-25 Regards, Oleg _____ Oleg Bartunov

Re: [HACKERS] damage control mode

Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hackers mailing

Re: [HACKERS] Knngist for 8.5

7 Feb 2010, Robert Haas wrote: 2010/2/7 Oleg Bartunov : I understand your complaints. I think, the real problem is that some of us live in the part of word with long holidays in December, while we in Russia have very long holidays in January. So, about a month we couldn't synchronize developer

Re: [HACKERS] [CFReview] Red-Black Tree

regards, tom lane Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, ht

Re: [HACKERS] knngist patch support

IN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFLc5YoBcgs9XrR2kYRAoW3AJ94tYWPenLOjH4B4GHD9DCYSSWYOQCeOcoM RYDhINv+k9YeD23xFHyj9yw= =K1E0 -END PGP SIGNATURE- Regards, Oleg _ Oleg Bartunov, Research Sc

Re: [HACKERS] knngist patch support

On Thu, 11 Feb 2010, Tom Lane wrote: Oleg Bartunov writes: This is very disgraceful from my point of view and reflects real problem in scheduling of CF. The patch was submitted Nov 23 2009, discussed and reworked Nov 25. Long holidays in December-January, probably are reason why there were no

Re: [HACKERS] knngist patch support

On Thu, 11 Feb 2010, Robert Haas wrote: 2010/2/11 Oleg Bartunov : This is very disgraceful from my point of view and reflects real problem in scheduling of CF. The patch was submitted Nov 23 2009, discussed and reworked Nov 25. Long holidays in December-January, probably are reason why there

Re: [HACKERS] knngist patch support

On Thu, 11 Feb 2010, Robert Haas wrote: On Thu, Feb 11, 2010 at 3:00 AM, Oleg Bartunov wrote: version I saw hadn't any documentation whatever.  It's not committable on documentation grounds alone, even if everybody was satisfied about the code. well, there is enough documentation

Re: [HACKERS] knngist patch support

Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hacke

Re: [HACKERS] knngist patch support

On Thu, 11 Feb 2010, Oleg Bartunov wrote: On Thu, 11 Feb 2010, Tom Lane wrote: My own feeling about it is that I much preferred the original proposal of a contrib module with little or no change to core code. I don't want to be changing core code for this at this late hour. If it were

Re: [HACKERS] review: More frame options in window functions

gist we use distance semantic, distance < 0 means FALSE, so we compatible with old GIST. It would be nice to come up with a general solution to this problem. yeah Regards, Oleg _____ Oleg Bartunov,

Re: [HACKERS] knngist patch support

On Fri, 12 Feb 2010, Robert Haas wrote: 2010/2/11 Oleg Bartunov : > On Thu, 11 Feb 2010, Robert Haas wrote: > >> On Thu, Feb 11, 2010 at 3:00 AM, Oleg Bartunov wrote: >>>> >>>> version I saw hadn't any documentation whatever. =A0It's not committab

Re: [HACKERS] Merge join and index scan strangeness

1 on t1 (cost=0.00..24274.83 rows=234839 width=69) (actual time=0.637..137.659 rows=234839 loops=1) Total runtime: 1969.029 ms (8 rows) Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astr

[HACKERS] building postgres-A4.tex-pdf crushed

Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hackers mailing l

[HACKERS] autovacuum and temp tables support

tables variable to control autovacuum behaviour ? Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@s

Re: [HACKERS] autovacuum and temp tables support

On Thu, 8 Apr 2010, Robert Haas wrote: On Thu, Apr 8, 2010 at 2:53 PM, Alvaro Herrera wrote: Oleg Bartunov wrote: our client complained about slow query, which involves temporary tables. Analyzing them manually solved the problem. I don't remember arguments against temporary tables su

[HACKERS] Very ineffective plan with merge join

Hi there, below is an example of interesting query and two plans - the bad plan, which uses merge join and big sorting, took 216 sec, and good plan with merge join disabled took 8 sec. Sorry for odd names, they were generated by popular accounting engine in Russia. 8.4.3 and HEAD show the same

Re: [HACKERS] Very ineffective plan with merge join

On Thu, 15 Apr 2010, Kevin Grittner wrote: Oleg Bartunov wrote: Sorry for odd names, they were generated by popular accounting engine in Russia. How much of that can you trim out and still see the problem? It's difficult, since I don't know semantics of data. I reduced que

Re: [HACKERS] Very ineffective plan with merge join

On Thu, 15 Apr 2010, Pavel Stehule wrote: Hello there is significant problem in statistics I think, Ah, you're right ! Regards Pavel Stehule 2010/4/15 Oleg Bartunov : On Thu, 15 Apr 2010, Kevin Grittner wrote: Oleg Bartunov wrote: Sorry for odd names, they were generated by po

Re: [HACKERS] Very ineffective plan with merge join

ng. -Kevin Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone

Re: [HACKERS] Very ineffective plan with merge join

On Thu, 15 Apr 2010, Tom Lane wrote: Oleg Bartunov writes: below is an example of interesting query and two plans - the bad plan, which uses merge join and big sorting, took 216 sec, and good plan with merge join disabled took 8 sec. The "good" plan seems to be fast mainly

Re: [HACKERS] Very ineffective plan with merge join

Sorry, I used random_page_cost=2, while random_page_cost=3 didn't help. Oleg On Fri, 16 Apr 2010, Oleg Bartunov wrote: On Thu, 15 Apr 2010, Tom Lane wrote: Oleg Bartunov writes: below is an example of interesting query and two plans - the bad plan, which uses merge join and big so

Re: [HACKERS] Choosing between seqscan and bitmap scan

hmm, what if we add index scan preference inside 1% tolerance ? Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow Universit

Re: [HACKERS] SP-GIST docs and examples

Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 --

Re: [HACKERS] Incorrect behaviour when using a GiST index on points

Yes, it's a bug and it needs to be applied ! On Tue, Jul 3, 2012 at 7:44 PM, Robert Haas wrote: > On Tue, Jul 3, 2012 at 11:34 AM, Tom Lane wrote: >> Robert Haas writes: >>> On Thu, Jun 21, 2012 at 2:53 PM, Alexander Korotkov >>> wrote: I think we definitely should apply this patch before

Re: [HACKERS] knngist - 0.8

the way: gistproc.c: In function ?gist_point_consistent?: gistproc.c:1023: error: ?distance? may be used uninitialized in this function Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Ste

Re: [HACKERS] knngist plans

Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 -- Sent via pgsql-hacke

Re: [HACKERS] knngist plans

odor will post soon. I would really like to see what Teodor has done. I could also prepare a document with the additions I would like to see in docs. Shall I do it? Of course it might take a while to finish it. On Fri, Oct 15, 2010 at 2:37 PM, Oleg Bartunov wrote: On Fri, 15 Oct 2010, Mari

Re: [HACKERS] knngist plans

On Tue, 19 Oct 2010, Marios Vodas wrote: On Sat, Oct 16, 2010 at 8:42 PM, Oleg Bartunov wrote: Marios, you're right. There are several reasons for poor documentation, but of course, no excuse, we do need good docs any way ! It's very nice you're willing to write one, si

Re: [HACKERS] Bug in plpython's Python Generators

PLy_function_handler disconnecting from SPI after calling into the Python code and then going ahead and reading the result from the iterator. Here's a patch with a fix for that bug. Cheers, Jan Regards, Oleg _

Re: [HACKERS] ts_count

#x27;d like to add something like this for 9.2, so I'd like to get the API agreed and then I'll prepare a patch and submit it for the next CF. Comments? cheers andrew Regards, Oleg _____ Oleg Bar

Re: [HACKERS] CommitFest progress - or lack thereof

anks, Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-

Re: [HACKERS] CommitFest progress - or lack thereof

late. Added to current commitfest. Oleg On Fri, 4 Feb 2011, Robert Haas wrote: On Fri, Feb 4, 2011 at 10:46 AM, Oleg Bartunov wrote: I don't see btree_gist with knn-support. I'm afraid it'll be forgotten. If you don't see it there, it's because you didn't add it.

[HACKERS] spam (http://wiki.openssi.org/go/PostgreSQL_on_OpenSSI_enabled_Knoppix)

oppix"; Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone

Re: [HACKERS] btree_gist (was: CommitFest progress - or lack thereof)

ng me and I'll work on writing up *something*, at least. Thanks, Stephen Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institut

Re: [HACKERS] btree_gist (was: CommitFest progress - or lack thereof)

Stephen, On Sat, 12 Feb 2011, Stephen Frost wrote: Oleg, * Oleg Bartunov (o...@sai.msu.su) wrote: what do you need for documentation ? From users point of view we add just knn support and all examples are available in btree_gist.sql and sql subdirectory. Contact me directly, if you have

Re: [HACKERS] btree_gist (was: CommitFest progress - or lack thereof)

pgsql-bugs/2010-10/msg00104.php regards, tom lane Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow Universi

Re: [HACKERS] tsearch Parser Hacking

│ [null] │ [null] hword_asciipart │ Hyphenated word part, all ASCII │ d │ {simple} │ simple │ {d} (4 rows) Possible? Or would I have to write a completely new parser just to change this bit? Thanks, David Regards, Oleg ____

Re: [HACKERS] tsearch Parser Hacking

h something a bit more modification-friendly. We thought about configurable parser, but AFAIR, we didn't get any support for this at that time. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of Astro

Re: [HACKERS] tsearch Parser Hacking

On Mon, 14 Feb 2011, David E. Wheeler wrote: On Feb 14, 2011, at 11:37 PM, Oleg Bartunov wrote: it's not easy to hack tsearch parser, sorry. You can preparse your input before to_tsquery,to_tsvector. Yeah, I was thinking about s{/}{-}g before passing the values in. Might be the only w

Re: [HACKERS] btree_gist (was: CommitFest progress - or lack thereof)

We need to fix inet support as Tom complained and then will commit. Oleg On Wed, 16 Feb 2011, Robert Haas wrote: On Sat, Feb 12, 2011 at 8:19 AM, Robert Haas wrote: On Sat, Feb 12, 2011 at 7:47 AM, Stephen Frost wrote: Oleg, * Oleg Bartunov (o...@sai.msu.su) wrote: what do you need for

Re: [HACKERS] tsearch Parser Hacking

. Wheeler wrote: On Feb 14, 2011, at 11:44 PM, Oleg Bartunov wrote: IMO, sooner or later we need to trash that code and replace it with something a bit more modification-friendly. We thought about configurable parser, but AFAIR, we didn't get any support for this at that time. What would it

Re: [HACKERS] knngist - 0.8

Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007

Re: [HACKERS] GSoC 2011 - Mentors? Projects?

on: http://www.postgresql.org/mailpref/pgsql-hackers Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@s

Re: [HACKERS] GSoC proposal: Fast GiST index build

splits into two buffers using penalty function. With best regards, Alexander Korotkov. Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Mo

[HACKERS] k-neighbourhood search in databases

Hi there, I'm interesting if other databases provides built-in effective knn search ? Google didn't help me. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),

Re: [HACKERS] workaround for expensive KNN?

. is there any alternative which does not simply die when i try to achieve what i want? the use case is quite simple: all products with a certain word (10 cheapest or so). is there any alternative approach to this? i was putting some hope into KNN but it seems it needs too much random I/O :(. many t

Re: [HACKERS] k-neighbourhood search in databases

erver side code it seems) sybase: disgusting workaround (no serverside code it seems) microsoft: there seems to be something coming out (or just out) but i have not seen anything working yet. regards, hans On Apr 8, 2011, at 2:21 PM, Oleg Bartunov wrote: Hi there,

Re: [HACKERS] workaround for expensive KNN?

r case say? many thanks, hans On Apr 8, 2011, at 3:22 PM, Oleg Bartunov wrote: Probably, you miss two-columnt index. From my early post: http://www.sai.msu.su/~megera/wiki/knngist =# CREATE INDEX spots_idx ON spots USING knngist (coordinates, to_tsvector(

Re: [HACKERS] workaround for expensive KNN?

om one specific place. my maths is like that: 11 mio in total 1 mio matching "iphone" cheapest / most expensive 10 out of this mio needed. operator classes are all nice and in place: SELECT 10 <-> 4 as distance; distance -- 6 (1 row) wh

Re: [HACKERS] k-neighbourhood search in databases

On Fri, 8 Apr 2011, Josh Berkus wrote: On 4/8/11 5:21 AM, Oleg Bartunov wrote: Hi there, I'm interesting if other databases provides built-in effective knn search ? Google didn't help me. Nobody I've talked to, and I asked both Couch and Oracle devs. That&

Re: [HACKERS] k-neighbourhood search in databases

8/10/23/nearest-neighbors.aspx [2]: http://www.sqlskills.com/BLOGS/BOBB/post/The-nearest-neighbor-optimization-in-SQL-Server-Denali.aspx Regards, Oleg _____ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet

<    1   2   3   4   5   6   7   8   9   10   >