Re: Extremely slow server? - Mailing list pgsql-performance

=# select * from pg_stat_activity where pid <> pg_backend_pid();
 datid  |  datname   |  pid  | usesysid | usename  | application_name | client_addr | client_hostname | client_port |         backend_start       
 |          xact_start           |         query_start          |         state_change          | waiting | state  |                              
                  query                                                 
--------+------------+-------+----------+----------+------------------+-------------+-----------------+-------------+------------------------------
-+-------------------------------+------------------------------+-------------------------------+---------+--------+-------------------------------
-------------------------------------------------------------------------
 231308 | emolecules | 13312 |       10 | postgres | pg_dump          |             |                 |          -1 | 2013-09-14 18:37:08.752938-07
 | 2013-09-14 18:37:08.783782-07 | 2013-09-14 18:39:43.74618-07 | 2013-09-14 18:39:43.746181-07 | f       | active | COPY orders.chmoogle_thesaurus
 (thesaurus_id, version_id, normalized, identifier, typecode) TO stdout;
(1 row)

And a bit later:

 231308 | emolecules | 13312 |       10 | postgres | pg_dump          |             |                 |          -1 | 2013-09-14 18:37:08.752938-07
 | 2013-09-14 18:37:08.783782-07 | 2013-09-14 18:47:38.287109-07 | 2013-09-14 18:47:38.287111-07 | f       | active | COPY orders.customer_order_items (customer_order_item_id, customer_order_id, orig_smiles, orig_sdf, orig_datatype, orig_catalog_num, orig_rownum, cansmiles, version_id, version_smiles, parent_id, match_type, catalogue_id, supplier_id, sample_id, catalog_num, price_code, reason, discount, format_ordered, amount_ordered, units_ordered, format_quoted, amount_quoted, units_quoted, price_quoted, wholesale, nitems_shipped, nitems_analytical, comment, salt_name, salt_ratio, original_order_id, price_quoted_usd, wholesale_usd, invoice_price, hazardous) TO stdout;
(1 row)

The Apache web server is shut off, and I upgraded to Postgres 9.2.4 since my first email.

top(1) reports nothing interesting that I can see:

Interestingly, it starts off going fairly fast according to "vmstat 2".  This was started almost immediately after pg_dump started.  Notice that it goes well for a couple minutes, slows for a bit, speeds up, then drops to almost nothing.  It stays that way forever, just not doing anything.  See below.

Thanks,
Craig