Low priority background query

Community
1

I’m curious if it’s possible to either: set the priority, or minimize the impact, of a large amount of background queries.

There’s the main traffic to the site, and then there’s a low priority background job I don’t want to have interfere with page views.

When people talk about using sleep statements or server side cursors… I’m not even sure if that’ll work on the neon side.

what are ways to reduce SQL server load / let it serve other requests in peace?

2

If you’re a Neon Pro Plan user, and these are read-only queries, you could offload the queries to a read replica. Alternatively, you could look at a caching solution like PolyScale.

If these are write queries, you could take a look at our Autoscaling feature for automatic handling of additional load.