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 checking out and
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
(
Id
Ü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 changes in
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
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 LRU list
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 within the US ...
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 firm policy that
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
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 patents on
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,
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
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
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
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
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 been using
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 if
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
-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 is
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
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
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
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
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
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
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
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 not a legal entity it
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, this
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 into
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 license that
--- 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
change
this TIP for something
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
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
32 matches
Mail list logo