Search Postgresql Archives

Re: checkpoint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2014-07-10 13:02, Guillaume Lelarge wrote:
> 2014-07-10 20:56 GMT+02:00 Yves Dorfsman <yves@xxxxxxxxx <mailto:yves@xxxxxxxxx>>:
> 
> 
>     Hi,
> 
>     If I run checkpoint from psql, is it applied to all the databases?
> 
>     What if I do it though an API? When connecting with psycopg2, I'm forced to
>     specify a database name, if I use "dbname=postgres", and execute
>     "checkpoint;", is it applied to all the databases?
> 
> 
> Yes. CHECKPOINT is more a cluster-wide operation, rather than a database one.
> 

This is what I had observed, but wanted to be 100% sure. Thanks.

-- 
Yves.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux