Hi Greg,
So I had a thought about how to soften the controversial hard cutoff of 100
for the use of the histogram selectivity. Instead of switching 100% one way or
the other between the two heuristics why not calculate both and combine them.
The larger the sample size from the histogram the
Magnus Hagander wrote:
It would also be better to be able to off-load it to more than one
person. For example, I would like to be able to get into the unapplied
patches list and remove the email about events on 8.3RC1. First of all,
it's not a patch, but it's listed under it. But more
Bruce Momjian wrote:
Bruce Momjian wrote:
Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I have added message-id's to both patches web sites. The message id
appears next to the author in the thread listing, and at the top of
the
message
Brendan Jurd wrote:
On Feb 13, 2008 10:45 AM, Bruce Momjian [EMAIL PROTECTED] wrote:
For the patches lists I need to take sometimes entire threads, sometimes
groups of comments, and store them in a format so people can review them
as a digest. And I want to allow comments on these items,
On Feb 13, 2008 10:45 AM, Bruce Momjian [EMAIL PROTECTED] wrote:
For the patches lists I need to take sometimes entire threads, sometimes
groups of comments, and store them in a format so people can review them
as a digest. And I want to allow comments on these items, and ideally
allow
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Suppose we were using a web-based discussion forum, rather than email.
That would be crazy, why would I suppose such a thing?
For the patches lists I need to take sometimes entire threads, sometimes
groups of comments, and
Bruce Momjian [EMAIL PROTECTED] writes:
Suppose we were using a web-based discussion forum, rather than email.
That would be crazy, why would I suppose such a thing?
For the patches lists I need to take sometimes entire threads, sometimes
groups of comments, and store them in a format so
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Just set down the branch so that movement can happen towards 8.4.0 ... let me
know if there are any problems ...
-
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED]
Given the improvements in 8.3 listed in the release notes:
- Improve efficiency of LIKE/ILIKE, especially for multi-byte character sets
like UTF-8 (Andrew, Itagaki Takahiro)
Does this still hold:
http://www.postgresql.org/docs/8.3/interactive/locale.html
The drawback of using locales other than
We have branced CVS for 8.4. The 8.3 CVS tag is REL8_3_STABLE.
I have started tracking our development status at the top of my
Postgres blog page.
--
Bruce Momjian [EMAIL PROTECTED]http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
For the patches lists I need to take sometimes entire threads, sometimes
groups of comments, and store them in a format so people can review them
as a digest.
Why do you need to do
Hi Alvaro-san.
Yes, However, It is not in good condition at the reason a message catalog still is not enough.
Then, I have tried these adjustments with the problem of a locale. Still, it is not much time.
But, My condition is not good so that I'm may be influenza. :-(
Regards,
Hiroshi Saito
From: Alvaro Herrera [EMAIL PROTECTED]
Dave Page wrote:
On Feb 12, 2008 4:44 PM, Alvaro Herrera [EMAIL PROTECTED] wrote:
What this really means is that locale support is completely broken in
the MSVC build, i.e. you cannot get localized strings at all (not just
to_char()). Is this correct?
Marc G. Fournier [EMAIL PROTECTED] writes:
Just set down the branch so that movement can happen towards 8.4.0 ... let me
know if there are any problems ...
Looks good from here --- I stamped HEAD as 8.4devel.
Let the games begin!
regards, tom lane
What this really means is that locale support is completely
broken in the MSVC build, i.e. you cannot get localized
strings at all (not just to_char()). Is this correct? If
so, this is a serious problem.
The way one could confirm this is by:
1. rename share/locale/de to
Bruce Momjian wrote:
Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I have added message-id's to both patches web sites. The message id
appears next to the author in the thread listing, and at the top of the
message page.
That's an
Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I have added message-id's to both patches web sites. The message id
appears next to the author in the thread listing, and at the top of the
message page.
That's an improvement, but it doesn't solve the
Alvaro Herrera wrote:
Gevik Babakhani wrote:
4. Locale names are different in MS Windows. I created a C app to test
gettext on Windows.
setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and
de_DE do not :(
SET LC_MESSAGES to '' has no effect because:
A. gettext
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I have added message-id's to both patches web sites. The message id
appears next to the author in the thread listing, and at the top of the
message page.
That's an improvement, but it doesn't solve the other fundamental
problem,
Joshua D. Drake wrote:
What the heck is a steam hammer? :P
http://en.wikipedia.org/wiki/Steam_hammer
The same people went on to invent the steam television ...
cheers
andrew
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
Stefan Kaltenbrunner wrote:
Stefan Kaltenbrunner wrote:
Tom Lane wrote:
[...]
Personally I'd be happier with an editable wiki page consisting of links
to the original messages in the mail list archives, plus free-format
annotations (such as status). This should be trivial to set up and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 11 Feb 2008 17:09:45 -0600
Decibel! [EMAIL PROTECTED] wrote:
On Feb 9, 2008, at 1:08 AM, Tom Lane wrote:
Let's not swat flies with steam hammers.
What the heck is a steam hammer? :P
http://en.wikipedia.org/wiki/Steam_hammer
Joshua
Bruce Momjian [EMAIL PROTECTED] writes:
I have added message-id's to both patches web sites. The message id
appears next to the author in the thread listing, and at the top of the
message page.
That's an improvement, but it doesn't solve the other fundamental
problem, which is the lack of any
On Feb 12, 2008 4:44 PM, Alvaro Herrera [EMAIL PROTECTED] wrote:
What this really means is that locale support is completely broken in
the MSVC build, i.e. you cannot get localized strings at all (not just
to_char()). Is this correct? If so, this is a serious problem.
Not judging by
Gevik Babakhani wrote:
4. Locale names are different in MS Windows. I created a C app to test
gettext on Windows.
setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and
de_DE do not :(
SET LC_MESSAGES to '' has no effect because:
A. gettext compiled/linked in
Andrew Dunstan [EMAIL PROTECTED] writes:
On Nov 24 2006 this was committed dor src/backend/utils/adt/formatting.c:
r 1.114: Fix to_char() locale handling to honor LC_TIME, not LC_MESSAGES.
A few hours later it was supposedly reverted: r 1.115: Revert (too late
in beta): Fix to_char() locale
Andrew Dunstan wrote:
Alvaro Herrera wrote:
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
What I can confirm is that lc_messages is supposed to work for to_char,
Hi
--Document.--
Table 9-22.
TM prefix translation mode (print localized day and month names based on
lc_messages)
--
http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png
But, Although Japanese is out of condition
Does the fundamental specification change?
Regards,
Hiroshi Saito
-
Folks,
I encountered a situation on Sunday night where the postmaster was in
a tight
loop. That's the conclusion we reached, but have no real proof. I
also have no
idea how to reproduce this situation. This post is just an FYI in
case it helps.
The laptop was running hot so I looked
Alvaro Herrera wrote:
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
What I can confirm is that lc_messages is supposed to work for to_char,
because it shows the localized output
Hiroshi Saito wrote:
Hi
--Document.--
Table 9-22.
TM prefix translation mode (print localized day and month names based on
lc_messages)
--
http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png
But, Although Japanese is out of condition
Does the fundamental specification change?
Humm,
Alvaro Herrera [EMAIL PROTECTED] writes:
I find it a bit worrying that the postmaster is calling that syscall at
all.
Yeah. Misguided thread-aware library perhaps?
Next time please try to get a stack trace.
regards, tom lane
---(end of
Dan Langille wrote:
Looking at ktrace output, I saw a lot of this:
1172 postgres CALL kse_release(0xbfbfd500)
1172 postgres RET kse_release -1 errno 22 Invalid argument
Humm, kse_release seems related to multithreading. Or so says
http://nixdoc.net/man-pages/FreeBSD/kse_release.2.html
I
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
What I can confirm is that lc_messages is supposed to work for to_char,
because it shows the localized output for me as I change lc_messages;
Right, I know that. But I didn't see you trying lc_time as
Andrew suggested.
Did that too, but no luck :(
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Well, that should be considered a bug, not a feature.
Perhaps it was fixed in 8.3.
This is 8.3 I am testing with.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Gevik Babakhani wrote:
Should that not be lc_time you are setting? lc_messages is
for, uh, messages.
No. The same thing works on 8.2.6
Well, that should be considered a bug, not a feature. Perhaps it was
fixed in 8.3.
--
Alvaro Herrera
Gevik Babakhani wrote:
Well, that should be considered a bug, not a feature.
Perhaps it was fixed in 8.3.
This is 8.3 I am testing with.
You are missing Alvaro's point. He is saying that the behaviour you
relied on in 8.2.6 was a bug, and possibly you can no longer rely on
Martijn van Oosterhout wrote:
On Tue, Feb 12, 2008 at 05:49:12AM -0500, Bruce Momjian wrote:
There is no reason I have to host the list here. I can _bounce_ emails
to any address. Is there a service we can use that allows emails to be
accepted and displayed on a web site and that allows
On Tue, Feb 12, 2008 at 05:49:12AM -0500, Bruce Momjian wrote:
There is no reason I have to host the list here. I can _bounce_ emails
to any address. Is there a service we can use that allows emails to be
accepted and displayed on a web site and that allows deletions and
comments, and has
Bruce Momjian [EMAIL PROTECTED] writes:
If we want to communicate via a web interface, I would still need a way
to collect specific messages (not always entire threads).
You're talking about collecting messages. Everyone else wants to collect
patches or proposed changes. There's not a
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
If we want to communicate via a web interface, I would still need a way
to collect specific messages (not always entire threads).
You're talking about collecting messages. Everyone else wants to collect
patches or proposed changes.
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
My test:
Gevik=#
Gevik=# show lc_messages ;
lc_messages
English_United States.1252
(1 row)
Gevik=#
Gevik=# set lc_messages TO
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
My test:
Gevik=#
Gevik=# set lc_messages TO 'de_DE.utf8';
SET
Gevik=# show lc_messages ;
lc_messages
-
de_DE.utf8
(1 row)
Should that not be lc_time you are setting? lc_messages is
for, uh, messages.
No. The same thing works on 8.2.6
---(end of broadcast)---
TIP 6: explain analyze is your friend
Gevik Babakhani wrote:
Well, that should be considered a bug, not a feature.
Perhaps it was fixed in 8.3.
This is 8.3 I am testing with.
Right, I know that. But I didn't see you trying lc_time as Andrew
suggested.
--
Alvaro Herrera
to_char's month/day name localization is implemented with
gettext() not strftime(), which is why it depends on
LC_MESSAGES not LC_TIME. I seem to recall that we didn't
like the side-effects of the patch you are mentioning, and so
it ended up being rejected outright.
Correct. I have been
Stephen Denne [EMAIL PROTECTED] writes:
i.e. Do I still have to either initdb --locale=C or explicitly use
text_pattern_ops?
yes, if you want an index to be used
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
48 matches
Mail list logo