, 2, idv, VARCHAROID, -1, 0, false);
Why I have to duplicate to?
Thank You
Pavel Stehule
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
On Sat, 27 Dec 2003, A E wrote:
Hi,
I was wondering if a solution was ever found to the error: wrong record type
supplied in RETURN NEXT when executing a function that returns the Record datatype?
I have seen a couple of previous post from Tom Lane and others, but no real
resolution.
,
is good idea use keywords begin sub and end sub? Programmers like me
will be an problems with reading and writing SP, because begin sub and
mostly end sub are keywords from visual basic with different sense.
BEGIN SUBTRANSACTION and END SUBTRANSACTION is longer but more readable
regards
Pavel
is, becouse I
can see only begin of queries in pg_stat_activity, and in this view is
text of query cut on 1Kb.
Can I set somewhere an long for text, which is in current_query in
pg_catalog.pg_stat_activity?
Regards
Pavel Stehule
---(end of broadcast
On Tue, 21 Jun 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
I wont to prohibit synonyms in exception (every exception has unique
sqlstate).
I don't think that's a particularly good idea --- maybe if SQL had been
designed according to your worldview, it'd be like
On Tue, 21 Jun 2005, Andrew Dunstan wrote:
Neil Conway said:
In PL/PgSQL, END LOOP is used to terminate loop blocks, and END IF
is used to terminate IF blocks. This is needlessly verbose: we could
simply accept END in both cases without syntactic ambiguity. I'd like
to make this change,
Hello
this patch allows optional using label with END and END LOOP. Ending label
has only informational value, but can enhance readability large block and
enhance likeness with Oracle.
mainLOOP
...
...
END LOOPmain;
Regards
Pavel Stehule
diff -c -r --new-file pgsql/doc/src/sgml/plpgsql.sgml
can
adapt gram.y plpgsql to psm
Regards
Pavel Stehule
---(end of broadcast)---
TIP 8: explain analyze is your friend
statements, with efectivity evaluation of expr, but parser is clean (in my
opinion).
what have to be rewriten?
Regards
Pavel Stehule
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 28 Jun 2005, Dave Cramer wrote:
One thing bytecode would allow us to do is to write a debugger with
break points etc.
We can write debugger with breakpoints without bytecode. Every stmt rec
can have flag if has breakpoints. No problem. I don't see any advance of
bytecode. Maybe,
What do you think you need for enhanced protocol ?
What I need? Some like synchronous elog(NOTICE,''), which can return some
user's interaction, if it's possible. I didn't find how I do it with
current set of messages. But my knowleadges of protocol are minimal.
Pavel
On Tue, 28 Jun 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
What do you think you need for enhanced protocol ?
What I need? Some like synchronous elog(NOTICE,''), which can return some
user's interaction, if it's possible. I didn't find how I do it with
current set
in protocol3 files will
be minimal. I wont to do prototype.
Pavel
Dave
On 28-Jun-05, at 10:36 AM, Pavel Stehule wrote:
On Tue, 28 Jun 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
What do you think you need for enhanced protocol ?
What I need? Some like synchronous
I lean with you and Tom. While running it over the same libpq protocol
would be helpful in some ways, it would have a lot of drawbacks and
would really change the function of libpq. I think a separate debugging
protocol is in order.
One message? I can't belive :).
work on it (ANTLR
There's going to be a painful period later this year when Mysqueel
is able to claim that their production db has more ansi compatability
than PG (at least for triggers and stored procs).
MySQL5 is really comparable with Pg8, but Firebird2 or SQLlite3 too. But
from my perspective procedural
);
delete(x, key);
index is accessable only from PL/pgSQL. Associative arrays can be spec
PostgreSQL type or clasic arrays with hash index.
Comments, notes?
Regards
Pavel Stehule
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
NOTICE: 3486004
NOTICE: 419
NOTICE: 420
NOTICE: 421
NOTICE: 157207208
NOTICE: 16
Can you help me, what I do wrong?
Thank You
Pavel Stehule
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Wed, 29 Jun 2005, Josh Berkus wrote:
Pavel,
The concept is from Oracle 9i, but with some changes.
http://www.oracle-10g.de/oracle_10g_documentation/appdev.101/b10807/05_coll
s.htm#i35672
How does this match the SQL2003 spec?
I don't know. What I can read about it, it's
have procedure witch
operate over big arrays of numbers(prices) and I need save somewhere this
arrays if I don't wont to read them again and again. And if I have in
data identification by key, I everytime have to find key, and translate it
into number
Regards
Pavel Stehule
19:00:00+01 or ???
There are somewhere some rules about behavior timestamp with time zone?
Thenk You
Pavel Stehule
_
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/
---(end
Hello
I am testing comformity between PostgreSQL and Oracle. I found one
difference. Century started 1900-01-01 for Oracle and 1901-01-01 for
PostgreSQL. What value is good?
Best regards
Pavel Stehule
_
Chcete sdilet sve
Hello,
I did patch
http://archives.postgresql.org/pgsql-patches/2005-09/msg00050.php SQL/XML
public functions. Can somebody help me with documentation? Or can somebody
write doc..
Regards
Pavel Stehule
_
Najdete si svou lasku
possibility get identity of user without impact of change
of role? (default role?)
thank you
Pavel Stehule
_
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
---(end of broadcast
session_user for this.
--
it's exactly it what I want.
Thank You
Pavel Stehule
_
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
---(end of broadcast)---
TIP 9
Hello
I found relative good thesis about job scheduling
http://hristov.com/master_thesis_final.pdf
it's implementation j.s. for mysql5. It's can be usefull for somebody
best regards
Pavel Stehule
_
Citite se osamele? Poznejte
)); = ((1,2,3))
Can I get inner tupdesc without lookup_rowtype_tupdesc?
Thank you very much
Pavel Stehule
_
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/
---(end of broadcast
isHash? So, hash array can be in line
array-null array-hash array
or flag for nor regular array (sparse array), not type unique arrays (array
can contains different types)
Regards
Pavel Stehule
_
Citite se osamele? Poznejte nekoho
)
Regards
Pavel Stehule
_
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
steps (example):
generate view, select from view. This is difference between procedures and
functions. Function have to have exactly defined interface. Procedures
can't.
3. easy porting from databases which support this style.
sorry for my wrong english.
best regards
Pavel Stehule
What do you mean? There are already 10 levels for elog, including five
levels of DEBUG. How many more do you want?
sometimes I need show only some text. Now I get stack info.
lighter elog ~ sending text, not. proc, stack info.
2. multi result sets. This is necessery for support
Consider:
create function a(anyrecord) returns anyrecord;
create function b(int4) returns anyrecord;
select a(b(2));
for my task I need little different form :-(
create function a(..) returns setof tables
but SQL2003 needs type table, and this can be solution
for my task I need little different form :-(
create function a(..) returns setof tables
but SQL2003 needs type table, and this can be solution
You want a function return entire tables at a time? Why bother when you
can just return rows and signal when the next table starts?
what is
in code. I think,
this need bigger changes and support next class of stored objects.
best regards
Pavel Stehule
_
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz
Hello
DB2, MySQL and MsSQL has shared group of function (date, time, strings). You
can do it a bit complex - use variable which direct behavior, but there
isn't bigger differences, I hope. Please (for start), use mycode, orafunc
from pgfoundry.
Regards
Pavel Stehule
From: Christopher
When we're having an alias discussion, I'd really like to see NVL in
postgres. Not because of porting from oracle as much as just spelling that
without the reference manual is completely impossible.
Best regards,
Marcus
You can found NVL in orafunc on pgfoundry.
Regards
Pavel Stehule
Regards
Pavel Stehule
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
, int) RETURNS int AS '
DECLARE a integer; b integer;
BEGIN a := $1; b := $2;
WHILE a b LOOP
IF a b THEN a := a - b; ELSE b := b - a; END IF;
END LOOP;
RETURN a;
END; ' LANGUAGE plpgsql;
Regards
Pavel Stehule
---(end of broadcast)---
TIP 1
and what can be impacts
on speed for my aplication. Iam not sure if I understand well.
Pavel Stehule
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
and some basic arithmetic operations.
On Thu, 13 Jan 2005, Michael Fuhr wrote:
On Thu, Jan 13, 2005 at 05:05:00PM -0500, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
And?
(ie, what test case are you talking about?)
This test is function for searching max factor
Hello,
with IMMUTABLE or STABLE function is only 7% slowly. It can be usefull add
into documentation so default flag is immutable, but if its not necessary
its recommended IMMUTABLE or STABLE flag.
Regards
Pavel Stehule
---(end of broadcast
EXECUTE command. But all is inpossible now.
Can you help me other possibilities?
Thank you
Pavel Stehule
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Pavel Stehule [EMAIL PROTECTED] writes:
Can you help me other possibilities?
Create the temp table only once per connection (you can use ON COMMIT
DELETE ROWS instead of ON COMMIT DROP to clean it out). Then you won't
need to use EXECUTE.
I am not sure so it's possible. I use persistent
FROM. It's not true for small temp
tables. On my computer TRUNCATE needs 100ms and DELETE 8ms. It's general
or any exception?
Thank You
Pavel Stehule
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
hello,
I tested you patch, and it's good work. I would all methods in PostgreSQL.
I found query which kill backand
WITH t AS (
SELECT 0::int AS i
UNION ALL SELECT i + 1 FROM t WHERE i 100)
SELECT * FROM t;
Regards
Pavel Stehule
---(end of broadcast
support all syntax H.Q. Is more easy created
question via Oracle syntax, and processing is faster (maybe better
optimalisation now), than ANSI WITH syntax. Can You add support for
clausule VALUE?
Pavel Stehule
---(end of broadcast)---
TIP 2: you can
Hello,
It's no possible now. But I prepared small patch which implemented
variables sqlcode and sqlerrm for plpgsql. I can send it tomorrow.
regards
Pavel Stehule
On Sat, 5 Mar 2005, Ali Baba wrote:
Hi ,
I am looking for the way to get the error code
corresponding to the exception
trap_exceptions
-
(1 row)
DROP FUNCTION
Regards,
Pavel Stehule
--
-- Test of built variables SQLERRM and SQLCODE
--
create or replace function trap_exceptions() returns void as $_$
begin
begin
raise exception 'first exception';
exception when others then
raise
I think we discussed this last year and decided that it would be a bad
idea to use those names because Oracle's use of them is not exactly
compatible with our error codes and messages. SQLCODE in particular is
not compatible at all --- it's an integer in Oracle, isn't it?
There is more
-structures.html#PLPGSQL-ERROR-TRAPPING
But in this time is inpossible get details about exception.
Regards
Pavel Stehule
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
command for variables
DECLARE b integer;
SELECT fce(10, b);
fce
---
t
SELECT b;
b
--
10
This is (I think) more standard behavior.
Regards
Pavel Stehule
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
];
IF NOT FOUND THEN
RAISE EXCEPTION '..';
END IF;
END LOOP;
RETURN NEW;
END; $$ LANGUAGE plpgsql;
CREATE TRIGGER foo BEFORE INSERT OR UPDATE ON ...
FOR EACH ROW EXECUTE PROCEDURE check_();
Regards
Pavel Stehule
---(end of broadcast
of constant contains equals values. Is possible remove it?
explain analyze select count(*) from foo
where v in (11,11,11,12)
Regards
Pavel Stehule
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 26 Apr 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
I tested bitmap scan and maybe I didnt find good examples, but with bitmap
scan is slower than hashjoin. Only when I use non otiptimized SELECT bps
was little bit faster. All my SELECTs are equal.
Bitmap
for 2PC, hiearch queries, and ...
PostgreSQL isn't only sw for me, it's more like idol :-)
Best Regards,
Pavel Stehule
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
Pavel Stehule
Regres test:
create function innerfx() returns integer as $$
declare my_excpt exception = 'U0001';
begin -- using msgtext as one param of exception
raise exception my_excpt '%', CURRENT_TIMESTAMP;
return 1;
end $$ language plpgsql;
psql:regres.sql:6: ERROR: Invalid class
, but
via last discussion I have opinion so Oracle compatibility isn't main
objective PL/pgSQL. There is some less/bigger diferencess: SQLSTATE,
EXCEPTION from my last proposal, atd.
What do you think about it?
Regards
Pavel Stehule
---(end of broadcast
On Thu, 16 Jun 2005, Josh Berkus wrote:
Pavel,
o User can specify SQLSTATE only from class 'U1'
o Default values for SQLSTATE usr excpt are from class 'U0'
o Every exception's variable has unique SQLSTATE
o User's exception or system's exception can be raised only with
level
On Thu, 16 Jun 2005, Josh Berkus wrote:
Pavel,
Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL
has statement GOTO. I don't need GOTO statement, but 'continue' can be
very usefull for me. I have to do some ugly trick now. With little change,
we can enhance stmt
On Thu, 16 Jun 2005, Tom Lane wrote:
Pavel Stehule [EMAIL PROTECTED] writes:
BEGIN
CONTINUE WHEN i = 10;
RAISE NOTICE '---1---';
END;
I find that really ugly and confusing. If we add a CONTINUE it's only
sensible to allow it inside a loop --- otherwise it's just
Well, yes, but I don't think we should break compatibility
arbitrarilly. I guess it could be argued that this is a missing feature
in PL/SQL and its Ada parent - implementing GOTO just to handle this
case seems unnecessary.
Yes. I din't use goto 5 years :-). Continue stmt is more
Hello
I did some test and I can see so DISTINCT works well on indexed columns, but
is slow on derived tables without indexes. If I use without distinct group
by I get much better times.
SELECT DISTINCT a, b FROM tab
SELECT a,b FROM tab GROUP BY a, b.
Can You Explain it.
Thank You
Pavel
Hello
I can't find any information of syntax for ANSI Conformance F262, F263. Has
somebody any information about this points: Extended CASE expression, comma
separated predicates in simple case expression
Thank You
Pavel Stehule
Pavel Stehule [EMAIL PROTECTED] writes:
I can't find any information of syntax for ANSI Conformance F262, F263.
Has
somebody any information about this points: Extended CASE expression,
comma
separated predicates in simple case expression
There are no such feature IDs listed in either
FOR _r IN SELECT generate_series AS x, generateseries + 1 AS y FROM
generate_series(1,4)LOOP
_rc := _rc + 1; ROW(_x,_y) := _r;
RETURN NEXT;
END LOOP;
RETURN;
END; $$ LANGUAGE plpgsql;
any comments?
Regards
Pavel Stehule
2)'
Can we save current behave (with small modification) with other operator,
like *
(1,1) * (1,2) = true
(1,2) * (2,1) is NULL
(2,3) * (1,2) = false
it's usefull for multicriterial optimalisation
Regards
Pavel Stehule
Huh? The only current behavior with other operators is failure:
you didn't understand me. I know so operator * isn't supported now.
I prefere SQL spec behave too. But what I wont:
a * b ~ ai = bi and one ai bi = true ; if one ai bi = NULL; else
false
but this behave is from some views
temp functions.
Regards
Pavel Stehule
_
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello,
it depend on your possibilities. Simply, use PL/Perl or PL/sh.
Regards
Pavel Stehule
or use PgSendMail
http://sourceforge.net/project/showfiles.php?group_id=35804
Hi there,
How can i send mail form postgresql.
any suggestion.
thanx regards
aftab
---(end
Hello,
Propably not. But You can use this patch
http://gorda.di.uminho.pt/community/pgsqlhooks/
regards
Pavel Stehule
HEY!!!
Are You going to implement some system triggers like in ORACLE i.e. on
login trigger
??
--
Best regards
LaroG
---(end of broadcast
?
best regards
Pavel Stehule
_
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
---(end of broadcast)---
TIP 6: explain analyze is your friend
: (pg_authid.oid = outer.relowner)
- Materialize (cost=1.05..1.10 rows=5 width=68) (actual
time=0.007..0.032 rows=5 loops=5)
- Seq Scan on pg_namespace n (cost=0.00..1.05 rows=5
width=68) (actual time=0.008..0.028 rows=5 loops=1$ Total runtime: 1.294 ms
Regards
Pavel Stehule
depend only on their arguments and never on any
outside influence. ... And your function is vollatile = you can't to do
expression index.
Regards
Pavel Stehule
_
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http
Andrej Ricnik-Bay wrote:
Has anyone here seen this one before? Do the values
appear realistic?
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Some of the particularly bad test results for PostgreSQL may be related
to using the default memory configuration and never having run ANALYZE.
don't want to
have two versions of source code.
Thank you
Pavel Stehule
_
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz/
---(end of broadcast
Hello
There isn't possibility change opclass for generated UNIQUE indexes. I found
syntax for CREATE TABLE command USING INDEX TABLESPACE ..., This form can be
enhanced to
USING INDEX [TABLESPACE ..] [OPCLASS ..]
What do you think about it?
Regards
Pavel Stehule
unique index. But it's redundant. This problem is
related to using nonC locale.
Regards
Pavel Stehule
_
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
---(end of broadcast
I seem to recall someone proposing extending the syntax of the UNIQUE
constraints themselves, but there really isn't enough use-case to
justify it AFAICS. Especially not when you can always use CREATE
UNIQUE
INDEX.
I can always use second unique index. But it's redundant. This problem
type PRIMARY KEY | UNIQUE [USING INDEX [TABLESPACE ...] [OPERATOR
CLASS opclass]
CREATE CONSTRAINT name
PRIMARY KEY | UNIQUE '(' colname opt_class,
I don't think so this need big patch.
What do you think?
Regards, nice a day
Pavel Stehule
Hello,
I want do sql wrap for woid plpgsql function. But void SQL function must not
finish SELECT cmd. I don't know any others command which I can use.
Can You help me?
Thank You
Pavel Stehule
_
Najdete si svou lasku a nove
From: Jaime Casanova [EMAIL PROTECTED]
To: Pavel Stehule [EMAIL PROTECTED]
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Function's final statement must not be a SELECT
Date: Sat, 11 Mar 2006 12:42:15 -0500
On 3/10/06, Pavel Stehule [EMAIL PROTECTED] wrote:
Hello,
I want do sql
packages too. plvdate is one from
widespread solutions for weakdays calculations.
I appreciate the comments
Regards
Pavel Stehule
_
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com.
http://www.msn.cz
Hello,
This patch is well, I hope. I didn't look on it half year. Contains: SQL/XML
support + doc by D.Fetter
http://candle.pha.pa.us/mhonarc/patches_hold/msg00134.html
regards
Pavel Stehule
_
Najdete si svou lasku a nove
/pgSQL knows three dynamic statements. All will be enhanced.
Some examples:
EXECUTE 'SELECT :name||:sp||:surname' USING 'Pavel',' ','Stehule';
EXECUTE e'SELECT \':name :surname' USING 'Pavel','Stehule';
EXECUTE 'SELECT * FROM :tabname' USING 'xb'::regclass;
EXECUTE 'SELECT * FROM :base:num USING
function. Whole
dbms_alert package is similar our LISTEN/NOTIFY. Difference is dbms_alert is
server side solution and L/N is client side. Is any chance so this
interface will be in 8.2?
Regards
Pavel Stehule
_
Dont just search
Pavel Stehule [EMAIL PROTECTED] writes:
Is possible make transaction commit trigger without patching code now?
You can get pretty close with a deferred trigger. I don't think
there's any way to have a guaranteed at commit trigger --- as soon
as (1) there are two of them and (2) one can get
Hello
I am working on general functions accessable from console too. I create
tempory tables from functions. Is necessary print notice about using serial
type? I think actually we don't need print it, becouse DROP TABLE use
dependencies.
Regards
Pavel Stehule
Refered triggers works well, better than I expected. It's not equal NOTIFY,
but it works.
Thank You
Pavel Stehule
CREATE OR REPLACE FUNCTION dbms_alert._defered_signal() RETURNS trigger AS
$$
BEGIN
PERFORM dbms_alert._signal(NEW.event, NEW.message);
DELETE FROM ora_alerts WHERE id=NEW.id
Hello
1.11) How can I learn SQL?
...
There is also a nice tutorial at
http://www.intermedia.net/support/sql/sqltut.shtm, at
http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM, and
at http://sqlcourse.com.
first link is broken, second moved
Regards
Pavel Stehule
David Fetter dir patch two days ago
Pavel
From: Bruce Momjian pgman@candle.pha.pa.us
To: Pavel Stehule [EMAIL PROTECTED]
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] please actualize FAQ, broken urls
Date: Thu, 13 Apr 2006 08:09:40 -0400 (EDT)
Pavel Stehule wrote:
Hello
1.11
Hello
yesterday I did one news notice on my orafunc page. But it isn't on main
page yet. Why? Can someboody explain mechanism of publishing messages on
pgfoundry?
Regards
Pavel Stehule
_
Citite se osamele? Poznejte nekoho
Hello,
please change url on http://www.postgresql.org/community/international from
postgresql.ok.cz to http://postgresql.interweb.cz I actualized content for
8.1 and migrated to wiki and new site. Older site exists still, but isn't
actualized.
Thank you
Pavel Stehule
I think you mean updated not actualized right? In any case, I've
changed
the url in cvs, it should appear on the next site build.
yes, I am sorry. Thank you
btw, I hope that site is running postgresql as a backend :-)
Not yet :-(. I had big problems get good free hosting with php5. And
| no| no | no| no limit|
(1 row)
postgres=# WARNING: role x is not a member of role root
REVOKE ROLE
postgres=#
what is wrong?
Regards
Pavel Stehule
p.s. root is postgresql superuser
_
Chcete sdilet sve obrazky a hudbu s prateli? http
Hello
I am stupid. 1) I don't call function.
I am sorry
Regards
Pavel Stehule
_
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
---(end of broadcast)---
TIP 2
on f1 (cost=0.00..187.00 rows=1
width=4)
- Index Scan using xxx on f2 (cost=0.00..4319.77 rows=14
width=4)
(5 rows)
PostgreSQL 8.1, Linux
Regards
Pavel Stehule
_
Citite se osamele? Poznejte nekoho vyjmecneho diky
Can we seen an EXPLAIN ANALYZE output to see where the miscalculation
lies. Is it underestimating the cost of the index scan, or
overestimating the cost of the hash join.
postgres= explain analyze select count(*) from f1 join f2 on pk=fk;
These are all minor abberations though, on the whole the estimates are
pretty good. Perhaps you need to tweak the values of random_page_cost
and similar variables.
Thank You, It's general problem or only mine? I have 100% standard current
PC.
Pavel
These are all minor abberations though, on the whole the estimates
are
pretty good. Perhaps you need to tweak the values of random_page_cost
and similar variables.
Thank You, It's general problem or only mine? I have 100%
standard current PC.
The default random_page_cost assumes some
with '{}'.
What is coorect style?
Thank You
Pavel Stehule
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
On Mon, 1 Sep 2003, Bruce Momjian wrote:
Pavel Stehule wrote:
Hello
I have function
CREATE FUNCTION foo(date, date, INTEGER[]) RETURNS INTEGER
Array and array's functions works fine, but I need call this function
with empty array. I can't use array constructor for empty
1 - 100 of 5108 matches
Mail list logo
