Re: Configure Postgres From SQL - Mailing list pgsql-general

From Andres Freund
Subject Re: Configure Postgres From SQL
Date
Msg-id 201007121728.31434.andres@anarazel.de
Whole thread Raw
In response to Configure Postgres From SQL  (Tom Wilcox <hungrytom@gmail.com>)
Responses Re: Configure Postgres From SQL  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
On Monday 12 July 2010 15:29:14 Tom Wilcox wrote:
> Hi,
>
> Is it possible to configure postgres from SQL?
>
> I am interested in turning off fsync for a set of queries (that take
> ages to run) and then turn fsync back on again afterwards.
disabling fsync is nearly never a good idea.

What you can change (and that makes quite a bit of sense in some situations)
is the "synchronous_commit" setting.

What kind of queries are those? Many small transactions?

Andres

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Configure Postgres From SQL
Next
From: Merlin Moncure
Date:
Subject: Re: getting the last N tuples of a query