Search Postgresql Archives

Re: delete from ... where not in

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Chris <dmagick@xxxxxxxxx>
Subject: Re: delete from ... where not in
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 19 Feb 2007 02:17:54 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Chris <dmagick@xxxxxxxxx> message dated "Mon, 19 Feb 2007 17:06:24 +1100"
In-reply-to: <45D93E60.50605@xxxxxxxxx>
References: <45D93E60.50605@xxxxxxxxx>

Chris <dmagick@xxxxxxxxx> writes:
> I have a problem with a delete query I'm not sure how to fix.

Try increasing work_mem --- you want EXPLAIN to show that it's using
a hashed subplan.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: delete from ... where not in
  - From: Chris

References:
- delete from ... where not in
  - From: Chris

Prev by Date: Re: Database performance comparison paper.
Next by Date: Re: Write errors in postgres log
Previous by thread: delete from ... where not in
Next by thread: Re: delete from ... where not in
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux