This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table PartTest1; | |
drop table PartTest2; | |
create table PartTest1 ( | |
id bigint not null primary key, | |
value1 text | |
) partition by range (id); | |
create table PartTest2 ( | |
id bigint not null primary key, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table tst_complex_index ( | |
id1 int not null, | |
id2 int not null, | |
value text, | |
primary key (id1, id2) | |
); | |
insert into tst_complex_index (id1, id2, value) | |
select (9*g.i + 177) % 100, (191*g.i + 197) % 10001, g.i || ' text ' || (g.i + 7) % 19 | |
from generate_series(1, 1000*1000) g (i); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Line": { | |
"attributes": { | |
"location": [ | |
-369.0294189453125, | |
12.2808837890625 | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Line": { | |
"attributes": { | |
"location": [ | |
-369.0294189453125, | |
12.2808837890625 | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Line": { | |
"attributes": { | |
"location": [ | |
-369.0294189453125, | |
12.2808837890625 | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Plane": { | |
"attributes": { | |
"location": [ | |
-388.2676086425781, | |
53.424434661865234 | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Plane": { | |
"attributes": { | |
"location": [ | |
-388.2676086425781, | |
53.424434661865234 | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"A Number": { | |
"attributes": { | |
"location": [ | |
-113.16841125488281, | |
215.54180908203125 | |
], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"export_version": "1.0", | |
"main_tree": { | |
"nodes": { | |
"Frame": { | |
"attributes": { | |
"location": [ | |
0.0, | |
0.0 | |
], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
>>> p1s = np.array([[1,2,3], [4,5,6]]) | |
>>> p2s = np.array([[1,2,4], [2,5,6]]) | |
>>> abs(p1s - p2s) | |
array([[0, 0, 1], | |
[2, 0, 0]]) | |
>>> abs(p1s - p2s).max() | |
2 | |
>>> abs(p1s - p2s).max(axis=1) | |
array([1, 2]) |