5 votes
Accepted

AWS Aurora PostgreSQL Serverless: How do you pre-warm the shared buffer after scaling?

My answer is not specific to AWS Aurora PostgreSQL Serverless, but for Postgres in general. Simple alternative In your related comment, you hinted that you only need rows from the last 24 hours. So ...
user avatar
3 votes

AWS Aurora PostgreSQL Serverless: How do you pre-warm the shared buffer after scaling?

I think you're out of luck on #1. The release notes for PG 11 note the addition of that feature. And I'm not familiar with Aurora, don't have any idea about #2. For #3, it all depends on what the &...
user avatar
  • 814
3 votes

Exclude tables from shared_buffers in postgres

There is no stock way to micromanage shared buffers that way. And in my experience is not a very fruitful area of effort. I've looked at the space used by the tables and those which use the most are ...
user avatar
  • 32.1k
2 votes

pg_prewarm like funcationality in MySQL

Not quite the same thing, but see innodb_buffer_pool_dump_at_shutdown as a way of somewhat quickly getting back to where you left off after a shutdown. It saves pointers to blocks, so shutdown is not ...
user avatar
  • 68.9k
1 vote

Postgres 10 Query waits on IO: BufFileWrite causing failure to get new database connections

I made tables and queries from your situation. Even though they are not the same as yours, it will be helpful to solve the issue. create table students (student_id integer, student_name varchar(100));...
user avatar
1 vote

Postgres 10 Query waits on IO: BufFileWrite causing failure to get new database connections

The value of "evaluation_date" is only needed to filter out rows from the GroupAggregate. Since that returns no rows, there is no need to execute the subplan that finds of the value of "...
user avatar
  • 32.1k

Only top scored, non community-wiki answers of a minimum length are eligible