On Sat, 6 Jan 2001, Valter Mazzola wrote:
> Excuse my ignorance.
> Is there a way to replace the shmem and sem (ipc.c) to use files. In this
> way we can have a sort of a parallel server using GFS.
...
Besides the slowness of file IO, it also doesn't make sense to have a
shared memory area f
I suppose it won't help here to suggest using memory mapped I/O, because
someone will complain their platform doesn't support it. I wonder though if
there could be an optional patch to use mmap for all disk I/O, not just
shared memory!
- Andrew
"Valter Mazzola" <[EMAIL PROTECTED]> writes:
> Is there a way to replace the shmem and sem (ipc.c) to use files. In this
> way we can have a sort of a parallel server using GFS.
Unless GFS offers access bandwidth approaching main memory speeds, this
idea is sheer folly :-(
Excuse my ignorance.
Is there a way to replace the shmem and sem (ipc.c) to use files. In this
way we can have a sort of a parallel server using GFS.
1.Starting a postmaster on ONE machine creates the shared structures, 2.then
start on other cluster-machines, the variuos machines share the same
The Hermit Hacker writes:
> Anyone have anything outstanding that prevents me rolling a Beta2 and
> announcing it this weekend? Tom? Vadim? Peter?
I'll commit the grammar changes we discussed yesterday, plus some new
documentation that goes with it, tomorrow. I'm also going to send you a
pat
Ross J. Reedstrom writes:
> > Do you really need the thing to be a bootstrap table, and not a plain
> > system table?
>
> Yup, 'cause it's going to store the schema info, including the system
> schema. I forsee it needing to be accessed immediately during bootstrap.
Does "schema info" mean SQL s
Tom Lane wrote:
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> OK. Second proposal: do the init_irels() call in
> >> RelationCacheInitializePhase2(). I've just looked through the
> >> other stuff that's done in between, and I don't think any of it
> >> needs valid relcach
On Fri, Jan 05, 2001 at 06:25:38PM -0500, Tom Lane wrote:
>
> Still, it sure looks like 'create bootstrap' should cause mdcreate()
> to be called, so I'm not sure why you'd see the file not get created
> at all. Have you tried tracing through it with a debugger?
>
> Do you really need the thing
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> OK. Second proposal: do the init_irels() call in
>> RelationCacheInitializePhase2(). I've just looked through the
>> other stuff that's done in between, and I don't think any of it
>> needs valid relcache entries.
> Oops, I neglecte
Tom Lane wrote:
>
> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> "Hiroshi Inoue" <[EMAIL PROTECTED]> writes:
> It seems that init_irels() should be called after
> InitializeTransactionSystem() was called.
> >>
> >> Can we just swap the order of the RelationCacheInit
Lamar Owen <[EMAIL PROTECTED]> writes:
> Ok, consider my mind changed. :-). My only concerns were, due to some
> feedback I have gotten, is that people would treat the RPM release as
> _productions_ rather than beta -- but maybe I'm just being paranoid.
As long as the RPMs are clearly marked be
Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > I am inclined to wait until a Release Candidate, if we have one this go
> > around, is available before releasing RPM's, but my mind can be
> > changed :-)
> Please do make beta RPMs available. Seems to me that there's a
> fair-si
Lamar Owen <[EMAIL PROTECTED]> writes:
> I am inclined to wait until a Release Candidate, if we have one this go
> around, is available before releasing RPM's, but my mind can be
> changed :-)
Please do make beta RPMs available. Seems to me that there's a
fair-size population of potential be
mike wrote:
>Tom Lane Wrote:
> > Wrap it up, I'd say. I don't have anything pending that seems worth
> > holding up beta2 for.
> Will RPM's be made availiable for this beta release?
I intend to do so, but it will be a few days to a week after the tarball
release.
I am inclined to wait until a
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> One difference between my new table and the other system tables,
> perhaps, is that there is no code using the table: perhaps something
> with how mdopen will substitute for mdcreate, and create files while
> under bootstrapmode?
I suspect that's
>> An fprintf returning 0 is a suspicious event; it's easy to imagine
>> cases where it makes sense, but I don't think I have ever coded one.
>> Probably > N (where N is the smallest reasonable output, defaulting
>> to 1) may be a better test in real code.
> On older systems fprintf returns 0 o
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > Anyone have anything outstanding that prevents me rolling a Beta2 and
> > announcing it this weekend? Tom? Vadim? Peter?
>
> Wrap it up, I'd say. I don't have anything pending that seems worth
> holding up beta2 for.
Will RPM's be made avai
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
> Does the SPI interface support recursion? That is, can a function
> use SPI to make a query which involves calling another function which
> uses SPI?
Looks to me like it should work.
> The documentation suggests not, saying that if a function which
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> Anyone have anything outstanding that prevents me rolling a Beta2 and
> announcing it this weekend? Tom? Vadim? Peter?
Wrap it up, I'd say. I don't have anything pending that seems worth
holding up beta2 for.
regards, to
> Anyone have anything outstanding that prevents me rolling a Beta2 and
> announcing it this weekend? Tom? Vadim? Peter?
I'll commit small changes to xlog.c today.
Vadim
Anyone have anything outstanding that prevents me rolling a Beta2 and
announcing it this weekend? Tom? Vadim? Peter?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|
Hey hackers -
I'm having a bit of trouble with creating a new bootstrap system
table. That is, one that is created during initdb via 'create bootstrap'
in the PKI file.
I realize that for this sort of system table, I need to add tuples via
bootstrap DATA statements to pg_class.h, pg_attribute.h
[EMAIL PROTECTED] (Nathan Myers) writes:
> An fprintf returning 0 is a suspicious event; it's easy to imagine
> cases where it makes sense, but I don't think I have ever coded one.
> Probably >N (where N is the smallest reasonable output, defaulting
> to 1) may be a better test in real code.
O
> Does the SPI interface support recursion? That is, can a function
> use SPI to make a query which involves calling another function which
> uses SPI?
>From http://www.postgresql.org/docs/programmer/spi.htm :
"SPI procedures are always called by some (upper) Executor and the SPI
manager
uses t
Does the SPI interface support recursion? That is, can a function
use SPI to make a query which involves calling another function which
uses SPI?
The documentation suggests not, saying that if a function which uses
SPI calls another function which uses SPI, it won't work, and calling
that ``bad
Alex Pilosov <[EMAIL PROTECTED]> writes:
> Tom, I'm not sure how (or whether) this relates to "alter table" happening
> when someone else is doing a SELECT from table.
The ALTER will wait for the SELECT to finish. That's not related to the
internal cache problem that I was worried about.
On Fri, 5 Jan 2001, Tom Lane wrote:
> I just finished running the parallel regress tests with inval.c rigged
> to flush the relcache and syscache at every available opportunity,
> that is anytime we could recognize a shared-cache-inval message from
> another backend (see diff below). This setup
Philip Warner <[EMAIL PROTECTED]> writes:
> There are a few places to check, but a lot less than before. Assuming I
> should just die on any failed write (which seems reasonable),
Yes, I see no point in continuing after a write failure. Just print
the strerror() message and exit.
> how do I
> c
At 20:50 4/01/01 -0500, Tom Lane wrote:
>
>Talk to Philip Warner about detecting output write failures. I think
>this might be a lot easier in current sources than it would have been in
>7.0.* or before; the actual I/O is more centralized, and I think you
>could reasonably hope to check for write
Tom Lane wrote:
>
> * Fix LIKE indexing optimization for non-ASCII locales
>
> I've applied a brute-force solution, which is not to do any LIKE
> optimization in non-ASCII locales :-(.
What is a non-ASCII locale ? Anything that is not LC_ALL=ASCII ?
BTW, it would really help if we had a way t
Tom Lane wrote:
>
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > I have noticed that AND and TRAILING could be made ColLabel's without
> > further changes. Currently they are completely reserved. (This is
> > especially odd given that OR is a ColLabel.) Would that be okay to
> > change?
Wo
31 matches
Mail list logo
