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

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

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

Re: [HACKERS] Horizontal scalability/sharding

On Tue, Sep 1, 2015 at 7:08 PM, Robert Haas wrote: > On Tue, Sep 1, 2015 at 12:00 AM, Pavan Deolasee > wrote: > > My worry is that if we start implementing them again from scratch, it > will > > take a few years before we get them in a usable

Re: [HACKERS] Horizontal scalability/sharding

On Mon, Aug 31, 2015 at 5:48 AM, Bruce Momjian wrote: > On Sun, Aug 30, 2015 at 10:08:06PM -0400, Bruce Momjian wrote: > > On Mon, Aug 31, 2015 at 09:53:57AM +0900, Michael Paquier wrote: > > > Well, I have had many such discussions with XC/XL folks, and that > was my > > >

Re: [HACKERS] Horizontal scalability/sharding

the acceptance of this approach? What actually is the FDW approach? Since its not been written down anywhere, or even explained verbally, how can anyone actually agree to it? July, 2015: Oleg Bartunov and his new company Postgres Professional (PP) started to think about joining the FDW approach

Re: [HACKERS] Proposal: Implement failover on libpq connect level.

On Wed, Aug 19, 2015 at 4:46 PM, Andres Freund and...@anarazel.de wrote: On 2015-08-19 09:41:32 -0400, Tom Lane wrote: In fact, they'd still need to use DNS balancing for Postgres, because not everything connects with libpq (think JDBC for instance). It already does support this though.

Re: [HACKERS] jsonb array-style subscripting

On Mon, Aug 17, 2015 at 11:26 PM, Peter Geoghegan p...@heroku.com wrote: On Mon, Aug 17, 2015 at 12:26 PM, Merlin Moncure mmonc...@gmail.com wrote: ...is a good idea. postgres operators tend to return immutable copies of the item they are referring to. This patch does not add an operator

Re: [HACKERS] GIN pending list clean up exposure to SQL

On Thu, Aug 13, 2015 at 2:19 AM, Jeff Janes jeff.ja...@gmail.com wrote: I've written a function which allows users to clean up the pending list. It takes the index name and returns the number of pending list pages deleted. # select * from gin_clean_pending_list('foo_text_array_idx');

Re: [HACKERS] Speakers Wanted for pgDay Cuba

I'm probably going, but my company supports this trip. On Thu, Jul 23, 2015 at 10:35 PM, Josh Berkus j...@agliodbs.com wrote: Contributors: We are looking for one or more PostgreSQL contributors to travel to Havana, Cuba, to present at the second pgDay Cuba. In order to encourage this

Re: [HACKERS] A huge debt of gratitude - Michael Stonebraker

Nice to hear you again Jolly ! On Wed, Jul 22, 2015 at 1:42 AM, Jolly Chen jo...@chenfamily.com wrote: Hey everyone, You have probably heard that Mike Stonebraker recently won the Turing award. A recording of his award lecture is available at: https://www.youtube.com/watch?v=BbGeKi6T6QI

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 aekorot...@gmail.com wrote: Hackers, currently built-in , @, @ array operators have selectivity estimations while same operator in intarray contrib haven't them.

Re: [HACKERS] WIP: Access method extendability

On Tue, Oct 28, 2014 at 7:57 PM, Simon Riggs si...@2ndquadrant.com wrote: On 28 October 2014 14:53, Robert Haas robertmh...@gmail.com wrote: On Tue, Oct 28, 2014 at 10:22 AM, Simon Riggs si...@2ndquadrant.com wrote: Or put it another way, it will be easier to write new index AMs because

Re: [HACKERS] GIN pageinspect functions

On Tue, Oct 7, 2014 at 9:03 PM, Heikki Linnakangas hlinnakan...@vmware.com 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

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[] and

Re: [HACKERS] Collations and Replication; Next Steps

On Thu, Sep 18, 2014 at 3:25 PM, Martijn van Oosterhout klep...@svana.org 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

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 p...@heroku.com wrote: On Wed, Sep 17, 2014 at 9:06 PM, Oleg Bartunov obartu...@gmail.com 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] jsonb format is pessimal for toast compression

