Re: Cost based SELECT/UPDATE - Mailing list pgsql-general

From Richard Huxton
Subject Re: Cost based SELECT/UPDATE
Date
Msg-id 431FE430.4090704@archonet.com
Whole thread Raw
In response to Cost based SELECT/UPDATE  (Leonid Safronie <evpatoria@gmail.com>)
List pgsql-general
Leonid Safronie wrote:
> Hi, ppl
>
> Is there any way to do SELECTs with different priorities?

> The issue is that response time for
> these 50 processes is very important unlike for report generation, and
> time spent by these processes while report running is unacceptable for
> my production environment (response time grows from 1-3 seconds up to
> 1-2 minutes).

The most important question is why response time drops so much? Does it
look like it's disk I/O that's the problem?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Acting on dropped/timed-out connections
Next
From: Bohdan Linda
Date:
Subject: Access management for DB project.