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
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 |
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... |