lowering priority automatically at connection

From: Chris Mair <list(at)1006(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: lowering priority automatically at connection
Date: 2006-05-25 16:16:24
Message-ID: 1148573784.6017.26.camel@dell.home.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I find this very helpful:

Lowering the priority of a PostgreSQL query
http://weblog.bignerdranch.com/?p=11

Now I was wondering whether one could have a
SELECT pg_setpriority(10);
executed automatically each time a certain user
connects (not necessarily using psql)?

Any ideas if and how this might be possible?

Regards :)
Chris.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kynn Jones 2006-05-25 16:21:53 Re: Optimizing a huge_table/tiny_table join
Previous Message Ian Westmacott 2006-05-25 03:20:24 Re: Getting even more insert performance (250m+rows/day)