agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: gmb <gmbouwer@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: High memory usage / performance issue ( temp tables ? )
Date: Mon, 18 Aug 2014 04:20:34 -0700 (PDT)
Message-ID: <1408360834601-5815206.post@n5.nabble.com> (raw)
In-Reply-To: <CAFj8pRDjpaJDKWVm7gMuA-TMuMBjZYPKTB6CR3GJtv9ysqb+vw@mail.gmail.com>
References: <1408260946918-5815108.post@n5.nabble.com>
<B6F6FD62F2624C4C9916AC0175D56D8828AC64E4@jenmbs01.ad.intershop.net>
<1408272021571-5815111.post@n5.nabble.com>
<1408304846514-5815126.post@n5.nabble.com>
<CAFj8pRB44Hq8kdiwfQZRJVNLGz1Q2NAd_7RLrLJyi9Xgy3pwoA@mail.gmail.com>
<1408339998171-5815175.post@n5.nabble.com>
<CAFj8pRDjpaJDKWVm7gMuA-TMuMBjZYPKTB6CR3GJtv9ysqb+vw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Just to make sure I understand this correct : > You can write PostgreSQL
extension in C - and store XML only in memory.Meaning that I write
function(s) which processes the XML using C which will allow me more option
with processing the XML ? Will this allow me to cache the payload data in
memory for the connection and not only for a single function ? If not , this
approach will not work , unless I rewrite a lot of the code / functions. The
current solution makes use of a separate function for each different part of
the XML. Reason for this is that a lot of validation is also done on the
data. > Temp tables are best when you do some queries or when you need
indexes, but> it is terrible slow cache.> > else - Postgres is good as
database and very slow as cache. It is good for> prototyping and for less or
middle load servers. For any other use> different softwareSo your point is
that the use of temp tables in this kind of scenario is not vey efficient.
I'll then try to replace the temp tables with actual tables with some kind
of UID.Thanks for the response.gmb
--
View this message in context: http://postgresql.1045698.n5.nabble.com/High-memory-usage-performance-issue-temp-tables-tp5815108p58...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
view thread (10+ messages) latest in thread
Message-ID: <1408360834601-5815206.post@n5.nabble.com>
Permalink: ../1408360834601-5815206.post@n5.nabble.com/
Also on: postgresql.org/message-id/1408360834601-5815206.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gmbouwer@gmail.com
Subject: Re: High memory usage / performance issue ( temp tables ? )
In-Reply-To: <1408360834601-5815206.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox