Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: insert vs select into performance
- From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: insert vs select into performance
- Date: Wed, 18 Jul 2007 21:13:14 +0200
Michael Stone wrote:
On Tue, Jul 17, 2007 at 11:01:15PM +0200, Thomas Finneid wrote:Arjen van der Meijden wrote:Have you also tried the COPY-statement? Afaik select into is similar to what happens in there.No, because it only works on file to db or vice versa not table to table.I don't understand how the insert you described is table to table?
SELECT INTO is table to table, so is INSERT INTO SELECT FROM. regards thomas
- Follow-Ups:
- Re: insert vs select into performance
- From: Michael Stone
- Re: insert vs select into performance
- References:
- insert vs select into performance
- From: Thomas Finneid
- Re: insert vs select into performance
- From: Arjen van der Meijden
- Re: insert vs select into performance
- From: Thomas Finneid
- Re: insert vs select into performance
- From: Michael Stone
- insert vs select into performance
- Prev by Date: Re: insert vs select into performance
- Next by Date: Re: improvement suggestions for performance design
- Previous by thread: Re: insert vs select into performance
- Next by thread: Re: insert vs select into performance
- Indexes: