Hi all, I added a new variable-length field to the pg_class catalog, but
I did something wrong, and I can't tell what else I'd need to change. (I
know about how extending pg_class is bad and all, but it seems to be the
simplest solution to my problem right now, and I'd just like to get it
On Sun, 2004-12-19 at 04:04, Bruce Momjian wrote:
BTom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
You mean all empty/zero rows can be removed? Can we guarantee that on
commit we can clean up the bitmap? If not the idea doesn't work.
For whatever data structure we use, we
This weekend, I decided to teach Ethereal to decode the FE/BE protocol
properly: until now, it could only extract likely-looking strings from
the conversation, which I found woefully inadequate for debugging. I'm
hoping the result will be useful to other people too:
Andrew Dunstan schrieb:
Reini Urban wrote:
What I also miss is the successful output of the make test step.
Something like the Log in Details, just behind an additional request.
Config =
Log
Link to Details
Without those details one doesn't trust the presented result.
He might think that only
On Sun, Dec 19, 2004 at 01:56:02AM -0800, overbored wrote:
Hi all, I added a new variable-length field to the pg_class catalog, but
I did something wrong, and I can't tell what else I'd need to change. (I
know about how extending pg_class is bad and all, but it seems to be the
simplest
Hi all,
I'm tring to understand a part of code of postgres and I saw a line like
this:
bms_is_subset(restrictinfo-right_relids,outerrelids) (createplan.c,
function get_switched_clauses() at ~/src/backend/optimizer/plan).
I don't understand the data types of the the arguments
of that function. The
Hi all,
after several weeks away I downloaded today the 8.0rc1 and I
tested it with our application.
I'm having a bounce of errors because IMMUTABLE and STABLE
attributes for some of my functions. Let me explain with an example,
what I do is ( plpgsql )
my_id_user = sp_id_user( a_login );
IF
On Sun, Dec 19, 2004 at 05:39:43PM +0200, Martha Chronopoulou wrote:
Hi,
A bitmap set can represent any set of nonnegative integers, although it
is mainly intented for sets where the maximum value is not large, say
at most a few hundred.
Clearly this can only come from the contorted mind of
On Sun, Dec 19, 2004 at 09:52:01AM +, Simon Riggs wrote:
Simon,
In similar circumstances, DB2 uses these techniques:
- when locktable X % full, then escalate locks to full table locks: both
locktable memory and threshold% are instance parameters
This is not useful at all, because the
Gaetano Mendola [EMAIL PROTECTED] writes:
I'm having a bounce of errors because IMMUTABLE and STABLE
attributes for some of my functions. Let me explain with an example,
Hmm. This particular example is a bug in exec_eval_simple_expr() ...
if we're going to bypass SPI then we'd better do the
Alvaro Herrera [EMAIL PROTECTED] writes:
On Sun, Dec 19, 2004 at 05:39:43PM +0200, Martha Chronopoulou wrote:
I'm tring to understand a part of code of postgres and I saw a line like
this:
bms_is_subset(restrictinfo-right_relids,outerrelids) (createplan.c,
function get_switched_clauses() at
Alvaro Herrera [EMAIL PROTECTED] writes:
On Sun, Dec 19, 2004 at 09:52:01AM +, Simon Riggs wrote:
- use a lock mode called Cursor Stability that locks only those rows
currently being examined by a cursor, those maintaining the lock usage
of a cursor at a constant level as the cursor moves.
On Sun, 19 Dec 2004, Alvaro Herrera wrote:
On Sun, Dec 19, 2004 at 09:52:01AM +, Simon Riggs wrote:
Simon,
In similar circumstances, DB2 uses these techniques:
- when locktable X % full, then escalate locks to full table locks: both
locktable memory and threshold% are instance parameters
This
Heikki Linnakangas [EMAIL PROTECTED] writes:
On Sun, 19 Dec 2004, Alvaro Herrera wrote:
This is not useful at all, because the objective of this exercise is to
downgrade locks, from exclusive row locking (SELECT ... FOR UPDATE) to
shared row locking.
Actually it might help in some scenarios.
On Sun, 19 Dec 2004, Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
On Sun, 19 Dec 2004, Alvaro Herrera wrote:
This is not useful at all, because the objective of this exercise is to
downgrade locks, from exclusive row locking (SELECT ... FOR UPDATE) to
shared row locking.
Actually
I wrote:
[ concerning a discussion about Kerberos' com_err.h being in
/usr/include/et/ on some systems ]
Actually, I'm wondering why we directly include com_err.h at all. At
least in the version of krb5.h I have here, that file is included by
krb5.h; so both backend/libpq/auth.c and
On Sun, 2004-12-19 at 18:31, Alvaro Herrera wrote:
Thanks for your ideas anyway. And keep having them!
No problem. Just giving some info on what works and doesn't work in
other implementations.
--
Best Regards, Simon Riggs
---(end of
Tom Lane said:
I wrote:
[ concerning a discussion about Kerberos' com_err.h being in
/usr/include/et/ on some systems ]
Actually, I'm wondering why we directly include com_err.h at all. At
least in the version of krb5.h I have here, that file is included by
krb5.h; so both
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane said:
Accordingly, I think we should just avoid the whole problem of exactly
where com_err.h lives by removing the #includes for it as well as the
configure test for it.
Works for me. I'm not sure why the reasoning only applies to 8.0 - is it
Mark Kirkwood wrote:
It occurs to me that cranking up the number of transactions (say
1000-10) and seeing if said regression persists would be
interesting. This would give the smoothing effect of the bgwriter
(plus the ARC) a better chance to shine.
I ran a few of these over the weekend -
Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
On Sun, 19 Dec 2004, Alvaro Herrera wrote:
This is not useful at all, because the objective of this exercise is to
downgrade locks, from exclusive row locking (SELECT ... FOR UPDATE) to
shared row locking.
Actually it might
On Sun, Dec 19, 2004 at 11:35:02PM +0200, Heikki Linnakangas wrote:
On Sun, 19 Dec 2004, Tom Lane wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
On Sun, 19 Dec 2004, Alvaro Herrera wrote:
This is not useful at all, because the objective of this exercise is to
downgrade locks, from
hello
what is the value of yyin variable for postgresql
parser.
It might be the default(stdout) when postgresql is
in interactive backend mode...but what happens when
clients from different workstations sends their
queries?
__
Do you Yahoo!?
On Sat, 18 Dec 2004, Bruce Momjian wrote:
BTom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
You mean all empty/zero rows can be removed? Can we guarantee that on
commit we can clean up the bitmap? If not the idea doesn't work.
For whatever data structure we use, we may reset
24 matches
Mail list logo