| From: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "maxim(dot)boguk" <maxim(dot)boguk(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #10675: alter database set tablespace and unlogged table |
| Date: | 2014-07-02 12:30:25 |
| Message-ID: | CABOikdNnQZ36MGPvNEB_g3ESeYHOcu1eeLzW4oxrTCxhZ3b=NA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Jul 2, 2014 at 5:36 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:
>
> Which reason, except the faster shutdown, for a user to want that?
>
>
May be to clean up shared buffers so that a regular backend does not need
to write the page during eviction? Of course bgwriter would that but not
under user's control. Say user wants to force a checkpoint before some high
priority, response time sensitive tasks are started. Not sure though if
this a valid use case in real world.
Thanks,
Pavan
--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hoschiraffel | 2014-07-02 13:05:37 | BUG #10836: Rule with RETURNING claims incorrect type |
| Previous Message | Andres Freund | 2014-07-02 12:09:45 | Re: BUG #10675: alter database set tablespace and unlogged table |