On 4 October 2017 at 08:48, Ben Nachtrieb wrote:
> I have 2 cores and my max_parallel_workers_per_gather = 2 and
> max_worker_processes = 8, but my load averages are between 8 and 5 with
> scheduled at 1/189 to 5/195. Are these so high because I increased
>
On 03/10/17 04:29, Tom Lane wrote:
Mariel Cherkassky writes:
explain analyze SELECT Ma.User_Id,
COUNT(*) COUNT
FROM Manuim Ma
WHERE Ma.Bb_Open_Date =
(SELECT
Hello,
This is my first question on this list.
How does max_parallel_workers_per_gather change Linux server load averages?
I have 2 cores and my max_parallel_workers_per_gather = 2 and
max_worker_processes = 8, but my load averages are between 8 and 5 with
scheduled at 1/189 to 5/195. Are
2017-10-03 17:17 GMT+02:00 Adam Brusselback :
> There is also the option of pg_stat_statements: https://
> www.postgresql.org/docs/current/static/pgstatstatements.html and
> auto_explain: https://www.postgresql.org/docs/current/
> static/auto-explain.html
>
> These
There is also the option of pg_stat_statements:
https://www.postgresql.org/docs/current/static/pgstatstatements.html and
auto_explain:
https://www.postgresql.org/docs/current/static/auto-explain.html
These should help you identify what is slowing things down. There is no
reason I could think of
Purav Chovatia wrote:
> I come from Oracle world and we are porting all our applications to
> postgresql.
>
> The application calls 2 stored procs,
> - first one does a few selects and then an insert
> - second one does an update
>
> The main table on which the insert and the update happens is
Hello,
I come from Oracle world and we are porting all our applications to
postgresql.
The application calls 2 stored procs,
- first one does a few selects and then an insert
- second one does an update
The main table on which the insert and the update happens is truncated
before every