Re: Lock contention high

Hi B-tree index used in the postgres environment Checked on warehouse different values like 100,800,1600,2400 and 3200 with virtual user 64 On different values(warehouse) the lock contention same i.e. approx 17% and iostat usage is 30-40% pg_Count_ware=100 - 17.76% postgres pos

Re: Postgres views cannot use both union and join/where

On Wed, Oct 20, 2021 at 6:58 AM Tom Lane wrote: > "David G. Johnston" writes: > > On Tuesday, October 19, 2021, Michael Lewis wrote: > >> On Tue, Oct 19, 2021 at 3:48 PM Mithran Kulasekaran < > >> mithranakulaseka...@gmail.com> wrote: > >>> create view template_view (id, name, description, is_

Re: Postgres views cannot use both union and join/where

"David G. Johnston" writes: > On Tuesday, October 19, 2021, Michael Lewis wrote: >> On Tue, Oct 19, 2021 at 3:48 PM Mithran Kulasekaran < >> mithranakulaseka...@gmail.com> wrote: >>> create view template_view (id, name, description, is_staged) as >>> select t.id,t.name, t.description, false as i