-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/17/07 17:12, [EMAIL PROTECTED] wrote:
> On Tuesday 17 July 2007 17:47:01 Tom Lane wrote:
>> [EMAIL PROTECTED] writes:
>>> i think i got it fixed as i saw that i pushed my maintenance_work_mem too
>>> high. It was higher than physical ram :-(
>> O
On Tuesday 17 July 2007 17:47:01 Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > i think i got it fixed as i saw that i pushed my maintenance_work_mem too
> > high. It was higher than physical ram :-(
>
> Ooops, that will definitely cause problems.
yes it did! I ran it again. And now it takes 10 m
[EMAIL PROTECTED] writes:
> i think i got it fixed as i saw that i pushed my maintenance_work_mem too
> high. It was higher than physical ram :-(
Ooops, that will definitely cause problems.
regards, tom lane
---(end of broadcast)--
Am Montag, 16. Juli 2007 16:19 schrieben Sie:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > After this i create the index and it took 10 hours just for one index
> > (primary key). I have 100.000.000 rows with one PK (int8), two integer
> > data values, and two FK (int8)
>
> What PG version is th
Tom Lane wrote:
> Janning Vygen <[EMAIL PROTECTED]> writes:
>> After this i create the index and it took 10 hours just for one index
>> (primary
>> key). I have 100.000.000 rows with one PK (int8), two integer data values,
>> and two FK (int8)
>
> What PG version is this? We did a fair amount
Janning Vygen <[EMAIL PROTECTED]> writes:
> After this i create the index and it took 10 hours just for one index
> (primary
> key). I have 100.000.000 rows with one PK (int8), two integer data values,
> and two FK (int8)
What PG version is this? We did a fair amount of work on sort speed
for
Hi
i try to populate a database. I dropped all indexes on the target table to
speed up the copy. it works fine.
After this i create the index and it took 10 hours just for one index (primary
key). I have 100.000.000 rows with one PK (int8), two integer data values,
and two FK (int8)
Are ther
