[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [azhang@verisign.com: RE: [ADMIN] tuning SQL]
From:       "Ross J. Reedstrom" <reedstrm () rice ! edu>
Date:       2002-01-29 19:24:55
[Download RAW message or body]

Just to complete the thread.

Ross

----- Forwarded message from "Zhang, Anna" <azhang@verisign.com> -----

From: "Zhang, Anna" <azhang@verisign.com>
To: "'Ross J. Reedstrom'" <reedstrm@rice.edu>
Subject: RE: [ADMIN] tuning SQL
Date: Tue, 29 Jan 2002 14:08:53 -0500
Return-Receipt-To: "Zhang, Anna" <azhang@verisign.com>
X-Virus-Scanned: by AMaViS snapshot-20010714

I had same thought as you. select into temp table only took a minute, then
insert into contact took 1 hour. Thanks!

Anna Zhang

-----Original Message-----
From: Ross J. Reedstrom [mailto:reedstrm@rice.edu]
Sent: Tuesday, January 29, 2002 1:46 PM
To: Zhang, Anna
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] tuning SQL


So, how long does the just the select take? You might be running into
something odd with selecting from and inserting into the same table: I'm
not sure of the visibility rules here. You might be better off selecting
into a new temp table (see: SELECT INTO) then inserting from that.

Ross

----- End forwarded message -----

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]