[PERFORM] Cache hit ratio

2007-04-03 Thread Jean Arnaud

Hi

Is there a way to get the cache hit ratio in PostGreSQL ?

Cheers

--
-- Jean Arnaud
-- Projet SARDES
-- INRIA Rhône-Alpes / LSR-IMAG
-- http://sardes.inrialpes.fr/~jarnaud



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [PERFORM] Restart time

2006-12-06 Thread Jean Arnaud

Rajesh Kumar Mallah a écrit :



On 12/5/06, *Tom Lane* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
wrote:


Jean Arnaud [EMAIL PROTECTED]
mailto:[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 cleanly-shut-down database, it
should be pretty much constant time.


Dear Sir,

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 scenerio) and i tend to do pg_ctl -m 
immediate stop

mostly.
 


regards, tom lane


Hi

Thanks everybody for answers !

To be sure SGBD will stop before a certain time, I use function that is 
a combination of pg_ctl -m fast to stop most of process cleanly, and 
after few seconds, I send pg_ctl -m immediate to be shut down immediatly 
the system if not already stoped. This works pretty well in practice and 
offers a good compromise between clean and fast shutdown.


Cheers

--
--- Jean Arnaud
--- Projet SARDES 
--- INRIA Rhône-Alpes



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


[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


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


[PERFORM] Changing max_connections without restart ?

2006-08-25 Thread Jean Arnaud

Hi !

I'm looking for a way to change the max_connections parameter without 
restarting the PostGreSQL database.
All the docs i found online are saying that this option can only be set 
on startup (-N option to comand-line) or by changing it in postgresql.conf.


Does anyone know how to do it ?

Thanks

--
-- Jean Arnaud
-- Projet SARDES
-- INRIA Rhône-Alpes / LSR-IMAG
-- Tél. : +33 (0)4 76 61 52 80


---(end of broadcast)---
TIP 6: explain analyze is your friend