On 19/07/2006, at 10:03 PM, Christian Rengstl wrote:
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
aennam varchar(8),
CONSTRAINT "PK_ENTRY" PRIMARY KE
On 19/07/2006, at 8:49 PM, Christian Rengstl wrote:
Obviously it had something to do with the rule, because now
everything finished within 20 minutes. the problem is just that i
don't really want to give up the inheritance design. is there a way
to maintain the inheritance that doesn't caus
Obviously it had something to do with the rule, because now everything finished
within 20 minutes. the problem is just that i don't really want to give up the
inheritance design. is there a way to maintain the inheritance that doesn't
cause this huge performance problem?
Q <[EMAIL PROTECTED]> w
Well, i'll try that, but honestly i don't think it's the rule as the rule is
really simple: it's just one simple integer comparison...
Q <[EMAIL PROTECTED]> wrote on 07/19/06 11:54 am:
> On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
>
>> The analyze is from the exact query and i dropped th
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dropped the indexes
before the insert as well without imrpvement. The target table is
as well completely empty and the insert is supposed to write, in
this case, more or less 8 million lines in the
The analyze is from the exact query and i dropped the indexes before the insert
as well without imrpvement. The target table is as well completely empty and
the insert is supposed to write, in this case, more or less 8 million lines in
the table. There is a rule though, because i have inheritanc
The thing is that in the text file there is a column that is something like
xyz_12 and in the table i just need the integer part of it that's what the
query is used for. The problem though is not really in the select part, because
running the select part on 8 million lines takes about 3 minutes,
On 19/07/2006, at 4:24 AM, Christian Rengstl wrote:
now finally after a long time i have the query plan for the whole
filled table. I hope somebody can explain me why it takes so much
longer...
These explain analyze results don't appear to be from the queries you
posted previously. For
On 7/18/06, Christian Rengstl
<[EMAIL PROTECTED]> wrote:
now finally after a long time i have the query plan for the whole filled table.
I hope somebody can explain me why it takes so much longer...
QUERY PLAN
now finally after a long time i have the query plan for the whole filled table.
I hope somebody can explain me why it takes so much longer...
QUERY PLAN
---
now finally after a long time i have the query plan for the whole filled
table. I hope somebody can explain me why it takes so much longer...
QUERY PLAN
-
On 7/14/06, Christian Rengstl
<[EMAIL PROTECTED]> wrote:
Hi,
somehow my reply yesterday got lost, but nevertheless here comes the
explain analyze again. It's the explain of the operation that causes
this huge performance discrepancy. Unfortunately i had to perform the
explain analyze with an emp
Hi,
somehow my reply yesterday got lost, but nevertheless here comes the
explain analyze again. It's the explain of the operation that causes
this huge performance discrepancy. Unfortunately i had to perform the
explain analyze with an empty temp_table, because after the whole
operation is done, i
On 7/13/06, Christian Rengstl
<[EMAIL PROTECTED]> wrote:
Good morning list,
the following query takes about 15 to 20 minutes for around 2 million lines in
the file myfile.txt, but with 8 million lines it takes around 5 hours and i
just don't understand why there is such a huge discrepancy in p
Good morning list,
the following query takes about 15 to 20 minutes for around 2 million lines in
the file myfile.txt, but with 8 million lines it takes around 5 hours and i
just don't understand why there is such a huge discrepancy in performance.
COPY public.temp_table FROM 'myfile.txt' WITH
16 matches
Mail list logo
