Re: Thousands of tables versus on table? - Mailing list pgsql-performance

From PFC
Subject Re: Thousands of tables versus on table?
Date
Msg-id op.tteytsyycigqcu@apollo13
Whole thread Raw
In response to Re: Thousands of tables versus on table?  (Thomas Andrews <tandrews@soliantconsulting.com>)
List pgsql-performance

> can tell you our vacuum every night is taking 2 hours and that disk IO is
> the real killer - the CPU rarely gets higher than 20% or so.

    How many gigabytes of stuff do you have in this database ?
    ( du -sh on the *right* directory will suffice, don't include the logs
etc, aim for data/base/oid)


pgsql-performance by date:

Previous
From: Thomas Andrews
Date:
Subject: Re: Thousands of tables versus on table?
Next
From: Gregory Stark
Date:
Subject: Re: Thousands of tables versus on table?