Postgres Pro
Downloads
Home   >   mailing lists

Re: Parallel Select query performance and shared buffers - Mailing list pgsql-performance

From Metin Doslu
Subject Re: Parallel Select query performance and shared buffers
Date
Msg-id CAL1dPcfJmYNaegTUVi9nDYZRBwr8F=dWUTcdUg9Y1P1gO-nYWw@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Select query performance and shared buffers  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Parallel Select query performance and shared buffers  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-performance
Tree view
> Is your workload bigger than RAM?

RAM is bigger than workload (more than a couple of times).

> I think a good bit of the contention
> you're seeing in that listing is populating shared_buffers - and might
> actually vanish once you're halfway cached.
> From what I've seen so far the bigger problem than contention in the
> lwlocks itself, is the spinlock protecting the lwlocks...

Could you clarify a bit what do you mean by "halfway cached" and "spinlock protecting the lwlocks".

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Parallel Select query performance and shared buffers
Next
From: Andres Freund
Date:
Subject: Re: Parallel Select query performance and shared buffers