Re: Postgres with pthread - Mailing list pgsql-hackers

From james
Subject Re: Postgres with pthread
Date
Msg-id 373938ca-931e-2da4-d13f-a1cd712244e3@mansionfamily.plus.com
Whole thread Raw
In response to Re: Postgres with pthread  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Postgres with pthread
List pgsql-hackers
 > All threads are blocked in semaphores.
That they are blocked is inevitable - I guess the issue is that they are 
thrashing.
I guess it would be necessary to separate the internals to have some 
internal queueing and effectively reduce the number of actively 
executing threads.
In effect make the connection pooling work internally.

Would it be possible to make the caches have persistent (functional) 
data structures - effectively CoW?

And how easy would it be to abort if the master view had subsequently 
changed when it comes to execution?



pgsql-hackers by date:

Previous
From: "Michelle Konzack"
Date:
Subject: Re: [table partitioning] How many partitions are possibel?
Next
From: Andres Freund
Date:
Subject: Re: Postgres with pthread