From: Bricklen Anderson <BAnderson@PresiNET.com>
To: meetesh.karia@alumni.duke.edu
Cc: pgsql-performance@postgresql.org
Subject: Re: ETL optimization
Date: Thu, 23 Jun 2005 13:16:50 -0700
Message-ID: <42BB18B2.4040009@PresiNET.com> (raw)
In-Reply-To: <fc5b04ca05062312546323c07e@mail.gmail.com>
References: <42BB0F9C.2050207@PresiNET.com>
<fc5b04ca05062312546323c07e@mail.gmail.com>
Meetesh Karia wrote:
> I don't know what this will change wrt how often you need to run VACUUM
> (I'm a SQL Server guy), but instead of an update and insert, try a
> delete and insert. You'll only have to find the duplicate rows once and
> your insert doesn't need a where clause.
>
> Meetesh
>
Vacuum analyze in generally run about once an hour. You know, I didn't even
think to try a delete + insert combo (which will not be visible to the other
queries that are occurring). Truncate is out of the question, because of the
aforementioned queries, but I'll give the d+i a shot.
Thanks!
--
_______________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
_______________________________
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-performance@postgresql.org
Cc: BAnderson@PresiNET.com, meetesh.karia@alumni.duke.edu
Subject: Re: ETL optimization
In-Reply-To: <42BB18B2.4040009@PresiNET.com>
* 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