Hi,
On Sun, 13 Aug 2006, Jorge Godoy wrote:
Christian Kratzer <[EMAIL PROTECTED]> writes:
I would at least try to assign multiple such numbers in batches to mimize
contention on the row you store the counter in.
What do you mean here? How would you guarantee that on of the re
es
to mimize contention on the row you store the counter in.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(
as it allows you to easily drop specific partitions.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(end of bro
Hi,
On Wed, 17 May 2006, Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Christian Kratzer
Sent: 17 May 2006 15:14
To: Tino Wildenhain
Cc: Christopher Browne; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
I only use
stian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(end of broadcast)---
TIP 1: if posting/reading th
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
a composite
of (now(), GetTopTransctionId()) to assume batch uniqueness.
Or use a touple of (now(), pg_backend_pid()) for this kind of stuff.
pg_backend_pid() should sufficiently disambiguate now() to make obove
touple unique.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECT
Hi,
On Sun, 23 Oct 2005, Christian Kratzer wrote:
Hi,
On Sat, 22 Oct 2005, Steve V wrote:
On 10/22/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
[snipp]
I'm using this for an auditing script, and want to use the txn ID to
indicate an atomic set of changes(the pg txn ID is mappe
o identify stuff done in the same transaction.
now() will be frozen during the transaction and session_backend_pid()
disambuguates this for cases where two transaction could have the
same start time.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
_base;
rollback;
---
any ideas how we would get
select * from test_base where partitioner between a and b
to just look in the correct partition and not doing a full sweep over
the other partitions
$row = pg_fetch_assoc($result);
return strval($row["id"]);
} else {
return 0;
}
}
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbH
kern.ipc.semmnu=120
these will be set on boot.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(end of broadcast
mething else like 0 to represent undefined
values Horrible ...
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
---(end of broadcast)---
TIP 8: explain analyze is your friend
t. Could someone helps me
please?
how about using NULL ? You say the correct value is still undefined so
NULL should be right on the spot.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 8
Hi,
j
On Wed, 23 Jun 2004, Martijn van Oosterhout wrote:
On Wed, Jun 23, 2004 at 12:49:19PM +0200, Christian Kratzer wrote:
Hi,
I have a stored procedure run periodically that assign accounting records
to their respective customers based on username and other criteria.
It also does all kinds of
ql;
---snipp---
the problem is that start_time and stop_time are identical.
Is there any way I can get plpgsql to reevaluate now at the end
of the batch ???
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.
16 matches
Mail list logo