Thread: Re: PostgreSQL on Cygwin

Re: PostgreSQL on Cygwin

From
Jason Tishler
Date:
Terry,

On Mon, Jul 16, 2001 at 08:28:28PM +0000, Terry Carlin wrote:
> I guess I confused you. I think the snapshot that Dmitry Yurtaev
> mentioned was of Cygwin snapshot 20010615 not of PostgreSQL.
> I am downloading the latest snapshot of Cygwin as I am typing this
> message.
> Will publish my results as soon as I can get the testing in.

Does your testing do any DROP TABLE commands?  If so, then please heed my
warning below:

> On 7/16/01, 1:57:22 PM, Jason.Tishler@dothill.com (Jason Tishler) wrote
> regarding Re: PostgreSQL on Cygwin:
>
> > Unfortunately, there is a bug in the current Cygwin CVS that causes
> > PostgreSQL to hang during a DROP TABLE. See the following for details:
>
> > http://www.cygwin.com/ml/cygwin-developers/2001-07/msg00070.html
>
> > I can email you a Cygwin DLL built from Cygwin CVS on 6/28/01 with the
> > problematic patch already removed or you can use the 6/16/01 snapshot
> > which is the last official snapshot that does not have this problem.
> > Either one is after 6/15/01, which Dmitry claims no longer has this
> > resource leak. Let me know which way you want to go.

Thanks,
Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

Re: Re: PostgreSQL on Cygwin

From
Terry Carlin
Date:
Yes, I would like you to send me the Cygwin DLL.  I downloaded the most
current snapshot.  The benchmarks that I am doing don't seem to drop any
tables, but just in case....
It seems that the problem that I was seeing with the handles has indeed
been fixed.  Was able to run a 20 user benchmark yesterday. This takes
around three hours.  The throughput seemed to be at least in the
neighborhood of RedHat 7.1 Linux 2.4.2 kernel. (1100 TPS on a random
read-only AS3AP query).
I am currently running a 1-100 user TPC-C benchmark.  This will take a
couple of days to run.  Will let you know how it turns out.

Thanks

Terry Carlin
VP QA
Great Bridge, LLC.



>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/16/01, 4:41:28 PM, Jason Tishler <Jason.Tishler@dothill.com> wrote
regarding [CYGWIN] Re: PostgreSQL on Cygwin:


> Terry,

> On Mon, Jul 16, 2001 at 08:28:28PM +0000, Terry Carlin wrote:
> > I guess I confused you. I think the snapshot that Dmitry Yurtaev
> > mentioned was of Cygwin snapshot 20010615 not of PostgreSQL.
> > I am downloading the latest snapshot of Cygwin as I am typing this
> > message.
> > Will publish my results as soon as I can get the testing in.

> Does your testing do any DROP TABLE commands?  If so, then please heed my
> warning below:

> > On 7/16/01, 1:57:22 PM, Jason.Tishler@dothill.com (Jason Tishler) wrote
> > regarding Re: PostgreSQL on Cygwin:
> >
> > > Unfortunately, there is a bug in the current Cygwin CVS that causes
> > > PostgreSQL to hang during a DROP TABLE. See the following for details:
> >
> > > http://www.cygwin.com/ml/cygwin-developers/2001-07/msg00070.html
> >
> > > I can email you a Cygwin DLL built from Cygwin CVS on 6/28/01 with the
> > > problematic patch already removed or you can use the 6/16/01 snapshot
> > > which is the last official snapshot that does not have this problem.
> > > Either one is after 6/15/01, which Dmitry claims no longer has this
> > > resource leak. Let me know which way you want to go.

> Thanks,
> Jason

> --
> Jason Tishler
> Director, Software Engineering       Phone: 732.264.8770 x235
> Dot Hill Systems Corp.               Fax:   732.264.8798
> 82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
> Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

Re: Re: PostgreSQL on Cygwin

From
Jason Tishler
Date:
Terry,

On Tue, Jul 17, 2001 at 03:51:17PM +0000, Terry Carlin wrote:
> Yes, I would like you to send me the Cygwin DLL.

I will send the (stripped) Cygwin DLL in a separate email.

> I downloaded the most
> current snapshot.  The benchmarks that I am doing don't seem to drop any
> tables, but just in case....
> It seems that the problem that I was seeing with the handles has indeed
> been fixed.

This is good news.

> Was able to run a 20 user benchmark yesterday. This takes
> around three hours.  The throughput seemed to be at least in the
> neighborhood of RedHat 7.1 Linux 2.4.2 kernel. (1100 TPS on a random
> read-only AS3AP query).

This is also good news.

> I am currently running a 1-100 user TPC-C benchmark.  This will take a
> couple of days to run.  Will let you know how it turns out.

I'm looking forward to your benchmark report.

Thanks,
Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com