Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoint - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: checkpoint
Date
Msg-id CAECtzeUg3yGz=yh_53sUVgynoFqs=3G5wJGbcFVFCko4AtcbCQ@mail.gmail.com
Whole thread Raw
In response to checkpoint  (Yves Dorfsman <yves@zioup.com>)
Responses Re: checkpoint  (Yves Dorfsman <yves@zioup.com>)
List pgsql-general
Tree view
2014-07-10 20:56 GMT+02:00 Yves Dorfsman <yves@zioup.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.


--

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Should I partition this table?
Next
From: Yves Dorfsman
Date:
Subject: Re: checkpoint