Zitat von Tom Lane <[EMAIL PROTECTED]>:
> Probably insufficient disk bandwidth. If you have two drives available,
> try putting the WAL files (pg_xlog directory) on a different drive from
> the data files. Assuming you have adequate RAM, updates will be mainly
> limited by writes to WAL, while ch
Zitat von Tom Lane <[EMAIL PROTECTED]>:
> A checkpoint pushes out all unwritten data since the last checkpoint.
> So yeah, it stands to reason that if you increase the time between
> checkpoints, each checkpoint will take longer. Whether this is really
> a problem is not clear --- the checkpoint
> You can not change the size but you can increase the number of WAL files
> used.
> See postgresql.conf.
>
> Setting it too high does not achieve anything though. You need to have enough
>
> disk bandwidth to make use of 200MB WAL logs.
I want write a lot of data (large objetcs) without any in
Can I change the size of a wal file, and if so where can I change this? I'd like
to set the value to bigger value than 16MB.
Thanks, Andreas.
-
This mail sent through IMP: http://horde.org/imp/
---(end of broadcast)
I am a little bit confused by the following effect.
For test reasons I insert about 10 large objects into the database. Each has
a size of 10240 Bytes (10K). So the expected size of the large object datafile
should be at least 102400 Bytes (about 976MB) just to hold the large objects.
But t
