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
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' br...@momjian.us writes:
On Thu, May 16, 2013 at 08:38:59PM +0530, Amit Kapila wrote:
Reduce query processing overhead by avoiding insertion of useless
plan
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:
* 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 that.
On Thu, May 16, 2013 at 10:05 PM, Peter Geoghegan p...@heroku.com 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
On Thu, May 16, 2013 at 10:06 PM, Daniel Farina dan...@heroku.com 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
On Thu, May 16, 2013 at 9:13 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, May 16, 2013 at 10:06 PM, Daniel Farina dan...@heroku.com 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
On Thu, May 16, 2013 at 9:36 PM, Stephen Frost sfr...@snowman.net 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
On Thu, May 16, 2013 at 11:55 PM, Stephen Frost sfr...@snowman.net 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
* Robert Haas (robertmh...@gmail.com) wrote:
On Thu, May 16, 2013 at 11:55 PM, Stephen Frost sfr...@snowman.net 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
On 16.05.2013 00:18, Robert Haas wrote:
On Wed, May 15, 2013 at 11:35 AM, Heikki Linnakangas
hlinnakan...@vmware.com 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
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
Sent from my iPad
On 17-May-2013, at 6:11, Liming Hu dawnin...@gmail.com 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?
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 how
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
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. Although
2013/5/17 Nikolay Samokhvalov samokhva...@gmail.com
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,
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
$ make
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
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 Thursday, May 16, 2013 7:02 PM Kevin Grittner wrote:
Josh Berkus j...@agliodbs.com 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
On Fri, May 17, 2013 at 4:47 AM, Andres Freund and...@2ndquadrant.com 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
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 TABLE
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 barw...@gmail.com
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
2013/4/21 Bruce Momjian br...@momjian.us
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:
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 br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's
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 haribabu.ko...@huawei.com
wrote:
On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote:
On Wed, Jan 23, 2013 at 10:18 AM, Hari Babu
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 and...@dunslane.net writes:
On 05/16/2013 05:41 AM, Dimitri Fontaine wrote:
And VPATH building
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 in this
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 line
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:
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.
On Fri, May 17, 2013 at 8:51 PM, Liming Hu dawnin...@gmail.com 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
On 5/17/2013 8:23 AM, Atri Sharma wrote:
On Fri, May 17, 2013 at 8:51 PM, Liming Hu dawnin...@gmail.com wrote:
Hi Atri,
Thanks for the quick response.
levenshtein edit distance defines operations of: insertion, deletion,
modification.
Levenshtein-Damerau edit distance defines operations of:
On Fri, May 17, 2013 at 8:56 PM, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 8:23 AM, Atri Sharma wrote:
On Fri, May 17, 2013 at 8:51 PM, Liming Hu dawnin...@gmail.com wrote:
Hi Atri,
Thanks for the quick response.
levenshtein edit distance defines operations of: insertion,
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 implementation and actual
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 Herrera
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 haribabu.ko...@huawei.com
wrote:
On Wed, Jan 23, 2013 11:48 PM, Magnus Hagander wrote:
On Wed,
On Fri, May 17, 2013 at 9:29 PM, Alvaro Herrera
alvhe...@2ndquadrant.com 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
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 atri.j...@gmail.com wrote:
On Fri, May 17, 2013 at 9:29 PM, Alvaro Herrera
Amit Kapila amit.kap...@huawei.com 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
Amit Kapila amit.kap...@huawei.com 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
2013/5/17 Kevin Grittner kgri...@ymail.com:
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
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
Small release notes correction attached.
Joe
From 330f5af36ffdba8930ea2da8146e8f17e1ec8a68 Mon Sep 17 00:00:00 2001
From: Joe Abbate j...@freedomcircle.com
Date: Fri, 17 May 2013 14:59:03 -0400
Subject: [PATCH] Correct release notes about DROP TABLE IF EXISTS and add
link.
---
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
Nicolas Barbier nicolas.barb...@gmail.com wrote:
2013/5/17 Kevin Grittner kgri...@ymail.com:
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
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus j...@agliodbs.com 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
On Fri, May 17, 2013 at 4:25 PM, Kevin Grittner kgri...@ymail.com 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
2013/5/17 Kevin Grittner kgri...@ymail.com:
Nicolas Barbier nicolas.barb...@gmail.com 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
On Sun, Nov 4, 2012 at 10:22 PM, Qi Huang huangq...@outlook.com 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
On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, May 17, 2013 at 4:47 AM, Andres Freund and...@2ndquadrant.com 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
Nicolas Barbier nicolas.barb...@gmail.com wrote:
2013/5/17 Kevin Grittner kgri...@ymail.com:
Nicolas Barbier nicolas.barb...@gmail.com wrote:
Note that the basic count algorithm assumes real-serializable
transactions for correctness. Example:
[..]
Good point.
It might be hard to detect
On Wed, Jan 9, 2013 at 5:17 AM, Peter Eisentraut pete...@gmx.net 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
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 a
On Fri, May 17, 2013 at 2:03 PM, Daniel Farina dan...@heroku.com 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
On 2013-05-17 15:48:38 -0500, Merlin Moncure wrote:
On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, May 17, 2013 at 4:47 AM, Andres Freund and...@2ndquadrant.com
wrote:
On 2013-05-15 16:46:33 -0500, Jon Nelson wrote:
* Is wal file creation performance
Josh Berkus j...@agliodbs.com 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
On Fri, May 17, 2013 at 4:18 PM, Andres Freund and...@2ndquadrant.com wrote:
On 2013-05-17 15:48:38 -0500, Merlin Moncure wrote:
On Fri, May 17, 2013 at 8:29 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, May 17, 2013 at 4:47 AM, Andres Freund and...@2ndquadrant.com
wrote:
On
2013/5/17 Claudio Freire klaussfre...@gmail.com:
On Fri, May 17, 2013 at 4:25 PM, Kevin Grittner kgri...@ymail.com 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.,
-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
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus j...@agliodbs.com 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.
On Sat, May 18, 2013 at 9:27 AM, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus j...@agliodbs.com wrote:
Can we add Levenshtein-Damerau edit distance since it is used in
spelling checker
instead of levenshtein edit
On 5/17/2013 9:10 PM, Atri Sharma wrote:
On Sat, May 18, 2013 at 9:27 AM, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus j...@agliodbs.com wrote:
Can we add Levenshtein-Damerau edit distance since it is used in
Sent from my iPad
On 18-May-2013, at 10:00, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 9:10 PM, Atri Sharma wrote:
On Sat, May 18, 2013 at 9:27 AM, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 12:39 PM, Liming Hu wrote:
On Fri, May 17, 2013 at 12:06 PM, Josh Berkus
On Fri, May 17, 2013 at 9:39 PM, Atri Sharma atri.j...@gmail.com wrote:
Sent from my iPad
On 18-May-2013, at 10:00, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 9:10 PM, Atri Sharma wrote:
On Sat, May 18, 2013 at 9:27 AM, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 12:39 PM,
Sent from my iPad
On 18-May-2013, at 10:41, Liming Hu dawnin...@gmail.com wrote:
On Fri, May 17, 2013 at 9:39 PM, Atri Sharma atri.j...@gmail.com wrote:
Sent from my iPad
On 18-May-2013, at 10:00, Liming Hu dawnin...@gmail.com wrote:
On 5/17/2013 9:10 PM, Atri Sharma wrote:
On
On Fri, May 17, 2013 at 10:21 PM, Atri Sharma atri.j...@gmail.com wrote:
Sent from my iPad
On 18-May-2013, at 10:41, Liming Hu dawnin...@gmail.com wrote:
On Fri, May 17, 2013 at 9:39 PM, Atri Sharma atri.j...@gmail.com wrote:
Sent from my iPad
On 18-May-2013, at 10:00, Liming Hu
68 matches
Mail list logo