Skip to content

Improve postgres memory#1794

Merged
shawncal merged 9 commits intomicrosoft:mainfrom
JadynWong:jadyn/improve-postgres-memory
Jul 3, 2023
Merged

Improve postgres memory#1794
shawncal merged 9 commits intomicrosoft:mainfrom
JadynWong:jadyn/improve-postgres-memory

Conversation

@JadynWong
Copy link
Contributor

@JadynWong JadynWong commented Jun 30, 2023

Motivation and Context

Follow #1735 (review) advice to rename methods and separate responsibilities.

Description

  • Separate the responsibilities of PostgresMemoryStore and PostgresDbClient.
  • Add the real batch methods to PostgresDbClient.
  • Save timestamp with TIMESTAMP WITH TIME ZONE type
  • Stop creating index

Contribution Checklist

@JadynWong JadynWong requested a review from a team as a code owner June 30, 2023 17:09
@github-actions github-actions bot added .NET Issue or Pull requests regarding .NET code kernel Issues or pull requests impacting the core kernel labels Jun 30, 2023
@JadynWong JadynWong force-pushed the jadyn/improve-postgres-memory branch from 80b0a3f to 7d73b22 Compare June 30, 2023 17:22
@JadynWong JadynWong force-pushed the jadyn/improve-postgres-memory branch from e8bea66 to 4e5177c Compare July 3, 2023 03:24
@dmytrostruk
Copy link
Member

Should fix #1810

@dmytrostruk dmytrostruk self-assigned this Jul 3, 2023
@dmytrostruk dmytrostruk added ai connector Anything related to AI connectors memory connector labels Jul 3, 2023
@dmytrostruk dmytrostruk linked an issue Jul 3, 2023 that may be closed by this pull request
Copy link
Member

@dmytrostruk dmytrostruk left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@JadynWong Thank you for this improvement, looks great!
I left small comments, as soon as they are resolved, we can merge this to main.

I verified the changes with integration tests and Example39_Postgres locally - works as expected.

@dmytrostruk dmytrostruk added the PR: feedback to address Waiting for PR owner to address comments/questions label Jul 3, 2023
@JadynWong JadynWong requested a review from dmytrostruk July 3, 2023 15:32
Copy link
Member

@dmytrostruk dmytrostruk left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM, thank you!

@dmytrostruk dmytrostruk added PR: ready to merge PR has been approved by all reviewers, and is ready to merge. and removed PR: feedback to address Waiting for PR owner to address comments/questions labels Jul 3, 2023
@shawncal shawncal added this pull request to the merge queue Jul 3, 2023
Merged via the queue into microsoft:main with commit b139203 Jul 3, 2023
@JadynWong JadynWong deleted the jadyn/improve-postgres-memory branch July 4, 2023 01:04
shawncal pushed a commit to shawncal/semantic-kernel that referenced this pull request Jul 6, 2023
### Motivation and Context
<!-- Thank you for your contribution to the semantic-kernel repo!
Please help reviewers and future users, providing the following
information:
  1. Why is this change required?
  2. What problem does it solve?
  3. What scenario does it contribute to?
  4. If it fixes an open issue, please link to the issue here.
-->
Follow
microsoft#1735 (review)
advice to rename methods and separate responsibilities.

### Description
<!-- Describe your changes, the overall approach, the underlying design.
These notes will help understanding how your code works. Thanks! -->
- Separate the responsibilities of PostgresMemoryStore and
PostgresDbClient.
- Add the real batch methods to PostgresDbClient.
- Save timestamp with `TIMESTAMP WITH TIME ZONE` type
- Stop creating index

### Contribution Checklist
<!-- Before submitting this PR, please make sure: -->
- [x] The code builds clean without any errors or warnings
- [x] The PR follows SK Contribution Guidelines
(https://github.com/microsoft/semantic-kernel/blob/main/CONTRIBUTING.md)
- [x] The code follows the .NET coding conventions
(https://learn.microsoft.com/dotnet/csharp/fundamentals/coding-style/coding-conventions)
verified with `dotnet format`
- [x] All unit tests pass, and I have added new tests where possible
- [x] I didn't break anyone 😄

---------

Co-authored-by: Dmytro Struk <13853051+dmytrostruk@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

ai connector Anything related to AI connectors kernel Issues or pull requests impacting the core kernel memory connector .NET Issue or Pull requests regarding .NET code PR: ready to merge PR has been approved by all reviewers, and is ready to merge.

Projects

Archived in project

Development

Successfully merging this pull request may close these issues.

Understanding of pgvector indexing seems incorrect

3 participants