Merlin Moncure wrote:
It was only with the 8.x versions that postgres
really started pulling away.
Today I was re-reading a great reminder of just how true this is:
http://suckit.blog.hu/2009/09/29/postgresql_history
From the baseline provided by 8.0, PostgreSQL increased in speed by
about
Ron Mayer wrote:
* There are enough large companies that depend entirely
on each of the databases that make either one a save
choice from that point of view (Skype). And the way
Apple and Cisco use it for a number of their programs
Yeah, these are all good examples. Cisco uses Postgre
Hi Raimon,
On Dec 20, 2009, at 2:11 PM, Raimon Fernandez wrote:
>
> I'm not seeing my e-mails on the PostgreSQL General List ...
>
> ??
Yes, my last message did not make it to the list yesterday (you obviously
received it). I double checked and it was cc to the list.
> I can pack all of
Alex - writes:
> Tom, Scott, Alvaro,thanks for the hints on this issue. It looks as if one of
> the EOD maintenance jobs which does a few extensive queries does push data
> out of memory leading to this behavior.
> Is there a way to permanently cash some tables into memory?
Not as such, and if
Tom, Scott, Alvaro,thanks for the hints on this issue. It looks as if one of
the EOD maintenance jobs which does a few extensive queries does push data out
of memory leading to this behavior.
Is there a way to permanently cash some tables into memory?
ThanksAlex
> Date: Sat, 19 Dec 2009 00:10:
On 12/20/2009 4:13 PM, Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
Some quick Googling found this if you are looking for a desktop solution:
http://groups.fsf
Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
perhaps OpenOffice Data could do what you need. I'm not real familiar
with Oracle Forms, but I know OOo Data can
Gauthier, Dave wrote:
> The arguments against PG are not technical.
A few more points that I didn't see in this thread yet that might help
answer the non-technical questions:
* There seem to be more commercial vendors providing support
for Postgres than MySQL - because most mysql support came
On Mon, Dec 21, 2009 at 12:13 AM, Andre Lopes wrote:
> Hi,
>
> I need to know if there is something like Oracle Forms in the Open Source
> world that works with PostgreSQL.
>
> If do you know something, please let me know.
>
> Best Regards,
> André.
>
IMHO moving towards traditional GUI or other
Hi,
I need to know if there is something like Oracle Forms in the Open Source
world that works with PostgreSQL.
If do you know something, please let me know.
Best Regards,
André.
Op 19-12-09 22:20, Jaime Casanova schreef:
are you planning to run this many times? what is wrong with making
this manually?
doesn't seem like something to make automatic...
but if you insist in plpgsql you can execute "select version() into
some_text_var" and act acordingly
No, this is don
The arguments against PG are not technical. The biggest advocate for MySQL is
actually a very sharp engineer who admits that PG is a superior DB. But MySQL
is more popular in the corp and has more formal recognition. So he's saying
that the differences aren't "big enoug" to justify using PG.
Ron Mayer writes:
> Lincoln Yeoh wrote:
>> Ten or so years ago MySQL was better than Postgres95, and it would have
>> been easy to justify using MySQL over Postgres95 (which was really slow
>> and had a fair number of bugs). But Postgresql is much better than MySQL
>> now. That's just my opinion o
On Sun, Dec 20, 2009 at 3:19 PM, Ron Mayer
wrote:
> Lincoln Yeoh wrote:
>> Ten or so years ago MySQL was better than Postgres95, and it would have
>> been easy to justify using MySQL over Postgres95 (which was really slow
>> and had a fair number of bugs). But Postgresql is much better than MySQL
Lincoln Yeoh wrote:
> Ten or so years ago MySQL was better than Postgres95, and it would have
> been easy to justify using MySQL over Postgres95 (which was really slow
> and had a fair number of bugs). But Postgresql is much better than MySQL
> now. That's just my opinion of course.
Really?!?
MyS
On Sun, Dec 20, 2009 at 10:04 AM, Lincoln Yeoh wrote:
> At 05:44 AM 12/17/2009, Greg Smith wrote:
>>
>> You've probably already found
>> http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
>> which was my long treatment of this topic (and overdu
Le 19 déc. 2009 à 16:20, Chris Ernst a écrit :
> Hmm.. That does look very interesting. The only thing that concerns me
> is where it says it supports "Basic Queries (Extended queries not yet
> supported)". I'm not sure what is meant by "Extended queries". Any idea?
I think it refers to the Ex
Hi, Andrus,
First, it does seem that you are expecting PostgreSQL to have the same
behavior as a flat-file manager such as FoxPro (indeed, it seems you'd
like PG to have the behavior of a *specific* flat-file manager).
Despite the superficial similarity in the command syntax, a modern
RD
You are confusing a few things, and you don't want to hear the
explanations because they are inconvenient.
Andrus wrote:
> 1. In my case b expression needs values from previous rows updated in this
> same command before:
You are confusing "to the left of" and "before".
If you want behaviour that
Hi Craig,
Many thanks for the detailed and quick reply. Must admit although I'd
read that every statement was implicitly in a transaction I hadn't
connected that through to the operations in any associated triggers.
Best regards
Larry Anderson
Craig Ringer wrote:
On 20/12/2009 9:02 PM, Lar
JGuillaume (ioguix) de Rorthais wrote:
>> I am currently developing such a beast, it is currently still quite
>> alpha. If you are interested I can send you a copy. I'll try to
>> publish it once it is sufficiently beta.
>
> Interesting project, but but I have one big issue under 8.1 and
> advanced
At 05:44 AM 12/17/2009, Greg Smith wrote:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
The main thing I intended to put into such an
On 20/12/2009 9:02 PM, Larry Anderson wrote:
Hi All,
I'm new to Postgres and need a way to test if a transaction is already
in progress.
The test will take place inside a trigger function in pl/pgsql and will
start a new transaction only if one is not in progress
You can't do that, I'm afraid
Hi All,
I'm new to Postgres and need a way to test if a transaction is already
in progress.
The test will take place inside a trigger function in pl/pgsql and will
start a new transaction only if one is not in progress ie started by a
previous trigger that cascaded through to this trigger. C
On 20/12/2009 7:59 PM, hubert depesz lubaczewski wrote:
On Fri, Dec 18, 2009 at 02:08:07PM -0700, Chris Ernst wrote:
Hi all,
I have a project where I need to be able to capture every query from a
production system into a file such that I can "replay" them on a staging
system. Does such a thing
On Fri, Dec 18, 2009 at 02:08:07PM -0700, Chris Ernst wrote:
> Hi all,
>
> I have a project where I need to be able to capture every query from a
> production system into a file such that I can "replay" them on a staging
> system. Does such a thing already exist or should I start writing my
> own
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Shoaib Mir a écrit :
> On Sun, Dec 20, 2009 at 9:37 AM, Albe Laurenz
> mailto:laurenz.a...@wien.gv.at>> wrote:
>
> Chris Ernst wrote:
>> I have a project where I need to be able to capture every
> query from a
>> production system into a file such that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey guys,
Albe Laurenz a écrit :
> Chris Ernst wrote:
>> I have a project where I need to be able to capture every query
>> from a production system into a file such that I can "replay"
>> them on a staging system. Does such a thing already exist or
On Sun, Dec 20, 2009 at 2:12 AM, Andrus wrote:
>> You cannot access new values of a particular row within a single UPDATE
>> statement, but you do see new values done in the same transaction.
>> This is explain in some detail in the documentation:
>>
>>
>> http://www.postgresql.org/docs/8.4/inte
You cannot access new values of a particular row within a single UPDATE
statement, but you do see new values done in the same transaction.
This is explain in some detail in the documentation:
http://www.postgresql.org/docs/8.4/interactive/transaction-iso.html#XACT-READ-COMMITTED
I tried
dro
30 matches
Mail list logo
