Re: SLOW pG performance

On Thu, 4 Sep 2003, Juan Francisco Diaz wrote:

> Hi again, I just tried the first load in my brand new pg database...
> And IT SUCKS! yeah! it took over an hour to load around 200 thousand
> records, while the sqlserver2000 took about 5-7 minutes...
> Im using the SAME program, some changes necessary but nothing really
> important.

How were you loading the data, one row per transaction or batched in some
fashion?

What do the schema(s) of the table(s) involved look like? What (if any)
constraints are involved (esp. foreign keys).

What do the specs of the relative machines look like?  Especially given
that in one case you're running multiple things on one machine and in the
other it sounds like they're on separate machines?

What do your function(s) look like?  Have you tried doing a subset not
using functions for comparison?