Postgres Pro
Downloads
Home   >   mailing lists

Re: Make recently inserted/updated records available in the buffer/cache - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Make recently inserted/updated records available in the buffer/cache
Date
Msg-id CAHOFxGozXOq=6Q1UOWi5=L1bvNvke_Rn+U-nm6FruxM-F61tSQ@mail.gmail.com
Whole thread Raw
In response to Re: Make recently inserted/updated records available in thebuffer/cache  (MichaelDBA <MichaelDBA@sqlexec.com>)
Responses Re: Make recently inserted/updated records available in thebuffer/cache  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-performance
Tree view
"I am going to use it as a queue"

You may want to look at lowering fillfactor if this queue is going to have frequent updates, and also make autovacuum/analyze much more aggressive assuming many updates and deletes.

pgsql-performance by date:

Previous
From: Aufar Gilbran
Date:
Subject: Re: [External] Join queries slow with predicate, limit, and ordering
Next
From: MichaelDBA
Date:
Subject: Re: Make recently inserted/updated records available in thebuffer/cache