Thanks for all your help, Scott. A friend of mine whipped out this
script which runs a lot faster than trying to use the original query I
posted.
-M@
begin;
create temporary table cart_temp as select distinct a.cart_id,
a.cart_cookie from v_carts a, v_cart_contents b where a.cart_id =
b.cart
On Tuesday, July 1, 2003, at 05:47 AM, scott.marlowe wrote:
what does the output of psql say if you have the /timing switch on?
# select cart_id from carts except (select distinct cart_id from
cart_contents) limit 1;
cart_id
-
2701
(1 row)
Time: 10864.89 ms
# explain analyze delete f
On Monday, June 30, 2003, at 12:00 PM, scott.marlowe wrote:
On Mon, 30 Jun 2003, Matthew Hixson wrote:
On Monday, June 30, 2003, at 05:06 AM, scott.marlowe wrote:
On Fri, 27 Jun 2003, Matthew Hixson wrote:
Hi, I have a bunch of records that I need to delete from our
database.
These records
On Monday, June 30, 2003, at 05:06 AM, scott.marlowe wrote:
On Fri, 27 Jun 2003, Matthew Hixson wrote:
Hi, I have a bunch of records that I need to delete from our database.
These records represent shopping carts for visitors to our website.
The shopping carts I'd like to delete are the
Hi, I have a bunch of records that I need to delete from our database.
These records represent shopping carts for visitors to our website.
The shopping carts I'd like to delete are the ones without anything in
them. Here is the schema:
create sequence carts_sequence;
create table carts(
cart
Hi Lonnie,
This is one of the reasons we are moving to an EJB server at work (we're
using Oracle there, but they wanted to accomplish the same thing you want
to do with Postgres). By exposing specialized interfaces to the db we
effectively limit the types of queries that can be run. That might
