On Tue, Jun 28, 2005 at 10:36:58AM -0700, Dann Corbit wrote:
Nope, truncate is undoubtedly faster. But it also means you would have
downtime as you mentioned. If it were me, I'd probably make the
trade-off of using a delete inside a transaction.
For every record in a bulk loaded table?
Sure.
On Tue, Jun 28, 2005 at 10:36:58AM -0700, Dann Corbit wrote:
> > Nope, truncate is undoubtedly faster. But it also means you would have
> > downtime as you mentioned. If it were me, I'd probably make the
> > trade-off of using a delete inside a transaction.
>
> For every record in a bulk loaded ta
> -Original Message-
> From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 27, 2005 6:55 PM
> To: Dann Corbit
> Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Populating huge tables each day
>
> On Mon, Jun 27, 2005 a
> Subject: Re: [GENERAL] Populating huge tables each day
> >
> > On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corbit wrote:
> > > I see a lot of problems with this idea.
> > >
> > > You mention that the database is supposed to be available 24
> -Original Message-
> From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 27, 2005 12:58 PM
> To: Dann Corbit
> Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Populating huge tables each day
>
> On Mon, Jun 27, 2005 a
On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corbit wrote:
> I see a lot of problems with this idea.
>
> You mention that the database is supposed to be available 24x7.
> While you are loading, the database table receiving data will not be
> available. Therefore, you will have to have one serve
ECTED] On Behalf Of Ben-Nes Yonatan
> Sent: Monday, June 27, 2005 1:13 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Populating huge tables each day
>
> Hi All,
>
> First I apologize for the length of this email im just afraid that my
> problem is quite complicate
Hi All,
First I apologize for the length of this email im just afraid that my
problem is quite complicated for explination & also about my english
which is not my native language sorry :)
I'm currently building a site for a client which will need to update his
database on a daily routine
