Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] scaling - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] scaling
Date
Msg-id 388F7A6E.2146FF07@austin.rr.com
Whole thread Raw
In response to scaling  ("Scott V. McGuire" <svmcguir@syr.edu>)
Responses Re: [GENERAL] scaling  ("Scott V. McGuire" <svmcguir@syr.edu>)
List pgsql-general
Tree view 
"Scott V. McGuire" wrote:
>
> I'm surprised about how long certain things are taking...
>
> What I'm surprised about is that the 10,000 row copies take < 1
> minute while the 50000 row copies take > 10 minutes.

See http://www.deja.com/getdoc.xp?AN=563958392

I suspect vacuum also would have a dramatic impact on performance in
your test case.

Cheers,
Ed Loehr

pgsql-general by date:

Previous
From: Sarah Officer
Date:
Subject: psql bug?
Next
From: Ed Loehr
Date:
Subject: [GENERAL] too many open files by postgresql backends