Have you actually seen any problem in simple get/put/delete/update
situations?
It's a shame when people spend a great deal of effort to invent a cure
for a disease that does not exist.
If you have problems with any of these things, there are usually good
solutions.
Using the copy API, you can insert like a raving madman. PostgreSQL has
a prepared insert. Safe, transacted inserts will be hard to do much
faster than that. You can also bracket bunches of operations in a
single transaction if you like.
In real life, how fast can you update records? If you have a titanic
pile of users all trying to update, then the MVCC model is probably
close to optimal anyway.
Do you have some measurement that shows PostgreSQL is not performing up
to a real business case time requirement?
Sometimes, we can be guilty of 1980's batch oriented mind-set, if we
have been doing data processing for a long time. The old paradigms no
longer apply for the most part.
Recommended reading:
http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2
005-39
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alexandre
Sent: Tuesday, April 19, 2005 10:41 AM
To: Tom Lane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Simplified (a-la [G|N]DBM) DB access
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking for.
Anyway, thank you for the information.
Regards,
/Alexandre.
On Apr 19, 2005, at 18:16, Tom Lane wrote:
> Alexandre <Xlex0x835@rambler.ru> writes:
>> What I mean is: currently to get/put/delete/edit any data I have to
>> compose an SQL query, which should be parsed, compiled, optimized and
>> so on. While, in some tasks simple interface a-la [G|N]DBM should be
>> more than enough, but it will be more preferable to store all data in
>> one database, which support concurrent access, transactions, etc.
>
> I seem to recall that someone has written an ISAM-style interface
> library, which might be more or less what you are asking for. Check
> the archives, and/or look at gborg and pgfoundry.
>
> regards, tom lane
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq