Long update query ?

From: "Sergei Chernev" <ser(at)nsu(dot)ru>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Long update query ?
Date: 1998-09-27 09:20:35
Message-ID: 000701bde9f8$158fd1b0$59d17cc1@ser.cnit.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hello,
I have query:
UPDATE userd_session_stat SET status =1 WHERE status=0 AND ((uid <>627 AND
tty <>'ttyA03') OR (uid <> 425 AND tty <> 'ttyA05') OR (uid <> 8011 AND tty
<> 'ttyA09') OR (uid <> 2092 AND tty <> 'ttyA0f') OR (uid <> 249 AND tty <>
'ttyp3') OR (uid <> 249 AND tty <> 'ttyp4') OR (uid <> 249 AND tty <>
'ttyp5') OR (uid <> 249 AND tty <> 'ttyp6'))

But, postgres complains that:
FATAL 1: palloc failure: memory exhausted

I see, the query must be less than 4kB, and this query is less.
Long SELECT queries works fine.
Have any idea? Maybe, I have to change postmaster's settings ? Query
executes from libpg programm.

Thanx,
---------------------------
Sergei Chernev
Internet: ser(at)nsu(dot)ru
Phone: +7-3832-397354

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stan Thomas 1998-09-28 07:08:29 subscribe
Previous Message Howie 1998-09-27 07:14:29 RE: [GENERAL] slow queries

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1998-09-27 21:34:33 It sorta works, but I'm confused about locking
Previous Message Bruce Momjian 1998-09-27 05:41:32 Re: [HACKERS] Think we need major revisions in async.c...