Agree, I had the same idea in my mind when was writing that script.
I will migrate it to TAP suite and write a review for Michael Paquier's patch.
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
> On 26 Jan 2016, at 20:20, Alvaro Herrer
check.sh
Description: Binary data
---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
> On 12 Jan 2016, at 22:57, Simon Riggs wrote:
>
> On 12 January 2016 at 18:14, Andres Freund wrote:
> Hi,
>
> Thank you for the additional review.
>
My +1 for moving function to xlogutils.c too.
Now call to this function goes through series of callbacks so it is hard to
find it.
Personally I found it only after I have implemented same function by myself
(based on code in pg_xlogdump).
Stas Kelvich
Postgres Professional: http
be
> executed in parallel.
That’s interesting observation. Simon already pointed me to this problem in 2pc
replay, but I didn’t thought that it is so slow. I’m now working on that.
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-hacke
e
transaction context and release it only if next command isn’t our designated
COMMIT/ROLLBACK. But that is a big amount of work and requires
changes to whole transaction pipeline in postgres.
Anyway I suggest that we should consider that as a separate task.
---
Stas Kelvich
Postgres Professional
erence, but I
think it is good idea to keep
GXact as small as possible. As far as I understand the same logic was behind
split of
PGPROC to PGPROC+PGXACT in 9.2 (comment in proc.h:166)
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-h
Description: Binary data
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
> On 08 Jan 2016, at 19:29, Alvaro Herrera wrote:
>
> Simon Riggs wrote:
>
>> I think we could do better still, but this looks like the easiest 80% and
>&g
arameter ones should.
>
Fixed.
> 7) Some of the functions use intexterm that does not match the function
> name. I see two such cases - to_tsvector and setweight. Is there a
> reason for that?
>
Because sgml compiler wants unique indexterm. Both functions that you mentioned
Dec 2015, at 16:46, Tomas Vondra wrote:
>
> Hi,
>
> On 12/16/2015 01:26 PM, Stas Kelvich wrote:
>> Hi, thanks for the review.
>>
>>> 1) (nitpicking) There seem to be some minor whitespace issues, i.e.
>>> trailing spaces, empty lines being added/removed, etc.
hould be (1,1),(3,3)
Updated patch attached.
cube_distances.patch
Description: Binary data
> On 15 Dec 2015, at 21:46, Tomas Vondra wrote:
>
> Hi,
>
> On 12/07/2015 03:47 PM, Stas Kelvich wrote:
>> Hello, fixed.
>
> I've looked at the patch tod
i thought that pgbench will change aid columns to
bigint if scale is more than 2.
2pc_xlog.v2.diff
Description: Binary data
---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Thanks, Kevin.
> I assume that last one should have been *Patched master with 2PC”?
Yes, this list should look like this:
Current master without 2PC: ~42 ktps
Current master with 2PC: ~22 ktps
Patched master with 2PC: ~36 ktps
And created CommitFest entry for this patch.
--
Stas Kelv
abalance = abalance + :delta WHERE aid = :to_aid;
PREPARE TRANSACTION ':client_id.:scale';
COMMIT PREPARED ':client_id.:scale';
2pc_xlog.diff
Description: Binary data
---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Se
Hello, fixed.
cube_distances.diff
Description: Binary data
---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
> On 01 Dec 2015, at 17:52, Teodor Sigaev wrote:
>
> Patch looks good, but there ara some review notices:
> 1 gmake instal
Hello.
Done with the list of suggestions. Also heavily edit delete function.
tsvector_ops.diff
Description: Binary data
---
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
> On 27 Nov 2015, at 15:13, Teodor Sigaev wrote:
>
> Hmm, seems, i
2015, at 16:40, Alexander Korotkov wrote:
>
> Hi!
>
> On Sat, May 9, 2015 at 6:53 AM, Stas Kelvich wrote:
> Patch is pretty ready, last issue was about changed extension interface, so
> there should be migration script and version bump.
> Attaching a version with all migration
[] to_array(tsvector)
converts tsvector to array of lexemes
tsvector to_tsvector(text[])
converts array of lexemes to tsvector
tsvector_funcs.diff
Description: Binary data
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql
t; Sergey Konoplev wrote:
>> On Thu, Mar 27, 2014 at 3:26 PM, Sergey Konoplev wrote:
>>> On Sun, Sep 22, 2013 at 4:38 PM, Stas Kelvich
>>> wrote:
>>>> Here is the patch that introduces kNN search for cubes with euclidean,
>>>> taxicab and cheby
Documentation along with style fix.
distances2r3.patch
Description: Binary data
> On 08 Feb 2015, at 00:32, Alexander Korotkov wrote:
>
> Hi!
>
> On Sat, Feb 7, 2015 at 12:45 PM, Stas Kelvich wrote:
> I had updated old patch with kNN operators for cube data s
ggested syntax with minus before coordinate.
This request selects rows ordered descending by 4th coordinate:
SELECT * FROM objects ORDER BY objects.coord->-4 LIMIT 10;
Stas Kelvich.
distances2.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postg
3 ms
As we can see, kNN ordering 10 times slower than B-tree (on silly request for
R-Tree, just as example), but still 100+ times faster than full scan on this
table.
Stas.
On Sep 25, 2013, at 5:25 PM, Peter Eisentraut wrote:
> On 9/22/13 7:38 PM, Stas Kelvich wrote:
>> Here is t
Hello, hackers.
I've fixed split algorithm that was implemented in cube extension. I've changed
it according to the original Guttman paper (old version was more simple
algorithm) and also ported Alexander Korotkov's algorithm from box datatype
indexing that work faster and better on low dimensi
Hello, hackers.
In this patch I've implemented support for different storage types for cubes.
Now it supports float8, float4, int4, int2, int1. Type stored in the header of
each cube, one for all coordinates. So for cubes with int1 coordinates it can
save up to 8x disk space. Typed cubes can be
system (OSX) it is second option in both situations. I've also tested it
on FreeBSD 9.0 and Ubuntu 12.04 with the same results. So is there some ideas
how can I reproduce such results?
Stas.
points.diff
Description: Binary data
On Sep 16, 2013, at 10:48 AM, Heikki Linnakangas wrote
ring suggested syntax with minus before coordinate.
This request selects rows ordered descending by 4th coordinate:
SELECT * FROM objects ORDER BY objects.coord->-4 LIMIT 10;
Stas Kelvich.
distances.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers
On May 14, 2013, at 4:53 PM, Alexander Korotkov wrote:
> Sounds promising. Did you examine how this technique can fit into GiST? In
> current GiST interface methods don't have access to parent entries.
No, i didn't examine it yet. Anyway in this technique lots of changes should be
performed to
ay 4, 2013 at 11:19 PM, Stas Kelvich wrote:
> > I think we have at least 3 data types more or less similar to cube.
> > 1) array of ranges
> > 2) range of arrays
> > 3) 2d arrays
> > Semantically cube is most close to array or ranges. However array of ranges
> >
rrays and declare operations of
> that domain.
But what we should do when arrays in different records have different numbers
of element?
Stas Kelvich.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Hello,
some time ago I started working on the data search system (about 100-200M of
records) with queries consisted of several diapason and equality conditions,
e.g.:
WHERE dim1 BETWEEN 128 AND 137 AND
WHERE dim2 BETWEEN 4815 AND 162342 AND
WHERE dim3 = 42
ORDER BY dim1 ASC
There are 6
101 - 129 of 129 matches
Mail list logo