Re: [PERFORM] Restart time

2006-12-06 Thread Jean Arnaud
Rajesh Kumar Mallah a écrit : On 12/5/06, *Tom Lane* <[EMAIL PROTECTED] > wrote: Jean Arnaud <[EMAIL PROTECTED] > writes: > Is there a relation between database size and PostGreSQL restart duration ? No. > Does any

Re: [PERFORM] Restart time

2006-12-05 Thread Rajesh Kumar Mallah
On 12/6/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > Startup time of a clean shutdown database is constant. But we still > face problem when it comes to shutting down. PostgreSQL waits > for clients to finish gracefully. till date i have never been

Re: [PERFORM] Restart time

2006-12-05 Thread Tom Lane
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > Startup time of a clean shutdown database is constant. But we still > face problem when it comes to shutting down. PostgreSQL waits > for clients to finish gracefully. till date i have never been able to > shutdown > quickly (web application scene

Re: [PERFORM] Restart time

2006-12-05 Thread Rajesh Kumar Mallah
On 12/5/06, Tom Lane <[EMAIL PROTECTED]> wrote: Jean Arnaud <[EMAIL PROTECTED]> writes: > Is there a relation between database size and PostGreSQL restart duration ? No. > Does anyone now the behavior of restart time ? It depends on how many updates were applied since the last checkpoint befo

Re: [PERFORM] Restart time

2006-12-05 Thread Tom Lane
Jean Arnaud <[EMAIL PROTECTED]> writes: > Is there a relation between database size and PostGreSQL restart duration ? No. > Does anyone now the behavior of restart time ? It depends on how many updates were applied since the last checkpoint before the crash. If you're talking about startup of a

[PERFORM] Restart time

2006-12-05 Thread Jean Arnaud
Hello, Is there a relation between database size and PostGreSQL restart duration ? If true, i'm looking for a law predicting how much time is required to restart PostGreSQL, depending on the DB size. Does anyone now the behavior of restart time ? Thanks -- -- Jean Arnaud --