=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> My queries were written in multi-line mode like this:
> insert into t1 values(1,
> 2,
> 3);
> I don't know, what effect this has to performace..
I tried my test again that way, and it made no difference at all.
Can anyone else
L PROTECTED]>
Cc:
Sent: Wednesday, August 03, 2005 1:03 AM
Subject: Re: [GENERAL] feeding big script to psql
=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
Thanks for the suggestion. I have just applied both switch , -f (I have
applied this in the previous case too)
Tom Lane wrote:
Peter Wilson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Oh? Could you provide a test case for this? I can certainly believe
that the planner might choose a bad plan if it has no statistics, but
it shouldn't take a long time to do it.
On investigation the problems occurs on
=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> Thanks for the suggestion. I have just applied both switch , -f (I have
> applied this in the previous case too) and -n, but it becomes slow again. At
> the beginning it reads about 300 KB a second, and when it has read 1.5 MB,
Peter Wilson <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>>> Oh? Could you provide a test case for this? I can certainly believe
>>> that the planner might choose a bad plan if it has no statistics, but
>>> it shouldn't take a long time to do it.
> On investigation the problems occurs on 'EXPL
Tom Lane wrote:
Peter Wilson <[EMAIL PROTECTED]> writes:
I found a while ago that after inserting a lot of rows into a clean
Postgres table it would take several minutes just to analyse a command,
not even starting the execution.
Oh? Could you provide a test case for this? I can certainly b
Tom Lane wrote:
> Peter Wilson <[EMAIL PROTECTED]> writes:
>> I found a while ago that after inserting a lot of rows into a clean
>> Postgres table it would take several minutes just to analyse a command,
>> not even starting the execution.
>
> Oh? Could you provide a test case for this? I can c
application did anything. No other HDD activity
either.
Best Regadrs,
Otto
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Tuesday, August 02,
I was a little busy with deadlines at the time but I saved the database
in it's slow configuration so I could investigate during a quieter period.
I'll do a restore now and see whether I can remember back to April when
I came across this issue.
Pete
Tom Lane wrote:
Peter Wilson <[EMAIL PRO
Peter Wilson <[EMAIL PROTECTED]> writes:
> I found a while ago that after inserting a lot of rows into a clean
> Postgres table it would take several minutes just to analyse a command,
> not even starting the execution.
Oh? Could you provide a test case for this? I can certainly believe
that t
On Tue, 2005-08-02 at 04:24, Havasvölgyi Ottó wrote:
> Tom,
>
> Thanks for the suggestion. I have just applied both switch , -f (I have
> applied this in the previous case too) and -n, but it becomes slow again. At
> the beginning it reads about 300 KB a second, and when it has read 1.5 MB,
> i
"
<[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 02, 2005 1:31 PM
Subject: Re: [GENERAL] feeding big script to psql
Hi,
The effect is the same even if I redirect the output to file with the
-o switch.
At the beginning 200 KB/sec, at 1.5 MB the speed is less than 20 KB/sec
AIL PROTECTED]>
To:
Sent: Tuesday, August 02, 2005 1:31 PM
Subject: Re: [GENERAL] feeding big script to psql
Hi,
The effect is the same even if I redirect the
output to file with the -o switch.
At the beginning 200 KB/sec, at 1.5 MB the speed is less than 20 KB/sec.
Best Regards,
Otto
-
Hi,
Now I am at 7 MB, and the reading speed is 3-4KB/sec.
Best Regards,
Otto
- Original Message -
From: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 02, 2005 1:31 PM
Subject: Re: [GENERAL] feeding big script to psql
Hi,
The effect is th
ot; <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 02, 2005 11:24 AM
Subject: Re: [GENERAL] feeding big script to psql
Tom,
Thanks for the suggestion. I have just applied both switch , -f (I have
applied this in the previous case too) and -n, but it becomes slow again.
At the beginnin
. Maybe others
should also try this scenario. Can I help anything?
Best Regards,
Otto
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, August 02, 2005 3:54 AM
Subject: Re: [GENERAL] fee
=?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> I know it would be faster with COPY, but this is extremly slow, and the
> bottleneck is psql.
> What is the problem?
Hmm, does the Windows port have readline support, and if so does adding
the "-n" switch to the psql invocation f
17 matches
Mail list logo