I did quick test on the same bookmarks to test performance of 9.4beta2 and 9.4beta2+patch The query was the same we used in pgcon presentation: SELECT count(*) FROM jb WHERE jb @ '{tags:[{term:NYC}]}'::jsonb; table size | time (ms) 9.4beta2:1374 Mb |

Re: [HACKERS] Minmax indexes

+1 for BRIN ! On Thu, Aug 7, 2014 at 6:16 PM, Simon Riggs si...@2ndquadrant.com wrote: On 7 August 2014 14:53, Robert Haas robertmh...@gmail.com wrote: On Wed, Aug 6, 2014 at 4:06 PM, Nicolas Barbier nicolas.barb...@gmail.com wrote: 2014-08-06 Claudio Freire klaussfre...@gmail.com: So, I

Re: [HACKERS] Why is it JSQuery?

People, we have many other tasks than guessing the language name. jsquery is just an extension, which we invent to test our indexing stuff. Eventually, it grew out. I think we'll think on better name if developers agree to have it in core. For now, jsquery is good enough to us. jsquery name

Re: [HACKERS] Why is it JSQuery?

The closest problem we have is jsonb statistics (lack of, actually) , which prevents use of all the power of jsquery. I hope Jan Urbański could work on this. Oleg On Tue, Jun 10, 2014 at 11:06 PM, Oleg Bartunov obartu...@gmail.com wrote: People, we have many other tasks than guessing

Re: [HACKERS] Why is it JSQuery?

Jsquery - is QUERY language, JsonPath - is language to EXTRACT json parts. On Fri, Jun 6, 2014 at 4:34 AM, David E. Wheeler da...@justatheory.com wrote: On Jun 5, 2014, at 5:25 PM, Andrew Dunstan and...@dunslane.net wrote: My understanding is that it's meant to be analogous to tsquery. At

Re: [HACKERS] jsonb access operators inefficiency

The patch really improves access performance to jsonb. On the delicious bookmarks I got 5 times better performance.Now jsonb outperforms json on simple access (slide 12 of pgcon presentation) by 103 times ! Oleg On Fri, May 30, 2014 at 9:35 AM, Teodor Sigaev teo...@sigaev.ru wrote: Hi!

Re: [HACKERS] default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)

+1 but bit confused with json instead of jsonb On Sun, May 11, 2014 at 1:00 AM, Andrew Dunstan and...@dunslane.net wrote: On 05/10/2014 04:42 PM, Heikki Linnakangas wrote: The main difference between the two opclasses from a user's standpoint is not whether they hash or not. The big

Re: [HACKERS] Wanted: jsonb on-disk representation documentation

FYI, http://obartunov.livejournal.com/178495.html This is hash based gin opclass for hstore with all operators support. It's pity we had no time to do the same for jsonb, but we may include it and couple of other opclasses to contrib/jsonx. Oleg On Wed, May 7, 2014 at 12:18 AM, Peter Geoghegan

Re: [HACKERS] 9.4 release notes

Bruce, you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass for GIN. Something like Alexander Korotkov introduced an elegant jsonb_hash ops for GIN, which competes with MongoDB performance in contains operator. Here is a link to discussion -

Re: [HACKERS] 9.4 release notes

I agree, no mongo :) On Sun, May 4, 2014 at 8:47 PM, Magnus Hagander mag...@hagander.net wrote: On Sun, May 4, 2014 at 4:06 PM, Oleg Bartunov obartu...@gmail.com wrote: Bruce, you forgot Alexander Korotkov, who contributed jsonb_hash_ops opclass for GIN. Something like Alexander Korotkov

Re: [HACKERS] [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.

I found a bit confusing, when planning time is greater total time, so +1 for execution time. On Thu, Apr 17, 2014 at 3:35 AM, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: Where are we on this? I still see: test= EXPLAIN ANALYZE SELECT 1;

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

We are working to avoid this limitation. On Tue, Apr 8, 2014 at 10:54 PM, Peter Geoghegan p...@heroku.com wrote: On Mon, Apr 7, 2014 at 8:29 PM, Michael Paquier michael.paqu...@gmail.com wrote: Documentation of jsonb tells that jsonb documents should be kept at a reasonable size to reduce

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

On Wed, Apr 9, 2014 at 1:48 AM, Tom Lane t...@sss.pgh.pa.us wrote: Oleg Bartunov obartu...@gmail.com writes: We are working to avoid this limitation. What do you mean by that ... do you see it as something that could be fixed quickly, or is this a long-term improvement project? Unfortunately

[HACKERS] json(b) equality rules

Hi there, I'm wondering if we should follow all js equility rules as nicely visualized in http://strilanc.com/visualization/2014/03/27/Better-JS-Equality-Table.html Oleg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] json(b) equality rules

Sure, we don't follow. I mean should we add to documentation such matrices. Oleg On Thu, Apr 3, 2014 at 11:32 AM, Oleg Bartunov obartu...@gmail.com wrote: Hi there, I'm wondering if we should follow all js equility rules as nicely visualized in http://strilanc.com/visualization/2014/03/27

Re: [HACKERS] json(b) equality rules

Well, we don't supported Infinity and NaN in json(b), as well as Json standard :) Now we need a script, which generated nice html table. On Thu, Apr 3, 2014 at 12:40 PM, Yeb Havinga yebhavi...@gmail.com wrote: On 2014-04-03 09:40, Oleg Bartunov wrote: Sure, we don't follow. I mean should we

Re: [HACKERS] Doing better at HINTing an appropriate column within errorMissingColumn()

Very interesting idea, I'd think about optionally add similarity hinting support to psql tab. With, say, 80% of similarity matching, it shouldn't be very annoying. For interactive usage there is no risk of slowdown. On Mar 27, 2014 11:11 PM, Peter Geoghegan p...@heroku.com wrote: With the

Re: [HACKERS] jsonb status

It's easy to add support of other operations to hash_ops, so it will be on par with default GIN opclass, at the price of bigger size. We can add it later to contrib/jsonbext. I'm mostly worrying about changing semantics of scalar. On Sun, Mar 23, 2014 at 4:27 AM, Peter Geoghegan

Re: [HACKERS] jsonb status

Alexander will take a look on TriConsistent function. On Mon, Mar 17, 2014 at 9:48 PM, Andrew Dunstan and...@dunslane.net wrote: On 03/16/2014 04:10 AM, Peter Geoghegan wrote: On Thu, Mar 13, 2014 at 2:00 PM, Andrew Dunstan and...@dunslane.net wrote: I'll be travelling a good bit of

Re: [HACKERS] jsonb and nested hstore

VODKA index will have no lenght limitation. On Fri, Mar 14, 2014 at 3:07 PM, Tomas Vondra t...@fuzzy.cz wrote: On 13 Březen 2014, 23:39, Peter Geoghegan wrote: On Thu, Mar 13, 2014 at 2:21 AM, Greg Stark st...@mit.edu wrote: It does sound like the main question here is which opclass should be

Re: [HACKERS] jsonb and nested hstore

9.5 may too optimistic :) On Fri, Mar 14, 2014 at 11:18 PM, Josh Berkus j...@agliodbs.com wrote: On 03/14/2014 04:52 AM, Oleg Bartunov wrote: VODKA index will have no lenght limitation. Yeah, so I think we go with what we have, and tell people if you're hitting these length issues, wait

Re: [HACKERS] jsonb and nested hstore

On Thu, Mar 13, 2014 at 4:21 PM, Alexander Korotkov aekorot...@gmail.com wrote: On Thu, Mar 13, 2014 at 1:21 PM, Greg Stark st...@mit.edu wrote: Well these are just normal gin and gist indexes. If we want to come up with new index operator classess we can still do that and keep the old ones

Re: [HACKERS] jsonb and nested hstore

