Jie Liang <[EMAIL PROTECTED]> writes:
> Hi, there,
>
> I tried different ways, include vaccum table , ensure index works, it
> still is as slow as ~100rows per minute.
>
PGFSYNC=no in postmaster.init?
Well, this might be Debian Linux specific, pardon me if it is. I have
just begun playing
Webb Sprague <[EMAIL PROTECTED]> writes:
> I am experimenting with this too. If I have any
> indexes at all, the copy's get VERY SLOW as the table
> gets big. Delete ALL your indexes, do your copy's,
> and then create your indexes again.
Do you have a lot of equal index keys in the data you're
On Wed, 30 Aug 2000, Jie Liang wrote:
> Hi,
>
> I knew that if no constarint, it populate very quick, my question is:
> when two tables have been
> reloaded, then I want to add a foreign key constraint to it, say:
> tableA has primary key column (id)
> tableB has a column (id) references it, so
Hi,
I knew that if no constarint, it populate very quick, my question is:
when two tables have been
reloaded, then I want to add a foreign key constraint to it, say:
tableA has primary key column (id)
tableB has a column (id) references it, so I say:
ALTER TABLE tableB ADD CONSTRAINT distfk FOREI
I am experimenting with this too. If I have any
indexes at all, the copy's get VERY SLOW as the table
gets big. Delete ALL your indexes, do your copy's,
and then create your indexes again.
Good luck.
--- Jie Liang <[EMAIL PROTECTED]> wrote:
> Hi, there,
>
> I tried different ways, include va
Hi, there,
I tried different ways, include vaccum table , ensure index works, it
still is as slow as ~100rows per minute.
Stephan Szabo wrote:
> On Tue, 29 Aug 2000, Jie Liang wrote:
>
> > Hi, there,
> >
> > 1. use copy ... from '.';
> > 2. write a PL/pgSQL function and pass multiple re
On Tue, 29 Aug 2000, Jie Liang wrote:
> Hi, there,
>
> 1. use copy ... from '.';
> 2. write a PL/pgSQL function and pass multiple records as an array.
>
> However, if your table have a foreign key constraint, it cannot be speed
> up,
>
> I have same question as you, my table invloving 9-1
Hi, there,
1. use copy ... from '.';
2. write a PL/pgSQL function and pass multiple records as an array.
However, if your table have a foreign key constraint, it cannot be speed
up,
I have same question as you, my table invloving 9-13 million rows, I
don't
know how can I add a foreign key t
Hi all,
Does anybody have any thoughts on optimizing a huge
insert, involving something like 3 million records all
at once? Should I drop my indices before doing the
copy, and then create them after? I keep a
tab-delimited file as a buffer, copy it, then do it
again about 400 times. Each separ
