Re: Configure Postgres From SQL

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: Tom Wilcox <hungrytom(at)gmail(dot)com>
Subject: Re: Configure Postgres From SQL
Date: 2010-07-12 15:28:30
Message-ID: 201007121728.31434.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-07-12 16:15:16 Re: getting the last N tuples of a query
Previous Message Guillaume Lelarge 2010-07-12 15:23:24 Re: Configure Postgres From SQL