Also, GiST index is faster for create/update operations. I really hope we will improve jsonb indexing in the next one-two releases. For now I'd suggest people index expressional indexes to index just interesting keys or use GiST. On Wed, Mar 12, 2014 at 5:15 PM, Tomas Vondra t...@fuzzy.cz wrote:

Re: [HACKERS] jsonb and nested hstore

On Thu, Mar 13, 2014 at 12:10 AM, Peter Geoghegan p...@heroku.com wrote: On Wed, Mar 12, 2014 at 11:57 AM, Oleg Bartunov obartu...@gmail.com wrote: Also, GiST index is faster for create/update operations. I really hope we will improve jsonb indexing in the next one-two releases. For now I'd

Re: [HACKERS] jsonb and nested hstore

On Thu, Mar 6, 2014 at 12:43 PM, Peter Geoghegan p...@heroku.com wrote: On Thu, Mar 6, 2014 at 12:23 AM, Teodor Sigaev teo...@sigaev.ru wrote: That's possible to introduce GUC variable for i/o functions which will control old bug-to-bug behavior. IMHO, this is much better option that stopping

Re: [HACKERS] jsonb and nested hstore

Hi there, Looks like consensus is done. I and Teodor are not happy with it, but what we can do :) One thing I want to do is to reserve our contribution to the flagship feature (jsonb), particularly, binary storage for nested structures and indexing. Their work was sponsored by Engine Yard. As

Re: [HACKERS] jsonb and nested hstore

I meant in Release Notes for 9.4 On Thu, Mar 6, 2014 at 10:26 PM, Andrew Dunstan and...@dunslane.net wrote: On 03/06/2014 12:50 PM, Oleg Bartunov wrote: Hi there, Looks like consensus is done. I and Teodor are not happy with it, but what we can do :) One thing I want to do

Re: [HACKERS] jsonb and nested hstore

On Thu, Mar 6, 2014 at 10:54 PM, Josh Berkus j...@agliodbs.com wrote: g? On 03/06/2014 09:50 AM, Oleg Bartunov wrote: Looks like consensus is done. I and Teodor are not happy with it, but what we can do :) One thing I want to do is to reserve our contribution to the flagship feature (jsonb

Re: [HACKERS] jsonb and nested hstore

Thanks, looks like a bug. On Tue, Mar 4, 2014 at 12:38 PM, Peter Geoghegan p...@heroku.com wrote: Hi Oleg, On Mon, Mar 3, 2014 at 7:17 AM, Oleg Bartunov obartu...@gmail.com wrote: you can always look at our development repository: I think I found a bug: [local]/postgres=# \d+ bar

Re: [HACKERS] jsonb and nested hstore

I tried try.mongodb.com 25 == 25.0 true On Tue, Mar 4, 2014 at 2:18 PM, Peter Geoghegan p...@heroku.com wrote: On Tue, Mar 4, 2014 at 2:18 AM, Teodor Sigaev teo...@sigaev.ru wrote: That is because compareJsonbValue compares numeric values with a help of numeric_cmp() instead of comparing

Re: [HACKERS] jsonb and nested hstore

Andres, you can always look at our development repository: https://github.com/feodor/postgres/tree/hstore - hstore only, https://github.com/feodor/postgres/tree/jsonb_and_hstore - hstore with jsonb Since we were concentrated on the jsonb_and_hstore branch we usually wait Andrew, who publish

Re: [HACKERS] jsonb and nested hstore

On Mon, Mar 3, 2014 at 7:22 PM, Andres Freund and...@2ndquadrant.com wrote: Hi Oleg, On 2014-03-03 19:17:12 +0400, Oleg Bartunov wrote: Since we were concentrated on the jsonb_and_hstore branch we usually wait Andrew, who publish patch. You last issues were addressed in both branches

Re: [HACKERS] jsonb and nested hstore

Yes, the repository you mentioned is the last version of our development. It contains various fixes of issues by Andres, but we are waiting Andrew, who is working on jsonb stuff. On Mon, Feb 24, 2014 at 5:34 PM, Tomas Vondra t...@fuzzy.cz wrote: On 7.2.2014 00:47, Andrew Dunstan wrote: On

Re: [HACKERS] jsonb and nested hstore

Andrew provided us more information and we'll work on recv. What people think about testing this stuff ? btw, we don't have any regression test on this. Oleg On Wed, Feb 5, 2014 at 2:03 AM, Josh Berkus j...@agliodbs.com wrote: On 02/03/2014 07:27 AM, Andres Freund wrote: On 2014-02-03

Re: [HACKERS] GIN improvements part2: fast scan

Tomasa, it'd be nice if you use real data in your testing. One very good application of gin fast-scan is dramatic performance improvement of hstore/jsonb @ operator, see slides 57, 58 http://www.sai.msu.su/~megera/postgres/talks/hstore-dublin-2013.pdf. I'd like not to lost this benefit :) Oleg

