1) I'm in favor of autotuning anything possible.
2) In addition to turning group_commit on and off, what about also
adjusting the commit delay, based on statistics of recent commits? It
might require a slightly larger sample set (maybe the last 100 commits),
but it seems it would provide more flexi
I'm glad to see a types view. A while ago I was trying to figure out a
way to query the pg_* views to see if a particular function existed. I
quickly got stuck trying to figure out how to properly handle the
arguments array. The solution Tom gave in this case was just to
hard-code the OID for the t
--- "Joshua D. Drake" <[EMAIL PROTECTED]>
escribió:
> Jaime Casanova wrote:
>
> >>TIP 9: the planner will ignore your desire to
> choose
> >>an index scan if your
> >> joining column's datatypes do not match
> >>
> >>
> >>
> >
> >Hi,
> >
> >sorry for using this list, but is not time to
John Hansen wrote:
> Folks,
>
> Asking this again as it seems my question got lost, or at least
> unanswered.
>
> Why not just contact IBM, and get their opinion?
>
> As I said before, we might just get a promise of a full licence for
> if/when the patent is granted.
I doubt we can get a licens
On Sat, 22 Jan 2005, Arnold.Zhu wrote:
> >Yeah, you just make your function return 'SETOF record' and specify the
> >types when you do the select:
> >
> >select * from func() as (a int, b text);
> >
>
> This is not a good idea when I use C# to program, I want to Fill the resultset
> directly i
Hello, Christopher Kings-Lynne
>Yeah, you just make your function return 'SETOF record' and specify the
>types when you do the select:
>
>select * from func() as (a int, b text);
>
>Chris
>
This is not a good idea when I use C# to program, I want to Fill the resultset
directly into Dataset, th
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> John Hansen wrote:
>
> >Folks,
> >
> >Asking this again as it seems my question got lost, or at least unanswered.
> >
> >Why not just contact IBM, and get their opinion?
> >
> 1. We don't have attorneys to do so.
> 2. The PostgreSQL community is no
Currently, we have group commit functionality via GUC parameters
commit_delay
and commit_siblings
Group commit is either off or on. Since we do not have a log writer
daemon, there is no way to know whether that is optimal. There is
research to show that setting group commit on when it
Jonah H. Harris wrote:
We could still get their opinion.
I have a couple aquaintances at IBM that I can try to contact about
it. Rather than assume what IBM will do, why not just ask them? If
they don't respond, they don't respond. If they do respond, it's
better than us guessing.
Yes, it's
We could still get their opinion.
I have a couple aquaintances at IBM that I can try to contact about it.
Rather than assume what IBM will do, why not just ask them? If they
don't respond, they don't respond. If they do respond, it's better than
us guessing.
Yes, it's only going to matter if
Hello!
One of least liked by me features of PostgreSQL is a need to specify
LC_CTYPE an LC_COLLATE at initdb time. Especially if you intend to
put into DB texts in
different languages (say, Polish, French, German and Russian) and use
functions like lower() or ORDER BY these texts. :)
I guess the
Jaime Casanova wrote:
TIP 9: the planner will ignore your desire to choose
an index scan if your
joining column's datatypes do not match
Hi,
sorry for using this list, but is not time to change
this TIP for something more suitable to the new PG8
capabilities?
Is this still not the case
John Hansen wrote:
Folks,
Asking this again as it seems my question got lost, or at least unanswered.
Why not just contact IBM, and get their opinion?
1. We don't have attorneys to do so.
2. The PostgreSQL community is not a legal entity it can license to.
3. It would take weeks if not months to
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>
Hi,
sorry for using this list, but is not time to change
this TIP for something more suitable to the new PG8
capabilities?
regards,
Jaime Casanova
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 21 Jan 2005, Josh Berkus wrote:
OK, is anyone opposed to this idea? I would register a pgfoundry
project (name suggestions? "translations"?), give most established
translators commit access, and move the statistics pages there.
BTW, there i
Folks,
Asking this again as it seems my question got lost, or at least unanswered.
Why not just contact IBM, and get their opinion?
As I said before, we might just get a promise of a full licence for if/when the
patent is granted.
... John
---(end of broadcast)
On Fri, Jan 21, 2005 at 12:17:08PM -0800, Josh Berkus wrote:
> Folks,
>
> This is for 8.1, or for 8.2 if we have a no-initdb cycle for 8.1.
>
> I'm proposing to expand both the coverage and number of "system views". Our
> system views are an extremely useful way to get data about the system i
Peter, Euler, others:
> > OK, is anyone opposed to this idea? ÂI would register a pgfoundry
> > project (name suggestions? "translations"?), give most established
> > translators commit access, and move the statistics pages there.
BTW, there is already a "translators" mailing list. While I've b
On Fri, 21 Jan 2005, Joshua D. Drake wrote:
Marc G. Fournier wrote:
On Fri, 21 Jan 2005, Joshua D. Drake wrote:
Hello,
On a slightly different note in regards to the development
cycle. I am authoring a new book and it would be helpful
to know the approximate completion of the dev cycle.
If the dev
Marc G. Fournier wrote:
On Fri, 21 Jan 2005, Joshua D. Drake wrote:
Hello,
On a slightly different note in regards to the development
cycle. I am authoring a new book and it would be helpful
to know the approximate completion of the dev cycle.
If the dev cycle is going to be really short, are we ex
Folks,
This is for 8.1, or for 8.2 if we have a no-initdb cycle for 8.1.
I'm proposing to expand both the coverage and number of "system views". Our
system views are an extremely useful way to get data about the system if
you're not on PSQL. They are a better idea than using the underlying
On Fri, 21 Jan 2005, Joshua D. Drake wrote:
Hello,
On a slightly different note in regards to the development
cycle. I am authoring a new book and it would be helpful
to know the approximate completion of the dev cycle.
If the dev cycle is going to be really short, are we expecting
a more tradition
Hello,
On a slightly different note in regards to the development
cycle. I am authoring a new book and it would be helpful
to know the approximate completion of the dev cycle.
If the dev cycle is going to be really short, are we expecting
a more traditional 12-16 month 8.2?
J
--
Command Prompt, Inc
On Tue, 18 Jan 2005 23:05:57 +0100, Reinoud van Leeuwen
<[EMAIL PROTECTED]> wrote:
> > Contrary to popular misconception, virtually all countries
> > grant software patents. The problem is that people have
>
> Thanks to the new European Union member Poland, the Dutch plan to put the
> software pa
On Wed, 19 Jan 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
If the patch is ready to be committed early in the cycle, I'd say most
definitely ... just depends on how late in the cycle its ready ...
My recollection is that it's quite far from being complete. I had hoped
to s
Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Mon, 2005-01-17 at 18:43 -0500, Tom Lane wrote:
> >> I have already
> >> suggested to core that we should insist on 8.1 not requiring an initdb,
> >> so as to ensure that people will migrate up to it easily from 8.0.
>
> > So is it f
Hannu Krosing wrote:
> ?hel kenal p?eval (esmasp?ev, 17. jaanuar 2005, 21:45-0300), kirjutas
> Alvaro Herrera:
> > On Mon, Jan 17, 2005 at 07:31:48PM -0400, Marc G. Fournier wrote:
> >
> > > Just curious here, but are patents global? PostgreSQL is not US
> > > software,
> > > but it is run with
On Fri, 21 Jan 2005 02:31:40 +0200, Hannu Krosing <[EMAIL PROTECTED]> wrote:
>2) Another simple, but nondeterministic, hack would be using randomness,
>i.e.
>
> 2.1) select a random buffer in LR side half (or 30% or 60%) of
> for replacement.
>
> 2.2) dont last accessed pages to top of L
This problem annoys me, if I have more than several hundred function
which returns different result set, like contains foreign keys,
I have to create many type for function's return.
Can plpgsql returns result set according to what exactly fetched,
then take return type as references to store dat
Ühel kenal päeval (neljapäev, 20. jaanuar 2005, 23:17+1100), kirjutas
Neil Conway:
> Simon Riggs wrote:
> >>However, I think the ARC replacement should *not* be a fundamental
> >>change in behavior: the algorithm should still attempt to balance
> >>recency and frequency, to adjust dynamically to ch
Hello, pgsql-hackers
I create a table, a type and a function like below:
CREATE TABLE "User"
(
"Id" int4 NOT NULL DEFAULT nextval('public."User_Id_seq"'::text),
"Name" varchar(32) NOT NULL
);
CREATE TYPE "UserSet" AS
(
On Thu, 20 Jan 2005 14:08:20 +0100, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Peter Eisentraut wrote:
> > > Maybe we should have a pgfoundry project where all translations
> > > were kept, and from which the main CVS could be updated
> > > semi-automatically. Then we wouldn't have Peter checkin
32 matches
Mail list logo
