Skip site navigation (1) Skip section navigation (2)

Re: Maximum Possible Insert Performance?

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: William Yu <wyu(at)talisys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maximum Possible Insert Performance?
Date: 2003-11-25 06:06:50
Message-ID: 3FC2F17A.5050307@persistent.co.in (view raw or flat)
Thread:
Lists: pgsql-performance
William Yu wrote:

> This is an intriguing thought which leads me to think about a similar 
> solution for even a production server and that's a solid state drive for 
> just the WAL. What's the max disk space the WAL would ever take up? 
> There's quite a few 512MB/1GB/2GB solid state drives available now in 
> the ~$200-$500 range and if you never hit those limits...

Maximum number of WAL segments at any time in 2*(number of checkpoint 
segments)+1 IIRC.

So if you have 3 checkpoint segments, you can not have more than 7 WAL segments 
at any time. Give or take 1.

Correct me if I am wrong..

  Shridhar


In response to

Responses

pgsql-performance by date

Next:From: Rob FieldingDate: 2003-11-25 14:07:58
Subject: Re: Where to start for performance problem?
Previous:From: Christopher BrowneDate: 2003-11-25 04:08:08
Subject: Re: [HACKERS] More detail on settings for pgavd?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group