[GitHub] [age] GPF199541 commented on issue #1127: AGE Integrationn-Project Planning and Requirements Gathering
GPF199541 commented on issue #1127: URL: https://github.com/apache/age/issues/1127#issuecomment-1700236958 How to choose a shard ID on citus is a problem -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] dehowef commented on issue #1000: Index is not used in the WHERE clause
dehowef commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1700137474 @vladiksun I have been looking into how B-tree indexing works and indexing in general, and I came across [documentation](https://www.postgresql.org/docs/15/xindex.html#XINDEX-BTREE-STRAT-TABLE) that shows that B-tree indexes rely on operators (=,<,>,<=,>=) to work. Since the IN operator filter as shown by EXPLAIN ANALYZE is a function call, I feel that this might contribute to why the index is not being used. The agtype operator class is defined in the age--x.x.x.sql file, maybe looking there might offer further insight. Just thought I'd share what I've been looking into with you. Hope this might be helpful. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age] WendelLana commented on issue #1004: Research multi-label
WendelLana commented on issue #1004:
URL: https://github.com/apache/age/issues/1004#issuecomment-1699864880
## Benchmarking of label IDs in an array with identical data
In this benchmarking, I conducted tests on three tables, each containing
identical data, with the only difference being the data type, changed from
`int4` (integer) to `int4[]` (integer array).
### Setup
**Creation of tables**
```sql
CREATE TABLE labels_test1.ag_label_vertex
(
id bigint NOT NULL,
label_id INT4,
PRIMARY KEY (id)
);
CREATE TABLE labels_test1.ag_label_vertex_array
(
id bigint NOT NULL,
label_id INT4[],
PRIMARY KEY (id)
);
```
**Populating the tables**
- The label_id array only contains 1 integer.
- Created 100 (one million) vertices (rows) for each table, same data in
both tables.
- Label IDs range from 1 to 10.
**Table 1 sample - ag_label_vertex**
```
SELECT * FROM labels_test1.ag_label_vertex LIMIT 10;
id | label_id
+--
1 |9
2 |5
3 | 10
4 |2
5 |4
6 |5
7 |3
8 |4
9 |4
10 |5
(10 rows)
```
**Table 2 sample - ag_label_vertex_array**
```
SELECT * FROM labels_test1.ag_label_vertex_array LIMIT 10;
id | label_id
+--
1 | {9}
2 | {5}
3 | {10}
4 | {2}
5 | {4}
6 | {5}
7 | {3}
8 | {4}
9 | {4}
10 | {5}
(10 rows)
```
### Queries that are tested
**Query 1 - MATCH (:1)**
```sql
EXPLAIN (ANALYZE, VERBOSE, BUFFERS)
SELECT * FROM labels_test1.ag_label_vertex
WHERE label_id = 1;
EXPLAIN (ANALYZE, VERBOSE, BUFFERS)
SELECT * FROM labels_test1.ag_label_vertex_array
WHERE '{1}'::int4[] <@ label_id;
```
**Query 2 - MATCH (:1|2)**
```sql
EXPLAIN (ANALYZE, VERBOSE, BUFFERS)
SELECT * FROM labels_test1.ag_label_vertex
WHERE label_id = 1 OR label_id = 2;
EXPLAIN (ANALYZE, VERBOSE, BUFFERS)
SELECT * FROM labels_test1.ag_label_vertex_array
WHERE '{1}'::int4[] <@ label_id OR '{2}'::int4[] <@ label_id;
```
### Indices
I've created a table to test the queries with GIN index.
```sql
CREATE INDEX idx_label_array ON labels_test1.ag_label_vertex_array_gin USING
gin(label_id);
```
### Performance tests
Execution time of each query for the table ag_label_vertex (Integer Column)
and ag_label_vertex_array (Array Column), also a test with GIN index.
| | Integer Column | Array Column | Array with Index |
|---|---|---|---|
| Query 1 | 180.381 ms | 305.785 ms | 245.435 ms |
| Query 2 | 189.958 ms | 312.840 ms | 230.046 ms |
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14
Looks good. - Verified signature - Checked commit hash and links - Checked License and Notice file - Checked for binary files On Wed, 30 Aug 2023 at 18:31, Rafsun Masud wrote: > +1 Looks good. > - Verified signature > - Checked commit hash and links > - Checked License and Notice file > - Checked for binary files > > Thanks for the good work! > > Regards, > Rafsun Masud > > > On Tue, Aug 29, 2023 at 3:51 PM Dehowe Feng > wrote: > > > Looks good to me. Exciting for this release > > > > I checked the signature and hash, > > tags and links, > > the license and notice, > > made sure there was no unexpected binary files. > > > > I also reviewed the patch notes as well > > > > Cheers. > > > > On Wed, Aug 23, 2023 at 12:12 PM John Gemignani < > > john.gemign...@bitnine.net> > > wrote: > > > > > Dear Apache Community, > > > > > > We would like to open a discussion for the Apache AGE release 1.4.0 for > > > PostgreSQL 14. > > > > > > To learn more about Apache AGE, please see http://age.apache.org/ > > > > > > Functionalities included and addressed in this release are: > > > > > > * > > > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 14 > > > > > > NOTE: This is an initial release of PG14. There are no upgrade > > > scripts to this release. > > > > > > NOTE: Some of these reference the master branch PR that was > > > either applied to lower versions via a separate PR or > > > merged into a newly created branch. > > > > > > Added license in Python driver README.md (#956) > > > Added the toStringList() function (#1128) > > > Added toBooleanList() (#1165) > > > Added toFloatList() function (#1016) > > > Added toIntegerList() function (#1025) > > > Added regression tests for MATCH clause using labels only (#1019) > > > Added REGTYPEOID to toString function (#1036) > > > Added Dockerfile.dev & move docker-related files to "docker/" (#943) > > > Fixed complex MERGE causes crash (#897) (#961) > > > Fixed docker build files (#1104) > > > Fixed case sensitivity on label usage of reserved keyword (#1040) > > > Fixed issue 1000: Indexes created on WHERE (#1133) > > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003) > > > Fixed issue 1033: access operator on vle edge lists (#1037) > > > Fixed issue 1043: ERROR: container must be an array or object (#1046) > > > Fixed issue 1124: Segmentation fault when using specific tables (#1125) > > > Fixed issue 395: ERROR: container is not an agtype array (#1039) > > > Fixed issue 870: regarding orderability and added regression tests > (#994) > > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous > > > (#931) > > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977) > > > Fixed issue 989: Impossible to create array with > 100 items (#1001) > > > Fixed memory leak issues with age_load (#1142) > > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958) > > > Fixed MERGE crashes due to incorrect label type (#957) > > > Fixed MERGE variable reuse (#997) > > > Fixed misspellings in many AGE files (#985) > > > Fixed warning messages in DockerHub builds. (#1075) > > > Modified test_agtypes to view useful testing message (#992) > > > Optimised Antlr4ResultHandler initialization (#1169) > > > Updated CIs to pull correct image based on branch (#1105) > > > Updated files, format, and version information (#1063) > > > Updated README. > > > > > > * > > > > > > The git tag to be discussed and voted on: > > > https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 > > > > > > The git commit hash: > > > commit a33b3cf996edaa6d334e30a153ad1ff712c65518 > > > > > > The release files for 1.4.0, can be found at: > > > https://dist.apache.org/repos/dist/dev/age/PG14/1.4.0.rc0/ > > > > > > Signatures used for AGE RCs can be found in this file: > > > https://downloads.apache.org/age/KEYS > > > > > > The fingerprint of key to sign release artifacts: > > > 4293 0603 8E35 AC05 4DBB 4B58 26B6 CD9D CD5B 0045 > > > > > > For information about the contents of this release see: > > > https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 > > > > > > Please verify the above links, files, and signatures in addition to > > sharing > > > your thoughts and feedback and if we can call for a vote. > > > > > > Thank you for your time. > > > > > > John Gemignani > > > > > >
Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14
+1 Looks good. - Verified signature - Checked commit hash and links - Checked License and Notice file - Checked for binary files Thanks for the good work! Regards, Rafsun Masud On Tue, Aug 29, 2023 at 3:51 PM Dehowe Feng wrote: > Looks good to me. Exciting for this release > > I checked the signature and hash, > tags and links, > the license and notice, > made sure there was no unexpected binary files. > > I also reviewed the patch notes as well > > Cheers. > > On Wed, Aug 23, 2023 at 12:12 PM John Gemignani < > john.gemign...@bitnine.net> > wrote: > > > Dear Apache Community, > > > > We would like to open a discussion for the Apache AGE release 1.4.0 for > > PostgreSQL 14. > > > > To learn more about Apache AGE, please see http://age.apache.org/ > > > > Functionalities included and addressed in this release are: > > > > * > > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 14 > > > > NOTE: This is an initial release of PG14. There are no upgrade > > scripts to this release. > > > > NOTE: Some of these reference the master branch PR that was > > either applied to lower versions via a separate PR or > > merged into a newly created branch. > > > > Added license in Python driver README.md (#956) > > Added the toStringList() function (#1128) > > Added toBooleanList() (#1165) > > Added toFloatList() function (#1016) > > Added toIntegerList() function (#1025) > > Added regression tests for MATCH clause using labels only (#1019) > > Added REGTYPEOID to toString function (#1036) > > Added Dockerfile.dev & move docker-related files to "docker/" (#943) > > Fixed complex MERGE causes crash (#897) (#961) > > Fixed docker build files (#1104) > > Fixed case sensitivity on label usage of reserved keyword (#1040) > > Fixed issue 1000: Indexes created on WHERE (#1133) > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003) > > Fixed issue 1033: access operator on vle edge lists (#1037) > > Fixed issue 1043: ERROR: container must be an array or object (#1046) > > Fixed issue 1124: Segmentation fault when using specific tables (#1125) > > Fixed issue 395: ERROR: container is not an agtype array (#1039) > > Fixed issue 870: regarding orderability and added regression tests (#994) > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous > > (#931) > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977) > > Fixed issue 989: Impossible to create array with > 100 items (#1001) > > Fixed memory leak issues with age_load (#1142) > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958) > > Fixed MERGE crashes due to incorrect label type (#957) > > Fixed MERGE variable reuse (#997) > > Fixed misspellings in many AGE files (#985) > > Fixed warning messages in DockerHub builds. (#1075) > > Modified test_agtypes to view useful testing message (#992) > > Optimised Antlr4ResultHandler initialization (#1169) > > Updated CIs to pull correct image based on branch (#1105) > > Updated files, format, and version information (#1063) > > Updated README. > > > > * > > > > The git tag to be discussed and voted on: > > https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 > > > > The git commit hash: > > commit a33b3cf996edaa6d334e30a153ad1ff712c65518 > > > > The release files for 1.4.0, can be found at: > > https://dist.apache.org/repos/dist/dev/age/PG14/1.4.0.rc0/ > > > > Signatures used for AGE RCs can be found in this file: > > https://downloads.apache.org/age/KEYS > > > > The fingerprint of key to sign release artifacts: > > 4293 0603 8E35 AC05 4DBB 4B58 26B6 CD9D CD5B 0045 > > > > For information about the contents of this release see: > > https://github.com/apache/age/releases/tag/PG14/v1.4.0-rc0 > > > > Please verify the above links, files, and signatures in addition to > sharing > > your thoughts and feedback and if we can call for a vote. > > > > Thank you for your time. > > > > John Gemignani > > >
[GitHub] [age-website] markgomer opened a new pull request, #195: Move "Explanation about the CSV format" to document start for better clarity
markgomer opened a new pull request, #195: URL: https://github.com/apache/age-website/pull/195 As the structure of the CSV files required is unique to Apache AGE, it would be beneficial to move the section to the beginning of the document. This way, users will know upfront the structure their data needs to be in, and they can prepare their CSV files accordingly before they begin working with the functions. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age-website] MuhammadTahaNaveed opened a new pull request, #194: Remove age, age-viewer project list and contributors section
MuhammadTahaNaveed opened a new pull request, #194: URL: https://github.com/apache/age-website/pull/194 Remove age, age-viewer project list and contributors section. Removed sections    -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [age-website] Zainab-Saad commented on pull request #193: Update release notes
Zainab-Saad commented on PR #193: URL: https://github.com/apache/age-website/pull/193#issuecomment-1698633163 @eyab Thanks for pointing that out. I have updated the release notes. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
