libre #smartos

13 Jun 2023

SmartOS -- A Modern, Open Source, Datacenter Operating System | smartos.org | github.com/TritonDataCenter/smartos-live | github.com/TritonDataCenter/triton | Security -- TritonDataCenter.com/security-issues | Channel logs - log.omnios.org/smartos

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