Results 1 to 2 of 2
  1. #1
    Newbie
    Join Date
    Jan 2013
    Posts
    1

    Default dumping table contens too CSV

    Not sure what forum this should be in :

    Stupid question I have an untangle box with some tables I need archived to CSV so I run

    nice -20 psql -d dbname U postgres -t -A -F"," -c "select * from reports.http_events" > http_events.csv &


    hoping to keep it from consuming too much memory and cpu it still does however , any hints on how to control it a bit better?

  2. #2
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Carlos, CA
    Posts
    17,486

    Default

    adding nice will have no real effect since its the postgres daemon that does the work not the process that connects to postgres and sends the query. nice/ionice might have some effect of just writing the results to the disk if you use -o instead of using the shell to redirect output to a file.

    you could nice or ionice the main postgres process.
    I have no idea what effect that would have nor if it is safe to do so.
    Last edited by dmorris; 01-21-2013 at 04:35 PM.
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2