Dear Nil,
Yes, the important thing is to use the MIPS compilers, not
gcc. You have your choice of compiler environments -- I suggest using
the 64-bit compilation model (CC="cc -64") -- you can use much bigger
buffer caches that way if you have sufficient RAM. --Bob
>
> Hello Everybody,
>
Robert Fitzpatrick wrote:
> I have a function that tells me if a record is positive and negative
> based on several field values. I use it in select statements:
>
> ohc=> SELECT sample_id, is_wipe_positive(tblleadwipe.sample_id) AS
> positive FROM tblleadwipe WHERE hud_building_id IS NOT NULL;
>
I see. I'll redirect the question there then. Thanks.
On Fri, 16 Jul 2004 23:32:13 -0500, mike g <[EMAIL PROTECTED]> wrote:
> Have you run the analyze function on the table or database?
>
> We would need to see the sql for your tests to determine why it was or
> was not used.
>
> By the way the
On Fri, 2004-07-16 at 16:55, Jim C. Nasby wrote:
> What plans are there for adding error trapping support to pl/PGSQL? In
> my case I'm trying to write code that will properly handle the race
> condition in doing a SELECT/INSERT (SELECT something but if it doesn't
> exist do an INSERT), and I can't
On Thu, 2004-07-15 at 12:08, Walter Landry wrote:
> Hello,
>
> I have a user with a postgresql database running on a Linux cluster.
> They would like to use the cluster to speed up an individual query.
> I've found the product Clusgres [1], but that is more oriented towards
> making multiple qu
On Sun, 18 Jul 2004 15:30:01 +0200, Ian Barwick <[EMAIL PROTECTED]> wrote:
> On Tue, 13 Jul 2004 05:53:36 +0100 (BST), raj veluchamy
> <[EMAIL PROTECTED]> wrote:
> > hello all,
> > i am running postgres in compiling postgres in OSCAR
> > cluster.
> > installation is done to /home/pgsql as i couldn'
Regular vacuum will (almost) never return your table to it's minimum
size. I don't think it's unreasonable for a table that is 4MB after a
vacuum full, to grow to 11MB, especially if it's a very active table.
The important question is does it keep growing? Or does it reach a
steady state size?
Chuck Bearden <[EMAIL PROTECTED]> writes:
> I am building from a freshly downloaded tar.gz of 7.4.3. The machine is
> a 4CPU Dell with an unsupported RH 9 install.
> When I ran the regression tests, two failed: horology and stats. I'll
> append the content of the regression.diffs file to the pos
Dear All!
I'm currently looking for multy-master PostgreSQL cluster software and
found one named PGCluster (version 1.0.7...something)
But looks like nobody use this software in production because in this
maillist i have found only questions and refferences to the PGCluster,
but no success story