information together with text data,
however it is referring to keeping it together when processing it,
not when storing the text.
Regards,
Stephen Denne.
--
At the Datamail Group we value teamwork, respect, achievement, client focus,
and courage.
This email with any attachments is confidential
variations on this kind of daemon can be used to perform testing,
configuring it to work well, go slow, pause, not respond, disconnect, or fail
in particular ways, emulating disk full, etc.
Regards,
Stephen Denne.
--
At the Datamail Group we value teamwork, respect, achievement, client focus
.
Regards,
Stephen Denne.
At the Datamail Group we value teamwork, respect, achievement, client focus,
and courage.
This email with any attachments is confidential and may be subject to legal
privilege.
If it is not intended for you please advise by replying immediately, destroy it
and do
: if you rollback,
GD and SD stay the same, and when you issue a query, you can
assume the
state of SD and GD is random (due to previous queries) unless you
initialize them to a known value.
Using txid_current() as a key should alleviate that.
Regards,
Stephen Denne.
Disclaimer
when to clear it.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise by
reply
Tom Lane wrote
Stephen Denne [EMAIL PROTECTED] writes:
From: Tom Lane [mailto:[EMAIL PROTECTED]
As for 2) and 3), can't you look into the pg_settings view?
pg_settings view doesn't contain custom variables created
on the fly,
Really? [ pokes around ... ] Hm, you're right, because
Tom Lane wrote
Transaction commit is an exceedingly subtle and carefully structured
thing. Throwing random user-defined code into it ain't gonna happen.
Deferred constraint triggers currently run random user-defined code. This'll do
me.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail
is private static data. The global dictionary GD is public data,
available to all Python functions within a session. Use with care.
Does session == transaction or connection?
I don't understand the difference between SD and GD, private and public. Where
are the context boundaries?
Regards,
Stephen
(There is a possible performance bug mentioned at the end of the email, the
rest is further discussion regarding materialised views)
I wrote
Pavan Deolasee wrote
On Thu, Mar 20, 2008 at 3:24 AM, Stephen Denne
[EMAIL PROTECTED] wrote:
Pavan also refers to deferred triggers, which
presume would
appear in pg_settings.
Updating existing variables is much quicker, over 10 updates per second.
Regards,
Stephen Denne.
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 16/04/2008 1:55 p.m.
Stephen Denne [EMAIL PROTECTED] writes:
The custom
would have solved my problem.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise
Pavan Deolasee wrote
On Thu, Mar 20, 2008 at 3:24 AM, Stephen Denne
[EMAIL PROTECTED] wrote:
Pavan also refers to deferred triggers, which has got me
thinking about another possible solution:
Instead of inserting a delta row, that will be updated a
lot of times, create
for some reason?
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise by
reply
(Sorry for the repeat email Tom, I forgot the cc's)
Tom Lane wrote:
Stephen Denne [EMAIL PROTECTED] writes:
I initially thought that what you meant by having
transactions enter delta entries was that I have a trigger
that would create a row each time it was called, writing how
many
Tom Lane wrote
Stephen Denne [EMAIL PROTECTED] writes:
What I was asking about with those questions, is if a
single row is inserted in transaction A, and updated 1000
times still within transaction A, then transaction A
commits... does a single row version get written, or 1001,
1000
as the lock would not be required
till late in the game, and not held for long?
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal
arithmetic
mean is equal to what I calculated the geometric mean to be.
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege
changing the algorithm that determines how many, and which pages to
analyze, perhaps so that it is adaptive to the results of the analysis as it
progresses? That doesn't sound easy.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
for the planner.
It wouldn't solve my problem though, which is frequent over-estimation of rows
when restricting by this field with values not known at plan time.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage
of the arithmetic mean.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise
),'No Operation Completed') as LastFinshedOp
regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please
creating any indexes on wooper.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise
include predicates of the form [indexed text expression] like ABC%)
Stephen Denne
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege
of any
old 1000 returned in order)
If A is a circular structure, you would have to know where it started, and
include this info in the dump/restore (or lose A's correlation).
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage
both v8.2 and v8.3rc1 at once, and I think it is the
second started that is missing the process descriptions.
Regards,
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential
document_file AS df SET document_type_id =
d.document_type_id FROM document AS d WHERE d.id = document_id;
to
UPDATE ONLY document_file AS df SET document_type_id =
(SELECT d.document_type_id FROM document AS d WHERE d.id = document_id);
Which is several orders of magnitude faster for me.
Stephen
estimate larger than the first estimate?
Stephen Denne.
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please
.
PostgreSQL is started as a service.
Stephen Denne
Disclaimer:
At the Datamail Group we value team commitment, respect, achievement, customer
focus, and courage. This email with any attachments is confidential and may be
subject to legal privilege. If it is not intended for you please advise by
reply
28 matches
Mail list logo