Re: [HACKERS] need info about extensibility in other databases

On Wed, Nov 8, 2017 at 2:37 PM, Li Song wrote: > Hi, > > When is the English version of "GiST programming tutorial" available? Well, I wrote it many years ago, so it needs to be updated. For now, you can use google translate, which seems works fine

Re: [HACKERS] Custom compression methods

On Thu, Nov 2, 2017 at 6:02 PM, Craig Ringer wrote: > On 2 November 2017 at 17:41, Ildus Kurbangaliev > wrote: > >> In this patch compression methods is suitable for MAIN and EXTENDED >> storages like in current implementation in postgres.

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

On Mon, Oct 30, 2017 at 12:05 PM, Oleg Bartunov <obartu...@gmail.com> wrote: > On Sun, Oct 29, 2017 at 10:07 AM, Connor Wolf > <w...@imaginaryindustries.com> wrote: >> Hi there! >> >> I'm looking at implementing a custom indexing scheme, and I've been having

Re: [HACKERS] How to implement a SP-GiST index as a extension module?

On Sun, Oct 29, 2017 at 10:07 AM, Connor Wolf wrote: > Hi there! > > I'm looking at implementing a custom indexing scheme, and I've been having > trouble understanding the proper approach. > > Basically, I need a BK tree, which is a tree-structure useful for indexing

Re: [HACKERS] Surjective functional indexes

On Thu, May 25, 2017 at 7:30 PM, Konstantin Knizhnik wrote: > Right now Postgres determines whether update operation touch index or not > based only on set of the affected columns. > But in case of functional indexes such policy quite frequently leads to > unnecessary

Re: [HACKERS] [PATCH] Generic type subscripting

On Fri, Sep 22, 2017 at 3:51 PM, Peter Eisentraut wrote: > On 9/21/17 11:24, Dmitry Dolgov wrote: >> One last thing that I need to clarify. Initially there was an idea to >> minimize changes in `pg_type` > > I see, but there is no value in that if it makes

Re: [HACKERS] Add Roman numeral conversion to to_number

On 3 Aug 2017 16:29, "Oliver Ford" wrote: Adds to the to_number() function the ability to convert Roman numerals to a number. This feature is on the formatting.c TODO list. It is not currently implemented in either Oracle, MSSQL or MySQL so gives PostgreSQL an edge :-) I see

Re: [HACKERS] SQL/JSON in PostgreSQL

On 16 Sep 2017 02:32, "Nikita Glukhov" <n.glu...@postgrespro.ru> wrote: On 15.09.2017 22:36, Oleg Bartunov wrote: On Fri, Sep 15, 2017 at 7:31 PM, Robert Haas <robertmh...@gmail.com> wrote: > >> On Fri, Sep 15, 2017 at 10:10 AM, Daniel Gustafsson <dan...@yesql.

Re: [HACKERS] SQL/JSON in PostgreSQL

On Fri, Sep 15, 2017 at 7:31 PM, Robert Haas wrote: > On Fri, Sep 15, 2017 at 10:10 AM, Daniel Gustafsson wrote: >> Can we expect a rebased version of this patch for this commitfest? Since >> it’s >> a rather large feature it would be good to get it in

Re: [HACKERS] [PATCH] Pageinspect - add functions on GIN and GiST indexes from gevel

era/wiki/Gevel) which provides functions for >> analyzing GIN and GiST indexes to pageinspect. Gevel was originally >> designed by Oleg Bartunov, and Teodor Sigaev for developers of GiST and >> GIN indexes. > > It's not clear from the web site in question that the relevant code

Re: [HACKERS] CTE inlining

On Mon, May 1, 2017 at 7:22 AM, Pavel Stehule wrote: > > > 2017-05-01 1:21 GMT+02:00 Andres Freund : >> >> On 2017-04-30 07:19:21 +0200, Pavel Stehule wrote: >> > why we cannot to introduce GUC option - enable_cteoptfence ? >> >> Doesn't really solve

