Stefan Krompass wrote:
>
Does PostgreSQL offer information
on the additional workload (execution costs) caused by a query? In case
it does not: Does anybody have an idea how I get an estimate for the
execution costs before executing a query?
I cant add to you question, but two nightly thoughts:
i
Hi,
I'd like to implement a system to prevent a PostgreSQL database from
being overloaded by delaying queries when the database is already highly
loaded. I.e. the the sum of the execution costs of queries currently in
the database is already near a certain threshold and executing the
"next" qu
Check it out here:
http://www.amsoftwaredesign.com/
This release adds built in SSH tunnel support right from the server
registration dialog along with the ability to
execute a database dump from the GUI.(restore coming soon).
This release also properly exports text fields with CRLF in them (strip
> Tatsuo,
>
> I'm excited that pgpool is working for us now. We plan to start using it in
> the near future on our production applications (hundreds of thousands of DB
> transactions per day). I have just a couple follow-up questions:
>
> 1. When we use pgpool, should we still use a databas
Hi Costin
I am very experienced with MS-SQL and have had very basic training on Oracle
and both of these raise an exception as well. I would suggest that a RDBMS
that automatically converts to null is way off the standards.
Craig
- Original Message -
From: "Costin Manda" <[EMAIL PROTEC
On Sat, Apr 16, 2005 at 10:15:55AM +0300, Costin Manda wrote:
>
> In other SQL programs a division by zero is solved by transforming the
> result to NULL.
The SQL standards state that "If the value of a divisor is zero,
then an exception condition is raised: data exception -- division
by zero."
Poul MÃller Hansen wrote:
I'm using Postgresql version 7.4.7 and jdbc driver version
pg74.215.jdbc3.jar.
Do you have a clue on what's going on ?
No, I don't. Do you have any more information? What is your code doing
when it fails? Just issuing a reg
From: "Alex" <[EMAIL PROTECTED]>
- How can i select only the newest record for each ProdId ?
100| 2005-04-01
200| 2005-04-01
DISTINCT ON was made for this and on the similar tables I have performs
rather more efficiently than using a subquery.
select distinct on (ProdId) ProdId , LastUpda
In other SQL programs a division by zero is solved by transforming the
result to NULL. How can I make postgres have the same behaviour without
using CASE ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
