LANoftheDead
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
ruffsl@programming.dev to PostgreSQL@programming.devEnglish · 3 years ago

Fix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmy

github.com

external-link
message-square
1
link
fedilink
9
external-link

Fix Posts List Performance + cursor-based pagination by phiresky · Pull Request #3872 · LemmyNet/lemmy

github.com

ruffsl@programming.dev to PostgreSQL@programming.devEnglish · 3 years ago
message-square
1
link
fedilink
This PR implements two things: Cursor-based pagination for the /posts/list API request. A new opaque parameter page_v2 is added that fetches the next page based on the previous one. The request n...

cross-posted from: https://programming.dev/post/1894165

Looks like @[email protected] is looking for reviews on their latest optimizations to the Lemmy backend. Figured folks here might be interested in taking a look.

alert-triangle
You must log in or # to comment.
  • Jason Novinger@programming.devM
    link
    fedilink
    arrow-up
    2
    ·
    3 years ago

    Thanks for sharing this here! Far from an expert, but will happily take a look.

PostgreSQL@programming.dev

postgresql@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

The world’s most advanced open source relational database

Project
  • About (history)
  • Docs
  • Donate to PostgreSQL
  • Wiki
  • Planet PostgreSQL
  • IRC
  • Mailing lists:
    • pgsql-announce
    • pgsql-hackers (developers)
    • pgsql-general
    • pgsql-jobs
  • User Groups
Events
  • SEAPUG Summer BBQ, 6 July in Seattle
  • SFBA PostgreSQL Meetup, 12 July
  • Chicago PostgreSQL Meetup, 19 July
  • PGDay UK 2023, 12 September in London
  • PGConf 2023, 3-5 October in New York City
  • PGDay Israel 2023, 19 October
  • PGConf.EU 2023, 12-15 December in Prague
Podcasts
  • postgres.fm (feed)
Related Fediverse communities
  • c/SQL on programming.dev
  • #sql on Mastodon
  • #postgresql on Mastodon
Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 5 users / day
  • 1 user / week
  • 15 users / month
  • 82 users / 6 months
  • 1 local subscriber
  • 2.11K subscribers
  • 186 Posts
  • 98 Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • starman@programming.dev
  • Jason Novinger@programming.dev
  • BE: 0.19.12
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org