Re: insert performance for win32

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insert performance for win32
Date: 2005-11-04 18:21:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E7F6@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

> > I'm inclined to treat this as an outright bug, not just a minor
> certainly...
>
> > performance issue, because it implies that a sufficiently long psql
> > script would probably crash a Windows machine.
>
> actually, it's worse than that, it's more of a dos on the
> whole system, as windows will eventually stop granting
> handles, but there is a good chance of side effects on other
> applications.

Does it actually use up *handles* there? I don't see anything in the
docs that says it should do that - and they usually do document when
handles are used. You should be seeing a *huge* increase in system
handles very fast if it does, right?

That said, I definitly agree with calling it a bug :-)

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-11-04 18:21:07 Re: [HACKERS] insert performance for win32
Previous Message Tom Lane 2005-11-04 18:19:02 Re: [HACKERS] insert performance for win32

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2005-11-04 18:21:07 Re: [HACKERS] insert performance for win32
Previous Message Tom Lane 2005-11-04 18:19:02 Re: [HACKERS] insert performance for win32