Peter T. Brown writes:
> Is there a way to reduce the priority of any psql queries depending on the
> user connecting to the database?
Officially: No.
Most ideas to this end have been a failure, because the low-priority query
might hold locks that the high-priority query needs, so merely "nice"
Hi,
I'm trying to streamline one of our processes that checks out files from CVS
and compiles them. I'd like to avoid locking by using the 'checkout -D' flag
and specify the current time. Since the number of files is huge, the checkout
process takes about 20 minutes.
My question is, what hap
Is there a way to reduce the priority of any psql queries depending on the
user connecting to the database? I basically want to be able to run lower
priority queries for some types of queries (for exporting and analysis)
while other queries run at higher priorities (for mission critical website
se
Manuel Trujillo wrote:
> Hi.
>
> Excuse me my ignorance, but I have a problem with the
> ../data/base/xxx/pg_sorttempxxx.x.
> About 7.4 G of file utilization of this files. Anybody can help me for
> look documentation about this, or directly, tell me why occur this?
You can delete it if the post
Manuel Trujillo wrote:
> About my problem exposed into my last e-mail, I found some information
> about this files (a "record" for sort's of a bad query's), in some
> word's, of course.
> Is possible to find into that files for looking the error query??
> I'm sure, if possible i'm in a mistake :(
About my problem exposed into my last e-mail, I found some information
about this files (a "record" for sort's of a bad query's), in some
word's, of course.
Is possible to find into that files for looking the error query??
I'm sure, if possible i'm in a mistake :(
Thank you very much.
--
Manuel
Hi.
Excuse me my ignorance, but I have a problem with the
../data/base/xxx/pg_sorttempxxx.x.
About 7.4 G of file utilization of this files. Anybody can help me for
look documentation about this, or directly, tell me why occur this?
Thank you very much.
--
Manuel Trujillo [EMAIL PROTECT
On Tue, 8 Jan 2002, RED wrote:
R> I have 2 base Ex: base1 and base2
R> When I connected to base1 I need data from base2 !
R> How did this without disconect from base1 and connect to base2
R> agregate all table into one databese not accesable
R> In mysql this is posible.
Depending on the programm
