PostgreSQL on Windows Paper
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.
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?
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/
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
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
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
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.