From: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: DB responce during DB dump |
Date: | 2006-01-25 16:47:27 |
Message-ID: | 20060125194727.685144d7.eugrid@fpm.kubsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Ok, It's VERY simple =) here:
http://deepcore.i-free.ru/simple_shaper.pl
I could dump it to a spare machine, but I don't have one.
Current DB server is 2xXEON / 4GbRAM / RAID10 (4 SCSI HDD). Performance is excellent, except during backups.
I wanted to set up some kind of replication but it's useless - I don't have a spare machine now, may be in future...
On Wed, 25 Jan 2006 12:44:45 +0000
Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> That's an interesting solution, and I'd guess people might like to see
> it posted to the list if it's not too big.
>
> Also, there's no reason you have to dump from the same machine, you can
> do so over the network which should reduce activity a little bit.
>
> Basically though, it sounds like you either need more disk I/O or a
> different approach.
>
> Have you looked into using PITR log-shipping or replication (e.g. slony)
> to have an off-machine backup?
--
Evgeny Gridasov
Software Engineer
I-Free, Russia
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Lor | 2006-01-26 01:46:12 | PostgreSQL Solaris packages now in beta |
Previous Message | Evgeny Gridasov | 2006-01-25 16:43:09 | Re: DB responce during DB dump |