On Mon, May 5, 2008 at 2:03 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Mon, 5 May 2008, Campbell, Lance wrote:
>
>
> > We currently backup all of our database tables per schema using pg_dump
> > every half hour. We have been noticing that the database performance
> > has been very poor during
On Mon, 5 May 2008, Scott Marlowe wrote:
Other than that, you might wanna look at a faster / better RAID
controller in the future. One with lots of battery backed cache set to
write back.
Hopefully Lance's PERC 6/I SAS already has its battery installed. The 6/I
with 256MB of cache is decen
On Mon, 5 May 2008, Campbell, Lance wrote:
We currently backup all of our database tables per schema using pg_dump
every half hour. We have been noticing that the database performance
has been very poor during the backup process. How can I improve the
performance?
Uh, don't do that? pg_dump
On Mon, May 5, 2008 at 11:19 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> Scott,
> When I do a df -h I see that the database takes up a total of 8Gig of
> disk space. This is not the size of the backup file of the database.
Ok. Just wanted to make sure. Looking at vmstat, with little or n
On Mon, 2008-05-05 at 09:10 -0700, Craig James wrote:
> Campbell, Lance wrote:
> > We currently backup all of our database tables per schema using pg_dump
> > every half hour. We have been noticing that the database performance
> > has been very poor during the backup process. How can I improve
On Mon, May 5, 2008 at 10:11 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> Scott,
> The last 6 entries are when the system is not backing up. The system
> was running fine. But the other entries are when it was backing up.
> Reads seem to be fine but any operations that need to write data j
Campbell, Lance wrote:
We currently backup all of our database tables per schema using pg_dump
every half hour. We have been noticing that the database performance
has been very poor during the backup process. How can I improve the
performance?
It sounds like the goal is to have frequent, n
On Mon, May 5, 2008 at 9:10 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> Scott,
> The server is a Dell PowerEdge 2900 II with the standard Perc 6/I SAS
> controller with 256 MB cache.
It's probably not gonna win any awards, but it's not too terrible.
What does vmstat 1 say during your backu
Marlowe [mailto:[EMAIL PROTECTED]
Sent: Monday, May 05, 2008 10:06 AM
To: Campbell, Lance
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Backup causing poor performance - suggestions
On Mon, May 5, 2008 at 8:59 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
>
> PostgreSQL
On Mon, May 5, 2008 at 8:59 AM, Campbell, Lance <[EMAIL PROTECTED]> wrote:
>
> PostgreSQL: 8.2.4
You should update to 8.2.7 as a matter of periodic maintenance. It's
a very short and easy update.
> We currently backup all of our database tables per schema using pg_dump
> every half hour. We hav
10 matches
Mail list logo
