""Shridhar Daithankar"" <shridhar_daithankar@persistent.co.in> wrote in
message news:3DAAACC3.24747.8A66792@localhost...
> On 13 Oct 2002 at 16:26, Brett wrote:
> >Forgive my ignorance, but what should I consider when sizing the
partition
> >which houses the pg_xlog area? Are logs cleared out every once in awhile
> >or do they continue to accumulate? Let's say your DB is around 4 GB,
> >what should the log area size be, or does the size of the DB not matter,
> >if not which factors should be considered?
>
> Well, you know the exact size of pg_xlogs in advance. It's 16MB*number of
WAL
> files. So for 40 WAL files in postgresql.conf, you get 640MB of pg_xlog.
>
> Yes, they are recycled. So they don't grow beyond this size. But from
> performance point of view, what's important is to put them on separate
drive,
> much better on separate IO channel.
Are they archived like Oracle logs? Oracle writes to a log area and reads
from the log area to generate archives. The archives are then used for
recovery in case of corruption. This is important because reading from the
drive throws off the head used for writing so seeking could be involved
given this situation where reading and writing happen on the same drive
concurrently. Oracle minimizes this by filling up, say, 500k of a certain
disk before writing the logs to the next disk. Then it reads the 500k of
logs and moves those to the archive. But if postgres doesn't use archives
then this isn't an issue.
Which leads me to another question... Does Postgres use archive logs and how
does Postgres recover if it doesn't use archive logs? Or does it not
recover as well as Oracle?
I realize that you get what you pay for so I'm prepared for the truth. :)