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
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
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
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
> 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
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
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
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 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
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.
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.
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
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
"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
14 matches
Mail list logo