Hello List,
i have a few postgresql servers running in a Xen3/DomU and i am having
real bead performance...
Since read-ahead seems to be a big tuning detail, i would like to know
where i have to set my read-ahead size?
Do i have to set it in the Dom0 or DomU?
My layers looks like this:
1.) Hard
Hello List,
i have a few postgresql servers running in a Xen3/DomU and i am having
real bead performance...
Since read-ahead seems to be a big tuning detail, i would like to know
where i have to set my read-ahead size?
Do i have to set it in the Dom0 or DomU?
My layers looks like this:
1.) Hard
Hello List,
i wrote a little and simple Script to do AND verify
Point-In-Time-Recovery automatically. Since i am not a Postgres or
Bash Guru, i would like to ask you to have a look at it. Just to check
if i made any logic mistake.
I use this script for about 2 Month now, and it seems to do its jo
Hello List,
postgres 8.2 is not doing too much but eating up all my memory:
http://pastebin.com/m4cf22ee2
The postgresql.conf is at the very bottom of the pastebin.
I guess this is a configuration issue. The CPUs are almost 100% idle
but i seem to run out of memory.
Any idea what i could do here
Hello List,
i am using the following archive command:
archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p
pg...@pg-backup:/restore/walfiles/'
Which works perfectly so far. My problem now is, what happens if the
"pg-backup" server is down for some time and the archove command can
not copy th