Re: [HACKERS] [PATCH] few fts functions for jsonb

On 30 Mar 2017 23:43, "Dmitry Dolgov" <9erthali...@gmail.com> wrote: On 31 March 2017 at 00:01, Andrew Dunstan wrote: > > I have just noticed as I was writing/testing the non-existent docs for > this patch that it doesn't supply variants of to_tsvector that take a

Re: [HACKERS] [GSoC] Push-based query executor discussion

On Wed, Mar 22, 2017 at 8:04 PM, Arseny Sher wrote: > > While I admire your fearlessness, I think the chances of you being > > able to bring a project of this type to a successful conclusion are > > remote. Here is what I said about this topic previously: > > > >

Re: [HACKERS] SQL/JSON in PostgreSQL

On Mon, Mar 13, 2017 at 9:24 AM, Nico Williams wrote: > On Thu, Mar 09, 2017 at 07:12:07PM +0100, Sven R. Kunze wrote: > > From my day-to-day work I can tell, the date(time) type is the only > missing > > piece of JSON to make it perfect for business applications (besides,

Re: [HACKERS] SQL/JSON in PostgreSQL

On Fri, Mar 10, 2017 at 7:07 AM, Petr Jelinek wrote: > On 09/03/17 19:50, Peter van Hardenberg wrote: > > Anecdotally, we just stored dates as strings and used a convention (key > > ends in "_at", I believe) to interpret them. The lack of support for > > dates in

Re: [HACKERS] SQL/JSON in PostgreSQL

On Wed, Mar 8, 2017 at 7:05 AM, David Steele wrote: > On 3/7/17 11:38 AM, Andres Freund wrote: > > <...> > > We have a plenty of time and we dedicate one full-time developer for >>> this project. >>> >> >> How about having that, and perhaps others, developer participate in

Re: [HACKERS] SQL/JSON in PostgreSQL

On Wed, Mar 8, 2017 at 12:43 AM, Sven R. Kunze wrote: > Hi, > > about the datetime issue: as far as I know, JSON does not define a > serialization format for dates and timestamps. > > On the other hand, YAML (as a superset of JSON) already supports a > language-independent

Re: [HACKERS] SQL/JSON in PostgreSQL

On Fri, Mar 3, 2017 at 11:49 PM, David Steele <da...@pgmasters.net> wrote: > Hi Oleg, > > On 2/28/17 2:55 PM, Pavel Stehule wrote: > > 2017-02-28 20:08 GMT+01:00 Oleg Bartunov <obartu...@gmail.com > > > > Attached patch is an implementation of SQL/J

Re: [HACKERS] SQL/JSON in PostgreSQL

On Tue, Feb 28, 2017 at 10:55 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hi > > > 2017-02-28 20:08 GMT+01:00 Oleg Bartunov <obartu...@gmail.com>: > >> Hi there, >> >> >> Attached patch is an implementation of SQL/JSON data model from S

[HACKERS] SQL/JSON in PostgreSQL

- the often requested feature by the users. The patch is consists of about 15000 insertions (about 5000 lines are from tests), passes all regression tests and doesn’t touches critical parts, so we hope with community help to bring it to committable state. Authors: Nikita Glukhov, Teodor Sigaev, Oleg

Re: [HACKERS] [PATCH] few fts functions for jsonb

The proposed patch looks not very important, but I consider it as an important feature, which Oracle and Microsoft already have, that's why I asked Dmitry to work on this and made it before feature freeze. My comments follows below the post. On Tue, Feb 28, 2017 at 1:59 PM, Dmitry Dolgov

Re: [HACKERS] ISO/IEC 9075-2:2016 for postgres community

On Tue, Jan 17, 2017 at 6:26 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Oleg Bartunov wrote: > > Hi there, > > > > I just bought ISO/IEC 9075-2:2016 > > http://www.iso.org/iso/home/store/catalogue_tc/catalogue_ > detail.htm?csnumber=63556 > &

[HACKERS] ISO/IEC 9075-2:2016 for postgres community

Hi there, I just bought ISO/IEC 9075-2:2016 http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63556 to satisfy my interest on json support in SQL. I am not ready to discuss here implementation details, but there is one problem with the status of this document, which is

Re: [HACKERS] [PATCH] Generic type subscription

On Wed, Oct 5, 2016 at 6:48 AM, Dmitry Dolgov <9erthali...@gmail.com> wrote: > On 5 October 2016 at 03:00, Oleg Bartunov <obartu...@gmail.com> wrote: > >> >> have you ever run 'make check' ? >> >> = >> 53 of 168 tests failed

Re: [HACKERS] [PATCH] Generic type subscription

On Sat, Oct 1, 2016 at 12:52 PM, Dmitry Dolgov <9erthali...@gmail.com> wrote: > > I've tried to compile this patch with current state of master (commit > > 51c3e9fade76c12) and found out that, when configured with > --enable-cassert, > > it doesn't pass make check. > > Thanks for the feedback.

Re: [HACKERS] Better tracking of free space during SP-GiST index build

On Sat, Sep 24, 2016 at 11:32 PM, Tomas Vondra wrote: > On 09/22/2016 07:37 PM, Tom Lane wrote: >> >> Tomas Vondra writes: >> >>> ... I've tried increasing the cache size to 768 >>> entries, with vast majority of them (~600) allocated

[HACKERS] Fwd: [Snowball-discuss] Greek stemmer

This is a chance to add default configuration for Greek language if somebody with good knowledge could follow this development. Oleg -- Forwarded message -- From: Oleg Smirnov Date: Thu, Aug 25, 2016 at 5:26 PM Subject: [Snowball-discuss] Greek stemmer

Re: [HACKERS] Index Onlys Scan for expressions

On Tue, Aug 16, 2016 at 1:03 AM, Ildar Musin wrote: > Hi, hackers! > > There is a known issue that index only scan (IOS) can only work with simple > index keys based on single attributes and doesn't work with index > expressions. In this patch I propose a solution that

Re: [HACKERS] 9.6 phrase search distance specification

On Tue, Aug 9, 2016 at 9:59 PM, Ryan Pedela wrote: > > > I would say that it is worth it to have a "phrase slop" operator (Apache > Lucene terminology). Proximity search is extremely useful for improving > relevance and phrase slop is one of the tools to achieve that. >

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

On Wed, Jun 29, 2016 at 2:51 AM, Stefan Keller wrote: > Hi, > > FYI: I'd just like to point you to following two forthcoming standard > parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on > "Multi-Dimensional Arrays" (SQL/MDA). > > They define there some things

Re: [HACKERS] WIP: About CMake v2

On Wed, Jun 29, 2016 at 7:23 PM, Yury Zhuravlev wrote: > Hello Hackers. > > I decided to talk about the current state of the project: > 1. Merge with 9.6 master. 2. plpython2, plpython3, plperl, pltcl, plsql all > work correctly (all tests pass). > 3. Works done for

Re: [HACKERS] Gin index on array of uuid

On Wed, Jun 29, 2016 at 6:17 AM, M Enrique wrote: > What's a good source code entry point to review how this is working for > anyarray currently? I am new to the postgres code. I spend some time > looking for it but all I found is the following (which I have not

[HACKERS] Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

On Tue, Jun 28, 2016 at 7:00 PM, Oleg Bartunov <obartu...@gmail.com> wrote: > On Tue, Jun 28, 2016 at 9:32 AM, Noah Misch <n...@leadboat.com> wrote: >> On Sun, Jun 26, 2016 at 10:22:26PM -0400, Noah Misch wrote: >>> On Wed, Jun 15, 2016 at 11:08:54AM -0400, Noah Mis

[HACKERS] Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

On Tue, Jun 28, 2016 at 9:32 AM, Noah Misch wrote: > On Sun, Jun 26, 2016 at 10:22:26PM -0400, Noah Misch wrote: >> On Wed, Jun 15, 2016 at 11:08:54AM -0400, Noah Misch wrote: >> > On Wed, Jun 15, 2016 at 03:02:15PM +0300, Teodor Sigaev wrote: >> > > On Wed, Jun 15, 2016 at

Re: [HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

On Thu, Jun 9, 2016 at 12:47 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Oleg Bartunov <obartu...@gmail.com> writes: >> On Wed, Jun 8, 2016 at 8:12 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>> Another thing I noticed: if you test with tsvectors that don't

Re: [HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

On Wed, Jun 8, 2016 at 1:05 AM, Tom Lane wrote: > Jean-Pierre Pelletier writes: >> I wanted to test if phraseto_tsquery(), new with 9.6 could be used for >> matching consecutive words but it won't work for us if it cannot handle >> consecutive

Re: [HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

On Wed, Jun 8, 2016 at 8:12 PM, Tom Lane wrote: > Another thing I noticed: if you test with tsvectors that don't contain > position info, <-> seems to reduce to &, that is it doesn't enforce > relative position: > > regression=# select 'cat bat fat rat'::tsvector @@ 'cat <->

Re: [HACKERS] Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?

t') @@ to_tsquery('simple', > 'cat <-> rat'); > returns "true" > > Jean-Pierre Pelletier > > -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Wednesday, June 8, 2016 1:12 PM > To: Teodor Sigaev; Oleg Bartunov > Cc: Jean-Pierre Pe

Re: [HACKERS] Precedence of new phrase search tsquery operator

On Wed, Jun 8, 2016 at 7:13 PM, Tom Lane wrote: > It appears that the new <-> operator has been made to have exactly the > same grammatical precedence as the existing & (AND) operator. Thus, > for example, 'a & b <-> c'::tsquery means something different from > 'b <-> c &

Re: [HACKERS] Precedence of new phrase search tsquery operator

On Wed, Jun 8, 2016 at 7:13 PM, Tom Lane wrote: > It appears that the new <-> operator has been made to have exactly the > same grammatical precedence as the existing & (AND) operator. Thus, > for example, 'a & b <-> c'::tsquery means something different from > 'b <-> c &

Re: [HACKERS] Adding an alternate syntax for Phrase Search

On Thu, May 26, 2016 at 3:00 PM, Josh berkus wrote: > On 05/22/2016 06:53 PM, Teodor Sigaev wrote: >> >>> to_tsquery(' Berkus & "PostgreSQL Version 10.0" ') >>> >>> ... would be equivalent to: >>> >>> to_tsquery(' Berkus & ( PostgreSQL <-> version <-> 10.0 )') >> >> select

Re: [HACKERS] Just-in-time compiling things (was: asynchronous and vectorized execution)

On Sat, May 14, 2016 at 12:10 PM, Andreas Seltenreich wrote: > Konstantin Knizhnik writes: > >> Latest information from ISP RAS guys: them have made good progress >> since February: them have rewritten most of methods of Scan, Aggregate >> and Join to LLVM API. > > Is their

Re: [HACKERS] Academic help for Postgres

On Wed, May 11, 2016 at 5:20 PM, Bruce Momjian wrote: > I am giving a keynote at an IEEE database conference in Helsinki next > week (http://icde2016.fi/). (Yes, I am not attending PGCon Ottawa > because I accepted the Helsinki conference invitation before the PGCon > Ottawa

Re: [HACKERS] Html parsing and inline elements

On Wed, Apr 13, 2016 at 6:57 PM, Marcelo Zabani wrote: > Hi, Tom, > > You're right, I don't think one can argue that the default parser should > know HTML. > How about your suggestion of there being an HTML parser, is it feasible? I > ask this because I think that a lot of

Re: [HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

On Fri, Apr 29, 2016 at 7:40 PM, Joshua D. Drake <j...@commandprompt.com> wrote: > On 04/29/2016 08:44 AM, Bruce Momjian wrote: > >> On Tue, Apr 12, 2016 at 11:07:04PM +0300, Oleg Bartunov wrote: >> >>> Our roadmap http://www.postgresql.org/developer/roadmap/ is t

Re: [HACKERS] Parser extensions (maybe for 10?)

On Tue, Apr 19, 2016 at 1:49 PM, Simon Riggs wrote: > On 12 April 2016 at 06:51, Tom Lane wrote: > >> Craig Ringer writes: >> > The other area where there's room for extension without throwing out the >> > whole thing and

Re: [HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

On Tue, Apr 12, 2016 at 9:25 PM, Josh berkus wrote: > On 04/12/2016 10:43 AM, Robert Haas wrote: > > 1. Large backward compatibility breaks are bad. Therefore, if any of > > these things are absolutely impossible to do without major > > compatibility breaks, we shouldn't do

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

On Fri, Apr 1, 2016 at 5:24 PM, Tom Lane wrote: > Alvaro Herrera writes: > > Teodor Sigaev wrote: > >> may be <=>? it isn't used anywhere yet. > >> > >> select 'fat'::tsquery <=> 'cat'; > >> select 'fat <=> cat'::tsquery; > >> select 'fat <3>

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

On Thu, Mar 31, 2016 at 9:14 PM, Alvaro Herrera wrote: > What led you to choose the ? operator for the FOLLOWED BY semantics? > It doesn't seem a terribly natural choice -- most other things seems to > use ? as some sort of wildcard. What about something like "...", so

Re: [HACKERS] Draft release notes for next week's releases

On Mon, Mar 28, 2016 at 6:08 PM, Robert Haas wrote: > On Mon, Mar 28, 2016 at 10:24 AM, Tom Lane wrote: > > I'm also not exactly convinced by your implicit assumption that ICU is > > bug-free. > > Noah spent some time looking at ICU back when he was

Re: [HACKERS] Draft release notes for next week's releases

On Mon, Mar 28, 2016 at 1:36 PM, Thomas Kellerer <spam_ea...@gmx.net> wrote: > Oleg Bartunov-2 wrote > > But still, icu provides us abbreviated keys and collation stability, > > Does include ICU mean that collation handling is identical across > platforms? > E.g. a quer

Re: [HACKERS] Dealing with collation and strcoll/strxfrm/etc

On Mon, Mar 28, 2016 at 5:57 PM, Stephen Frost <sfr...@snowman.net> wrote: > All, > > Changed the thread name (we're no longer talking about release > notes...). > > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > Oleg Bartunov <obartu...@gmail.com> writes: >

Re: [HACKERS] Draft release notes for next week's releases

On Mon, Mar 28, 2016 at 2:06 PM, Peter Geoghegan <p...@heroku.com> wrote: > On Mon, Mar 28, 2016 at 12:55 AM, Oleg Bartunov <obartu...@gmail.com> > wrote: > > We'll post the patch. > > Cool. > > > Teodor made something to get abbreviated keys work as

Re: [HACKERS] Draft release notes for next week's releases

On Mon, Mar 28, 2016 at 1:21 PM, Peter Geoghegan <p...@heroku.com> wrote: > On Mon, Mar 28, 2016 at 12:08 AM, Oleg Bartunov <obartu...@gmail.com> > wrote: > > Should we start thinking about ICU ? I compare Postgres with ICU and > without > > and found 27x im

Re: [HACKERS] Draft release notes for next week's releases

On Mar 28, 2016 09:44, "Peter Geoghegan" wrote: > > On Sat, Mar 26, 2016 at 4:34 PM, Tom Lane wrote: > > Probably the most discussion-worthy item is whether we can say > > anything more about the strxfrm mess. Should we make a wiki > > page about that and

Re: [HACKERS] Bug in searching path in jsonb_set when walking through JSONB array

On Wed, Mar 23, 2016 at 6:37 AM, Vitaly Burovoy wrote: > Hello, Hackers! > > While I was reviewed a patch with "json_insert" function I found a bug > which wasn't connected with the patch and reproduced at master. > > It claims about non-integer whereas input values are

Re: [HACKERS] Background Processes and reporting

On Tue, Mar 15, 2016 at 7:43 PM, Alexander Korotkov < a.korot...@postgrespro.ru> wrote: > On Tue, Mar 15, 2016 at 12:57 AM, Robert Haas > wrote: > >> On Mon, Mar 14, 2016 at 4:42 PM, Andres Freund >> wrote: >> > On 2016-03-14 16:16:43 -0400, Robert

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

On Mon, Mar 14, 2016 at 9:01 PM, David Steele wrote: > On 2/15/16 10:29 AM, Teodor Sigaev wrote: > > It's very pity but author is not able to continue work on this patch, >> and I would like to raise this flag. >> >> I'd like to add some comments about patches: >> >>

Re: [HACKERS] Background Processes and reporting

On Sat, Mar 12, 2016 at 12:45 AM, Andres Freund wrote: > On 2016-03-12 02:24:33 +0300, Alexander Korotkov wrote: > > > > So, situation looks like dead-end. I have no idea how to convince Robert > > about any kind of advanced functionality of wait monitoring to > PostgreSQL.

Re: [HACKERS] eXtensible Transaction Manager API (v2)

On Fri, Mar 11, 2016 at 7:11 PM, David Steele wrote: > On 2/10/16 12:50 PM, Konstantin Knizhnik wrote: > > > PostgresProffesional cluster teams wants to propose new version of > > eXtensible Transaction Manager API. > > Previous discussion concerning this patch can be found

Re: [HACKERS] WIP: Access method extendability

On Wed, Mar 9, 2016 at 8:31 PM, Alexander Korotkov < a.korot...@postgrespro.ru> wrote: > Hi! > > On Wed, Mar 9, 2016 at 3:27 PM, Alvaro Herrera > wrote: > >> Hi. As I just said to Tomas Vondra: since your patch creates a new >> object type, please make sure to add a

Re: [HACKERS] The plan for FDW-based sharding

On Fri, Mar 11, 2016 at 9:09 AM, Bruce Momjian wrote: > > > > 3. I have tried to encourage others to get involved, with limited > success. I do think the FDW is perhaps the only reasonable way to get > _built-in_ sharding. The external sharding solutions are certainly >

Re: [HACKERS] SP-GiST support for inet datatypes

On Tue, Mar 8, 2016 at 11:17 PM, Oleg Bartunov <obartu...@gmail.com> wrote: > > > On Thu, Mar 3, 2016 at 11:45 AM, Emre Hasegeli <e...@hasegeli.com> wrote: > >> > Emre, I checked original thread and didn't find sample data. Could you >> provide them fo

Re: [HACKERS] SP-GiST support for inet datatypes

On Thu, Mar 3, 2016 at 11:45 AM, Emre Hasegeli wrote: > > Emre, I checked original thread and didn't find sample data. Could you > provide them for testing ? > > I found it on the Git history: > > >

Re: [HACKERS] The plan for FDW-based sharding

On Tue, Mar 8, 2016 at 6:40 AM, Craig Ringer wrote: > Either that, or bless experimental features/API as an official concept. > I'd quite like that myself - stuff that's in Pg, but documented as "might > change or go away in the next release, experimental feature". As

Re: [HACKERS] SP-GiST support for inet datatypes

On Thu, Mar 3, 2016 at 8:51 AM, Oleg Bartunov <obartu...@gmail.com> wrote: > > > On Wed, Mar 2, 2016 at 11:56 PM, Emre Hasegeli <e...@hasegeli.com> wrote: > >> Attached patches add SP-GiST support to the inet datatypes. The >> operator class comes with a s

Re: [HACKERS] SP-GiST support for inet datatypes

On Wed, Mar 2, 2016 at 11:56 PM, Emre Hasegeli wrote: > Attached patches add SP-GiST support to the inet datatypes. The operator > class comes with a small change on the SP-GiST framework to allow fixed > number of child nodes. > > The index is like prefix tree except that it

Re: [HACKERS] The plan for FDW-based sharding

On Mar 3, 2016 4:47 AM, "Michael Paquier" wrote: > > On Wed, Mar 2, 2016 at 6:54 PM, Alexander Korotkov > wrote: > > If FDWs existed then Postgres XC/XL were being developed then I believe they > > would try to build full-featured prototype

Re: [HACKERS] The plan for FDW-based sharding

On Wed, Mar 2, 2016 at 4:36 AM, Tomas Vondra wrote: Hi, > > On 03/01/2016 08:02 PM, Bruce Momjian wrote: > >> On Tue, Mar 1, 2016 at 07:56:58PM +0100, Petr Jelinek wrote: >> >>> Note that I am not saying that other discussed approaches are any >>> better, I am

Re: [HACKERS] The plan for FDW-based sharding

On Tue, Mar 1, 2016 at 7:03 PM, Robert Haas wrote: > On Tue, Mar 1, 2016 at 10:37 AM, Bruce Momjian wrote: > > On Tue, Mar 1, 2016 at 10:19:45AM -0500, Robert Haas wrote: > >> > Two reasons: > >> > 1. There is no ideal implementation of DTM which will

Re: [HACKERS] WIP: Upper planner pathification

On Tue, Mar 1, 2016 at 3:11 PM, Teodor Sigaev wrote: > The basic point of this patch is to apply the generate-and-compare-Paths >> paradigm to the planning steps after query_planner(), which only covers >> > ... > > The present patch addresses this problem by inventing Path

Re: [HACKERS] The plan for FDW-based sharding

On Fri, Feb 26, 2016 at 3:50 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Wed, Feb 24, 2016 at 3:05 PM, Oleg Bartunov <obartu...@gmail.com> > wrote: > > I already several times pointed, that we need XTM to be able to continue > > development in different direc

Re: [HACKERS] The plan for FDW-based sharding

On Wed, Feb 24, 2016 at 12:17 PM, Alexander Korotkov < a.korot...@postgrespro.ru> wrote: > Hi, Bruce! > > The important point for me is to distinguish different kind of plans: > implementation plan and research plan. > If we're talking about implementation plan then it should be proven that >

Re: [HACKERS] [WIP] speeding up GIN build with parallel workers

On Wed, Feb 17, 2016 at 6:55 PM, Constantin S. Pan wrote: > On Sat, 16 Jan 2016 01:38:39 +0300 > "Constantin S. Pan" wrote: > > > The task of building GIN can require lots of time and eats 100 % CPU, > > but we could easily make it use more than a 100 %,

Re: [HACKERS] Figures in docs

On Wed, Feb 17, 2016 at 4:17 AM, Tatsuo Ishii wrote: > It seems there's no figures/diagrams in our docs. I vaguely recall that > we used to have a few diagrams in our docs. If so, was there any > technical reason to remove them? > I don't know the reason, but it's shame,

Re: [HACKERS] tsearch_extras extension

On Wed, Feb 17, 2016 at 6:57 AM, Tim Abbott wrote: > Just following up here since I haven't gotten a reply -- I'd love to work > with someone from the Postgres community on a plan to make the > tsearch_extras functionality available as part of mainline postgres. > > >

Re: [HACKERS] pglogical - logical replication contrib module

On Tue, Feb 16, 2016 at 5:38 PM, Bruce Momjian wrote: > On Tue, Jan 26, 2016 at 08:14:26PM -0800, Joshua Drake wrote: > > On 12/31/2015 03:34 PM, Petr Jelinek wrote: > > >Hi, > > > > > >I'd like to submit the replication solution which is based on the > > >pglogical_output [1]

[HACKERS] commitfest problem ?

This entry https://commitfest.postgresql.org/8/419/ contains very unrelated patches from another commitfest. I think Oleg

Re: [HACKERS] [WIP] ALTER ... OWNER TO ... CASCADE

On Mon, Feb 15, 2016 at 7:25 PM, Tom Lane wrote: > Teodor Sigaev writes: > >> So basically, a generic CASCADE facility sounds like a lot of work to > >> produce something that would seldom be anything but a foot-gun. > > > DELETE FROM or TRUNCATE could be

Re: [HACKERS] old bug in full text parser

On Wed, Feb 10, 2016 at 7:21 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Oleg Bartunov <obartu...@gmail.com> writes: > > It looks like there is a very old bug in full text parser (somebody > > pointed me on it), which appeared after moving tsearch2 into the core. >

Re: [HACKERS] old bug in full text parser

On Wed, Feb 10, 2016 at 7:45 PM, Mike Rylander <mrylan...@gmail.com> wrote: > On Wed, Feb 10, 2016 at 4:28 AM, Oleg Bartunov <obartu...@gmail.com> > wrote: > > It looks like there is a very old bug in full text parser (somebody > pointed > > me on it), whi

Re: [HACKERS] old bug in full text parser

On Wed, Feb 10, 2016 at 12:28 PM, Oleg Bartunov <obartu...@gmail.com> wrote: > It looks like there is a very old bug in full text parser (somebody > pointed me on it), which appeared after moving tsearch2 into the core. The > problem is in how full text parser process hyphen

[HACKERS] old bug in full text parser

It looks like there is a very old bug in full text parser (somebody pointed me on it), which appeared after moving tsearch2 into the core. The problem is in how full text parser process hyphenated words. Our original idea was to report hyphenated word itself as well as its parts and ignore

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

pro.ru> > wrote: >> >> This patch was originally developed by Teodor Sigaev and Oleg Bartunov in >> 2009, so all credit goes to them. Any feedback is welcome. > > This is not a small patch: > 28 files changed, 2441 insertions(+), 380 deletions(-) > And the last CF of 9.6

Re: [HACKERS] [PATCH] Phrase search ported to 9.6

On Tue, Feb 2, 2016 at 2:04 PM, Alvaro Herrera wrote: > Andreas Joseph Krogh wrote: > > > Which seems to indicate it has received a fair amount of testing and is > quite > > stable. > > Hopefully it integrates into the 9.6 codebase without too much risk. > > Yes, yes,

Re: [HACKERS] Fuzzy substring searching with the pg_trgm extension

On Fri, Jan 29, 2016 at 1:11 PM, Alvaro Herrera wrote: > Artur Zakirov wrote: > > > What status of this patch? In commitfest it is "Needs review". > > "Needs review" means it needs a reviewer to go over it and, uh, review > it. Did I send an email to you prodding you

[HACKERS] thanks for FOSDEM/PGDay 2016 Developer Meeting

I read https://wiki.postgresql.org/wiki/FOSDEM/PGDay_2016_Developer_Meeting and would like to say thanks for such nice review of meeting. Oleg

Re: [HACKERS] New committer

On Thu, Jan 28, 2016 at 5:37 PM, Magnus Hagander wrote: > Hello! > > The PostgreSQL core team would like to welcome Dean Rasheed as a new > committer for the PostgreSQL project. > > Dean - welcome! Now let's see how quickly you can break the buildfarm! > Congratulations, of

[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

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

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

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.

[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

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

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

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"

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,

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

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

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... >> >> >

  1   2   3   4   5   6   7   8   9   10   >