Hello all!
I need to setup high performance DB server. Some time ago I red
there about processor cache influence on query execution
performance.
A question:
What system would perform better?
lh6000 with two xeon 7000Mhz 2MB cache
or
with four xeon 7000Mhz 1MB cache
Mark
-
I need to add a field to an existing table that contains a good amount of
data. Do I need to drop table, recreate, and then reload data to do this? I
cannot seem to find any documentation to say otherwise.
Thanks
Jodi
___Jodi
L KanterBioInformatics Database Admi
Thank you. I found this doc just after I sent the email. I appreciate the
quick response.
Jodi
- Original Message -
From:
Florian
Helmberger
To: Jodi Kanter
Cc: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 10:14
AM
Subject: RE: [ADMIN] adding fields
Hi
Hi Jodi--
No, you shouldn't have to go to that amount of
trouble. Try this instead (change the name of the table, the default value, the
column name, and the column type to suit your needs):
BEGIN WORK;LOCK
TABLE table_adding_stuff_to IN ACCESS EXCLUSIVE MODE;
ALTER TABLE table_adding_s
Hi.
You should use
ALTER TABLE ADD COLUMN
;
instead. Also, take a look at the
docs:
http://www.postgresql.org/idocs/index.php?sql-altertable.html
Cheers,
Florian
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jodi
KanterSent
Hi,
i have a performance problem with a db. This db consists of only a few tables and is
continuously fed with new datasets (3min interval) and at night it is pruned (all but
the last set are deleted) and vacuumed.
the problem is that queries run (far) too slow because the planner seems to be
Hi,
i have a performance problem with a db. This db consists of only a few tables and is
continuously fed with new datasets (3min interval) and at night it is pruned (all but
the last set are deleted) and vacuumed.
the problem is that queries run (far) too slow because the planner seems to be
"Esger Abbink" <[EMAIL PROTECTED]> writes:
> if i manually VACUUM ANALYZE the db when it is pretty loaded (~300k
> rows) the planner starts using a different plan which runs acceptable
> performance wise. however after the daily cleanup it reverts back to
> the old (bad) plan.
> so it seems the n
did everyone else also receive two copies of my last post?
if so, i hope it stays at 2 as on an other pg list one post got duplicated 5 times and
tbh i'm stumped as to why it happens...
/me scratches head..
--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net
---
On Friday, January 18, 2002, at 02:00 AM, Martins Zarins wrote:
> Hello all!
>
> I need to setup high performance DB server. Some time ago I red
> there about processor cache influence on query execution
> performance.
> A question:
> What system would perform better?
> lh6000 with two xeon 7000
At 05:00 AM 1/14/2002 , Rodrigo Miguel wrote:
>My problem is, my filesystem is full and I can't extend it, so can i use a
>secondary filesystem ?
Yeah, move some files to another file system, and then use symbolic links
to point to them from within $PGDATA.
-crl
--
Chad R. Larson (CRL2
It's all good. The root of the problem lied in the fact that
the default perl install for Solaris8 was built using SUNWspro (Sun's
compiler), and therefore the Config.pm had flags/paths/arguments to
reflect that compiler However, we are using the sunfreeware
installs of GCC and
12 matches
Mail list logo
