On Fri, Oct 6, 2017 at 1:22 PM, Paul A Jungwirth
wrote:
> On Fri, Jul 22, 2016 at 4:15 AM, Anton Dignös wrote:
>> We would like to contribute to PostgreSQL a solution that supports the query
>> processing of "at each time point". The basic
_string_similarity?
>
At least for this English speaker, substring_similarity is not
confusing even if it's not internally accurate, but English is a
strange language.
Because I want the bike shed to be blue, how does
query_string_similarity sound instead? If that's overly precise, then
word_simila
this by pre-normalizing
strings matching /(\d+)-(\d+)/ into two numbers separated by a space
instead of a hyphen, but if fixing this bug would remove the need for
such a preprocessing step it would be a great help to us. Would such
strings be parsed "properly" into lexems of the form o
On Thu, Feb 19, 2015 at 5:53 AM, Marko Tiikkaja ma...@joh.to wrote:
Hi,
Commit 79af9a1d2668c9edc8171f03c39e7fed571eeb98 changed xpath handling
with regard to namespaces, and it seems to be fixing an actual issue.
However, it was also backpatched to all branches despite it breaking for
standbys to be named in this fashion.
This role could be provided on connect of the standby is more-or-less
tangential to the specific registration issue.
Big +1 FWIW.
--
Mike Rylander
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription
FUNCTION my_xml_is_valid ( x TEXT ) RETURNS BOOL AS $$
BEGIN
PERFORM XMLPARSE( DOCUMENT x::XML );
RETURN TRUE;
EXCEPTION WHEN OTHERS THEN
RETURN FALSE;
END;
$$ LANGUAGE PLPGSQL;
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN
be extremely useful to me when creating or
persisting raw class instances of these sorts.
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: mi...@esilibrary.com
| web: http://www.esilibrary.com
--
Sent via
*conflict*, and
it's less surprising that the standby can fall indefinitely behind in
the worst case. If we name the setting along those lines, I could live
with that.
+1 from the peanut gallery.
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone
is what more people would expect, I'd think.
+1
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: mi...@esilibrary.com
| web: http://www.esilibrary.com
--
Sent via pgsql-hackers mailing list (pgsql
and
fast code I could share, if it's needed, though I suspect it's not.
:)
UPDATE: Thanks, Robert, for pointing to the RFC.
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: mi...@esilibrary.com
| web
On Sun, Mar 28, 2010 at 8:33 PM, Robert Haas robertmh...@gmail.com wrote:
On Sun, Mar 28, 2010 at 8:23 PM, Mike Rylander mrylan...@gmail.com wrote:
In practice, every parser/serializer I've used (including the one I
helped write) allows (and, often, forces) any non-ASCII character
AS 'DIRECTORY/funcs', 'add_one'
LANGUAGE C STRICT;
CREATE FUNCTION add_one(integer) RETURNS integer
AS 'My::Package', 'add_one'
LANGUAGE plperl STRICT;
+1, fwiw
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS
functions I use, they are
lightly edited to remove the use of wrappers I've created to paper
over the transition from xpath_nodeset() to core XPATH().
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: mi
] as uuid from table;
Not as clean, but it produces the same result as xpath_string().
Combined with array_to_string() could can collapse the array instead
of just grabbing the first element (in cases other than uuid, of
course).
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc
be easier to use for those not familiar with more advanced
XPath, but it also has non-standard default actions. That being said,
I'd love to see wrapper functions that provide the older api but
leverage the core code.
--miker
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc
Sorry, forgot to reply-all.
-- Forwarded message --
From: Mike Rylander mrylan...@gmail.com
Date: Wed, Jul 8, 2009 at 4:17 PM
Subject: Re: [HACKERS] tsvector extraction patch
To: Alvaro Herrera alvhe...@commandprompt.com
On Wed, Jul 8, 2009 at 3:38 PM, Alvaro
Herreraalvhe
sure | 4
(4 rows)
This looks very useful! I wonder if providing a weight column would
be relatively simple? I think this would present problems with the
cast-to-text[] idea that Peter suggests, though.
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen
; it would be interesting old HW / old Solaris for us.
Would you like an IPC instead? Though building PG on it might take
longer than the average release cycle. ;)
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email
rotate a
logfile every minute this still transfers 16*60*24 = ~23 GB a day.
I archived 1965 logs yesterday on one instance of my app totalling
8.5GB ... not to bad, really.
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673
On Dec 22, 2007 1:04 PM, Tom Lane [EMAIL PROTECTED] wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Wouldn't SSL work over Unix-domain sockets as well? The API only deals with
file descriptors.
Hmm ... we've always thought of SSL as being primarily comm security
and thus useless on a
On 8/18/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Aug 17, 2007 at 04:06:15PM -0700, Josh Berkus wrote:
Bruce,
Oh, so you want the config inside each tsvector value. Interesting
idea.
Yeah, hasn't anyone suggested this
On 8/15/07, Bruce Momjian [EMAIL PROTECTED] wrote:
I have added another idea for index-only scans to the TODO list:
A third idea would be for a heap scan to check if all rows are visible
and if so set a per-table flag which can be checked by index scans.
Any change to the table would
On 8/13/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Heikki Linnakangas wrote:
Bruce Momjian wrote:
Heikki Linnakangas wrote:
Removing the default configuration setting altogether removes the 2nd
problem, but that's not good from a usability point of view. And it
doesn't solve the
On 8/14/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:
Mike Rylander wrote:
[snip]
Don't you need to use the right configuration to parse the query into a
tsquery as well?
Only if the user (or user agent) can supply enough information to move
away from the configured default of, say, en-US
On 8/14/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Bruce Momjian wrote:
Basically, the default GUC doesn't work because of:
error prone
if super-user only, non-super-user doesn't work on restore
if non-super-user, can cause mismatch (perhaps this is the best
On 8/14/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Oleg Bartunov wrote:
On Tue, 14 Aug 2007, Alvaro Herrera wrote:
Oleg Bartunov wrote:
On Thu, 9 Aug 2007, [EMAIL PROTECTED] wrote:
Maybe I'm missing something, but it seems to me that the configuration
is more attached to a
On 8/14/07, Gregory Stark [EMAIL PROTECTED] wrote:
Mike Rylander [EMAIL PROTECTED] writes:
My application (http://open-ils.org, which run 80% of the public
libraries in Georgia, USA, http://gapines.org and
http://georgialibraries.org/lib/pines.html) requires that I be able to
search
for listening (and for all the great work on getting tsearch
into core! :) ...
--
Mike Rylander
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
On 6/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Mike Rylander [EMAIL PROTECTED] writes:
I can certainly understand the benefit of making the default
configuration a simple locale to language map, but there are
definitely uses for searching using different stemmers/stop-lists even
within
On 6/1/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Mike Rylander wrote:
I understand that XML support is planned and at least partially
implemented for 8.3, but many production instances will be unable
(or, in fact, unwilling) to upgrade to 8.3 for quite some time.
Because this patch
with, and no, I can't change
that) will have exactly the same problems using the new mechanisms as
with the current xml2 contrib module. I ask because, based on the
design emails I've seen on -hackers, nothing surrounding explicit
support for said issue jumped out at me.
Thanks again.
--
Mike Rylander
On 3/6/07, Mike Rylander [EMAIL PROTECTED] wrote:
On 3/6/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Mike Rylander wrote:
The patch adds support for default XML namespaces in xml2 by providing
a mechanism for supplying a prefix to a named namespace URI.
How does it support multiple
://www.postgresql.org/docs/faq
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 3/6/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Mike Rylander wrote:
The patch adds support for default XML namespaces in xml2 by providing
a mechanism for supplying a prefix to a named namespace URI.
How does it support multiple namespaces in one document?
It supports one default
On 3/6/07, Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
On 3/6/07, Mike Rylander [EMAIL PROTECTED] wrote:
Attatched you'll find a patch that I've been kicking around for a
while that I'd like to propose for inclusion in 8.3. I attempted to
submit this through the original xml2 author (as far
if there is any more I can/need-to do to help this
patch along!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
xml2-namespaces.patch
Description: Binary data
---(end of broadcast)---
TIP 1: if posting
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Mike Rylander
[EMAIL
de Informática do Paraná - Brasil
http://www.pr.gov.br
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
.
Thanks again, Qingqing, for the work on this. I'm very excited about
where this could go. :)
Regards,
Qingqing
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Mike
an aggreagate around it
CREATE AGGREGATE public.last (
sfunc= public.last_agg,
basetype = anyelement,
stype= anyelement
);
Hope that helps!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end
of representation of their DNA?
Unless the person in question happens to be a chimera (yes, they do exist).
;-)
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 4: Have
it
look like the dog did it. -- Unknown
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast
://www.postgresql.org/docs/faq
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
of enquiry.
Best Regards, Simon Riggs
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
--
==
All 98 tests passed.
==
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 6: explain analyze is your friend
PAM to Windows, and then everybody wins.
Well, for one that's going to be a *lot* more work. I'm not even sure
how many of the concepts would apply to win32, but then I don't really
know PAM...
Most of the work has already been done:
http://pgina.xpasystems.com/
--
Mike Rylander
[EMAIL
functions look
like RETURNS functions. If that were removed then we'd have what, at
least by counting the responses on this thread, seems to be the
desired (and expected) behaviour.
Or I could just be misunderstanding the implementation again.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES
, and the one
column in such a rowtype certainly has a name of it's own.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
)?
[snip]
Please, if You think, so Oracle way is good, correct it.
I'm still favoring non-strict but it deserves more than two votes.
Anybody else have an opinion?
regards, tom lane
My $0.02: I'd prefer the non-strict version.
--
Mike Rylander
[EMAIL
outweighed by the bitmap setup overhead.
TIA
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
0m3.347s
user0m3.343s
sys 0m0.000s
Hope the numbers help!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 6: Have you searched our list archives
Sorry, forgot the compiler version.
gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6)
On Wed, 2 Feb 2005 01:12:04 +, Mike Rylander [EMAIL PROTECTED] wrote:
On Tue, 01 Feb 2005 16:23:56 -0500, Tom Lane [EMAIL PROTECTED] wrote:
a_ogawa [EMAIL PROTECTED] writes:
I
and completely sidestep the need for precalculated
cross-column correlations. Am I getting that right?
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 6: Have you searched our
On Sun, 30 Jan 2005 11:07:59 +1100, Neil Conway [EMAIL PROTECTED] wrote:
Mike Rylander wrote:
For on-disk bitmap indexes, yes. I don't see any reason this couldn't
be done with GiST
It might be possible to do it with GiST, but GiST is designed for
implementing tree-structured indexes; I
bitwise a OR on bitmaps 1 and 3, find the
possition of the 1s, jump to those possitions in the ctid array, and
bounce to the heap for the value.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast
: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
On Mon, 6 Dec 2004 08:17:29 -0500 (EST), [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
On Mon, 6 Dec 2004, Mike Rylander wrote:
Just so that you have some info, I've been using DBD::PgSPI with Pg 8.0
since beta 1. The only restriction I've run into with the old code is
that it doesn't like
.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
. Please, CORE, include this one!
As an alternative, what would be the possibility of creating a new PL
as a contrib module, say PLPGSQL_NG, to move forward with extensions
like this and perhaps EVALUATE?
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
On 23 Nov
= 'INSERT' OR (TG_OP = 'UPDATE' AND NEW.name !=
OLD.name) IS TRUE) ...
In this case, since OLD.name does not exist during INSERT it cannot be
replaced. Perhaps someone else can shed a little more light on this.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
A while back I was looking the backend code in preparation to start
beginning to look at parallelization techniques for PG ;)... My
thought was instead of trying to parallelize each individual plan node
(multi-process sort, etc.) I would look at creating worker
threads/processes for each plan node
Not that my 2c is worth 1c, but I second this. I'd rather initdb now
than get bitten by some catalog difference when I move my DB into
production. :)
--miker
On Sat, 02 Oct 2004 14:22:50 -0400, Tom Lane [EMAIL PROTECTED] wrote:
[...]
I'd prefer if all users of 8.0 were guaranteed to have
Tom Lane wrote:
Just so you know --- core has agreed that it's about time for beta2.
If you've got any must fix issues, please get 'em in over the weekend.
Will we be looking at a re-initdb with beta2? I didn't notice any changes
that would force it, but just to be clear...
regards, tom
Seems the NNTP server went wonky again...
TIA!
--
Mike Rylander
[EMAIL PROTECTED]
Indentation is a wonderful form of commentary from
programmer to programmer, but its symbology is
largely wasted on the computer. We don't tell poets
how to format their poetry.
-- Larry Wall
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
I've been thinking about what to do with cursors in subtransactions.
So within this proposal, a query executed by normal means will get its
resources saved in the transaction
Mike Rylander wrote:
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Tue, Jul 13, 2004 at 04:57:06PM -0400, Tom Lane wrote:
I've been thinking about what to do with cursors in subtransactions.
So within this proposal, a query executed by normal means will get its
resources
posted mailed
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Sat, Jul 10, 2004 at 09:18:28PM -0700, elein wrote:
The new plperl returns sets by having
the function return an array.
I think RETURN NEXT does the same thing anyway ... they just store
tuples in a Tuplestore and
posted mailed
Dennis Bjorklund wrote:
On Sat, 10 Jul 2004, Mike Rylander wrote:
They do, if only to make particular constructs easier to write. This is
an opinion, but for example an EXCEPTION framework for plpgsql would be
easier to implement and use if it used the nested transactions
posted mailed
Dennsnippetssklund wrote:
On Fri, 9 Jul 2004, Mike Rylander wrote:
Nested transactions and savepoints serve two different purposes. They
have some overlap, but for the most part solve two distinct problems.
Then show some examples that illustrait the difference. So far
Dennis Bjorklund wrote:
On Fri, 9 Jul 2004, Bruce Momjian wrote:
I think we agreed on BEGIN NESTED/COMMIT NESTED, and START NESTED
TRANSACTION and COMMIT NESTED TRANSACTION.
Should I read this as pg will get its own implementation of sub
transactions and not implement the almost
On Thursday 01 July 2004 09:26 pm, Scott Marlowe wrote:
On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote:
On Thu, 1 Jul 2004, Mike Rylander wrote:
On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
Hi Mike,
In this release, unfortunately not.
That't too bad, but it's
On Thursday 01 July 2004 08:54 pm, Gavin Sherry wrote:
On Thu, 1 Jul 2004, Mike Rylander wrote:
On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
Hi Mike,
In this release, unfortunately not.
That't too bad, but it's not that urgent I suppose.
I had some idea early
Now that PG will have tablespaces I can stick my really high I/O data on a
fiberchannel array, and save some money by putting the rest of it (also the
majority of it) on less expensive SCSI RAID sets. Will I also be able to
tune individual tablespaces with the likes of random_page_cost? Sorry if
On Tuesday 11 May 2004 09:44 am, Bruce Momjian wrote:
[snip]
Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
Added to TODO:
* Add MERGE command that does UPDATE, or on failure, INSERT
[snip]
Hello all.
I have been lurking here for a bit and the MERGE topic (on
74 matches
Mail list logo