Re: [HACKERS] jsonb and nested hstore

Hmm, neither me, nor Teodor have experience and knowledge with populate_record() and moreover hstore here is virgin and we don't know the right behaviour, so I think we better take it from jsonb, once Andrew realize it. Andrew ? On Fri, Jan 31, 2014 at 4:52 AM, Andrew Dunstan and...@dunslane.net

Re: [HACKERS] nested hstore patch - FailedAssertion(!(value-array.nelems == 1)

https://github.com/feodor/postgres On Wed, Jan 15, 2014 at 11:10 AM, Erik Rijkers e...@xs4all.nl wrote: On Wed, January 15, 2014 08:01, Oleg Bartunov wrote: It doesn't crashed in the last version in our repository. =# select 'x'::hstore || ('a=1':: hstore) ; ?column

Re: [HACKERS] nested hstore patch

Erik, thanks for docs fixes, we have even more :) Oleg On Tue, Jan 14, 2014 at 4:18 AM, Erik Rijkers e...@xs4all.nl wrote: On Mon, January 13, 2014 18:30, Andrew Dunstan wrote: On 01/13/2014 11:16 AM, Oleg Bartunov wrote: Andrew, did you run perl script ? Actually, I found, that operator

Re: [HACKERS] nested hstore patch - FailedAssertion(!(value-array.nelems == 1)

It doesn't crashed in the last version in our repository. =# select 'x'::hstore || ('a=1':: hstore) ; ?column? --- x, a, 1 (1 row) On Wed, Jan 15, 2014 at 3:53 AM, Erik Rijkers e...@xs4all.nl wrote: On Mon, January 13, 2014 16:36, Andrew Dunstan wrote: A new version of the

Re: [HACKERS] nested hstore patch

Thank you, Erik ! Oleg On Mon, Jan 13, 2014 at 12:25 PM, Erik Rijkers e...@xs4all.nl wrote: On Mon, January 13, 2014 00:24, Erik Rijkers wrote: On Sat, January 11, 2014 22:47, Andrew Dunstan wrote: On 01/11/2014 03:03 PM, Erik Rijkers wrote: On Sat, January 11, 2014 20:30, Peter Eisentraut

Re: [HACKERS] nested hstore patch

Andrew, did you run perl script ? Actually, I found, that operator table needs to be fixed. Oleg On Mon, Jan 13, 2014 at 7:36 PM, Andrew Dunstan and...@dunslane.net wrote: On 01/13/2014 03:25 AM, Erik Rijkers wrote: There are errors in the example expressions in Table F-6. hstore

Re: [HACKERS] nested hstore patch

I moved patch to the January commitfest (https://commitfest.postgresql.org/action/patch_view?id=1289) . Oleg PS. Kudos to Teodor and his mobile phone, which he used to synchronize branches on github. On Fri, Jan 10, 2014 at 2:08 AM, Andrew Dunstan and...@dunslane.net wrote: On 01/09/2014

Re: [HACKERS] [BUG FIX] Version number expressed in octal form by mistake

Yes, we got temp licence key from them and will provide full report. On Wed, Dec 25, 2013 at 4:38 PM, Joel Jacobson j...@trustly.com wrote: As reported by Andrey Karpov in his article http://www.viva64.com/en/b/0227/, the version number is expressed in octal form 070100 should be changed to

Re: [HACKERS] GIN improvements part 1: additional information

Guys, before digging deep into the art of comp/decomp world I'd like to know if you familiar with results of http://wwwconference.org/www2008/papers/pdf/p387-zhangA.pdf paper and some newer research ? Do we agree in what we really want ? Basically, there are three main features: size,

Re: [HACKERS] Cube extension kNN support

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

Re: [HACKERS] Looking for information on our elephant

Tatsuo, you could ask Marc about archives. Probably he has original mbox files. Oleg On Sun, Sep 22, 2013 at 11:18 AM, Tatsuo Ishii is...@postgresql.org wrote: Oleg, Unfortunately the archives seem to miss attached files. I love to see the attached files because they are logo images. Any

Re: [HACKERS] Looking for information on our elephant

Tatsuo, I have emails even from 1995 ! You can see that historical message here: http://www.pgsql.ru/db/mw/msg.html?mid=1238939 Re: [HACKERS] PostgreSQL logo. *Author:* yang( at )sjuphil( dot )sju( dot )edu *Date:* 1997-04-03 20:36:33

[HACKERS] \h open

I noticed there is nothing available in built-in psql help about OPEN command. Does it intentional ? postgres=# \h open No help available for open. Try \h with no arguments to see available help. Oleg

Re: [HACKERS] Hstore: Query speedups with Gin index

for me locally with the --enable-cassert configure flag. Please let me know what you think and if there is any other work that would need to be done (style cleanups, updating documentation, etc) to get this merged. Thanks! Blake On Fri, Sep 6, 2013 at 1:47 PM, Oleg Bartunov obartu

Re: [HACKERS] Hstore: Query speedups with Gin index

Blake, I think it's better to implement this patch as a separate opclass, so users will have option to choose indexing. Oleg On Tue, Sep 3, 2013 at 6:24 PM, Blake Smith blakesmi...@gmail.com wrote: Thanks for the feedback everyone. I've attached the patch that we are now running in

Re: [HACKERS] [v9.4] row level security

Any constraints could be covert channel. On Wed, Aug 28, 2013 at 4:17 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote: 2013/8/28 Oleg Bartunov obartu...@gmail.com: btw, there is serious problem with row-level security and constraints. For example, user with low security level could use unique

Re: [HACKERS] [v9.4] row level security

btw, there is serious problem with row-level security and constraints. For example, user with low security level could use unique constraint to know about existence of a row with higher security. I don't know, what is the best practice to avoid this. On Wed, Aug 28, 2013 at 1:37 AM, Greg Smith

Re: [HACKERS] Hstore: Query speedups with Gin index

Michael, take a look on http://obartunov.livejournal.com/171959.html As for the indexing stuff we already thought many times about keyvalue mixing, but real solution, probably, could come from spgist and gin combination. I mean, spgist (suffix array) instead of btree for avoiding key

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 robertmh...@gmail.com wrote: On Tue, Jul 3, 2012 at 11:34 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Jun 21, 2012 at 2:53 PM, Alexander Korotkov

Re: [HACKERS] SP-GIST docs and examples

! 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] CUDA Sorting

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, Oleg _ Oleg Bartunov

[HACKERS] NULL's support in SP-GiST

_ 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] TS: Limited cover density ranking

