Mike Mascari <[EMAIL PROTECTED]> writes:
But just as a quick notice to those upgrading from 7.3 to 7.4 with
fully
normalized databases requiring > 11 joins, the GEQO setting can be a
killer...
Uh ... dare I ask whether you think it's too high? Or too low?
Just a data point: With a fresh 7.4 and
Mike Mascari <[EMAIL PROTECTED]> writes:
> But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
> normalized databases requiring > 11 joins, the GEQO setting can be a
> killer...
Uh ... dare I ask whether you think it's too high? Or too low?
regards,
I know Tom would like a definitive and thorough testing to determine the
proper GEQO threshold limit , and that is the right thing to do, of course.
But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
normalized databases requiring > 11 joins, the GEQO setting can be a
kill
I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make && make install and all was well.
I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I have several, very specific needs:
1) having now done
Chris Ochs wrote:
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because th
David Helgason wrote:
I'm already using 'real' GUIDs, which in my case means that the database
never generates them (since I don't have a generate_real_guid() function
in the database (and don't need to).
Neither GUID project on gborg (mentioned in another thread) seem to be
Mac OSX compatible,
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes:
> I was trying to create a sql function today (see below) using
> postgresql 7.3.3. I don't see how to get around this error, anyone
> have any suggestions?
> tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
> ...
> tocr'# c
http://www.commandprompt.com/community/
I'd appreciate if you mention somewhere OpenFTS utilization, so people
could recognize it. But I'm not insisting ;)
Full intent to do so... want to get it finished up first. :)
Sincerely,
Joshua Drake
On Fri, 16 Jan 2004, Joshua D. Drake wrote:
> Hello,
>
> Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
> documentation
> all searchable using OpenFTS and Tsearch2. You can take a look at:
>
> http://www.commandprompt.com/community/
I'd appreciate if you mention somewhere O
Matthew T. O'Connor wrote:
I was trying to create a sql function today (see below) using
postgresql 7.3.3. I don't see how to get around this error, anyone
have any suggestions?
Thanks much,
Matthew
tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
tocr-# RETURNS void AS
I was trying to create a sql function today (see below) using
postgresql 7.3.3. I don't see how to get around this error, anyone
have any suggestions?
Thanks much,
Matthew
tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar)
tocr-# RETURNS void AS
tocr-# '
tocr'# begin;
toc
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because those things can
alw
Hello,
Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL
documentation
all searchable using OpenFTS and Tsearch2. You can take a look at:
http://www.commandprompt.com/community/
Sincerely,
Joshua Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
On 16. jan 2004, at 12:18, David Garamond wrote:
David Helgason wrote:
I'm switching right away. The notation doesn't really do anything for
me, but that's fine. I've been using bit(128), but always suspected
that of being unoptimal (for no particular reason).
I think bit(128) is quite efficient
Nigel J. Andrews wrote:
On Fri, 16 Jan 2004, Jeff Bowden wrote:
So maybe this is a packaging issue. On Debian when I install postgres
it is necessary to do root shit in order to enable non-priveledged users
to create and destroy databases. My understanding has alwasy been that
these operat
What's the best way to ease development of plpgsql.
My largest issues with plpgsql pertain to the quoting of course.
Bill McMilleon
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, 16 Jan 2004, Jeff Bowden wrote:
> Tom Lane wrote:
>
> >Jeff Bowden <[EMAIL PROTECTED]> writes:
> >
> >
> >>Still, the main problem I, and I suspect others, would like to solve is
> >>installation/configuration. For my app I don't want the user to have to
> >>understand anything about
Along similar lines - have generally obtained better server performance
(and stability) from most Linux distros after replacing their supplied
kernel with one from kernel.org .
regards
Mark
Josh Berkus wrote:
Folks,
While debugging a wireless card, I came across this interesting bit:
http://
Folks,
While debugging a wireless card, I came across this interesting bit:
http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html
What it indicates is that by default SuSE 9.0 plays with the timeslice values
for the Linux kernel in order to provide a "smoother" user experience. In
my
OK boys, i've made a mistake by using the term "register". What i meant is
"record".
Could you please tell me if there's a limit in the amount of records that
the database can handle?
Thanks... Ruby
Martin: why do you say i meant tuple?
From: Martin Marques <[EMAIL PROTECTED]>
To: Doug McNaught
Tom,
Actually, I've never had a corrupted firebird database. There were
two bugs in an older version of InterBase that produced income for me.
The first was a failure to realize that a file had just gone over 4Gb
and therefore the word holding the offset had rolled over and the system
had b
Richard Huxton wrote:
On Thursday 15 January 2004 15:02, Bill Moran wrote:
I'm having a little trouble understanding how to do something. I assume
I'm just missing it in the documentation, so a pointer to relevent docs
would be as welcome as a direct answer.
I have a project in which I'll need to
--- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article
> <[EMAIL PROTECTED]>,
> "LitelWang" <[EMAIL PROTECTED]> writes:
>
> > I need this function :
> > CheckDate('2002-02-29') return false
> > CheckDate('2002-02-28') return true
>
> Why would you want to do that? Just try to insert
> '2002-02
Seems that none of them is same as MS GUID.
> Linux-only?
Seems so, damn currently use windows for developement.
"David Garamond" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Chris Gamache wrote:
> > You want
> > http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.p
Chris Gamache wrote:
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
Another alternative:
http://gborg.postgresql.org/project/pguuid/projdisplay.php
(How do the two compare, aside from uniqueidentifier seeming to be
Linux-only? Should I use one of the above for pro
On Fri, 2004-01-16 at 04:41, Richard Huxton wrote:
> On Friday 16 January 2004 04:50, LitelWang wrote:
> > I need catch the error when my insert clause violate the
> > primary key .How to write in the server function ?
> > Thanks for any advice .
>
> You can't (at the moment). An error terminates
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
CG
--- Ivar <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to generate GUID("f741d0ce-351c-4c8d-9625-d23765ca7f45") values in
> postgre ?
>
>
>
>
> ---(end of broadcast)-
Hi,
How to generate GUID("f741d0ce-351c-4c8d-9625-d23765ca7f45") values in
postgre ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Friday 16 January 2004 10:35, Paul Ganainm wrote:
> Hi all,
>
>
> I would be interested in playing around with the beta version for the
> Windows native port - where can I get it?
I don't think there is a beta yet. There is a status page here
http://momjian.postgresql.org/main/writings/pgsql/wi
Hi,
Oh ok..my conf didnt show the log_statement option. Thanks, should be helpful some other time.
Regards,
Ritu
On Fri, 2004-01-16 at 17:39, Shridhar Daithankar wrote:
On Friday 16 January 2004 16:43, Ritu Khetan wrote:
> Hi,
>
> No such option found. There is the "S" switch for silent mod
On Friday 16 January 2004 16:43, Ritu Khetan wrote:
> Hi,
>
> No such option found. There is the "S" switch for silent mode which is
> off by default anyways.
In my local installation I have following relevant options.
#log_connections = false
#log_duration = false
#log_pid = false
#log_statemen
Hi all,
I discovered the problem, AutoCommit is off by default and I did not commit the transaction..it works fine now.
Thanks,
Ritu
On Fri, 2004-01-16 at 16:56, Csaba Nagy wrote:
Have you read the documentation about configuring the postgres server:
http://www.postgresql.org/docs/view.ph
Have you read the documentation about configuring the postgres server:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime.html
Actually there is a very fine suite of documentation on that site.
HTH,
Csaba.
On Fri, 2004-01-16 at 12:13, Ritu Khetan wrote:
> Hi,
>
> No such opt
David Helgason wrote:
I'm switching right away. The notation doesn't really do anything for
me, but that's fine. I've been using bit(128), but always suspected that
of being unoptimal (for no particular reason).
I think bit(128) is quite efficient (OCTET_LENGTH() function shows me
it's using 16
Hi,
No such option found. There is the "S" switch for silent mode which is off by default anyways.
Regards,
Ritu
On Fri, 2004-01-16 at 16:34, Shridhar Daithankar wrote:
On Friday 16 January 2004 16:03, Ritu Khetan wrote:
> Hello Richard,
>
>How do I switch on statement logging...?
>
>
On Friday 16 January 2004 16:03, Ritu Khetan wrote:
> Hello Richard,
>
>How do I switch on statement logging...?
>
>postmaster --help doesn't talk of any such switch.
Check options in postgresql.conf.
Shridhar
---(end of broadcast)---
TI
Hello Richard,
How do I switch on statement logging...?
postmaster --help doesn't talk of any such switch.
Regards,
Ritu
On Fri, 2004-01-16 at 15:25, Richard Huxton wrote:
On Friday 16 January 2004 09:18, Ritu Khetan wrote:
> Hello all,
>
> I am trying to use DBI in perl to conne
Hi all,
I would be interested in playing around with the beta version for the
Windows native port - where can I get it?
TIA.
Paul...
--
plinehan y_a_h_o_o and d_o_t com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.
"XML avoids the fundamental question
On Jan 16, 2004, at 6:46 PM, Richard Huxton wrote:
On Friday 16 January 2004 05:14, Michael Glaesemann wrote:
That said, I haven't been successful finding which functions accept
tinterval as arguments, though this is probably because I don't know
how to handle where clauses involving arrays, or pe
On Friday 16 January 2004 09:18, Ritu Khetan wrote:
> Hello all,
>
> I am trying to use DBI in perl to connect to my Postgres database. I
> am able to connect to the database but when any further queries are made
> using the database handle, I see the following message in my error logs
> and no
On Friday 16 January 2004 05:14, Michael Glaesemann wrote:
>
> That said, I haven't been successful finding which functions accept
> tinterval as arguments, though this is probably because I don't know
> how to handle where clauses involving arrays, or perhaps its because
> the pg_proc.proargtypes
41 matches
Mail list logo
