From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-admin@postgresql.org
Subject: [azhang@verisign.com: RE: tuning SQL]
Date: Tue, 29 Jan 2002 13:24:55 -0600
Message-ID: <20020129192455.GA2290@rice.edu> (raw)
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 -----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: reedstrm@rice.edu
Subject: Re: [azhang@verisign.com: RE: tuning SQL]
In-Reply-To: <20020129192455.GA2290@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox