hi ,
Thanks for several of the links that you guys posted.
The issue is not that I am looking for consulting companies who will set up
and optimize postgres+software. There are a million small firms that do
M*SQL+any CMS work. And I am looking to do that kind of work with clients
-
Pierre Thibault wrote:
Hello people of the Postgresql world!
I am wondering if Postgresql would a great choice for my database needs.
I would like to create a db with dynamic data model. I would like to
be able to add tables and columns to existing tables while other
queries are running.
It
On 28/07/10 02:58, Howard Rogers wrote:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
Thanks very much Howard.
It might be my schoolboy-physics ability to fit a curve to two data
points, but does anyone else think that the second and
On Wed, 28 Jul 2010 22:24:07 -0700
Joshua D. Drake j...@commandprompt.com wrote:
On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
BTW up to my memory Django suggest postgres. I haven't seen any
benchmark of Django with pg vs mysql.
Django was originally developed for
Karsten Hilbert karsten.hilb...@gmx.net wrote in message
news:20100728182051.gj2...@hermes.hilbert.loc...
On Tue, Jul 27, 2010 at 10:33:19AM +0200, Davor J. wrote:
Well... I found it out the hard way :). There are some extra caveats I
have
come along. There is the very clumsy ALTER TABLE
Greg Williamson wrote:
Our tests -- very much oriented at postGIS found Oracle to be between 5
and 15% _faster_ depending on the specifics of the task. We decided to go
with postgres given the price difference (several hundred thousand dollars for
Oracle in the configuration we needed vs. zip
Hello everyone,
I saw a question about PostgreSQL and distributed transactions in the mail
archives. But it looked a bit old. I am hoping things have changed and
hence this mail.
We have a database for 'Admin' which will be one PostgreSQL server. We
have different servers for our 'Clients'. We
On Thu, Jul 29, 2010 at 10:50:02AM +0200, Davor J. wrote:
For completeness, I think this link
(http://projects.nocternity.net/index.py/en/psql-inheritance) provides some
scripts you mention.
Very interesting.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537
Hi,
We need some help to either design a new logo, or spruce up the
existing logo for PGDay.EU 2010. the European PostgreSQL conference.
It needs to be related to PostgreSQL in some way of course, and needs
to be in colours that will work when converted to black and white or
when printed onto a
Jayadevan M jayadevan.maym...@ibsplc.com writes:
But the initial setup for the client is done by 'Admin' and in that
work-flow, we need distributed transactions. The transaction will start
from the 'Admin server, do some inserts on the 'Client' server and then
either rollback or commit on
Brian,
you have two options:
1. Use your own parser (just modify default)
2. Use replace function, like
postgres=# select to_tsvector( replace('qw/er/ty','/',' '));
to_tsvector
--
'er':2 'qw':1 'ty':3
(1 row)
Oleg
On Wed, 28 Jul 2010, Brian Hirt wrote:
I have
On 7/28/2010 3:06 PM Sandeep Srinivasa wrote:
yup I did. The reason why I wanted examples was to amply demonstrate,to
clients, that postgresql is viable.
It is kinda weird if the only examples I have are restricted to the postgresql
_community_ websites themselves.
Both xTuple web sites
On 28 July 2010 02:58, Howard Rogers h...@diznix.com wrote:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
Thanks, very interesting results. I wonder, are the results being
sorted by the database? The performance degradation for large
Dear All,
How can i retrieve only spatial enabled tables form the
database(Postgresql/PostGIS).Please let me know.
I am waiting for your great response.
Thanks and Regards,
Venkat
On Wed, Jul 28, 2010 at 5:27 PM, J. Greg Davidson j...@well.com wrote:
Hi fellow PostgreSQL hackers,
I just got burned by the idiomatic loop
documented in the PostgreSQL manual as
Example 39-2. Exceptions with UPDATE/INSERT
I have now replaced this standard idiom
with a safer one
On 29/07/10 22:36, Pierre Thibault wrote:
Why so? This is something expected by a database used in a constant
integration environment. Maybe I did not expressed myself very well. Users
are not changing their models all the time. They create new models which
mean create new tables and from
On Thu, 2010-07-29 at 11:57 +0530, Sandeep Srinivasa wrote:
What really, really hurts me is this - come Postgres 9.0 you will have
the most amazing DB software in the open source community. I (and
millions of small time developers like me) wont be able to leverage
that - because our clients
On Thu, 2010-07-29 at 08:10 -0400, Ned Lilly wrote:
On 7/28/2010 3:06 PM Sandeep Srinivasa wrote:
yup I did. The reason why I wanted examples was to amply demonstrate,to
clients, that postgresql is viable.
It is kinda weird if the only examples I have are restricted to the
postgresql
P Kishor wrote:
On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost sfr...@snowman.net wrote:
* P Kishor (punk.k...@gmail.com) wrote:
Three. At least, in my case, the overhead is too much. My data are
single bytes, but the smallest data type in Pg is smallint (2 bytes).
That, plus the per row
On Thu, Jul 29, 2010 at 10:06 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Jul 28, 2010 at 5:27 PM, J. Greg Davidson j...@well.com wrote:
Hi fellow PostgreSQL hackers,
I just got burned by the idiomatic loop
documented in the PostgreSQL manual as
Example 39-2. Exceptions with
On Thu, 29 Jul 2010 08:52:46 -0700
Joshua D. Drake j...@commandprompt.com wrote:
The issue isn't Drupal. It is modules. There are a lot of popular
modules that do not work with PostgreSQL (Lightbox for example).
The google checkout module for Ubercart didn't work either until
relatively
This touches on a question I would love to be able to answer
Why is MySQL so much more popular right now, especially in the OpenSource
community? As a database I find its architecture with multiple underlying
engines and other quirks to be rather dubious. Then there is the issue of
On Jul 29, 2010, at 10:53 AM, Samantha Atkins wrote:
This touches on a question I would love to be able to answer
Why is MySQL so much more popular right now, especially in the OpenSource
community? As a database I find its architecture with multiple underlying
engines and other quirks
Samantha Atkins sjatk...@mac.com writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was established in the late 90s, a time when mysql
worked reasonably well (at least
On Thu, 2010-07-29 at 14:57 -0400, Tom Lane wrote:
Samantha Atkins sjatk...@mac.com writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was established in the late 90s,
On Thu, 29 Jul 2010 14:57:04 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Samantha Atkins sjatk...@mac.com writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was
On Thu, 2010-07-29 at 21:19 +0200, Ivan Sergio Borgonovo wrote:
On Thu, 29 Jul 2010 14:57:04 -0400
Tom Lane t...@sss.pgh.pa.us wrote:
Samantha Atkins sjatk...@mac.com writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly
On 10-07-29 02:57 PM, Tom Lane wrote:
Samantha Atkinssjatk...@mac.com writes:
Why is MySQL so much more popular right now, especially in the
OpenSource community?
I think it's strictly historical. The mysql bias you see in so
many web tools was established in the late 90s, a time
On Thu, Jul 29, 2010 at 10:46 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
On Thu, 29 Jul 2010 08:52:46 -0700
Joshua D. Drake j...@commandprompt.com wrote:
The issue isn't Drupal. It is modules. There are a lot of popular
modules that do not work with PostgreSQL (Lightbox for
On 07/29/10 12:52 PM, Sandeep Srinivasa wrote:
Biggest example - Wordpress. Strictly mysql only. If I want to throw
together a company blog + mailing list + SEO, I can get it done using
Wordpress in a matter of hours.
Serendipity - http://www.s9y.org - a full featured blog server, in php,
Hy,
I have a system working with the client-server structure and PostgreSQL 8.4.
My problem is that if a client who is editing a record and lose his connection
to the server,the TCPIP connection is still considered! So, the record stay
allocated for the client in my database.
I need the records
Shopping carts, company blogs, etc. Popular pieces of software.
As common denominators go, that's pretty low.
Perhaps what is needed is a dumbed down version of Postgres.
My hobby horse. MySQL supports regular expressions... In a [rhymes
with rat's ass]. It supports a kind of tinker toy
Dear postgresql list,
I have some troubles generating data
for a analysis task at hand.
I have a table (table A) containing 5
million records and 28 number of attributes. This table is 461MB big
if I copy it to a csv file.
I want to create another table (table
B) based
On 07/29/10 2:58 PM, Dino Vliet wrote:
Dear postgresql list,
I have some troubles generating data for a analysis task at hand.
I have a table (table A) containing 5 million records and 28 number of
attributes. This table is 461MB big if I copy it to a csv file.
I want to create another
Greg Williamson wrote:
Our tests -- very much oriented at postGIS found Oracle to be between 5
and 15% _faster_ depending on the specifics of the task. We decided to go
with postgres given the price difference (several hundred thousand dollars for
Oracle in the configuration we needed vs. zip
Joshua D. Drake wrote:
If you look at Rails, Django, Turbo Gears, Catalyst, Groovy+Grails they all
have excellent PostgreSQL
support.
Exactly. If Ivan were building on a Rails or Java software platform,
this discussion of why is PostgreSQL not well supported? wouldn't be
happening.
Samantha Atkins wrote:
Amazon cloud has great scalable MySQL support but apparently not postgreql.
Why?
The perception is that MySQL has good built-in replication usable for
scaling up purposes, and therefore is suitable for cloud deployments.
Whereas the perception is that PostgreSQL has
On Thu, Jul 29, 2010 at 5:42 PM, Greg Smith g...@2ndquadrant.com wrote:
Greg Williamson wrote:
Our tests -- very much oriented at postGIS found Oracle to be between 5
and 15% _faster_ depending on the specifics of the task. We decided to go
with postgres given the price difference (several
On Thu, Jul 29, 2010 at 10:33 PM, Dean Rasheed dean.a.rash...@gmail.com wrote:
On 28 July 2010 02:58, Howard Rogers h...@diznix.com wrote:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
Thanks, very interesting results. I wonder, are
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving them credit for. For
many common loads, up until PG
Samantha Atkins wrote:
Why is MySQL so much more popular right now, especially
in the OpenSource community? As a database I find its
architecture with multiple underlying engines and other
quirks to be rather dubious. Then there is the issue of
commercial licenses and exactly when you must
Why is MySQL so much more popular right now, especially in the
OpenSource community?
This is not true in Japan. PostgreSQL and MySQL has been having even
share in many surveys.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
On Fri, Jul 30, 2010 at 3:05 AM, John Gage jsmg...@numericable.fr wrote:
Shopping carts, company blogs, etc. Popular pieces of software.
As common denominators go, that's pretty low.
Perhaps what is needed is a dumbed down version of Postgres.
I dont think that is what is required - as I
43 matches
Mail list logo