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 more
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 im
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
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
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 m
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
"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
-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
+ I
"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.
>>
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
"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 share/loca
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.
> > >
>
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 do
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 com
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
>
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 post
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
-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
J
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
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? If so, this is a serious prob
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 Hiro
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/link
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() l
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 t
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
- Origin
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 ar
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 f
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 chang
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 broa
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
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 Herrerahttp://www.Com
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 th
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 deleti
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 one
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 chang
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 'de_
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)
Gevi
> 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 Herrerahttp://www.Comman
> 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
"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!
-
49 matches
Mail list logo
