Is anybody using (succesfully) PostgreSQL? Any comments on speed/reliability/(zope)zen?
Yes... very. Speed is very good if you use the SQL Method cache.
I have had a database up and running for months and never had to touch it.
Ditto. I've had a bug-tracking zope/postgresql app running for nearly a year without any problems. Plus PostgreSQL 7.0 is coming out with lots more goodies. PostgreSQL Tips: Indexes may not be used untill you run a vacuum. Never, never let it run out of disk space. Bad things happen. -- cary
Cary O'Brien wrote:
Is anybody using (succesfully) PostgreSQL? Any comments on speed/reliability/(zope)zen?
Yes... very. Speed is very good if you use the SQL Method cache.
I have had a database up and running for months and never had to touch it.
Ditto. I've had a bug-tracking zope/postgresql app running for nearly a year without any problems.
Plus PostgreSQL 7.0 is coming out with lots more goodies.
PostgreSQL Tips:
Indexes may not be used untill you run a vacuum. Never, never let it run out of disk space. Bad things happen.
-- cary
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
What is the date for release of postgreSQL 7 ? I have been messing with MySQL but I think that I need to learn a real RDBMS like postgreSQL instead. I have Zope, Apache, and MySQL running on my home server/test box now. It is just a 233mmx with 96 megs will I be able to run postgres on the samebox or is the overhead too great ?
On Sat, 6 May 2000, Richard Smith wrote:
What is the date for release of postgreSQL 7 ?
These days there is Release Candidate 5; real release will be within few days, I think.
I have Zope, Apache, and MySQL running on my home server/test box now. It is just a 233mmx with 96 megs will I be able to run postgres on the samebox or is the overhead too great ?
Yes. Postgres is relatevely good in adapting itself (scaling). Oleg. (All opinions are mine and not of my employer) ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
What is the date for release of postgreSQL 7 ?
I have it from VERY HIGH UP that it will be this Monday. I just downloaded and installed RC5.
I have been messing with MySQL but I think that I need to learn a real RDBMS like postgreSQL instead. I have Zope, Apache, and MySQL running on my home server/test box now. It is just a 233mmx with 96 megs will I be able to run postgres on the samebox or is the overhead too great ?
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL. If you were to go to production throw a lot of RAM at Zope which likes RAM. PostgreSQL likes speed. J
"J. Atwood" wrote:
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL.
Why? I wasn't aware that PostGres and MySQL have problems sharing the same box. -- Steve Alexander Software Engineer Cat-Box limited
I meant it more as a joke. Like: Why would you want MySQL on a box once you have the power of PostgreSQL. Wait for 7.0 though. Faster with better joins and foreign keys. J At 4:49 PM +0100 5/6/2000, Steve Alexander wrote:
"J. Atwood" wrote:
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL.
Why? I wasn't aware that PostGres and MySQL have problems sharing the same box.
-- Steve Alexander Software Engineer Cat-Box limited
Steve Alexander wrote:
"J. Atwood" wrote:
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL.
Why? I wasn't aware that PostGres and MySQL have problems sharing the same box.
I've never heard about it either. I even have a quite high-profile box that runs them both in parallel with no problems. I guess you can even use them on the same Zope page if you want/need it. ----------- Hannu
On Sat, 6 May 2000, Steve Alexander wrote:
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL.
Why? I wasn't aware that PostGres and MySQL have problems sharing the same box.
I have no problems running both on the same Sparc Solaris box. I am sure other systems will do no worse. Oleg. (All opinions are mine and not of my employer) ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
"J. Atwood" wrote:
What is the date for release of postgreSQL 7 ?
I have it from VERY HIGH UP that it will be this Monday. I just downloaded and installed RC5.
I have been messing with MySQL but I think that I need to learn a real RDBMS like postgreSQL instead. I have Zope, Apache, and MySQL running on my home server/test box now. It is just a 233mmx with 96 megs will I be able to run postgres on the samebox or is the overhead too great ?
That is fine! PostGreSQL asks for very little. Of course you will have to remove MySQL. If you were to go to production throw a lot of RAM at Zope which likes RAM. PostgreSQL likes speed.
J
7 by monday this is great. I just downloaded 6.5.3 and started hacking, this thing works great. I was afraid that postgres would be too much for my little box. This is really sweet, wow odbc on Linux too, now where did I put those SQL books .. :)
On Sat, 06 May 2000 14:46:12 -0400 you wrote:
7 by monday this is great. I just downloaded 6.5.3 and started hacking, this thing works great. I was afraid that postgres would be too much for my little box. This is really sweet, wow odbc on Linux too, now where did I put those SQL books .. :)
Have a look at Philip Greenspun's tut. at photo.net: http://photo.net/sql/ Some notes about postgresql's documentation: It's generally good, but quite short on examples, which would be particularly useful for a lot of it's unique abilities and idiosyncroses. Some features are woeully underdocumented (arrays, for example), others make claims about support for features that don't actually work (rules that activate on a particular column of a table, specified as table.column, aren't supported in practice). Most of the time, you can work around these problems, though. And don't bother using pg_sql for stored procedures as it's a nightmare to debug. You'll get their more quickly with the embedded tcl interpreter (and I hate tcl...). Questions for the list: What's the status of the python/zope postgresql drivers? I recall someone saying that it was behaving as a 'level 2' adapter, unlike the oracle adapter with is a level 3 or something. What's the difference? What do we need to do to get it up to level 3? Does anybody know of a module for postgresql to embed python to use for stored procedures? Anyone what to write one :-) John
Thus spake Cary O'Brien (cobrien@Radix.Net):
Is anybody using (succesfully) PostgreSQL? Any comments on speed/reliability/(zope)zen?
Yes... very. Speed is very good if you use the SQL Method cache.
I have had a database up and running for months and never had to touch it.
Ditto. I've had a bug-tracking zope/postgresql app running for nearly a year without any problems.
Plus PostgreSQL 7.0 is coming out with lots more goodies.
PostgreSQL Tips:
Indexes may not be used untill you run a vacuum. Never, never let it run out of disk space. Bad things happen.
-- cary
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Is there a way to use large objects with zope's sql product? sRp -- Scott Parish http://srparish.net
At 22:41 07/05/00 +0000, you wrote:
Thus spake Cary O'Brien (cobrien@Radix.Net):
Is anybody using (succesfully) PostgreSQL? Any comments on speed/reliability/(zope)zen?
I'm using it on Linux very successfully. There's a web front-end called postgressadmin (available from www.postgresql.org) which needs PHP3 installed which I use as well, though I'm meaning to write a Zope based admin tool. My only problem is that I cannot get the NT version to work yet - it needs Cygwin and other stuff as well so I'm beginning to think PostgreSQL is not ideal if you need a cross-platform solution - shame.
Yes... very. Speed is very good if you use the SQL Method cache.
I have had a database up and running for months and never had to
touch it.
Ditto. I've had a bug-tracking zope/postgresql app running for nearly a year without any problems.
Plus PostgreSQL 7.0 is coming out with lots more goodies.
PostgreSQL Tips:
Indexes may not be used untill you run a vacuum. Never, never let it run out of disk space. Bad things happen.
-- cary
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Is there a way to use large objects with zope's sql product?
sRp
-- Scott Parish http://srparish.net
Richard Moon richard@dcs.co.uk
I'm using it on Linux very successfully. There's a web front-end called postgressadmin (available from www.postgresql.org) which needs PHP3 installed which I use as well, though I'm meaning to write a Zope based admin tool.
My only problem is that I cannot get the NT version to work yet - it needs Cygwin and other stuff as well so I'm beginning to think PostgreSQL is not ideal if you need a cross-platform solution - shame.
Mmm, yes that brings me to the Interbase topic. At the moment I'm looking if I can use Interbase instead of PostGresSQL, because i'm only aware of a PostGresSQL client running on Windows, not a PostGresSQL server. Yes, I know, some people now start thinking, why do you need it on windows? Well, some customers work on Linux, so no problem, other just only want windows... and therefor I'm looking at Interbase, because it runs on both. Tom.
Tom Deprez wrote:
Mmm, yes that brings me to the Interbase topic. At the moment I'm looking if I can use Interbase instead of PostGresSQL, because i'm only aware of a PostGresSQL client running on Windows, not a PostGresSQL server.
The postgreSQL for windows NT should be on ftp.postgresql.org. It needs cygwin and some additional stuff (?). I dont know if it works on Win9x
Yes, I know, some people now start thinking, why do you need it on windows? Well, some customers work on Linux, so no problem, other just only want windows... and therefor I'm looking at Interbase, because it runs on both.
I still suspect that PostgreSQL runs on more platforms ;) -------------- Hannu
Mmm, yes that brings me to the Interbase topic. At the moment I'm looking if I can use Interbase instead of PostGresSQL, because i'm only aware of a PostGresSQL client running on Windows, not a PostGresSQL server.
There is a binary for the NT version of the server, but as I say it needs Cygwin, there are no clear instructions on how to install it (only on how to compile from source) and I have given up at present - I'm about to dive into the PostgreSQL mailing lists to see if anything comes up.
Yes, I know, some people now start thinking, why do you need it on windows? Well, some customers work on Linux, so no problem, other just only want windows... and therefor I'm looking at Interbase, because it runs on both.
Tom.
Well I need it on Windows because some clients prefer it that way. I cannot tell my clients they are wrong if they choose NT - it may do everything they want. Zope is extremely easy to install on NT and has run very reliably in a real-world installation. The Windows-only ODBC DA makes it the platform of choice if you need ODBC. If we could find a decent open-source database that ran as well as Zope cross platform that would be brilliant and if Interbase gets there before PostgreSQL that's the way I'll be going. I'd also like an Informix DA if anybody feels so inclined :-) Richard Richard Moon richard@dcs.co.uk
participants (10)
-
Cary O'Brien -
Hannu Krosing -
J. Atwood -
John Morton -
Oleg Broytmann -
Richard Moon -
Richard Smith -
Scott Parish -
Steve Alexander -
Tom Deprez