In the last exciting episode, [EMAIL PROTECTED] ("Andrew G. Hammond") wrote:
> I don't know what your budget is, but there are now 10k RPM SATA 150
> drives on the market. Their price/performance is impressive. You may
> want to consider going with a bunch of these instead of SCSI disks
> (more spi
I don't know what your budget is, but there are now 10k RPM SATA 150
drives on the market. Their price/performance is impressive. You may
want to consider going with a bunch of these instead of SCSI disks (more
spindles vs. faster spindles). 3ware makes a hardware raid card that can
drive up to
Tom Lane <[EMAIL PROTECTED]> writes:
> I don't believe anyone has proposed removing the facility
> altogether. There's a big difference between making the default
> behavior be not to have OIDs and removing the ability to have OIDs.
Right, that's what I had meant to say. Sorry for the inaccuracy.
Neil Conway <[EMAIL PROTECTED]> writes:
> BTW, we intend to phase out the use of OIDs for user tables in the
> long term.
I don't believe anyone has proposed removing the facility altogether.
There's a big difference between making the default behavior be not
to have OIDs and removing the ability
On Sun, Dec 14, 2003 at 12:42:21AM -0500, Bruce Momjian wrote:
>
> I know this is an old email, but have you tested larger shared buffers
> in CVS HEAD with Jan's new cache replacement policy?
Not yet. It's on our TODO list, for sure, because the consequences
of relying too much on the filesyste
On Sat, 13 Dec 2003, Kari Lavikka wrote:
> I evaluated pg 7.4 on our development server and it looked just fine
> but performance with production loads seems to be quite poor. Most of
> performance problems are caused by nonsensical query plans
Some of the estimates that pg made in the plans you
On Sat, 13 Dec 2003, Kari Lavikka wrote:
> I evaluated pg 7.4 on our development server and it looked just fine
> but performance with production loads seems to be quite poor. Most of
> performance problems are caused by nonsensical query plans but there's
> also some strange slowness that I can't
Here are my query and schema. The ERD is at http://dshadovi.f2o.org/pg_erd.jpg
(sorry about its resolution).
-David
SELECT
zbr.zebra_name
, dog.dog_name
, mnk.monkey_name
, wrm.abbreviation || ptr.abbreviation as abbrev2
, whg.warthog_num
, whg.color
, rhn.rhino_name
, der.deer_name
,
