Re: checkpoint

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Yves Dorfsman <yves(at)zioup(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: checkpoint
Date: 2014-07-10 19:02:50
Message-ID: CAECtzeUg3yGz=yh_53sUVgynoFqs=3G5wJGbcFVFCko4AtcbCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2014-07-10 20:56 GMT+02:00 Yves Dorfsman <yves(at)zioup(dot)com>:

>
> 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.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

  • checkpoint at 2014-07-10 18:56:22 from Yves Dorfsman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yves Dorfsman 2014-07-10 19:16:10 Re: checkpoint
Previous Message Bill Moran 2014-07-10 18:56:34 Re: Should I partition this table?