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 use
All I was trying to achieve is to limit I/O rate done by pg_dump.
The script is a very simple pipe rate limitter and nothing more:
it reads input, but outputs data no more than at rate specified.
I guess it helps because even if pg_dump outputs data at 20 mb/sec,
the script won't be able to read i
Richard Huxton writes:
> Evgeny Gridasov wrote:
>> I've written a perl script to limit pg_dump output bandwidth,
>> ...
>> Is there any other solution to avoid this problem?
> 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.
Yea
Evgeny Gridasov wrote:
Hi, everybody!
I experience problems with backing up one of my Postgresql 8.1.2 installations.
The problem is that when I do DB backup, all queries begin to run very slow =(
The database only grows in its size (~20Gb today), and the number of
transactions increases every
