Search Postgresql Archives

Re: Loading table with indexed jsonb field is stalling

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/20/19 11:05 AM, Will Hartung wrote:
I send this earlier, but it did not make it to the list, so I’m resending it.

On May 18, 2019, at 11:02 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

In addition to the questions about what PG version you're using, is
the backend process that's doing the load actually consuming CPU time,
or is it just sitting?

It’s consuming both CPU and disk space.

What do the below show:

1) ps ax | grep postgres

2) As superuser:
	select * from pg_stat_activity ;

Thanks.





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux