| 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: | Whole Thread | Raw Message | 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... |