Would it be a good idea to have a separate shared buffer process to
manage the cache? Could such a process take workload off of the main
backend and improve their performance?
Just an idea?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] |
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Would it be a good idea to have a separate shared buffer process to
> manage the cache? Could such a process take workload off of the main
> backend and improve their performance?
> Just an idea?
I can't recall if this has been discussed on the list, b
Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > I think theoretically in serializable the cases where the difference
> > between the snapshot from this statement and the standard snapshot for the
> > transaction are noticable we probably have a serialization failure
>
> Hmm, that i
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I just noticed that libpq/ecpg use $(THREAD_CFLAGS) as part of CPPFLAGS.
> Is that correct? Should it be added to CFLAGS instead?
I was just noticing that today. THREAD_CFLAGS typically includes -D
flags, and as such it *must* be added to CPPFLAGS ---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I just noticed that libpq/ecpg use $(THREAD_CFLAGS) as part of CPPFLAGS.
> > Is that correct? Should it be added to CFLAGS instead?
>
> I was just noticing that today. THREAD_CFLAGS typically includes -D
> flags, and as such it *mus
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Actually, the most common THREAD_CFLAGS is -pthread, used by Solaris,
> OSF, and FreeBSD 4.X. Only Linux uses -D flags for threading.
So is -pthread a compile-time or link-time flag?
If we need both THREAD_CPPFLAGS and THREAD_CFLAGS then let's go ahead
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am documenting this behavior in the CREATE VIEW manual page, diff
> attached.
> +
> + While access to tables in the view is controlled entirely by permissions
> + on the view, functions called by the view are checked independently.
> +
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Actually, the most common THREAD_CFLAGS is -pthread, used by Solaris,
> > OSF, and FreeBSD 4.X. Only Linux uses -D flags for threading.
>
> So is -pthread a compile-time or link-time flag?
>
> If we need both THREAD_CPPFLAGS and THR
Ah, I was just thinking that you could do a nice multi-line version (same
as how they are dumped from 7.3.x)
But yes, it doesn't really matter.
Chris
On Fri, 26 Sep 2003, Andreas Pflug wrote:
> Christopher Kings-Lynne wrote:
>
> > I note there is no pretty printing option for pg_get_triggerdef.
> > We really don't need threads to replace existing functionality. That
> > would be dog work.
>
> No, that's not the point at all. The problem we are facing at the
> moment with the Windows port is lack of fork(), which means there's
> no way for separate-subprocess backends to inherit variable
> Not "it can", but "it has to". The master *must* keep hold of that
> request forever (or until the slave responds, or until we reconfigure
> the system not to consider that slave valid anymore). Similarly, the
> slave cannot forget the maybe-committed transaction on pain of not being
> a valid
On Fri, 2003-09-26 at 23:18, Bruce Momjian wrote:
> If you are loading from pg_dump, you have lots of copy commands, so how
> do you know which COPY command caused the failure. You just have the
> line number of _a_ copy.
I would recommend using
psql -e
so that the sql commands are output too.
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> ... You can make this work, but the resource costs
>> are steep.
> So, after 'n' seconds of waiting, we abandon the slave and the slave
> abandons the master.
[itch...] But you surely cannot guarantee that the slave and the master
time out a
On Fri, 26 Sep 2003, Kevin Brown wrote:
> Tom Lane wrote:
> > Stephan Szabo <[EMAIL PROTECTED]> writes:
> > > I think theoretically in serializable the cases where the difference
> > > between the snapshot from this statement and the standard snapshot for the
> > > transaction are noticable we pro
Saw that these guys had raised some more VC money, and made an acquisition. Anyone
from the company on the lists? (Probably best to reply only to -advocacy, but wanted
to cast the net wide).
From their website (www.metapa.com):
--
Metapa CDB is an enterprise Java software application running
Where are we on this --- we all decided on #4. Does this just require
an announcment in the release notes.
(I need to complete the release notes soon.)
---
Tom Lane wrote:
> Following up this gripe
> http://archives.postgr
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Where are we on this --- we all decided on #4. Does this just require
> an announcment in the release notes.
I haven't done anything about it --- been busy with other stuff, and I
wasn't sure we'd agreed to change it for 7.4 anyway. I'm willing to
make
Stephan Szabo wrote:
> The case at hand (with *'s on the ri queries) assuming pk already
> has an id=1 row would be.
> T1: begin;
> T1: set transaction isolation level serializable;
> T1 ... (something that does a select, not necessarily on either pk or fk)
> T2: begin;
> T2: insert into fk values
101 - 118 of 118 matches
Mail list logo