-- Luben Karavelov 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

Re: [HACKERS] PgNext: CFP

://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 Internet: o

Re: [HACKERS] pgsphere

:) Oleg On Tue, 10 Jan 2012, Dave Cramer wrote: Hi Oleg, On Sun, Jan 8, 2012 at 1:19 PM, Oleg Bartunov o...@sai.msu.su wrote: Dave, The situation with pgshpere is so, that I think we need new developer, since Janko keep silence :)  I wrote him several time, since I wanted pgsphere now could

Re: [HACKERS] pgsphere

On Tue, 10 Jan 2012, Jan-Benedict Glaw wrote: On Sun, 2012-01-08 22:19:53 +0400, Oleg Bartunov o...@sai.msu.su wrote: pgsphere now could benefit very much from our KNNGiST feature. This is number one development from my point of view. I and Teodor have no time to work on pgsphere, sorry

Re: [HACKERS] pgsphere

of the owners is Teodor, who is a core committer ... I hope he's not MIA. cheers andrew Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical

Re: [HACKERS] pgsphere

_ 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

Re: [HACKERS] Real-life range datasets

. 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

[HACKERS] PostgreSQL 9.1 poster picture ?

Hi there, I'm looking for the picture of PostgreSQL 9.1 poster, which we all signed at Developers Meeting. Anybody knows where it's now ? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [HACKERS] ts_rank

of that :-( Oleg, Teodor, can you give me a description of how ts_rank decided how to rank items? Thanks. Any news on this question? Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

We are working on the hackers documentation, hope to submit it before my himalaya track. Oleg On Sun, 2 Oct 2011, Tom Lane wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: On 06.09.2011 20:34, Oleg Bartunov wrote: Here is the latest spgist patch, which has all planned

Re: [HACKERS] Feature proposal: www_fdw

to be a security hazard in some people's usages. I can see that some people will want this type of functionality, but others definitely won't. regards, tom lane Regards, Oleg _ Oleg Bartunov

Re: [HACKERS] unaccent contrib

/unaccent-0.2.tar.gz Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o...@sai.msu.su, http

Re: [HACKERS] ginfastupdate.. slow

_ 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] WIP: Fast GiST index build

committed the patch now, including that fix. Thanks for a great GSoC project! Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

Here is the latest spgist patch, which has all planned features as well as all overhead, introduced by concurrency and recovery, so performance measurement should be realistic now. Oleg On Mon, 5 Sep 2011, Oleg Bartunov wrote: I attached wrong patch in previous message, sorry ! Here

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

Attached is updated SP-GiST patch, which provides full logging support and fixed several bugs (Thanks ALexander Korotkov for help). Regards, Oleg On Thu, 1 Sep 2011, Oleg Bartunov wrote: This is updates SP-GiST patch, which fixed one bug and replaced test to the locale independent one

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

I attached wrong patch in previous message, sorry ! Here is a last version. This is a new WIP of SP-GiST patch, which provides support for: 1. Concurrent vacuum 2. Vacuum logging 3. WAL replay Oleg On Thu, 1 Sep 2011, Oleg Bartunov wrote: This is updates SP-GiST patch, which fixed one bug

Re: [HACKERS] WIP: SP-GiST, Space-Partitioned GiST

This is updates SP-GiST patch, which fixed one bug and replaced test to the locale independent one. On Wed, 31 Aug 2011, Oleg Bartunov wrote: Hi there, attached is our WIP-patch for 9.2 development source tree, which provides implementation of SP-GiST (prototype was presented at PGCon-2011

[HACKERS] WIP: SP-GiST, Space-Partitioned GiST

no overlaps) and much better performance on real-life data, plus much better index creation time. Also, we appreciate your comments and suggestions about API. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head

[HACKERS] WIP: SP-GiST, Space-Partitioned GiST

Hi there, attached is WIP-patch for 9.2 development source tree, which provides implementation of SP-GiST (prototype was presented at PGCon-2011, see http://www.pgcon.org/2011/schedule/events/309.en.html and presentation for details) as a core feature. Main differences from prototype version:

Re: [HACKERS] index-only scans

updating, but I haven't tracked 'em down yet. Comments, testing, review appreciated... Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute

Re: [HACKERS] blog post on ancient history

for granting commit access back then that we do now. Regards, Oleg _ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: o

Re: [HACKERS] ts_count

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 Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru

Re: [HACKERS] k-neighbourhood search in databases

-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.ru), Sternberg

Re: [HACKERS] k-neighbourhood search in databases

On Sun, 10 Apr 2011, Jesper Krogh wrote: On 2011-04-10 12:18, Oleg Bartunov wrote: Wow, custom solution for 2008 still much faster Denali 2011 solution. Also, what's about not spatial data types ? In our approach, we can provide knn for any datatype, which has GiST index and distance method

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