--- On Wed, 17/9/08, Jonathan Nalley <[EMAIL PROTECTED]> wrote:
> From: Jonathan Nalley <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] unable to backup database -- psql not up to date
> To: "dbchristopher" <[EMAIL PROTECTED]>, pgsql-admin@postgresql.org
> Date: Wednesday, 17 September, 2008, 3:23 P
Hi list,
I have got a script that is inserting, updating heavily at the moment. So, I
want to turn fsync off to speed things up but I don't want to interrupt the
script.
If I do `postgresql reload` or `kill -HUP postmaster_pid` woudl that apply the
fsync change? By the way, I have already trie
shared_buffers is in disk block size, typically 8K, at least that's what it is
on Linux platforms. shmmax is quite simply in bytes.
The default shared_buffer of a 1000 is quite conservative. A good starting
value is something like 15-25 percent of your main memory or so I am being
told. It real
Hi,
I run out of disk space on the box and had to delete some files and restart
postgres. Ever since I have been getting the above message. PS shows this
process:
9351 ?D 0:04 postgres: startup process
Running an strace on this process shows that it is trying to write 8K of zeros
