On Mon, Jun 28, 2010 at 9:09 PM, Robert Haas wrote:
> I mulled over which of those names was better; updated version,
> reflecting your proposed naming, attached.
I read the patch and found some small typos.
> +If true, any error will terminate the current session. Normally,
> +
Hi,
On 07/13/2010 08:45 PM, Kevin Grittner wrote:
> You could submit them as Work In Progress patches
Okay, I added them. I guess they get more attention that way.
Regards
Markus
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
ht
hello everybody,
we are currently facing some serious issues with cross correlation issue.
consider: 10% of all people have breast cancer. we have 2 genders (50:50).
if i select all the men with breast cancer, i will get basically nobody - the
planner will overestimate the output.
this is the com
On 14/07/10 13:12, PostgreSQL - Hans-Jürgen Schönig wrote:
hello everybody,
we are currently facing some serious issues with cross correlation issue.
consider: 10% of all people have breast cancer. we have 2 genders (50:50).
if i select all the men with breast cancer, i will get basically nobody
On Jul 14, 2010, at 12:40 PM, Heikki Linnakangas wrote:
> On 14/07/10 13:12, PostgreSQL - Hans-Jürgen Schönig wrote:
>> hello everybody,
>>
>> we are currently facing some serious issues with cross correlation issue.
>> consider: 10% of all people have breast cancer. we have 2 genders (50:50).
>
Heikki Linnakangas wrote:
However, the problem is how to represent and store the
cross-correlation. For fields with low cardinality, like "gender" and
boolean "breast-cancer-or-not" you can count the prevalence of all the
different combinations, but that doesn't scale. Another often cited
exam
Hello Robert,
As part of the current reviewfest, I reviewed your patch, and made some
changes on the way.
This was all ok:
*) while proofreading I did not find typos other than the one that
Joachim had already pointed out.
*) the addition of 5-key lookups to the existing ones seems a natural
Hello
this patch is significantly reduced original patch. It doesn't propose
a simple allocator - just eliminate a high memory usage for ispell
dictionary.
without this patch the ispell dictionary takes 55MB for tsearch2
context and 27MB in temp context. With this patch it takes "only" 25MB
tsear
Heikki Linnakangas writes:
> On 14/07/10 13:12, PostgreSQL - Hans-Jürgen Schönig wrote:
>> maybe somehow like this ...
>> ALTER TABLE x SET CORRELATION STATISTICS FOR (id = id2 AND id3=id4)
> +1 is my general feeling, it's good if you can tell the system to
> collect additional statistics where
On Wed, Jul 14, 2010 at 01:21:19PM +0200, Yeb Havinga wrote:
> Heikki Linnakangas wrote:
>> However, the problem is how to represent and store the
>> cross-correlation. For fields with low cardinality, like "gender" and
>> boolean "breast-cancer-or-not" you can count the prevalence of all the
hello tom,
i think that having stats on an index is a problem by itself for 2 reasons -
for cross column correlation at least:
a.) joins cannot be covered by an index on two tables - we would fix
"inside a table correlation problems" but not joins.
b.) who says that there is act
=?iso-8859-1?Q?PostgreSQL_-_Hans-J=FCrgen_Sch=F6nig?=
writes:
> i think that having stats on an index is a problem by itself for 2 reasons -
> for cross column correlation at least:
> a.) joins cannot be covered by an index on two tables - we would fix
> "inside a table correlation probl
Tom Lane wrote:
If the combination of columns is actually interesting, there might well
be an index in place, or the DBA might be willing to create it.
I'm having a hard time imagining an interesting case where that wouldn't
be so.
For
that matter, have you considered the idea of examin
On Wed, Jul 14, 2010 at 7:27 AM, Yeb Havinga wrote:
> Attach is a new patch with all things described above addressed.
Thanks!
I think we should probably hold off applying this until some of the
other KNNGIST work is ready, or we have some other concrete need for
5-key syscaches.
--
Robert Haa
hello ...
look at the syntax i posted in more detail:
>> ALTER TABLE x SET CORRELATION STATISTICS FOR (x.id = y.id AND x.id2 =
>> y.id2)
>
it says X and Y ...
the selectivity of joins are what i am most interested in. cross correlation of
columns within the same table are just a byprod
On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus wrote:
>> An actual plan here might look like "let's flip it before 9.1alpha1
>> so we can get some alpha testing cycles on it" ...
>
> "Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing
> cycles on it."
Should we do this? Patch
Robert Haas wrote:
On Wed, Jul 14, 2010 at 7:27 AM, Yeb Havinga wrote:
Attach is a new patch with all things described above addressed.
Thanks!
I think we should probably hold off applying this until some of the
other KNNGIST work is ready, or we have some other concrete need for
5-k
On Wed, Jul 14, 2010 at 3:41 AM, Fujii Masao wrote:
> I read the patch and found some small typos.
Thanks. Corrected version attached.
> We should add something like?:
>
> -
> Even if this value is set to true, a backend crash during hot standby doesn't
> reinitialize the database.
> --
Robert Haas wrote:
> On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus wrote:
> >> An actual plan here might look like "let's flip it before 9.1alpha1
> >> so we can get some alpha testing cycles on it" ...
> >
> > "Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing
> > cycles on i
On Wed, Jul 14, 2010 at 10:56 AM, Yeb Havinga wrote:
> Robert Haas wrote:
>> On Wed, Jul 14, 2010 at 7:27 AM, Yeb Havinga wrote:
>>> Attach is a new patch with all things described above addressed.
>> Thanks!
>>
>> I think we should probably hold off applying this until some of the
>> other KNNGI
On Wed, Jul 14, 2010 at 04:41:01PM +0200, PostgreSQL - Hans-Jürgen Schönig
wrote:
> hello ...
>
> look at the syntax i posted in more detail:
>
> >>ALTER TABLE x SET CORRELATION STATISTICS FOR (x.id = y.id AND x.id2 =
> >> y.id2)
> >
> it says X and Y ...
> the selectivity of joins are wha
2010/7/14 Tom Lane :
> If the combination of columns is actually interesting, there might well
> be an index in place, or the DBA might be willing to create it.
Indexes aren't free, though, nor even close to it.
Still, I think we should figure out the underlying mechanism first and
then design th
On Wed, Jul 14, 2010 at 2:50 AM, Fujii Masao wrote:
> The patch have no features for performance improvement of synchronous
> replication. I admit that currently the performance overhead in the
> master is terrible. We need to address the following TODO items in the
> subsequent CF.
>
> * Change t
Robert Haas writes:
> On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus wrote:
> An actual plan here might look like "let's flip it before 9.1alpha1
> so we can get some alpha testing cycles on it" ...
>>
>> "Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing
>> cycles on it."
>
Peter Eisentraut wrote:
> Here is a proof of concept for per-column collation support.
Did you want a WIP review of that patch? (CF closing to new
submissions soon)
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http:
On Fri, 2010-07-09 at 00:58 -0300, Marc G. Fournier wrote:
> As decided at this years hackers conference, we are branching
> REL9_0_STABLE *before* the release, instead of after.
>
> The hope is that we won't be taking away resources from finishing the
> release, but still allow ppl to continue
Hello
I have only one question - If I understand well you can use collate
just for sort. What is your plan for range search operation? Sort is
interesting and I am sure important for multilangual applications, for
me - more important is case sensitive, case insensitive, accent
sensitive, insensiti
On Jul 14, 2010, at 12:25 PM, "Joshua D. Drake" wrote:
> On Fri, 2010-07-09 at 00:58 -0300, Marc G. Fournier wrote:
>> As decided at this years hackers conference, we are branching
>> REL9_0_STABLE *before* the release, instead of after.
>>
>> The hope is that we won't be taking away resources f
* Robert Haas (robertmh...@gmail.com) wrote:
> On Jul 14, 2010, at 12:25 PM, "Joshua D. Drake"
> wrote:
> >> The branch is now created.
> >
> > Is Git now the authoritative source?
> >>
>
> No. Marc created the branch in CVS.
Right, the decision at the dev meeting (which could be OBE, so don'
Following on the smashing success of PostgreSQL Conference East,
PostgreSQL Conference West, The PostgreSQL Conference for Decision
Makers, End Users and Developers, is being held at the St. Francis,
Westin Hotel in San Francisco from November 2nd through 4th 2010. Please
join us in making this the
On ons, 2010-07-14 at 19:35 +0200, Pavel Stehule wrote:
> I have only one question - If I understand well you can use collate
> just for sort. What is your plan for range search operation?
My patch does range searches. Sorting uses the same operators, so both
will be supported. (Sorting is not y
On Wed, Jul 14, 2010 at 5:13 PM, Robert Haas wrote:
> 2010/7/14 Tom Lane :
>> If the combination of columns is actually interesting, there might well
>> be an index in place, or the DBA might be willing to create it.
>
> Indexes aren't free, though, nor even close to it.
>
> Still, I think we shou
Joshua Tolley writes:
>> >> ALTER TABLE x SET CORRELATION STATISTICS FOR (x.id =3D y.id AND x.id=
2 =3D y.id2)
>> >=20
>> it says X and Y ... the selectivity of joins are what i am most
>> interested in. cross correlation of columns within the same table are
>> just a byproduct. the core thing
David,
I'd like to volunteer reviewing your patch at first in this commit fest.
We already had a few comments on the list before. I want to see your
opinion for the suggestions prior to code reviews.
Itagaki-san suggested:
| > Enclosed is a patch to add a -C option to initdb to allow you to easi
On Wed, Feb 10, 2010 at 12:19 AM, Tom Lane wrote:
> Andrew Dunstan writes:
>> Tom Lane wrote:
>>> The code is only trying to substitute for something you can't have
>>> in parallel restore, ie --single-transaction.
>
>> Exactly. IIRC that's why --single-transaction was introduced in the
>> first
2010/7/14 Peter Eisentraut :
> On ons, 2010-07-14 at 19:35 +0200, Pavel Stehule wrote:
>> I have only one question - If I understand well you can use collate
>> just for sort. What is your plan for range search operation?
>
> My patch does range searches. Sorting uses the same operators, so both
>
On 14/07/10 15:48, Robert Haas wrote:
On Fri, Jan 29, 2010 at 10:02 PM, Josh Berkus wrote:
An actual plan here might look like "let's flip it before 9.1alpha1
so we can get some alpha testing cycles on it" ...
"Hey, let's flip it in 9.1 CF 1, so that we can have some alpha testing
cycles on i
37 matches
Mail list logo