to obtain a value between 0 and
255, thus we
could partition the whole id set into 255 part without conflict with
each other thus avoid
the race etc. problem with concurrently 256 consumer process at most,
and we surly could
change it into adapt for more process, depend on you
T condition clause
and a UPDATE statement;
2, when NOT EXISTS, INSERT succeed, and the query tree in 1 proceed to
UPDATE;
3, the UPDATE saw the INSERT in 2, then UPDATE it;
if so, then I understand what happed there, and it's surly not a bug but
a mis-use of rule.
thanks and best regards
-la
A. Kretschmer wrote:
am Wed, dem 28.05.2008, um 15:56:22 +0800 mailte laser folgendes:
hi all,
see query below:
create table ruleTest(id integer, name text);
create or replace rule ruleTest_insert_rule AS on insert to ruleTest
where exists(select 1 from ruleTest where ruleTest.name
unique index ruletest_name_uniq_idx on ruletest using btree (name);
laser=# insert into ruletest(id,name) values(1, 'laser0');
INSERT 0 1
laser=# select * from ruletest;
id | name
+
2 | laser0
I think the id should be 1, cause the rule condition should only affect
exist row
hi all,
Yahoo China sponsored a small project to build a WebDB interface
based on HTTP/JSON/REST etc. and it could be found from here:
http://search.cpan.org/~agent/OpenResty-0.1.10/lib/OpenResty.pm
any comments are welcome!
-laser
--
Sent via pgsql-general mailing list (pgsql-general
PostgreSQL, but I can't found
clear docs, can someone
give me some hint about that?
thanks and best regards
laser
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and run vacuum analyze; then run the query, now the query return the result,
through top, we found that the postmaster process used 600+M RAM, the
enable_hashagg is ON.
wish that helps.
regards laser
---(end of broadcast)---
TIP 9: In versions belo
ery,
and finally got the out of memory error.
After that, we dig in the archive and find a solution:
issue a 'set enable_hashagg=off' and re-run the query,
and now the query give me the result.
regards laser
---(end of broadcast)---
TIP 8: explain analyze is your friend
test in newly checkout CVS tip, but want to report here
first.
regards laser
TopMemoryContext: 24576 total in 3 blocks; 7360 free (5 chunks); 17216 used
Operator class cache: 8192 total in 1 blocks; 4916 free (0 chunks); 3276 used
Type information cache: 8192 total in 1 blocks; 1844 free (0 chunks
Danny wrote:
> - Hello
> - I had previous experience with Access and MySQL.
>
> -Situation
>
> - I am trying to create the equvilant of the following which is a mysql
> command.
>
> - Queston
> - But I cannot figure out how to do this is postgresql
>
> "mysql -u root -p mydb < mydb.dump"
>
I thi
10 matches
Mail list logo
