We've had a system in operation for a few years that makes use of a substantial
amount of partitioning. The parent table now has over 4,000 children tables.
Within the last couple of days the server started giving "out of shared memory"
errors with the suggestion to increase the max_locks_per_tr
I have a number of web servers that access a server largely dedicated to just
Postgres. There are over a million queries a day to this server. It's working
well and doesn't seem to be bogged down.
I would like to improve my server system by using a mirror or alternate machine
for both backup an
On 09/22/2012 06:25 AM, Walter Hurry wrote:
On Fri, 21 Sep 2012 10:33:25 -0600, Scott Marlowe wrote:
On Tue, Sep 11, 2012 at 2:48 PM, Vincent Dautremont
wrote:
Hi,
I'm using Postgresql 9.1.3 x64 on Windows 2008,
I'm doing reliability tests and effects and consequences of a server
power failur
