Sent from my iPad
On 18-May-2013, at 12:07, Liming Hu wrote:
> On Fri, May 17, 2013 at 11:13 PM, Atri Sharma wrote:
>>
>>
>> Sent from my iPad
>>
>> On 18-May-2013, at 11:23, Liming Hu wrote:
>>
>>> On Fri, May 17, 2013 at 10:21 PM, Atri Sharma wrote:
Sent from my iPad
On Fri, May 17, 2013 at 11:13 PM, Atri Sharma wrote:
>
>
> Sent from my iPad
>
> On 18-May-2013, at 11:23, Liming Hu wrote:
>
>> On Fri, May 17, 2013 at 10:21 PM, Atri Sharma wrote:
>>>
>>>
>>> Sent from my iPad
>>>
>>> On 18-May-2013, at 10:41, Liming Hu wrote:
>>>
On Fri, May 17, 2013 at
Sent from my iPad
On 18-May-2013, at 11:23, Liming Hu wrote:
> On Fri, May 17, 2013 at 10:21 PM, Atri Sharma wrote:
>>
>>
>> Sent from my iPad
>>
>> On 18-May-2013, at 10:41, Liming Hu wrote:
>>
>>> On Fri, May 17, 2013 at 9:39 PM, Atri Sharma wrote:
Sent from my iPad
>
On Fri, May 17, 2013 at 10:21 PM, Atri Sharma wrote:
>
>
> Sent from my iPad
>
> On 18-May-2013, at 10:41, Liming Hu wrote:
>
>> On Fri, May 17, 2013 at 9:39 PM, Atri Sharma wrote:
>>>
>>>
>>> Sent from my iPad
>>>
>>> On 18-May-2013, at 10:00, Liming Hu wrote:
>>>
On 5/17/2013 9:10 PM, At
Sent from my iPad
On 18-May-2013, at 10:41, Liming Hu wrote:
> On Fri, May 17, 2013 at 9:39 PM, Atri Sharma wrote:
>>
>>
>> Sent from my iPad
>>
>> On 18-May-2013, at 10:00, Liming Hu wrote:
>>
>>> On 5/17/2013 9:10 PM, Atri Sharma wrote:
On Sat, May 18, 2013 at 9:27 AM, Liming Hu
On Fri, May 17, 2013 at 9:39 PM, Atri Sharma wrote:
>
>
> Sent from my iPad
>
> On 18-May-2013, at 10:00, Liming Hu wrote:
>
>> On 5/17/2013 9:10 PM, Atri Sharma wrote:
>>> On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote:
On 5/17/2013 12:39 PM, Liming Hu wrote:
> On Fri, May 17, 2013 a
Sent from my iPad
On 18-May-2013, at 10:00, Liming Hu wrote:
> On 5/17/2013 9:10 PM, Atri Sharma wrote:
>> On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote:
>>> On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:
>> Can we add Levenshtein-Dam
On 5/17/2013 9:10 PM, Atri Sharma wrote:
On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote:
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:
Can we add Levenshtein-Damerau edit distance since it is used in
spelling checker
instead of levenshtein edi
On Sat, May 18, 2013 at 9:27 AM, Liming Hu wrote:
> On 5/17/2013 12:39 PM, Liming Hu wrote:
>>
>> On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:
Can we add Levenshtein-Damerau edit distance since it is used in
spelling checker
instead of levenshtein edit distance?
>>>
>>
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:
Can we add Levenshtein-Damerau edit distance since it is used in
spelling checker
instead of levenshtein edit distance?
Patches welcome! You, too, can be a PostgreSQL contributor.
However, you will n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Em 13-05-2013 09:50, Heikki Linnakangas escreveu:
> I've been working on-and-off on the WAL-insert scaling patch. It's
> in pretty good shape now, and I'll post it shortly, but one thing I
> noticed is that it benefits a lot from using an atomic
> comp
2013/5/17 Claudio Freire :
> On Fri, May 17, 2013 at 4:25 PM, Kevin Grittner wrote:
>
>>> (3) The count algorithm must be implemented in a way that understands
>>> MVCC internals: Reading the base tables must be done using a technique
>>> that reads all rows (i.e., also the ones not visible to th
On Fri, May 17, 2013 at 4:18 PM, Andres Freund wrote:
> On 2013-05-17 15:48:38 -0500, Merlin Moncure wrote:
>> On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure wrote:
>> > On Fri, May 17, 2013 at 4:47 AM, Andres Freund
>> > wrote:
>> >> On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
>> >>> > *
Josh Berkus wrote:
> This sounds like a fairly good approach. It would require a
> couple of things though:
>
> 1) admins would need to be able to enable and disable incremental
> updating of matviews, so that if the creation of delta tables is
> bogging down writes, they can disable them tempor
On 2013-05-17 15:48:38 -0500, Merlin Moncure wrote:
> On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure wrote:
> > On Fri, May 17, 2013 at 4:47 AM, Andres Freund
> > wrote:
> >> On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
> >>> > * Is wal file creation performance actually relevant? Is the per
On Fri, May 17, 2013 at 2:03 PM, Daniel Farina wrote:
> Thanks for getting through all that text. Fin. And, thoughts?
I have uploaded the resolvers, the last mail, and the patch to github:
https://github.com/fdr/pq-resolvers
So, if one prefers to use git to get this and track potential change
Kevin,
> The count_t column saves us from having to scan foo for all the old
> val values. It does not require any scan of the entire bar
> matview. It allows us to zero in on exactly the right rows, and
> lets us know what needs doing.
This sounds like a fairly good approach. It would require
On Wed, Jan 9, 2013 at 5:17 AM, Peter Eisentraut wrote:
> I would like to have something like ssh-askpass for libpq. The main
> reason is that I don't want to have passwords in plain text on disk,
> even if .pgpass is read protected. By getting the password from an
> external program, I can inte
Nicolas Barbier wrote:
> 2013/5/17 Kevin Grittner :
>> Nicolas Barbier wrote:
>>
>>> Note that the basic count algorithm assumes real-serializable
>>> transactions for correctness. Example:
>
> [..]
>
>> Good point.
>>
>> It might be hard to detect when this type of race condition exists,
>> sinc
On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure wrote:
> On Fri, May 17, 2013 at 4:47 AM, Andres Freund wrote:
>> On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
>>> > * Is wal file creation performance actually relevant? Is the performance
>>> > of a system running on fallocate()d wal files an
On Sun, Nov 4, 2012 at 10:22 PM, Qi Huang wrote:
> Dear hackers
> Sorry for not replying the patch review. I didn't see the review until
> recently as my mail box is full of Postgres mails and I didn't notice the
> one for me, my mail box configuration problem.
> I am still kind of busy
2013/5/17 Kevin Grittner :
> Nicolas Barbier wrote:
>
>> Note that the basic count algorithm assumes real-serializable
>> transactions for correctness. Example:
[..]
> Good point.
>
> It might be hard to detect when this type of race condition exists,
> since it could be hidden inside a functio
On Fri, May 17, 2013 at 4:25 PM, Kevin Grittner wrote:
>> (3) The count algorithm must be implemented in a way that understands
>> MVCC internals: Reading the base tables must be done using a technique
>> that reads all rows (i.e., also the ones not visible to the current
>> transaction), and the
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus wrote:
>
>> Can we add Levenshtein-Damerau edit distance since it is used in
>> spelling checker
>> instead of levenshtein edit distance?
>
> Patches welcome! You, too, can be a PostgreSQL contributor.
>
> However, you will need to preserve the abilit
Nicolas Barbier wrote:
> 2013/5/17 Kevin Grittner :
>
>> During calculation of the deltas to apply to the matviews, it must
>> be possible to query the referenced tables from the perspective of
>> both the "before" and "after" versions of the data.
>
> [..]
>
>> I don't think the process applying
Robert,
> But I still feel like that thought
> experiment indicates that there must be a solution here just by
> rejiggering the locking, and maybe with a bit of modest pre-extension.
> The mediocre results of my last couple tries must indicate that I
> wasn't entirely successful in getting the b
Small release notes correction attached.
Joe
>From 330f5af36ffdba8930ea2da8146e8f17e1ec8a68 Mon Sep 17 00:00:00 2001
From: Joe Abbate
Date: Fri, 17 May 2013 14:59:03 -0400
Subject: [PATCH] Correct release notes about DROP TABLE IF EXISTS and add
link.
---
doc/src/sgml/release-9.3.sgml |5 +
> Can we add Levenshtein-Damerau edit distance since it is used in
> spelling checker
> instead of levenshtein edit distance?
Patches welcome! You, too, can be a PostgreSQL contributor.
However, you will need to preserve the ability of users to use the old
levenshtien algorithm as well, for bac
2013/5/17 Kevin Grittner :
> During calculation of the deltas to apply to the matviews, it must
> be possible to query the referenced tables from the perspective of
> both the "before" and "after" versions of the data.
[..]
> I don't think the process applying the deltas needs to do
> anything u
Amit Kapila wrote:
> On Thursday, May 16, 2013 7:02 PM Kevin Grittner wrote:
>> Let's say there is a table and matview like this:
>
>> create table foo (fooid int primary key, val int not null);
>> create materialized view bar as select distinct val from foo;
>
>> Let's say there are millions of
Amit Kapila wrote:
> On Wednesday, May 15, 2013 1:22 AM Kevin Grittner wrote:
>
> Good explanation for understanding the initial concept of
> incremental update of matviews.
Thanks. This is one of those topics where it takes a lot of time
going over highly technical papers to really get your hea
Actually it is easy for me to just modify the code, and use it for me
case, I would like to contribute to the
community. I will write a basic implementation first.
On Fri, May 17, 2013 at 9:10 AM, Atri Sharma wrote:
> On Fri, May 17, 2013 at 9:29 PM, Alvaro Herrera
> wrote:
>> Liming Hu escribió
On Fri, May 17, 2013 at 9:29 PM, Alvaro Herrera
wrote:
> Liming Hu escribió:
>> Hi Atri,
>>
>> I also talked to the author of fuzzystrmatch, he also thinks it is a
>> good feature.
>
> Yeah, I heard our fuzzystrmatch module being talked down a decade ago
> for not considering transpositions, so +1
2013-05-17 16:05 keltezéssel, Heikki Linnakangas írta:
On 18.02.2013 16:35, Boszormenyi Zoltan wrote:
2013-01-29 11:15 keltezéssel, Magnus Hagander írta:
On Thu, Jan 24, 2013 at 7:04 AM, Hari Babu
wrote:
On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote:
On Wed, Jan 23, 2013 at 10:18 AM,
Liming Hu escribió:
> Hi Atri,
>
> I also talked to the author of fuzzystrmatch, he also thinks it is a
> good feature.
Yeah, I heard our fuzzystrmatch module being talked down a decade ago
for not considering transpositions, so +1 for getting it patched.
--
Álvaro Herrerahttp:/
Hello Liming,
> >> Sounds interesting. How can we build this over our current
> >> implementation, or do we need to build it from scratch?
> >>
> > I know how to write the code, but just need approval of accepting into
> > the new version.
>
> Well, acceptance depends largely on the implementati
On Fri, May 17, 2013 at 8:56 PM, Liming Hu wrote:
> On 5/17/2013 8:23 AM, Atri Sharma wrote:
>>
>> On Fri, May 17, 2013 at 8:51 PM, Liming Hu wrote:
>>>
>>> Hi Atri,
>>>
>>> Thanks for the quick response.
>>>
>>> levenshtein edit distance defines operations of: insertion, deletion,
>>> modificati
On 5/17/2013 8:23 AM, Atri Sharma wrote:
On Fri, May 17, 2013 at 8:51 PM, Liming Hu wrote:
Hi Atri,
Thanks for the quick response.
levenshtein edit distance defines operations of: insertion, deletion,
modification.
Levenshtein-Damerau edit distance defines operations of: insertion,
deletion,
On Fri, May 17, 2013 at 8:51 PM, Liming Hu wrote:
> Hi Atri,
>
> Thanks for the quick response.
>
> levenshtein edit distance defines operations of: insertion, deletion,
> modification.
> Levenshtein-Damerau edit distance defines operations of: insertion,
> deletion, modification
> and transposit
Hi Atri,
I also talked to the author of fuzzystrmatch, he also thinks it is a
good feature.
Thanks,
Liming
On 5/17/2013 8:21 AM, Liming Hu wrote:
Hi Atri,
Thanks for the quick response.
levenshtein edit distance defines operations of: insertion, deletion,
modification.
Levenshtein-Damerau
Hi Atri,
Thanks for the quick response.
levenshtein edit distance defines operations of: insertion, deletion,
modification.
Levenshtein-Damerau edit distance defines operations of: insertion, deletion,
modification
and transposition (
it will be two operations in levenshtein edit distance:
on
On 05/16/2013 09:14 AM, Christoph Berg wrote:
Re: Stephen Frost 2013-05-16 <20130516123344.gt4...@tamriel.snowman.net>
* Christoph Berg (c...@df7cb.de) wrote:
That was because the plain "./configure" version (for a minimal way to
reproduce) didn't built with debug symbols. The original gcc lin
Dmitriy Igrishin escribió:
> I've noticed a small inaccuracy:
>
> E.1.3.4 Object Manipulation
> [...]
>
> "This allows C functions to be called when DDL commands are run."
>
> But according to
> http://www.postgresql.org/docs/devel/static/event-triggers.html
> not only C functions can be called
Le jeudi 16 mai 2013 18:53:19, Alvaro Herrera a écrit :
> Andrew Dunstan wrote:
> > On 05/16/2013 10:39 AM, Cédric Villemain wrote:
> > >Le jeudi 16 mai 2013 15:51:48, Tom Lane a écrit :
> > >>Andrew Dunstan writes:
> > >>>On 05/16/2013 05:41 AM, Dimitri Fontaine wrote:
> > And VPATH building
On 18.02.2013 16:35, Boszormenyi Zoltan wrote:
2013-01-29 11:15 keltezéssel, Magnus Hagander írta:
On Thu, Jan 24, 2013 at 7:04 AM, Hari Babu
wrote:
On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote:
On Wed, Jan 23, 2013 at 10:18 AM, Hari Babu
wrote:
Test scenario to reproduce:
1. Start
On Tue, May 7, 2013 at 09:10:37PM -0400, Peter Eisentraut wrote:
> It doesn't look as though it is used or usable.
Agreed. I don't why it is there.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everythin
2013/4/21 Bruce Momjian
> I am not sure if Tom shared yet, but we are planning to package 9.3
> beta1 on April 29, with a release on May 2. Those dates might change,
> but that is the current plan. I have completed a draft 9.3 release
> notes, which you can view here:
>
> http://momjian
On Tue, May 7, 2013 at 02:47:16PM -0400, Robert Haas wrote:
> On Tue, May 7, 2013 at 2:36 PM, Ian Lawrence Barwick
> wrote:
> > As a British native speaker involved in translating some PostgreSQL-related
> > Japanese text, all I can say is "yes please". (Although for true Japanese
> > support, t
On Fri, May 17, 2013 at 10:22:59AM +0530, Amit Kapila wrote:
> > Yes, that would be user-visible, though we rarely add details like
> > that.
> > What queries are faster, that users would understand?
>
> Example:
> CREATE TABLE tbl_parent (c01 numeric, c02 int);
>
> CREATE
On Fri, May 17, 2013 at 4:47 AM, Andres Freund wrote:
> On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
>> > * Is wal file creation performance actually relevant? Is the performance
>> > of a system running on fallocate()d wal files any different?
>>
>> In my limited testing, I noticed a drop of
On Thursday, May 16, 2013 7:02 PM Kevin Grittner wrote:
Josh Berkus wrote:
> Let's say there is a table and matview like this:
> create table foo (fooid int primary key, val int not null);
> create materialized view bar as select distinct val from foo;
> Let's say there are millions of rows in
On Wednesday, May 15, 2013 1:22 AM Kevin Grittner wrote:
Good explanation for understanding the initial concept of incremental update
of matviews.
> The original and modified versions of the relations (tables or
> other matviews) which define a matview must be available to
> calculate the matview
On 17.05.2013 12:29, Nikolay Samokhvalov wrote:
Hello hackers,
Consider a Postgres cluster containing several DBs (for example several
projects/sites). If one wants to optimize queries on one specified site --
what should he do? His obvious need is to switch full logging for the exact
database o
> Yes, am aware PLJava is a 3rd party lib, just surprised the same party
> hasn't built them given they seem to be built all the way to 9.1.
>
> My question was primarily about obtaining pgsx.mk file which is a part of
> the PostgreSQL project.
With linux you do something like that for pljava
$
2013/5/17 Nikolay Samokhvalov
> Consider a Postgres cluster containing several DBs (for example several
> projects/sites). If one wants to optimize queries on one specified site --
> what should he do? His obvious need is to switch full logging for the exact
> database on, collect the logs and an
On 2013-05-17 10:45:26 +0300, Heikki Linnakangas wrote:
> On 16.05.2013 04:15, Andres Freund wrote:
> >On 2013-05-15 18:35:35 +0300, Heikki Linnakangas wrote:
> >>Truncating a heap at the end of vacuum, to release unused space back to
> >>the OS, currently requires taking an AccessExclusiveLock. Al
Hello hackers,
Consider a Postgres cluster containing several DBs (for example several
projects/sites). If one wants to optimize queries on one specified site --
what should he do? His obvious need is to switch full logging for the exact
database on, collect the logs and analyze them using pgFouin
On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
> > * Is wal file creation performance actually relevant? Is the performance
> > of a system running on fallocate()d wal files any different?
>
> In my limited testing, I noticed a drop of approx. 100ms per WAL file.
> I do not have a good idea for
Sent from my iPad
On 17-May-2013, at 6:11, Liming Hu wrote:
> Hi,
>
> I am studying your levenshtein edit distance contribution in Postgresql.
>
> Can we add Levenshtein-Damerau edit distance since it is used in
> spelling checker
> instead of levenshtein edit distance?
>
> Levenshtein-Dame
On 16.05.2013 04:15, Andres Freund wrote:
On 2013-05-15 18:35:35 +0300, Heikki Linnakangas wrote:
Truncating a heap at the end of vacuum, to release unused space back to
the OS, currently requires taking an AccessExclusiveLock. Although it's only
held for a short duration, it can be enough to ca
On 16.05.2013 00:18, Robert Haas wrote:
On Wed, May 15, 2013 at 11:35 AM, Heikki Linnakangas
wrote:
Shared memory space is limited, but we only need the watermarks for any
in-progress truncations. Let's keep them in shared memory, in a small
fixed-size array. That limits the number of concurre
* Robert Haas (robertmh...@gmail.com) wrote:
> On Thu, May 16, 2013 at 11:55 PM, Stephen Frost wrote:
> > You don't change that. However, when a seq scan asks the storage layer
> > for blocks that it knows don't actually exist, it can simply skip over
> > them or return "empty" records or somethi
On Thu, May 16, 2013 at 11:55 PM, Stephen Frost wrote:
> * Robert Haas (robertmh...@gmail.com) wrote:
>> I think it's pretty unrealistic to suppose that this can be made to
>> work. The most obvious problem is that a sequential scan is coded to
>> assume that every block between 0 and the last bl
On Thu, May 16, 2013 at 9:36 PM, Stephen Frost wrote:
>> What we do have is
>> a relation extension lock, but the size of the segment on disk has
>> nothing to do with that: there's only one for the whole relation, and
>> you hold it when adding a block to the relation.
>
> Yes, which is farrr too
On Thu, May 16, 2013 at 9:13 PM, Robert Haas wrote:
> On Thu, May 16, 2013 at 10:06 PM, Daniel Farina wrote:
>> Do you have a sketch about mechanism to not encounter that problem?
>
> I didn't until just now, but see my email to Peter. That idea might
> be all wet, but off-hand it seems like it
On Thu, May 16, 2013 at 10:06 PM, Daniel Farina wrote:
> Do you have a sketch about mechanism to not encounter that problem?
I didn't until just now, but see my email to Peter. That idea might
be all wet, but off-hand it seems like it might work...
> However little it may matter, I would like t
On Thu, May 16, 2013 at 10:05 PM, Peter Geoghegan wrote:
>>> I don't think it's bad. I think that we shouldn't be paternalistic
>>> towards our users. If anyone enables a setting like zero_damaged_pages
>>> (or, say, wal_write_throttle) within their postgresql.conf
>>> indefinitely for no good rea
* Robert Haas (robertmh...@gmail.com) wrote:
> I think it's pretty unrealistic to suppose that this can be made to
> work. The most obvious problem is that a sequential scan is coded to
> assume that every block between 0 and the last block in the relation
> is worth reading,
You don't change th
Hi,
I am studying your levenshtein edit distance contribution in Postgresql.
Can we add Levenshtein-Damerau edit distance since it is used in
spelling checker
instead of levenshtein edit distance?
Levenshtein-Damerau edit distance C source code:
http://stackoverflow.com/questions/10727174/damera
On Friday, May 17, 2013 4:22 AM Bruce Momjian wrote:
> On Thu, May 16, 2013 at 06:49:33PM -0400, Tom Lane wrote:
> > "'Bruce Momjian'" writes:
> > > On Thu, May 16, 2013 at 08:38:59PM +0530, Amit Kapila wrote:
> > >> Reduce query processing overhead by avoiding insertion of useless
> plan nodes
>
Thx.
Yes, am aware PLJava is a 3rd party lib, just surprised the same party hasn't
built them given they seem to be built all the way to 9.1.
My question was primarily about obtaining pgsx.mk file which is a part of the
PostgreSQL project.
Paul
From: Andrew
71 matches
Mail list logo
