I've run into this myself. Tom lane helped me out.
In my case, it was the fact that indexes don't release the space of
indexes of deleted rows. So, if you have a table that has a lot of
inserts/deletes, your indexes will grow incredibly fast.
The way to see what your biggest items are:
selec
turns 17.
That means that unless the results of process B depend in some way upon
the results of process A, there's no problem.
-Ken
--
Ken Corey CTO http://www.atomic-interactive.com 07720 440 731
---(end of broadcast)
VALUES (tempvar,$1, $2);
-- Everything has passed, return id as pk
RETURN tempvar;
END;
' LANGUAGE 'plpgsql';
WARNING: this is not guaranteed to be the correct syntax, I didn't
create the tables and the function to test it
nsert.
>
> -Josh Berkus
>
>
>
>
>
>
> __AGLIO DATABASE SOLUTIONS___
>Josh Berkus
> Complete information technology [EMAIL PROTECTED]
> and data management solutions (415) 565-7293
>
from that, but
that sounds like much busywork for the database.
It sounds easiest to me to just punt and number the rows as they are returned
in my calling application...
What's the best approach here?
--
Ken Corey, CTOAtomic Interactive, Ltd. [EMAIL PROTECTED]
---
;s the best approach here?
--
Ken Corey, CTOAtomic Interactive, Ltd. [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
My apologies to the lists...in trying to stop my own spam, I spammed you all.
This has now been fixed.
Again, sorry for any inconvenience.
-Ken
Hi All!
Are the BEGIN/END; seen in a typical PL/PGSQL function a transaction wrapper,
or do I need to add another BEGIN/END block?
Should I just put a 'rollback' in the function, or do I need to do something
special?
Thanks!
-Ken
Wow! Answering emails on a Sunday? Someone should be giving you an award or
something.
On Sunday 04 February 2001 8:13 pm, you wrote:
> Ken Corey <[EMAIL PROTECTED]> writes:
> > When the select at the bottom of this email is executed, I'm getting the
> > message:
In trying to use a plpgsql stored proc, I'm getting an error I don't
understand.
When the select at the bottom of this email is executed, I'm getting the
message:
ERROR: parser: parse error at or near "$1"
Any ideas?
--
Ken Corey, CTOAtomic Interactive, Lt
Frederic Metoz wrote:
> I am looking for the binary AND and OR ... SHIFT as well.
> Do they exist for postgresql ?
Depending on what you're doing...you might get away with using
mathematical operators to accomplish the above...
A right SHIFT would be dividing by 2. A left shift would be multipl
[NOTE: I'm a pgsql newbie myself. Take this reply with a large-ish
grain of salt!)
Shouldn't it be something straightforward like:
select a.a, a.b, a.c, ...
from a a,
b b
where a.x = b.x,
and a.y = b.y, ... (I'd watch out for too many clauses here...
12 matches
Mail list logo
