>>> On Tue, Dec 18, 2007 at 3:23 AM, in message
<[EMAIL PROTECTED]>, Heikki Linnakangas
<[EMAIL PROTECTED]> wrote:
> Robert Bernabe wrote:
>> In a nutshell it seems that MS SQL allows bad T-SQL code by optimizing and
>> ignoring redundant/useless from and where clauses in an update statement
>>
Robert Bernabe wrote:
In a nutshell it seems that MS SQL allows bad T-SQL code by optimizing and
ignoring redundant/useless from and where clauses in an update statement
whereas plpgsql will execute exactly what the code is asking it to do...
We had several update instances in the T-SQL code t
Robert Bernabe wrote:
> I'm happy (actually ecstatic) to report that Win2kPro + PG performance
> is slightly faster than Win2kPro + MSSQL/MSDE.
>
> Linux(FC7) + PG 8.x performance seems to be 3x faster than Win2KPro +
> MSSQL/MSDE for our stored functions.
>
> Thanks for all the help! Am a belie
Hi All,
Thanks for all the help here. Sorry for the late update but we've found our
problem and fixed it already. Prior to looking at the translated code more
intently, I wanted to make sure that our environmental settings were acceptable
and the various emails from members have confirmed t
On Thu, 2007-12-06 at 08:50 +, Dave Page wrote:
> EnterpriseDB Postgres is essentially a packaging and bundling project in
> which the aim is to provide consistent and easy to use installers for
> Windows, Mac and Linux that allow users to get started with Postgres,
> Slony, PostGIS, pgAdmin,
Mark Cave-Ayland wrote:
> BTW you mention both EnterpriseDB PostgreSQL 8.3 beta and just
> PostgreSQL 8.3 beta in the text above. Both of these are different -
> which one are you actually using?
No they're not. EnterpriseDB Postgres ships entirely standard binaries -
in fact, the Windows build us
On Wed, 2007-12-05 at 00:13 -0800, Robert Bernabe wrote:
> Hi All,
> I've been tasked to evaluate PG as a possible replacement of our
> MS SQL 2000 solution. Our solution is 100% stored procedure/function
> centric. It's a report generation system whose sole task is to produce
> text files fill
On Dec 5, 2007 2:13 AM, Robert Bernabe <[EMAIL PROTECTED]> wrote:
>
> Hi All,
> I've been tasked to evaluate PG as a possible replacement of our MS SQL
> 2000 solution. Our solution is 100% stored procedure/function centric. It's
> a report generation system whose sole task is to produce text f
On Dec 5, 2007 3:13 AM, Robert Bernabe <[EMAIL PROTECTED]> wrote:
> Would it also make sense to optimize (as far as possible) everything
> (including the code) for windows first? The target here would be a linux OS
> but since the discrepancy is so big...the unified Windows OS might be a good
> pla
In response to Robert Bernabe <[EMAIL PROTECTED]>:
> Hi All,
> I've been tasked to evaluate PG as a possible replacement of our
> MS SQL 2000 solution. Our solution is 100% stored procedure/function
> centric.
I've trimmed 99% of your email out, because it's not relevant to my
answer.
Fact i
On Dec 5, 2007 1:13 PM, Robert Bernabe <[EMAIL PROTECTED]> wrote:
> Anyways I'd like to break up this request/begging for help into two parts.
>
> 1) First would be settings of postgresql.conf. Did I do it correctly? The
> sample data is so smallI based my settings on the recommendations
> res
I don't know if this is true in this case, but transaction level can be
different, in mssql it is normally something like
TRANSACTION_READ_UNCOMMITTED
in postgres
TRANSACTION_READ_COMMITTED
and that makes huge difference in performance.
other thing can be the queries in procedures, if you use sa
Hi All,
I've been tasked to evaluate PG as a possible replacement of our MS SQL
2000 solution. Our solution is 100% stored procedure/function centric. It's a
report generation system whose sole task is to produce text files filled with
processed data that is post-processed by a secondary sys
13 matches
Mail list logo
