With big thanks to Josh Berkus and Devrim Gunduz, I'm happy to announce
that Sun has just released a Solaris distribution of PostgreSQL 8.1.2
with ready-to-install packages for both Sparc and x86. These packages
are currently in Beta, and we expect to FCS in 2 -3 weeks. The
packages, along
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
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 month.
A year ago such sl
Daniel Gish wrote:
Hi,
Thanks for your response. The actual query is below; the joins are only 4
deep. Adjusting the stats target did help, but not dramatically.
QUERY PLAN
