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 idea is to offer two new
>> operators, NORMALIZE and ALIG
?
>
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_similarit
around 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 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
> example code
rate this into quorum commit
> to express 3 of 5 "reporting" standbys, 1 "berlin" standby and 1 "tokyo"
> standby from a group of multiple per data center, or even just utilize role
> sizes of 1 if you wanted individual standbys to be "named" in th
ity to simply return a
> truth value
> in the way that we need?.
You could do something like this (untested):
CREATE OR REPLACE 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;
$$
) are and the data
types of the elements, simply by removing the redundant object keys.
This function would 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:
mit, which it isn't. But if we name it
> something like:
>
> # -1 = no timeout
> # 0 = kill conflicting queries immediately
> # > 0 wait for N seconds, then kill query
> standby_conflict_timeout = -1
>
> it's more clear that the setting is a timeout for each *c
o far. It violates the JS part of JSON ...
> I don't think we should because doing so would be rather zany. It
> would mean JSON content could be invalid in value context, as in:
>
> // JavaScript
> var content = "key" : "value";
>
Right.
Thanks, Joseph. I
ms, not
> humans.
> * Output is expected to be valid JSON and work anywhere JSON should work.
> * Strict JSON 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-
On Sun, Mar 28, 2010 at 8:33 PM, Robert Haas wrote:
> On Sun, Mar 28, 2010 at 8:23 PM, Mike Rylander wrote:
>> In practice, every parser/serializer I've used (including the one I
>> helped write) allows (and, often, forces) any non-ASCII character to
>> be encoded as
t a matter of scanning for multi-byte sequences and
replacing those with their \u equivalents. I have some simple 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 a
nteger
> 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
| E
t TEXT columns, as the
xml2 versions do. I hope these (attached) will be of some help to
others. Note, these are not the exact 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 Rylan
e, in this case the uuid element.
> The API is less intuitive than the previous incarnation and is, indeed,
> more difficult to use.
It may 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 se
l\.myclass/uuid/text()',
XMLPARSE(CONTENT datum)))[1] 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
Sorry, forgot to reply-all.
-- Forwarded message --
From: Mike Rylander
Date: Wed, Jul 8, 2009 at 4:17 PM
Subject: Re: [HACKERS] tsvector extraction patch
To: Alvaro Herrera
On Wed, Jul 8, 2009 at 3:38 PM, Alvaro
Herrera wrote:
> Mike Rylander escribió:
>> On Fri, Ju
+--
> good | 8
> patch | 9
> pretti | 3
> 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
umption.
>
> Now, if we had a DSL line we could hook it to, I could see using it for the
> buildfarm; 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,
files are not
particularly compressable to be sure, but due to (and given) the
nature of the data bzip2 works pretty well, and much better than gzip.
>
> So you may have some kB changes in the wal logfile every minute but you
> still copy 16 MB data. Sure, it's not so much - but if you rot
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 usel
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
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 ta
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://georgialibr
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
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
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
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
> > >> do
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 dif
avoided.
Thanks 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/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.
>
x27;ve seen on -hackers, nothing surrounding explicit
support for said issue jumped out at me.
Thanks again.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 7: You
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 U
s, Florian Pflug
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://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, 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 t
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
t.
Please let me know 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)
tp://www.enterprisedb.com
---(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
ll.org/~hjort
CELEPAR - Cia 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 chec
>
>
> -------(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
>
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
2;
$$ LANGUAGE SQL STABLE;
-- And then wrap 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 Develop
My Own Twin" from the Discovery Health Channel.
Couldn't find a link from the official page, but:
http://www.globalspin.com/mt/archives/000547.html .
> --
> "cbbrowne","@","gmail.com"
> http://linuxdatabases.info/info/lsf.html
> "Ca
aybe
> their retinal scan. Of course, that could change due to serious injury.
> Maybe some kind 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
Databas
TL for the
DNS record, and not a reload of our config.
just my $0.02.
>
> Jon
>
> --
> Jon Jensen
> End Point Corporation
> http://www.endpoint.com/
> Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...
>
> ---(end of broadcast)--
.
> We cannot decide this sort of thing just by debate alone. So, I'll leave
> this as a less potentially fruitful line of enquiry.
>
> Best Regards, Simon Riggs
>
>
> ---(end of broadcast)---
> TIP 5: don't forget to
dl -lm -lbsd
VERSION = PostgreSQL 8.1RC1
--
==
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
't really
> know PAM...
>
Most of the work has already been done:
http://pgina.xpasystems.com/
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
d of special casing single-OUT functions? If I understand
correctly, Tom has just added a test to make single-OUT 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) beh
functions with one OUT param would be the same as
a function returning a rowtype with only one column, 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
t/smallest of the non-null inputs)?
>
[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
query for tenk2 from above? I'd be very interested to see if the
bitmap forced TID order fetch actually does help, or if it's
outweighed by the bitmap setup overhead.
TIA
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
--
BALLY UNIQUE (unique_column);
That could use a bitmapped OR scan of indexes on "unique_column" on
the base table and all descendant tables to check for a unique value
across a "partitioned table". Hmmm... thinking more, I suppose it
could just to a quick scan of
the new code did to
your test query...), or a seq scan.
> Things will get more interesting once we can AND the results of
> unrelated indexes ...
I can't wait! How close to initial testing is the AND stuff for
unrelated indexes? Could this bitmapping code be used to combine
indexes
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_og
time ./pg_test -unrolled 10
test Unrolled(5): 10
real0m3.347s
user 0m3.343s
sys 0m0.000s
Hope the numbers help!
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)
001001000
2 | 1001011
3 | 010110100010110
ctids
1 | {2,5,8,11}
2 | {0,7,9,14}
3 | {1,3,4,6,10,12,13}
The index scan would do bitwise a OR on bitmaps 1 and 3, find the
possition of the "1"s, jump to those possitions in the ctid array, and
bounce to t
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 design
tats. The planner
would be able to choose a multi index scan based on multiple single
column stat entries 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:/
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 int
#x27;re merrie than you know. :)
> -alex
>
> ---(end of broadcast)---
> TIP 3: 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 l
developer to use 'eval', but that is a familiar
concept to defensive developers.
--
Mike Rylander
[EMAIL PROTECTED]
GPLS -- PINES Development
Database Developer
http://open-ils.org
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
work, Matt. 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
ECT statement after replacing the TG_* identifiers
with their respective values.
Your first example is essentially
IF (SELECT (TG_OP = '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
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 hav
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,
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
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
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
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 th
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 ne
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 an
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 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
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,
> > > >
rt, but with some
pointers I'll do what I can!
-miker
>
> Gavin
>
> On Mon, 28 Jun 2004, Mike Rylander wrote:
> > 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
> &g
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
78 matches
Mail list logo
