Lists: | pgsql-advocacypgsql-general |
---|
From: | Chris Travers <chris(at)metatrontech(dot)com> |
---|---|
To: | PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | PostgreSQL on Windows Paper |
Date: | 2007-02-23 18:22:44 |
Message-ID: | 45DF30F4.4070208@metatrontech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Hi all;
Microsoft has seen it fit to publish a paper I have written as an
introduction to PostgreSQL on Windows. This paper covers the basics of
installing and configuring the software. I thought it might be of
interest here so here is the link:
http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
If there are any editorial concerns they can be directed to me. It is
my hope that this will help introduce our favorite RDBMS to a wider
audience.
Best Wishes,
Chris Travers
PS I hope this is appropriate to mention on -general as well as
-advocacy. Since this has both advocacy and practical aspects, I
figured I would cross-post.
Attachment | Content-Type | Size |
---|---|---|
chris.vcf | text/x-vcard | 171 bytes |
From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Chris Travers <chris(at)metatrontech(dot)com> |
Cc: | PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL on Windows Paper |
Date: | 2007-02-23 18:55:08 |
Message-ID: | 1172256908.20651.5.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
> Hi all;
>
> Microsoft has seen it fit to publish a paper I have written as an
> introduction to PostgreSQL on Windows. This paper covers the basics of
> installing and configuring the software. I thought it might be of
> interest here so here is the link:
>
> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
>
> If there are any editorial concerns they can be directed to me. It is
> my hope that this will help introduce our favorite RDBMS to a wider
> audience.
One point, the paper mentions that you can't run pgsql under an admin
account, but I thought that changed with 8.2. Or is that with Vista or
something?
From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-23 19:00:32 |
Message-ID: | 45DF39D0.1080200@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Scott Marlowe wrote:
> On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
>> Hi all;
>>
>> Microsoft has seen it fit to publish a paper I have written as an
>> introduction to PostgreSQL on Windows. This paper covers the basics of
>> installing and configuring the software. I thought it might be of
>> interest here so here is the link:
>>
>> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
>>
>> If there are any editorial concerns they can be directed to me. It is
>> my hope that this will help introduce our favorite RDBMS to a wider
>> audience.
>
> One point, the paper mentions that you can't run pgsql under an admin
> account, but I thought that changed with 8.2. Or is that with Vista or
> something?
You can start postgresql under and admin account, but is uses drop
privelages or something like that to insure that it doesn't *run* under
an admin account.
Joshua D. Drake
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-23 19:51:56 |
Message-ID: | 20070223195156.GF20242@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Joshua D. Drake wrote:
> Scott Marlowe wrote:
> > On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
> >> Hi all;
> >>
> >> Microsoft has seen it fit to publish a paper I have written as an
> >> introduction to PostgreSQL on Windows. This paper covers the basics of
> >> installing and configuring the software. I thought it might be of
> >> interest here so here is the link:
> >>
> >> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
> >>
> >> If there are any editorial concerns they can be directed to me. It is
> >> my hope that this will help introduce our favorite RDBMS to a wider
> >> audience.
> >
> > One point, the paper mentions that you can't run pgsql under an admin
> > account, but I thought that changed with 8.2. Or is that with Vista or
> > something?
>
> You can start postgresql under and admin account, but is uses drop
> privelages or something like that to insure that it doesn't *run* under
> an admin account.
It drops privileges, which is something very much like dropping the root
UID in a setuid root Unix program. So in practice you can run Postgres
under the admin account, but without the admin privileges.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-26 09:32:11 |
Message-ID: | 45E2A91B.7080001@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Scott Marlowe wrote:
> On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
>> Hi all;
>>
>> Microsoft has seen it fit to publish a paper I have written as an
>> introduction to PostgreSQL on Windows. This paper covers the basics of
>> installing and configuring the software. I thought it might be of
>> interest here so here is the link:
>>
>> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
>>
>> If there are any editorial concerns they can be directed to me. It is
>> my hope that this will help introduce our favorite RDBMS to a wider
>> audience.
>
> One point, the paper mentions that you can't run pgsql under an admin
> account, but I thought that changed with 8.2. Or is that with Vista or
> something?
Yes, it did change with 8.2. A couple of other points whilst we're on
the subject:
- It says to click postgresql-8.2-int.msi to install. That's wrong -
it's postgresql-8.2.msi.
- It says that 'one should expect performance on Windows to be lower
[because of the per-process architecture], especially where large
numbers of small queries are made.' That's not really accurate - it will
be slower when there are large numbers of short lived connections. Lots
of queries in one connection should be fine though.
- It should be noted that on Vista, UAC can be re-enabled following
installation. We are aiming to fix this for 8.3.
- It's "pgAdmin III", not PGAdmin III or PgAdmin III (yeah, I know, get
a life Dave...)
Regards, Dave
From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Dave Page <dpage(at)postgresql(dot)org> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-26 17:53:34 |
Message-ID: | 45E31E9E.9010407@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Dave Page wrote:
> Scott Marlowe wrote:
>> On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
>>> Hi all;
>>>
>>> Microsoft has seen it fit to publish a paper I have written as an
>>> introduction to PostgreSQL on Windows. This paper covers the basics of
>>> installing and configuring the software. I thought it might be of
>>> interest here so here is the link:
>>>
>>> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
>>>
>>> If there are any editorial concerns they can be directed to me. It is
>>> my hope that this will help introduce our favorite RDBMS to a wider
>>> audience.
>> One point, the paper mentions that you can't run pgsql under an admin
>> account, but I thought that changed with 8.2. Or is that with Vista or
>> something?
>
> Yes, it did change with 8.2. A couple of other points whilst we're on
> the subject:
>
> - It says to click postgresql-8.2-int.msi to install. That's wrong -
> it's postgresql-8.2.msi.
>
> - It says that 'one should expect performance on Windows to be lower
> [because of the per-process architecture], especially where large
> numbers of small queries are made.' That's not really accurate - it will
> be slower when there are large numbers of short lived connections. Lots
> of queries in one connection should be fine though.
I believe ou will still see worse performance, because of at least two
things: context switching is more expensive (much more), and shared
memory access appears to be more expensive.
It will be worse if you have short lived connections, of course.
> - It should be noted that on Vista, UAC can be re-enabled following
> installation. We are aiming to fix this for 8.3.
>
> - It's "pgAdmin III", not PGAdmin III or PgAdmin III (yeah, I know, get
> a life Dave...)
Nah, you gotta keep at them. it's like all those people who use postgre.
//Magnus
From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-26 19:06:31 |
Message-ID: | 45E32FB7.1070902@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-advocacy pgsql-general |
Magnus Hagander wrote:
>> - It says that 'one should expect performance on Windows to be lower
>> [because of the per-process architecture], especially where large
>> numbers of small queries are made.' That's not really accurate - it will
>> be slower when there are large numbers of short lived connections. Lots
>> of queries in one connection should be fine though.
>
> I believe ou will still see worse performance, because of at least two
> things: context switching is more expensive (much more), and shared
> memory access appears to be more expensive.
> It will be worse if you have short lived connections, of course.
OK, 'relatively speaking'. I think the important part is the connection
setup time, if only because many web apps may setup new connections for
every page (for example) which is where people often seem to come
unstuck and really see the performance hit.
Regards, Dave.