>Have you tried this with Oracle or similar commercial database?
I have timed COPY/LOAD times for Postgresql/Mysql/Oracle/Db2 -
the rough comparison is :
Db2 and Mysql fastest (Db2 slightly faster)
Oracle approx twice as slow as Db2
Postgresql about 3.5-4 times slower than Db2
However Postgre
This is small README fix for contrib/intarray. Thank you.
--
Teodor Sigaev
[EMAIL PROTECTED]
intarray_patch.gz
Description: application/gzip
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
>
> What is the reason for maintaining separate rscale and dscale values in
> numeric variables?
>
> I am finding that this arrangement leads to some odd results, for
> example this:
>
> regression=# select (exp(ln(2.0)) - 2.0);
> ?column?
> -
> -0.000
Mario Weilguni <[EMAIL PROTECTED]> writes:
> So timespan is no longer supported I guess, but reltime will work as
> well. Is there a compatibility or migration section in the
> documentation that might help users to handle this?
The release notes are still in a pretty crude state, but they do men
Mario Weilguni <[EMAIL PROTECTED]> writes:
> Ok, I checked this again. Up until 7.2, it was possible to compare an empty string
>to a number, and it worked::
> e.g.: select * from mytable where int4id=''
> worked fine, but delivered no result.
No, that was not what it did: in reality, the '' wa
Jan Wieck <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> What is the reason for maintaining separate rscale and dscale values in
>> numeric variables?
> You need to carry around a decent number of digits when you divide
> already. Exposing them in a manner that numericcol(15,2) / 3.0 all of
> t
>> But oracle accepts this one:
>> SQL> select * from re_eintraege where id='';
>> no rows selected
>> because oracle treats the empty string as NULL
>
>Oracle does that for string data, but it doesn't do it for numerics
>does it? In any case, that behavior is surely non-compliant with
>the SQL s
At 09:42 AM 2/10/2002 +1000, Philip Warner wrote:
>Yes, and do the peripheral stuff to support old archives etc.
Does silence mean people agree? Does it also mean someone is doing this
(eg. whoever did the off_t support)? Or does it mean somebody else needs to
do it?
---
On Wed, 2 Oct 2002, Mario Weilguni wrote:
> >> But oracle accepts this one:
> >> SQL> select * from re_eintraege where id='';
> >> no rows selected
> >> because oracle treats the empty string as NULL
> >
> >Oracle does that for string data, but it doesn't do it for numerics
> >does it? In any ca
Philip Warner <[EMAIL PROTECTED]> writes:
> At 09:42 AM 2/10/2002 +1000, Philip Warner wrote:
>> Yes, and do the peripheral stuff to support old archives etc.
> Does silence mean people agree? Does it also mean someone is doing this
> (eg. whoever did the off_t support)? Or does it mean somebody
Tom Lane wrote:
>
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> What is the reason for maintaining separate rscale and dscale values in
> >> numeric variables?
>
> > You need to carry around a decent number of digits when you divide
> > already. Exposing them in a manner that
This document:
http://developer.postgresql.org/docs/postgres/release-7-2-3.html
mentions a release date of 2002-10-01 for version 7.2.3.
It isn't on the main website, tough, is it?
Regards,
Michael
---(end of broadcast)---
TIP 2: you can get off
On Wed, 2 Oct 2002, Michael Paesold wrote:
> This document:
> http://developer.postgresql.org/docs/postgres/release-7-2-3.html
>
> mentions a release date of 2002-10-01 for version 7.2.3.
>
> It isn't on the main website, tough, is it?
The documentation on the developers website is not necessari
It's just a cosmetic change, fixes the help screen. Should be applied in
/contrib/vacuumlo
Regards,
Mario Weilguni
--- ../vacuumlo.c Thu Sep 5 23:19:13 2002
+++ vacuumlo.c Wed Oct 2 18:03:29 2002
@@ -383,7 +383,6 @@
fprintf(stdout, " -U username\tUsername to connect a
Have you looked at transform_null_equals in the postgresql.conf file to
see if turning that on makes this work like oracle?
On Wed, 2 Oct 2002, Mario Weilguni wrote:
> Ok, I checked this again. Up until 7.2, it was possible to compare an empty string
>to a number, and it worked::
> e.g.: selec
This small patch adds a Makefile for /contrib/reindexdb/ and renames the README to
README.reindexdb.
Regards,
Mario Weilguni
diff -Nur postgresql-7.3b2.orig/contrib/reindexdb/Makefile postgresql-7.3b2/contrib/reindexdb/Makefile
--- postgresql-7.3b2.orig/contrib/reindexdb/Makefile 1970
You all know this FAQ: "Why does Postgres not use my index?" Half of
the time this problem can easily be solved by casting a literal to the
type of the respective column; this is not my topic here.
In many other cases it turns out that the planner over-estimates the
cost of an index scan. Some
On Wed, 2 Oct 2002, Manfred Koizar wrote:
> As nobody knows how each of these proposals performs in real life
> under different conditions, I suggest to leave the current
> implementation in, add all three algorithms, and supply a GUC variable
> to select a cost function.
I'd certainly be willin
All,
I'd like to help work on some 7.4 features, however, since you've not seen
my name before, I'm obviously new to the list and the org.
I really like working on speed optimizations and rewrites. I have 15 years
experience with C++-based systems and databases, and have worked on
commercial da
I'm not a developer, but I know this item on the todo list has been a
magor pain in my side for quite a while:
# Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS
[http://momjian.postgresql.org/cgi-bin/pgtodo?exists]
Any time I've attempted to use this feature, the query cost is in th
"Curtis Faith" <[EMAIL PROTECTED]> writes:
> I'd like to help work on some 7.4 features, however, since you've
> not seen my name before, I'm obviously new to the list and the org.
[...]
> Any suggestions for where to start?
Well, I'd suggest working on what you find interesting -- there is
roo
Manfred Koizar <[EMAIL PROTECTED]> writes:
> AFAICS (part of) the real problem is in costsize.c:cost_index() where
> IO_cost is calculated from min_IO_cost, pages_fetched,
> random_page_cost, and indexCorrelation. The current implementation
> uses indexCorrelation^2 to interpolate between min_IO_
Justin Clift <[EMAIL PROTECTED]> wrote:
> Hi Michael,
>
> Michael Paesold wrote:
>
> > Hi Justin,
> >
> > I am from Austria, and I would like to help. I could provide a German
> > translation. The Babelfish's translation is really funny. Machine
> > translation is readable, but it is no advocac
Looks good from my end, Peter, I pulled the same docs that I pulled for
v7.2.2, which I hope is okay?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
Justin wrote:
> Hi Michael,
> Michael Paesold wrote:
>
> > Hi Justin,
> > I am from Austria, and I would like to help. I could provide a German
> > translation. The Babelfish's translation is really funny. Machine
> > translation is readable, but it is no advocacy. ;-) I do not really nead an
>
[EMAIL PROTECTED] wrote:
> > Cool. Could you deal with an OpenOffice Calc or M$ Excel file having
> > the lines of English text in one column, and doing the German
> > translation into a second column?
>
> Isn't this, um, the sort of thing you might want to put into, um, a, um,
> database?
Sur
Forgot to cc' the list.
-Original Message-
From: Curtis Faith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 10:59 PM
To: Tom Lane
Subject: RE: [HACKERS] Advice: Where could I be of help?
Tom,
Here are the things that I think look interesting:
1) Eliminate unchanged colu
> Based on past experience, from a bang-for-buck perspective, I'd probably do
> this in the numerical order. What do you think? I know what I like and can
> do but I don't really know enough about PostgreSQL's performance weaknesses
> yet.
>
> What are we getting killed on?
>
I'm not a developer,
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Looks good from my end, Peter, I pulled the same docs that I pulled for
> v7.2.2, which I hope is okay?
Sources look okay from here. Didn't look at the built-docs files.
regards, tom lane
---(end o
On Wednesday 02 October 2002 11:52 pm, Tom Lane wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > Looks good from my end, Peter, I pulled the same docs that I pulled for
> > v7.2.2, which I hope is okay?
> Sources look okay from here. Didn't look at the built-docs files.
Builds fine h
At 11:06 AM 2/10/2002 -0400, Tom Lane wrote:
>It needs to get done; AFAIK no one has stepped up to do it. Do you want
>to?
I'll have a look; my main concern at the moment is that off_t and size_t
are totally non-committal as to structure; in particular I can probably
safely assume that they ar
On Thursday 03 October 2002 12:29 am, Lamar Owen wrote:
> RPMs will be uploaded either tonight or tomorrow morning after I get to
> work; it will depend on how much upload bandwidth I can get out of this
> dialup. It appears to be running OK, so I may let it run.
After I get to work. Too ma
On Wed, 02 Oct 2002 18:48:49 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>I don't think it's really a good idea to expect users to pick among
>multiple cost functions
The idea is that PG is shipped with a default representing the best of
our knowledge and users are not encouraged to change it. Wh
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I would read the developers corner stuff, the developers FAQ, pick a
> > TODO item, and try a patch. It's that simple.
>
> Yup. I'd also suggest starting with something relatively small and
> localized (the nearby suggestion to fix
Justin,
what does world map with fuzzy points supposed to show ?
Oleg
On Wed, 2 Oct 2002, Justin Clift wrote:
> Hi all,
>
> Over the last few weeks we've put together a new "Advocacy and
> Marketing" website for PostgreSQL:
>
> http://advocacy.postgresql.org
>
> It's now ready for publi
Hello!
On Mon, 30 Sep 2002, Bruce Momjian wrote:
> It is not clear to me; is this its own transaction or a function call?
BTW.
As reported by my friend:
Oracle 8.1.7 (ver.9 behaves the same way):
--- cut ---
SQL> SET TRANSACTION READ WRITE;
Transaction set.
SQL> SELECT TO_CHAR(SYSDATE, 'DD-
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
> Sent: 01 October 2002 21:05
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [HACKERS] psqlODBC *nix Makefile (new 7.3 open item?)
>
>
> Dave Page writes:
>
> > > > majority of you!) k
Hi Oleg,
It's supposed to show roughly where everyone is.
Based mostly on Vince's map from the developer site, but this one is
really easy to update.
If you're not located on the map correctly (probably hard to tell, but
if you're wrong on Vince's map then you're wrong on this one) it can be
up
On Wed, 2 Oct 2002, Justin Clift wrote:
> Hi Oleg,
>
> It's supposed to show roughly where everyone is.
>
> Based mostly on Vince's map from the developer site, but this one is
> really easy to update.
>
> If you're not located on the map correctly (probably hard to tell, but
> if you're wrong on
On Wed, 2 Oct 2002, Vince Vielhaber wrote:
> On Wed, 2 Oct 2002, Justin Clift wrote:
>
> > Hi Oleg,
> >
> > It's supposed to show roughly where everyone is.
> >
> > Based mostly on Vince's map from the developer site, but this one is
> > really easy to update.
> >
> > If you're not located on the
Oleg Bartunov wrote:
> Coordinates seems ok (Moscow), I asked if map should present something
> more like old Bruce's map with photos. I'm using Mozilla and see just
> a picture of the world :-)
Heh Heh Heh
Nah, just went for the simple approach. :) Could have added them, but
didn't want to s
On Wed, 2 Oct 2002, Oleg Bartunov wrote:
> On Wed, 2 Oct 2002, Vince Vielhaber wrote:
>
> > On Wed, 2 Oct 2002, Justin Clift wrote:
> >
> > > Hi Oleg,
> > >
> > > It's supposed to show roughly where everyone is.
> > >
> > > Based mostly on Vince's map from the developer site, but this one is
> >
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Teodor Sigaev wrote:
> This is small README fi
Yury Bokhoncovich <[EMAIL PROTECTED]> writes:
> As reported by my friend:
> Oracle 8.1.7 (ver.9 behaves the same way):
> [ to_char(sysdate) advances in a transaction ]
Now I'm really confused; this directly contradicts the report of Oracle
8's behavior that we had earlier from Roland Roberts. Ca
On Wed, 2 Oct 2002, Vince Vielhaber wrote:
> On Wed, 2 Oct 2002, Oleg Bartunov wrote:
>
> > On Wed, 2 Oct 2002, Vince Vielhaber wrote:
> >
> > > On Wed, 2 Oct 2002, Justin Clift wrote:
> > >
> > > > Hi Oleg,
> > > >
> > > > It's supposed to show roughly where everyone is.
> > > >
> > > > Based mo
On Wed, 2 Oct 2002, Oleg Bartunov wrote:
> On Wed, 2 Oct 2002, Vince Vielhaber wrote:
>
> > On Wed, 2 Oct 2002, Oleg Bartunov wrote:
> >
> > > On Wed, 2 Oct 2002, Vince Vielhaber wrote:
> > >
> > > > On Wed, 2 Oct 2002, Justin Clift wrote:
> > > >
> > > > > Hi Oleg,
> > > > >
> > > > > It's suppo
Tom Lane wrote:
> Yury Bokhoncovich <[EMAIL PROTECTED]> writes:
>
>>As reported by my friend:
>>Oracle 8.1.7 (ver.9 behaves the same way):
>>[ to_char(sysdate) advances in a transaction ]
>
>
> Now I'm really confused; this directly contradicts the report of Oracle
> 8's behavior that we had ea
Just in case anyone enjoys these sorts of things :) It deals with the
whole .org TLD assignment ...
http://forum.icann.org/org-eval/gartner-report
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.po
Mike Mascari wrote:
> Tom Lane wrote:
> > Yury Bokhoncovich <[EMAIL PROTECTED]> writes:
> >
> >>As reported by my friend:
> >>Oracle 8.1.7 (ver.9 behaves the same way):
> >>[ to_char(sysdate) advances in a transaction ]
> >
> >
> > Now I'm really confused; this directly contradicts the report o
Bruce Momjian wrote:
> Mike Mascari wrote:
>>
>>Oracle isn't processing those statements interactively. SQL*Plus
>>is waiting on the "/" to send the PL/SQL block to the database.
>>I suspect its not going to take Oracle more than a second to
>>insert a row...
>
>
> Oh, I understand now. He
Mike Mascari wrote:
> Bruce Momjian wrote:
> > Mike Mascari wrote:
> >>
> >>Oracle isn't processing those statements interactively. SQL*Plus
> >>is waiting on the "/" to send the PL/SQL block to the database.
> >>I suspect its not going to take Oracle more than a second to
> >>insert a row...
Philip Warner wrote:
> At 09:42 AM 2/10/2002 +1000, Philip Warner wrote:
> >Yes, and do the peripheral stuff to support old archives etc.
>
> Does silence mean people agree? Does it also mean someone is doing this
> (eg. whoever did the off_t support)? Or does it mean somebody else needs to
> d
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Mario Weilguni wrote:
> It's just a cosmetic c
Bruce Momjian wrote:
>
> OK, two requests. First, would you create a _named_ PL/SQL function
> with those contents and try it again. Also, would you test
> CURRENT_TIMESTAMP too?
>
SQL> CREATE TABLE foo(a date);
Table created.
As a PROCEDURE:
SQL> CREATE PROCEDURE test
2 AS
3 BEGIN
> > > Attached is a patch to fix the mb linking problems on AIX. As a nice side effect
> > > it reduces the duplicate symbol warnings to linking libpq.so and libecpg.so
> > > (all shlibs that are not postmaster loadable modules).
> >
> > Can you explain the method behind your patch? Have you tr
Any news about new DBD::Pg ?
It's a stopper for many projects based on perl interface
to use 7.3.
Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow Uni
Mike Mascari <[EMAIL PROTECTED]> writes:
> SQL> CREATE PROCEDURE test
>2 AS
>3 BEGIN
>4 INSERT INTO foo SELECT SYSDATE FROM dual;
>5 dbms_lock.sleep(5);
>6 INSERT INTO foo SELECT SYSDATE FROM dual;
>7 END;
>8 /
> Procedure created.
> SQL> execute test;
> PL
I received this via personal email. I assume the author wants it
shared. It shows CURRENT_TIMESTAMP changing within a function!
---
Steve Hulcher wrote:
> Oracle 9i.
>
> Hope this is helpful
>
>
> --SQL RUN
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Mario Weilguni wrote:
> This small patch adds
I would read the developers corner stuff, the developers FAQ, pick a
TODO item, and try a patch. It's that simple. Feel free to contact me
for specific advice. I am on chat at:
AIM bmomjian
ICQ 151255111
Yahoo bmomjian
MSN [EMAIL PROTECTED
Mike Mascari <[EMAIL PROTECTED]> wrote:
> I can't test the use of CURRENT_TIMESTAMP because I have Oracle
> 8, not 9.
What about NOW()? It should be available in Oracle 8? Is it the same as
SYSDATE?
Regards,
Michael Paesold
---(end of broadcast)---
Michael Paesold wrote:
> What about NOW()? It should be available in Oracle 8? Is it the same as
> SYSDATE?
>
Unless I'm missing something, NOW() neither works in Oracle 8
nor appears in the Oracle 9i online documentation:
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I would read the developers corner stuff, the developers FAQ, pick a
> TODO item, and try a patch. It's that simple.
Yup. I'd also suggest starting with something relatively small and
localized (the nearby suggestion to fix IN/EXISTS, for example, is
Mike Mascari <[EMAIL PROTECTED]> wrote:
> Michael Paesold wrote:
>
> > What about NOW()? It should be available in Oracle 8? Is it the same as
> > SYSDATE?
> >
>
> Unless I'm missing something, NOW() neither works in Oracle 8
> nor appears in the Oracle 9i online documentation:
>
>
http://downloa
Ok, finally had time to narrow this down.
Here's the simplified script that will reproduce this (this sequence
reroduces on my system using 7.3b2):
\echo BEGIN tst.sql
create table pp
( x integer
, i text
);
create view p as
select * from pp where i is null;
Justin Clift <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> Have just put together a prototype page to show off the multi-lingual
> capabilities that the Advocacy sites' infrastructure has:
>
> http://advocacy.postgresql.org/?lang=de
>
> The text was translated to german via Altavista's Babelfish,
Hi Michael,
Michael Paesold wrote:
> Hi Justin,
>
> I am from Austria, and I would like to help. I could provide a German
> translation. The Babelfish's translation is really funny. Machine
> translation is readable, but it is no advocacy. ;-) I do not really nead an
> interface, but just tell
Hi everyone,
Have just put together a prototype page to show off the multi-lingual
capabilities that the Advocacy sites' infrastructure has:
http://advocacy.postgresql.org/?lang=de
The text was translated to german via Altavista's Babelfish, so it's
probably only about 80% accurate, but it conv
68 matches
Mail list logo
