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
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
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 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
"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
> 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,
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
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
[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
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
>
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 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
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
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,
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;
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
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
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
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
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_
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)---
"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
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
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
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 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
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
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
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
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
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
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
> > > 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
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
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
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
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
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
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...
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
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:
> 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
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
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
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
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
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
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
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, 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
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
>> 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
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
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
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
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
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
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
> >
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, 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
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
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
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
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]
> -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
>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
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-
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
68 matches
Mail list logo
