08:47:17 <tozhu> is there anyone could take a look for this issue?  https://pastebin.com/NME64NTW
08:48:07 <tozhu> I think this issue will be reproduced on all SmartOS 
08:48:10 <tozhu> a big thanks
10:06:01 <neuroserve> tozhu - sorry I use postgesql in native zones
10:07:02 <tozhu> neuroserve: how about the SYSTEM usage when stress postgresql ?
11:30:09 <neuroserve> tozhu - citus-benchmark is still loading the database...
11:35:03 <tozhu> neuroserve: I use HammerDB
11:53:23 <neuroserve> tozhu - citus-benchmark does, too (https://github.com/citusdata/citus-benchmark)
11:56:03 <tozhu> Thank you
12:32:50 <neuroserve> 441679 postgres 2,6 0,3 0,0 0,0 0,0 0,0  97 0,1 337   6 872   0 postgres/1  <- prstat -a -m output of one postgres process
12:33:19 <neuroserve> first column is USR then SYS 
12:34:22 <neuroserve> obviously first column is pid then process name then USR then SYS
12:43:01 <Smithx10> neuroserve:  you are compiling up all the citus stuff in native?
13:08:15 <neuroserve> Smithx10 : yup
13:12:00 <neuroserve> jperkin showed me the one line patch for multi_copy.c
13:14:19 <neuroserve> and jasper has a patch for pg_auto_failover (from citus, too) - https://github.com/siepkes/pg_auto_failover
13:23:06 <neuroserve> TEST RESULT : System achieved 21892 NOPM from 50331 PostgreSQL TPM <- Ok for hardware from 2014 :-)
13:25:49 <neuroserve> and it's now pretty easy to set up citus clusters with patroni 3.x
13:26:25 <Smithx10> Nice,  did you do most of the extension s
13:26:46 <Smithx10> I know fdw and a few others are commonly used in city’s
13:26:50 <Smithx10> Citus*
13:26:58 <Smithx10> Is the idea to get away from manatee ?
13:27:25 <neuroserve> nope - I just compiled citus to be able to play with patroni and citus
13:27:32 <Smithx10> Ahhh ok
13:27:48 <Smithx10> I’ve got a branch of some of them
13:27:51 <neuroserve> no, no - just as an application - not on the infrastructure level
13:28:08 <Smithx10> I went down this path to give some user the ability for some columnar stuff
13:28:18 <Smithx10> But they really didn’t want it
13:28:28 <Smithx10> It was just a agile time waster
13:28:47 <neuroserve> is there a list of the most popular pg extensions?
13:28:51 <Smithx10> Teams have learned to game their sprints into 2 week vacations
13:28:57 <neuroserve> :-)
13:29:11 <Smithx10> I think aws rds has a list
13:29:27 <Smithx10> Was my go to when I was compiling pg for folks
13:29:42 <Smithx10> Im on the phone atm
13:29:46 <Smithx10> Or I’d grab a link
13:30:20 <neuroserve> i c - there's a whole bunch of lists (top10, top50, etc.)
13:42:03 <Smithx10> the extensions I brought in with citus were 
13:42:32 <Smithx10> postgres-hll, postgresql-topn, pg-cron, cstore_fdw 
13:42:42 <Smithx10> I think citus got rid of cstore tho
13:43:15 <Smithx10> https://github.com/citusdata/cstore_fdw
13:43:21 <Smithx10> yea,  that got pulled into the citus extension
13:43:56 <Smithx10> https://github.com/citusdata/postgresql-hll  think hll is still something that could be useful
13:44:21 <Smithx10> https://github.com/citusdata/postgresql-topn