Postgresql usage clip.

Started by Alfred Perlsteinover 26 years ago40 messagesgeneral
Jump to latest
#1Erich
hh@cyberpass.net
In reply to: Alfred Perlstein (#2)
Re: Postgresql usage clip.

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

e

--
This message was my two cents worth. Please deposit two cents into my
e-gold account by following this link:
http://rootworks.com/twocentsworth.cgi?102861
275A B627 1826 D627 ED35 B8DF 7DDE 4428 0F5C 4454

#2Alfred Perlstein
bright@wintelcom.net

http://www.indiaserver.com/thehindu/2000/05/26/stories/0426211w.htm

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

#3John Steele
jsteele@writeme.com
In reply to: Alfred Perlstein (#2)
Re: Postgresql usage clip.

Bruce Momjian <pgman@candle.pha.pa.us> writes:

We support WIn95/98 clients, not servers.

I thought we did have a cygwin-based server port? If not, there's
a heckuva lot of useless "PORTNAME=win" conditional compilation in
the backend.

Mind you, I don't think any sane dbadmin would use Windoze as a
platform for a mission-critical application, regardless of database
engine choice. So the cygwin port is pretty much a toy IMHO.
If MySQL wants to have the toy-application market segment, they're
welcome to it.

We support servers on NT, but not on Win95/98. Cygwin supports both,
but the Win95/98 has missing features that we need. People have asked
about it, and they have said they were going to try Win95/98 and report
back on the problems they had, but no one has. I assume they got lots
of "unimplemented" messages from Cygwin and gave up.

IMO, having a 'toy' server during development on a win9x platform would be really nice. Coming from a MySQL/PHP background, it sure is nice to take the laptop out on a nice day and be able to develop 'real' applications that are then moved to a real server platform.

I just tried the latest NT port binaries, hoping that I could at least start up the server process. Even an extremely limited server on this platform would be welcome. Sometimes you don't get to choose your development OS :(

I have Cygwin installed, but when I try to start postgres.exe I get the following error message:

FATAL 1: SetPgUserName: no entry in host passwd file

I also find no postmaster in the install. So am I just wasting time?

Thanks,
John

--
/* SteeleSoft Consulting John Steele - Systems Analyst/Programmer
* We also walk dogs... jsteele@writeme.com
* http://www.gamecomputer.com/ssc/
*/

#4Gunnar R|nning
gunnar@candleweb.no
In reply to: Erich (#1)
Re: Postgresql usage clip.

Erich <hh@cyberpass.net> writes:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

And Oracle. I would love to see more "neutral" performance tests between
databases though. I suppose MS SQL could be could good for somethings as it
is based on the code bought from Sybase.

Still, the effiency can be a lot of things. I like PostgreSQL mainly
because I can develop and deploy applications in a cost efficient way with
it. But this equation will ofcourse depend on your organizations demands
and skills.

Regards,

Gunnar

#5Lincoln Yeoh
lylyeoh@mecomb.com
In reply to: Erich (#1)
Re: Postgresql usage clip.

At 12:57 PM 29-05-2000 -0700, Erich wrote:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

Actually it said efficacy - more like effectiveness. You can be efficient
but not effective and vice versa.

Well whatever it is, it's a nice article to show the PHBs.

Cheerio,
Link.

#6Lamar Owen
lamar.owen@wgcr.org
In reply to: Lincoln Yeoh (#5)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Ron Chmara wrote:

The Hermit Hacker wrote:

Huh? You caught my eye on this one ... what platform are we missing? :(

Well, you have binaries for NT, but what about home users/developers on 95?

98? > mySQL even does OS/2. Really.

For home use/development, run either Linux or FreeBSD in another partition on
your Win9x machine. Or, even use one of the 'WinLinux' style distributions
that cooexist with Windows very well. You'll (and PostgreSQL will) be much
happier with a unix-like environment (which Cygwin duplicates anyway for the
Win32 PostgreSQL server) for running the PostgreSQL server. Get VMWare and run
Win9x in a window on your Linux partition to test Win9x apps if you must run
Win9x.

Or, port Cygwin to Win9x so that PostgreSQL can run on Win9x.

However, the point is taken -- MySQL does Win9x. We don't.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

#7Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Lincoln Yeoh (#5)
Re: Postgresql usage clip.

On Tue, 30 May 2000, Lincoln Yeoh wrote:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

Actually it said efficacy - more like effectiveness. You can be efficient
but not effective and vice versa.

Efficient but not effective... you mean like MySQL? :-P

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
"The Lord gave us farmers two strong hands so we could grab as much as
we could with both of them."
-- Joseph Heller, "Catch-22"

#8Ron Chmara
ron@Opus1.COM
In reply to: Brett W. McCoy (#7)
Re: Postgresql usage clip.

"Brett W. McCoy" wrote:

On Tue, 30 May 2000, Lincoln Yeoh wrote:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

Actually it said efficacy - more like effectiveness. You can be efficient
but not effective and vice versa.

Efficient but not effective... you mean like MySQL? :-P

This has "fire" written all over it....

But as somebody who uses both, in large scale (er.. global) enterprise
level data management, each has it's place. MySQL has much faster
simple table scans, but it cannot handle the complex structures that
Pgsql can. Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

Heck, on a global level, we're also managing Access, MSSQL, Oracle,
Access, and even Filemaker. They all have features that others can't
even come close to. That's why homogeneity in the data center, or
the desktop, is a bad thing. Use what works best, when it works best.

:-)

-Ronabop

#9The Hermit Hacker
scrappy@hub.org
In reply to: Ron Chmara (#8)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Ron Chmara wrote:

"Brett W. McCoy" wrote:

On Tue, 30 May 2000, Lincoln Yeoh wrote:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

Actually it said efficacy - more like effectiveness. You can be efficient
but not effective and vice versa.

Efficient but not effective... you mean like MySQL? :-P

This has "fire" written all over it....

But as somebody who uses both, in large scale (er.. global) enterprise
level data management, each has it's place. MySQL has much faster
simple table scans, but it cannot handle the complex structures that
Pgsql can. Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

Huh? You caught my eye on this one ... what platform are we missing? :(

#10The Hermit Hacker
scrappy@hub.org
In reply to: The Hermit Hacker (#9)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Brett W. McCoy wrote:

On Mon, 29 May 2000, The Hermit Hacker wrote:

This has "fire" written all over it....

But as somebody who uses both, in large scale (er.. global) enterprise
level data management, each has it's place. MySQL has much faster
simple table scans, but it cannot handle the complex structures that
Pgsql can. Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

Huh? You caught my eye on this one ... what platform are we missing? :(

Actually, I daresay PostgreSQL runs on more platforms, than other RDBMSes.

That was my understanding too ... which is why I'm really curious as to
which one MySQL runs on that we don't ...

#11Ron Chmara
ron@Opus1.COM
In reply to: The Hermit Hacker (#9)
Re: Postgresql usage clip.

The Hermit Hacker wrote:

Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

Huh? You caught my eye on this one ... what platform are we missing? :(

Well, you have binaries for NT, but what about home users/developers on 95? 98?
mySQL even does OS/2. Really.

-Ronabop

#12Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Ron Chmara (#8)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Ron Chmara wrote:

This has "fire" written all over it....

But as somebody who uses both, in large scale (er.. global) enterprise
level data management, each has it's place. MySQL has much faster
simple table scans, but it cannot handle the complex structures that
Pgsql can. Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

MySQL is great for small websites with small budgets with read-only data
or data that doesn't change often. It doesn't scale very well at all, and
for larger sites it really falls apart without anyy referential integrity
or supprto for views. But beyond that, you really need something bigger
like Postgres (for a big site with a small budget) or Oracle (for a huge
site with a huger budget).

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
"The Lord gave us farmers two strong hands so we could grab as much as
we could with both of them."
-- Joseph Heller, "Catch-22"

#13Lincoln Yeoh
lylyeoh@mecomb.com
In reply to: Brett W. McCoy (#7)
Re: Postgresql usage clip.

At 10:28 PM 29-05-2000 -0400, Brett W. McCoy wrote:

On Tue, 30 May 2000, Lincoln Yeoh wrote:

What an insulting article! They say that PostgreSQL is "equal" in
efficiency to MS SQL. The rest of it was pretty good, though.

Actually it said efficacy - more like effectiveness. You can be efficient
but not effective and vice versa.

Efficient but not effective... you mean like MySQL? :-P

Now, now, be nice :).

MySQL is pretty good at most of the things it does and attempts to do. And
I really like the GET LOCK feature/function, is it possible to add
something like that to Postgresql?

And it's fast :).

It seems that with fsync off Postgresql can be just as fast with updates,
but I'm still reluctant to do that as data recovery methods don't seem as
developed on Postgresql - arguably you could say because there's less need
of them compared to other databases ;). But that may only be true if fsync
is _on_.

(I get the impression that you can specify fsync on a per connection basis
with v7.0, that'll be real cool - will be tempted to start up two
connections per app).

How fast comparatively are inserts for Postgresql?

Cheerio,
Link.

#14Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: The Hermit Hacker (#9)
Re: Postgresql usage clip.

On Mon, 29 May 2000, The Hermit Hacker wrote:

This has "fire" written all over it....

But as somebody who uses both, in large scale (er.. global) enterprise
level data management, each has it's place. MySQL has much faster
simple table scans, but it cannot handle the complex structures that
Pgsql can. Pgsql has scads of additional features, but is limited
in platform support compared to mysql.

Huh? You caught my eye on this one ... what platform are we missing? :(

Actually, I daresay PostgreSQL runs on more platforms, than other RDBMSes.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
"The Lord gave us farmers two strong hands so we could grab as much as
we could with both of them."
-- Joseph Heller, "Catch-22"

#15Ron Chmara
ron@Opus1.COM
In reply to: Brett W. McCoy (#12)
Re: Postgresql usage clip.

"Brett W. McCoy" wrote:

MySQL is great for small websites with small budgets with read-only data
or data that doesn't change often. It doesn't scale very well at all, and
for larger sites it really falls apart without anyy referential integrity
or supprto for views. But beyond that, you really need something bigger
like Postgres (for a big site with a small budget) or Oracle (for a huge
site with a huger budget).

Have a db comparison toy. Lots of fun.

http://mysql.com/crash-me-choose.htmy

-Bop

#16Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Ron Chmara (#11)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Ron Chmara wrote:

Huh? You caught my eye on this one ... what platform are we missing? :(

Well, you have binaries for NT, but what about home users/developers on 95? 98?
mySQL even does OS/2. Really.

But you have to pay money to run it on those platforms (except for OS/2).

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Hello. Jim Rockford's machine, this is Larry Doheny's machine. Will you
please have your master call my master at his convenience? Thank you.
Thank you. Thank you. Thank you. Thank you. Thank you.
-- "The Rockford Files"

#17Ron Chmara
ron@Opus1.COM
In reply to: Brett W. McCoy (#16)
Re: Postgresql usage clip.

"Brett W. McCoy" wrote:

On Mon, 29 May 2000, Ron Chmara wrote:

limited
in platform support compared to mysql.

And:

Well, you have binaries for NT, but what about home users/developers on 95? 98?
mySQL even does OS/2. Really.

But you have to pay money to run it on those platforms (except for OS/2).
Brett W. McCoy

Yes. How much money has to be paid to run postgreSQL on Win95? Is it
comparable in cost to get support for that platform?

:-)

-Ron

--
Brought to you from iBop the iMac, a MacOS, Win95, Win98, LinuxPPC machine,
which is currently in LinuxPPC land. Your bopping may vary.

#18Ron Chmara
ron@Opus1.COM
In reply to: The Hermit Hacker (#9)
Re: Postgresql usage clip.

Lamar Owen wrote:

On Mon, 29 May 2000, Ron Chmara wrote:

Well, you have binaries for NT, but what about home users/developers on 95?

98? > mySQL even does OS/2. Really.
For home use/development, run either Linux or FreeBSD in another partition on
your Win9x machine. Or, even use one of the 'WinLinux' style distributions
that cooexist with Windows very well. You'll (and PostgreSQL will) be much
happier with a unix-like environment (which Cygwin duplicates anyway for the
Win32 PostgreSQL server) for running the PostgreSQL server. Get VMWare and run
Win9x in a window on your Linux partition to test Win9x apps if you must run
Win9x.

Hm. See my .sig (missing from prior posts).... yes, it's nice that a hardware
platform can be bent to work with certain applications. I do lots of bending.
However, most users prefer to get applications for their platform, not the
other way round. Not all of us are platform agnostic. ;-)

However, the point is taken -- MySQL does Win9x. We don't.

Yet?

-Ronabop

--
Brought to you from iBop the iMac, a MacOS, Win95, Win98, LinuxPPC machine,
which is currently in LinuxPPC land. Your bopping may vary.

#19Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Lamar Owen (#6)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Lamar Owen wrote:

Well, you have binaries for NT, but what about home users/developers on 95?

98? > mySQL even does OS/2. Really.

For home use/development, run either Linux or FreeBSD in another partition on
your Win9x machine. Or, even use one of the 'WinLinux' style distributions
that cooexist with Windows very well. You'll (and PostgreSQL will) be much
happier with a unix-like environment (which Cygwin duplicates anyway for the
Win32 PostgreSQL server) for running the PostgreSQL server. Get VMWare and run
Win9x in a window on your Linux partition to test Win9x apps if you must run
Win9x.

Or, port Cygwin to Win9x so that PostgreSQL can run on Win9x.

CygWin does run on Windows 9x, doesn't it? Or at least it used to!

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Hello. Jim Rockford's machine, this is Larry Doheny's machine. Will you
please have your master call my master at his convenience? Thank you.
Thank you. Thank you. Thank you. Thank you. Thank you.
-- "The Rockford Files"

#20Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Ron Chmara (#17)
Re: Postgresql usage clip.

On Mon, 29 May 2000, Ron Chmara wrote:

Well, you have binaries for NT, but what about home users/developers on 95? 98?
mySQL even does OS/2. Really.

But you have to pay money to run it on those platforms (except for OS/2).
Brett W. McCoy

Yes. How much money has to be paid to run postgreSQL on Win95? Is it
comparable in cost to get support for that platform?

Can PostgreSQL run on Win9x with CygWin32?

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Hello. Jim Rockford's machine, this is Larry Doheny's machine. Will you
please have your master call my master at his convenience? Thank you.
Thank you. Thank you. Thank you. Thank you. Thank you.
-- "The Rockford Files"

#21The Hermit Hacker
scrappy@hub.org
In reply to: Brett W. McCoy (#16)
#22The Hermit Hacker
scrappy@hub.org
In reply to: Ron Chmara (#15)
#23Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Brett W. McCoy (#20)
#24Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: The Hermit Hacker (#21)
#25Bruce Momjian
pgman@candle.pha.pa.us
In reply to: The Hermit Hacker (#21)
#26Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Brett W. McCoy (#24)
#27Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: Bruce Momjian (#26)
#28Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#26)
#29Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Tom Lane (#28)
#30'JanWieck@t-online.de'
JanWieck@t-online.de
In reply to: Ron Chmara (#15)
#31Joseph
lters@mrtc.com
In reply to: John Steele (#3)
#32Horák Daniel
horak@sit.plzen-city.cz
In reply to: Joseph (#31)
#33Vince Vielhaber
vev@michvhf.com
In reply to: John Steele (#3)
#34'JanWieck@t-online.de'
JanWieck@t-online.de
In reply to: John Steele (#3)
#35Ned Lilly
ned@greatbridge.com
In reply to: Erich (#1)
#36Ron Peterson
rpeterson@yellowbank.com
In reply to: Tom Lane (#28)
#37Thomas Good
tomg@admin.nrnet.org
In reply to: Ron Peterson (#36)
#38Joseph Shraibman
jks@selectacast.net
In reply to: 'JanWieck@t-online.de' (#30)
#39Vince Vielhaber
vev@michvhf.com
In reply to: Joseph Shraibman (#38)
#40Lincoln Yeoh
lylyeoh@mecomb.com
In reply to: Joseph (#31)