"Cyrille Bonnet" <[EMAIL PROTECTED]> writes:
> Should I be worried that Postgres is eating up 99% of my CPU??? Or is this
> *expected* behaviour?
It's not expected, unless you are running some very long-running query.
The conflict between what top says and what mpstat says is strange; I
wonder if
Bruno et al,
Any self-repsecting lurker would know that oids as row identifiers are
depreciated in postgres. Can anyone provide a brief history regarding
the reasoning behind using them as row identifiers in the first place?
I see a discussion of their use as various primary keys in he system
Sccot,
Thank you very much, I think taht you are right about this.
I tested a single query, there is no problem. I'll do a full test with my program.
Jie Liang
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 12:57 PM
To: Jie Liang
Cc: [EMA
All,
This is old topic, when I use:
select url from urlinfo where url like 'http://www.lycos.de%';
it uses the index, good!
but if I use:
select url from urlinfo where url like 'http://%.lycos.de';
it won't use index at all, NOT good!
is there any way I can force secon query use index???
Thanks.
I try to do:
CREATE RULE ndicti AS ON INSERT TO ndict
DO INSTEAD INSERT INTO 'ndict_' || (NEW.word_id & 255)
VALUES( NEW.url_id, NEW.word_id, NEW.intag);
I got an error on 'ndict_' .
I did not found the right syntax.
In fact I discover that
SELECT * FROM / INSERT INTO table
doesn't accept f
James Robinson wrote:
> Bruno et al,
>
> Any self-repsecting lurker would know that oids as row identifiers are
> depreciated in postgres. Can anyone provide a brief history regarding
> the reasoning behind using them as row identifiers in the first place?
> I see a discussion of their us
I'm guessing you have a 4 cpu box:
1 99 percent busy process on a 4 way box == about 25% busy overall.
On May 5, 2004, at 6:03 AM, Tom Lane wrote:
"Cyrille Bonnet" <[EMAIL PROTECTED]> writes:
Should I be worried that Postgres is eating up 99% of my CPU??? Or is
this
*expected* behaviour?
It's not
Jie Liang wrote:
All,
This is old topic, when I use:
select url from urlinfo where url like 'http://www.lycos.de%';
it uses the index, good!
but if I use:
select url from urlinfo where url like 'http://%.lycos.de';
it won't use index at all, NOT good!
is there any way I can force secon query use in
> but if I use:
> select url from urlinfo where url like 'http://%.lycos.de';
> it won't use index at all, NOT good!
> is there any way I can force secon query use index???
create index nowww on urlinfo(replace(replace(url, 'http://', ''),
'www.', '')));
SELECT url
FROM urlinfo
WHERE replace(re
Hello all,
What's the case of bigger database PostgreSQL (so greate and amount of
registers) that they know???
Thanks,
Carlos Eduardo Smanioto
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subs
On Sat, 2004-06-05 at 11:55, Carlos Eduardo Smanioto wrote:
> What's the case of bigger database PostgreSQL (so greate and amount of
> registers) that they know???
You might want to fix the month on your system time.
With respect to how big PostgreSQL databases can get in practice, these
are our
On Sat, 5 Jun 2004, Carlos Eduardo Smanioto wrote:
> Hello all,
>
> What's the case of bigger database PostgreSQL (so greate and amount of
> registers) that they know???
http://www.postgresql.org/docs/faqs/FAQ.html#4.5
---(end of broadcast)---
TI
What's the case of bigger database PostgreSQL (so greate and amount of
registers) that they know???
Didn't someone say that RedSheriff had a 10TB postgres database or
something?
Chris
---(end of broadcast)---
TIP 6: Have you searched our list archiv
All,
After I upgraded postgres from 7.3.4 to 7.4.2, one of my program got following error:
DRROR: out of memory
DETAIL: Fail on request of size 92.
any idea??
does memory management have big difference between 7.3.4 and 7.4.2???
this program using a chunk of share memory and a lot of temp tables.
14 matches
Mail list logo