[PERFORM] History of oids in postgres?
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 catalog in the oid-datatype doc page, but not regarding their history as 'user-space' row ids. Thanks, James James Robinson Socialserve.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[PERFORM] LIKE and INDEX
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. Jie Liang QUERY PLAN Index Scan using urlinfo_ukey on urlinfo (cost=0.00..6.01 rows=1 width=33) Index Cond: ((url = 'http://www.lycos.de/'::text) AND (url 'http://www.lycos.de0'::text)) Filter: (url ~ '^http://www\\.lycos\\.de/.*$'::text) (3 rows) QUERY PLAN - Seq Scan on urlinfo (cost=0.00..100440.48 rows=4 width=33) Filter: (url ~ '^http://.*\\.lycos\\.de$'::text) (2 rows) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PERFORM] INSERT RULE
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 function that returns the name of the table as table, but only function that returns rows I'm dead. Does this feature, is possible or plan ? Is there a trick to do it ? Cordialement, Jean-Gérard Pailloncy ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] History of oids in postgres?
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 use as various primary keys in he system catalog in the oid-datatype doc page, but not regarding their history as 'user-space' row ids. They were added at Berkeley and I think are related to the Object-relational ability of PostgreSQL. I think the newer SQL standards have a similar capability specified. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] very high CPU usage in top, but not in mpstat
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 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 you might have a buggy version of one of them? You should probably check some other tools (try vmstat 1 for instance) to see if you can get a consensus on whether the CPU is maxed out or not ... regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PERFORM] LIKE and INDEX
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 index??? I've seen people define a reverse(text) function via plperl or similar then build a functional index on reverse(url). Of course, that would rely on your knowing which end of your search pattern has the % wildcard. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL Database
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 subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
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 two biggest implementations: - 0.5 Tb GIS database (this maybe upwards of 600-700Gb now, I didn't check) - 10 Gb OLTP system with 70 million rows and a typical working set of 2-3 Gb. Postgres is definitely capable of handling large pretty databases with ease. There are some narrow types of workloads that it doesn't do so well on, but for many normal DBMS loads it scales quite well. j. andrew rogers ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
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)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
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 archives? http://archives.postgresql.org
[PERFORM] 7.4.2 out of memory
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. Thanks. Jie Liang ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])