On Mon, 04 Aug 2003 20:07:18 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
> Richard Welty <[EMAIL PROTECTED]> writes:
> > On Mon, 04 Aug 2003 18:07:49 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
> >> You don't have to. See CREATE CAST.
>
> > cool. although it does look like there's still a piece miss
On 4 Aug 2003, Jenny Zhang wrote:
> On Mon, 2003-08-04 at 06:33, Manfred Koizar wrote:
> > | effective_cache_size | 1000
> >
> > With 4GB of memory this is definitely too low and *can* (note that I
> > don't say *must*) lead the planner to wrong decisions.
> >
> I changed the default t
Thanks all for your feedback.
I think I should explain more about how to use this test kit.
The main purpose of putting the test kit on Scalability Test
Platform(STP) is that testers can run the workload against the database
with different parameters and Linux kernels to see performance
differen
Well, I don't see that = would be significantly faster than LIKE with a
no-wildcard string, so I don't see the value in having LIKE detect
non-whildcard strings.
---
Joseph Shraibman wrote:
> I notice in 7.3.3 the planner ca
Richard Huxton wrote:
On Monday 04 August 2003 04:29, Joseph Shraibman wrote:
Hmm. I didn't work for me. I'll try and figure this out.
Tom Lane wrote:
Joseph Shraibman <[EMAIL PROTECTED]> writes:
I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards
and is in reality an '='.
On Mon, 4 Aug 2003, Joe Conway wrote:
> scott.marlowe wrote:
> >>10.Fix license
> >
> > Looking at the license for PHP found here:
> >
> > http://www.php.net/license/3_0.txt
> >
> > it would seem to be pretty much an apache style license that doesn't allow
> > you to relicense it without permi
scott.marlowe wrote:
10.Fix license
Looking at the license for PHP found here:
http://www.php.net/license/3_0.txt
it would seem to be pretty much an apache style license that doesn't allow
you to relicense it without permission. but it looks BSD compatible.
The issue was that plPHP as posted
On Mon, 4 Aug 2003, Joe Conway wrote:
> Robert Treat wrote:
> > On Fri, 2003-08-01 at 21:08, Ron Johnson wrote:
> >>Is there a possibility of getting this in v7.5?
> >
> > Heres the things I think would have to happen to put this in 7.5
> >
> > 1) Resolve license issues (not bsd licensed)
> > 2)
"=?iso-8859-1?Q?Freddy_Menj=EDvar_M.?=" <[EMAIL PROTECTED]> writes:
> is there any way to get user's
> functions and procedures
> code from postgresql system catalog.
Sure, just look at pg_proc.prosrc for your function.
regards, tom lane
---(end of
On Sat, 2 Aug 2003, Vernon Smith wrote:
>
> We usually use another table for a multi-valued field. Is possible
> having a single multi-valued field table for all tables in the same
> heredity, other than having a multi-valued table for every single
> tables in the heredity?
The SQL 3 standard
Oh, not sure. I hope someone makes them soon after we go beta so people
can do testing.
---
Ivar wrote:
>
> I mean cygwin binaries, it hard to compile it.
>
> I want to get latest version with cywing.
>
> "Bruce Momjian"
is there any way to get user's
functions and procedures
code from postgresql system
catalog.
if a create a function something
like
CREATE OR REPLACE FUNCTION
myfunction()
RETURNS INTEGER
AS'
BEGIN
my
code ;
END;
' LANGUAGE
'plpgsql';
--
Any chance that PHP in safe mode meets our requirements for a trusted
language? It would be nice to have both php and phpu as two different
choices.
On Fri, 1 Aug 2003, Joshua D. Drake wrote:
> Hello,
>
> As a recent flurry of activity has commenced within Command Prompt we
> have released
Robert Treat wrote:
On Fri, 2003-08-01 at 21:08, Ron Johnson wrote:
Is there a possibility of getting this in v7.5?
Heres the things I think would have to happen to put this in 7.5
1) Resolve license issues (not bsd licensed)
2) Integrate it into the postgresql build system so it can work on all
p
On Fri, 1 Aug 2003, MT wrote:
> Hi,
>
> I'm using Postgresql to store customer and product information. Since
> this is a French language database, some of the names include commas.
> Information entered into this database is via html forms and php
> scripts.
> When I search the database with
I mean cygwin binaries, it hard to compile it.
I want to get latest version with cywing.
"Bruce Momjian" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> No, you have to use cygwin under 7.3.3. Win32 is delayed for 7.5, and
> 7.4 isn't even in beta yet.
>
> --
No, you have to use cygwin under 7.3.3. Win32 is delayed for 7.5, and
7.4 isn't even in beta yet.
---
Ivar wrote:
> Hi,
>
> Is there any place to get 7.4 win binaries ?
>
>
>
>
> ---(end of broa
On Fri, 1 Aug 2003, Roger Hand wrote:
> We are moving an application from Oracle 8i to Postgres and I've run
> into a problem attempting to duplicate a feature we currently use.
>
> In Oracle you can divide a table into partitions. We use this feature
> to break up the data by month. Each mont
On Fri, 2003-08-01 at 21:08, Ron Johnson wrote:
> On Fri, 2003-08-01 at 19:06, Joshua D. Drake wrote:
> > Hello,
> >
> > As a recent flurry of activity has commenced within Command Prompt we
> > have released
> > upon this rather unround earth, plPHP. Yes it is trigger safe, yes you
> > can wr
Javascript does suck, but I have a captive audience. They have to have it turned on
or nothing happens when you click the submit button. If nothing happens when you
click the submit button, you don't get paid
=8^O
>>> Lincoln Yeoh <[EMAIL PROTECTED]> 08/02/03 02:32AM >>>
If it's double-click s
Did you think about cluster on index ?
[EMAIL PROTECTED] wrote:
I am looking at ways to speed up queries, the most common way by for
queries to be constrianed is by date range. I have indexed the date
column. Queries are still slower than i would like.
Would there be any performance increase f
You could create an index on the function date(), which strips the time
information.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2003 14:01
> To: PgSQL General ML
> Subject: Re: [GENERAL] Monthly table partitioning for fast purges?
>
>
> I
I am looking at ways to speed up queries, the most common way by for
queries to be constrianed is by date range. I have indexed the date
column. Queries are still slower than i would like.
Would there be any performance increase for these types of queries if
the tables were split by month as de
Dear all
I was waiting for this type of product but will plPHP turn to be like LXP
also does it support all the PHP4 syntax
Regards,
V Kashyap
- Original Message -
From: "Francisco J Reyes" <[EMAIL PROTECTED]>
To: "Joshua D. Drake" <[EMAIL PROTECTED]>
Cc: "Gavin M. Roy" <[EMAIL PROTECT
On Monday 04 August 2003 04:29, Joseph Shraibman wrote:
> Hmm. I didn't work for me. I'll try and figure this out.
>
> Tom Lane wrote:
> > Joseph Shraibman <[EMAIL PROTECTED]> writes:
> >>I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards
> >>and is in reality an '='. Is this
Hi,
Is there any place to get 7.4 win binaries ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
Yes, my company Elma Ingénierie Informatique do that in France, Paris.
About the French market of PostgreSQL ... is really small for the moment but
whe are doing our best to make it growing :o) ...
Regards,
Le Samedi 2 Août 2003 13:55, Francois Suter a écrit :
> Hi All,
>
> Someone asked me via
27 matches
Mail list logo
