Title: Message
I am wondering if
it is possible, or even advisable, to run two postmasters on a single
system.
For example, we
have an embedded system with a normal runtime partition (called the "A") in
which the PGDATA is /var/lib/pgsql/data. We also have a offline partition which
is a c
Again, we have an odd performance problem with PGSQL, 7.4b2.
Here is the query:
delete from numplan where pkid in
(select numplan.pkid from numplan
left outer join pilothuntgroup on
numplan.pkid=pilothuntgroup.fknumplan
left outer join devicenumplanmap
I am doing to large dataset performance tests with 7.3.4b2 today and I noticed an
interesting phenomenon. My shared memory buffers are set at 128MB. Peak postmaster
usage appears to be around 90MB.
My test app performs inserts across 4 related tables, each set of 4 inserts
representing a sing
I had an opportunity to test this massive left outer join this with 7.4b2 today.
It took <3 seconds on an untuned, new install...which is MUCH better. In fact, it
performed as well as Oracle 9i.
cwl
> -Original Message-
> From: Clay Luther
> Sent: Thursday, August 28,
Sent: Thursday, August 28, 2003 8:20 PM
> To: Mike Mascari
> Cc: Clay Luther; Greg Stark; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] left outer join terrible slow compared to inner
> join
>
>
>
> Mike Mascari <[EMAIL PROTECTED]> writes:
>
> > > 1
My initial impression is that AFTER triggers written in C cannot abort the wrapping
transaction if an error occurs. Is this correct?
---
Clay
Cisco Systems, Inc.
[EMAIL PROTECTED]
(972) 813-5004
I've stopped 15,797 spam messages. You can too!
One month FREE spam protection at http://www.cloudm
Thanks Tom. That is good info.
(gnashing of teeth in background)
Clay
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 6:46 PM
> To: Clay Luther
> Cc: Doug McNaught; [EMAIL PROTECTED]
> Subject: Re: [GENERAL]
NM, it appears to be fixed now.
cwl
> -Original Message-
> From: Clay Luther
> Sent: Monday, July 07, 2003 3:59 PM
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTECTED]'
> Subject: www.postgresql.org FUBAR
>
>
> The following is the HTML of the www
The following is the HTML of the www.postgresql.org homepage:
--snip--
http://www.postgresql.org/";>
--snip--
Basically, an empty page that is constantly reloaded.
Pretty FUBAR.
cwl
---(end of broadcast)---
TIP 7: don't forget to increase your f
