1 preceding and 1
following) as sum_rows,
sum(i) over (order by i / 3 range between 1 preceding and 1 following)
as sum_range
==
regards,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
On Sat, January 16, 2010 09:29, Hitoshi Harada wrote:
2010/1/16 Erik Rijkers e...@xs4all.nl:
Thanks for the review. I've found another crash today and attached is
fixed version. The case is:
SELECT four, sum(ten) over (PARTITION BY four ORDER BY four RANGE 1
PRECEDING) FROM tenk1 WHERE
/0001000100FF (log file 1, segment 255): No such file or
directory
This has happened several times, always 'segment' 255, 'log file' 1, 3 or 4.
hth,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
: Broken pipe
LOG: unexpected EOF on client connection
but apparently this is not problematic?
HS/SR is a fantastic set of features. I'll keep hammering away a bit at the
dynamic duo; if you
have specific testing ideas, let me know.
Thanks!
Erik Rijkers
--
Sent via pgsql-hackers mailing
00010001
-rw--- 1 16777216 Feb 3 22:35 0001
Maybe the message is not really a bug: everything works fine otherwise.
thanks,
Erik Rijkers
# primary ./data/postgresql.conf
data_directory = '/var/data1/pg_stuff/pg_installations/pgsql.sr_primary/data
a problem,
but only because I was testing anyway :)
I think most people would do what I did: search the documentation
for the string 'No such file or directory' or 'cannot stat'.
(But that produces no mention of this (non-)problem.)
ISTM mentioning in the documentation is good enough.
Erik Rijkers
it causes/influences this panic.
And to be clear: I realize that one cannot expect a pg_dump at a slave to work:
I only did this
accidentally. Nevertheless, ISTM it shouldn't PANIC...
hth,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Thu, February 18, 2010 23:08, Alvaro Herrera wrote:
Erik Rijkers wrote:
And to be clear: I realize that one cannot expect a pg_dump at a slave to
work:
Hmm, why not?
Because the slave is readonly.
My case was:
pg_dump $pg8.4.2 | psql $slave
I ran this by accident.
I suppose I
On Thu, February 18, 2010 23:32, Andres Freund wrote:
On Thursday 18 February 2010 22:25:35 Erik Rijkers wrote:
localhost:55432 = 8.4.2 instance (ssh tunnel)
/tmp:7575 = a 9.0devel standby
time pg_dump -h localhost -p 55432 -t public.tab_jobs --clean --no-owner
--no-privileges ms | psql -q
as shown?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
PostgreSQL 9.0devel on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.4.3, 64-bit
(1 row)
Is the filename that pg_xlogfile_name_offset(
pg_last_xlog_(replay|receive)_location() ) reports a
bug, or expected as shown?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing
On Wed, February 24, 2010 20:40, Erik Rijkers wrote:
pg_last_xlog_receive_location | pg_xlogfile_name_offset
---+---
E2/C012AD90 | (00E200C0,1224080)
(1 row)
These zero-timeline filenames
(500 GB or
so) into the primary
(eventually I want at the same time run pgbench on both).)
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
to accept read only connections
(btw, I think I have seen this exact same one (File twophase.c, Line: 1201) a
few times before,
without reporting it here, so it might have no connection to this particular
patch. Sorry to be
vague about that)
Is it useful to report these cases of FailedAssertion?
Erik
)
replicas=# select version();
version
--
PostgreSQL 9.0devel-standby on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.4.3, 64-bit
(1 row)
Erik Rijkers
/2010-02/msg02221.php
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Wed, March 3, 2010 15:03, Fujii Masao wrote:
On Tue, Mar 2, 2010 at 10:52 PM, Fujii Masao masao.fu...@gmail.com wrote:
Here is the revised patch. I used new local variable instead of lastPageTLI
to track the tli of last applied record. It is updated with the tli of the
log page header when
On Thu, March 4, 2010 17:00, Erik Rijkers wrote:
in a 9.0devel, primary+standby, cvs from 2010.03.04 01:30
With three patches:
new_smart_shutdown_20100201.patch
extend_format_of_recovery_info_funcs_v4.20100303.patch
fix-KnownAssignedXidsRemoveMany-1.patch
pg_dump -d $db8.4.2
---
quick
(1 row)
This shows that both ^ and parentheses are regex-interpreted, and not
literally as the
release-note text would have one believe.
Perhaps those mentions of substring-change under point 1 and 2 can be removed?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql
, but maybe it's just deemed too elusive to
be assigned a todo
entry.
Was the issue eventually found/solved?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
explanation in the documentation.
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sat, April 10, 2010 01:23, Erik Rijkers wrote:
Using 9.0devel cvs HEAD, 2010.04.08.
I am trying to understand the performance difference
between primary and standby under a standard pgbench
read-only test.
server has 32 GB, 2 quadcores.
primary:
tps = 34606.747930 (including
On Mon, April 12, 2010 14:22, Erik Rijkers wrote:
On Sat, April 10, 2010 01:23, Erik Rijkers wrote:
Oops, typos in that pseudo loop:
of course there was a pgbench init step after that first line.
for scale in 10 100 500 1000
pgbench ... # initialise
sleep ((scale / 10) * 60
resending this message, as it seems to have bounced.
(below, I did fix the typo in the pseudocode loop)
Original Message
Subject: Re: [HACKERS] testing HS/SR - 1 vs 2 performance
From:Erik Rijkers e
This replication test that was working well earlier (it ran daily), stopped
working
after reinstall of new instances of cvs HEAD. I think the change must have been
today (or at least
recent).
This test copies a schema from a 8.4.3 instance to the 9.0 primary:
pg_dump -c -h /tmp -p 5432 -n
On Wed, April 14, 2010 02:34, Erik Rijkers wrote:
This replication test that was working well earlier (it ran daily), stopped
working
after reinstall of new instances of cvs HEAD. I think the change must have
been today (or at least
recent).
This test copies a schema from a 8.4.3 instance
On Wed, April 14, 2010 08:23, Heikki Linnakangas wrote:
Erik Rijkers wrote:
This replication test that was working well earlier (it ran daily), stopped
working
This is probably because of this change:
date: 2010/04/12 09:52:29; author: heikki; state: Exp; lines: +71 -23
Change
primary or standby).
I have no idea what could cause this; is no one else is seeing this ?
(if I have time I'll repeat on other hardware in the weekend)
any comment is welcome...
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Thu, April 22, 2010 23:54, Mark Kirkwood wrote:
Greg Smith wrote:
Erik Rijkers wrote:
This is the same behaviour (i.e. extreme slow standby) that I saw
earlier (and which caused the
original post, btw). In that earlier instance, the extreme slowness
disappeared later, after many
hours
that email was sent,
is that the error can also occur without the postbio package
being been installed (this has happened once).
It's a very easy test; I will probably run it a few more times.
Erik Rijkers wrote:
On Thu, March 4, 2010 17:00, Erik Rijkers wrote:
in a 9.0devel, primary+standby
On Sat, April 24, 2010 00:39, Simon Riggs wrote:
On Fri, 2010-04-23 at 11:32 -0400, Robert Haas wrote:
99% of transactions happen in similar times between primary and standby,
everything dragged down by rare but severe spikes.
We're looking for something that would delay something that
On Sat, April 24, 2010 01:17, Erik Rijkers wrote:
On Sat, April 24, 2010 00:39, Simon Riggs wrote:
On Fri, 2010-04-23 at 11:32 -0400, Robert Haas wrote:
99% of transactions happen in similar times between primary and standby,
everything dragged down by rare but severe spikes.
We're
aberration').
testing is more difficult than I thought...
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, April 26, 2010 08:52, Fujii Masao wrote:
On Mon, Apr 26, 2010 at 3:25 AM, Erik Rijkers e...@xs4all.nl wrote:
FWIW, here are some more results from pgbench comparing
primary and standby (both with Simon's patch).
Was there a difference in CPU utilization between the primary
On Mon, April 26, 2010 09:43, Simon Riggs wrote:
On Sun, 2010-04-25 at 23:52 +0200, Erik Rijkers wrote:
I'll try to repeat this pattern on other hardware; although
if my tests were run with faulty hardware I wouldn't know how/why
that would give the above effect (such a 'regular aberration
On Tue, May 4, 2010 15:40, Robert Haas wrote:
On Tue, May 4, 2010 at 7:46 AM, Srinivas Naik naik.sr...@gmail.com wrote:
Hi Mark,
Please find the below details:
postgresql-8.3
and UBUNTU-8.10 with linux-image-2.6.27.18-standard_810_i386.deb
and its an 32bit Ubuntu.
Err, before you
at the moment not much time for more testing)
thanks,
Erik Rijkers
On Sun, April 25, 2010 21:07, Simon Riggs wrote:
On Sun, 2010-04-25 at 20:25 +0200, Erik Rijkers wrote:
Sorry if it's too much data, but to me at least it was illuminating;
I now understand the effects of the different
On Tue, May 4, 2010 18:19, Simon Riggs wrote:
On Tue, 2010-05-04 at 18:10 +0200, Erik Rijkers wrote:
It would be interesting if anyone repeated these simple tests and
produced evidence that these non-HS.
(Unfortunately, I have at the moment not much time for more testing)
Would you be able
On Tue, May 4, 2010 20:26, Greg Smith wrote:
Erik Rijkers wrote:
OS: Centos 5.4
2 quadcores: Intel(R) Xeon(R) CPU X5482 @ 3.20GHz
Areca 1280ML
primary and standby db both on a 12 disk array (sata 7200rpm, Seagat
Barracuda ES.2)
To fill in from data you already mentioned upthread
,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
, 2009 01:57, Erik Rijkers wrote:
While test building from CVS head on fedora 10 (also on fedora 6), I get:
./configure --prefix=/home/super/pg_stuff/pg_installations/pgsql.cvs_vanilla
--with-pgport=6542
--quiet --enable-depend --with-openssl --with-perl --with-libxml
--with-libxslt
gcc
, install OK, without errors, then initdb:
initializing pg_authid ... ok
setting password ... ok
initdb: The password file was not generated. Please report this problem.
initdb: removing data directory
/home/super/pg_stuff/pg_installations/pgsql.cvs_vanilla/data
hth,
Erik Rijkers
--
Sent
centos 5.4 2.6.18-164.el5 x86_64 GNU/Linux
libxml2.x86_64 2.6.26-2.1.2.8 installed
libxml2-devel.x86_642.6.26-2.1.2.8 installed
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
contrib/stringfunc was missing this small change in contrib/Makefile, I think.
With it, it
installs and runs make check cleanly.
Erik Rijkers
stringfunc_fix.diff
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
into
core, as seems to be the plan.
If you agree, it seems best to include this change in your patch and change
that example
function's name when the stringfunc patch gets applied.
Erik Rijkers
xfunc.sgml.diff
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers
On Thu, July 29, 2010 22:43, Erik Rijkers wrote:
Hi Pavel,
In xfunc.sgml, I came across a function example (for use of VARIADIC in
polymorphic functions),
where the function name is concat(): (in the manual: 35.4.10. Polymorphic
SQL Functions).
Although that is not strictly wrong
On Tue, August 10, 2010 13:18, David Fetter wrote:
On Tue, Aug 10, 2010 at 05:13:22PM +0900, Fujii Masao wrote:
Is it worth allowing pg_restore to accept multiple -t
switches as well as pg_dump?
$ pg_restore -t tbl1 -t tbl2 db.dump
Regards,
Yes. :)
What other functionality in
/data
this is on centos 5.4 - x86_64 GNU/Linux (2.6.18-164.el5)
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Tue, August 17, 2010 19:13, Peter Eisentraut wrote:
On tis, 2010-08-17 at 15:59 +0200, Erik Rijkers wrote:
creating template1 database in
/var/data1/pg_stuff/pg_installations/pgsql.progress_indicator/data/base/1
... FATAL: could not
create unique index pg_proc_oid_index
DETAIL: Key
to not see the full path in the 'keep WAL
file'-message (esp. when it is
repeated many screenfulls).
If only for consistency, this patch adds the path info to that message.
Erik Rijkers--- contrib/pg_archivecleanup/pg_archivecleanup.c.orig 2010-08-22 00:05:06.0 +0200
+++ contrib
On Sun, August 22, 2010 17:54, Tom Lane wrote:
Erik Rijkers e...@xs4all.nl writes:
If only for consistency, this patch adds the path info to that message.
Seems reasonable, but speaking of consistency:
+#ifdef WIN32
+snprintf(WALFilePath, MAXPGPATH, %s\\%s
On Tue, August 24, 2010 08:32, Itagaki Takahiro wrote:
I applied the attached patch to HEAD. concat(), concat_ws(), left(),
right(), and reverse() are in it, but format() and sprintf() are not.
+1 to add also sprintf
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
of contents
for ordering\n
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
. These tables were
simply not created by the pg_migrator-run.
I don't know how this influenced the results,
but I'll repeat it in the coming days.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On Sun, May 10, 2009 02:05, Alvaro Herrera wrote:
Erik Rijkers wrote:
2009.05.09
pg_migrator alpha 5 results
from PostgreSQL 8.3.7 to 8.4cvs
Centos 5.2 x86_64 GNU/Linux
pg_migrator ran without errors.
Of 120 tables, all smaller tables
have the correct rowcount, but all
larger tables
is not used in the postgres docs,
nor is it in the SQL
2008 standard docs.
hth
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
the code, esp. the regex engine hard to understand sofar, so all
the above are
somewhat inconclusive remarks; I hope nonetheless they are useful.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
this is the mystery bug that I
encountered repeatedly
already in 9.0devel; but I was never able to reproduce it reliably. But I
don't think it was ever
solved.
http://archives.postgresql.org/pgsql-hackers/2010-03/msg00223.php
Erik Rijkers
In another test run I had
- set full page
On Sat, January 21, 2012 06:26, Alexander Korotkov wrote:
Hi!
Thank you for your feedback!
On Fri, Jan 20, 2012 at 3:33 AM, Erik Rijkers e...@xs4all.nl wrote:
The patch yields spectacular speedups with small, simple-enough regexen.
But it does not do a
good enough job when guessing where
:
This utility, like most other PostgreSQL utilities, also uses the environment
variables supported
by libpq (see Section 31.13).
I could look into fixing one (binary) or the other (docs), but what /is/ the
preferred behavior?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list
On Sun, February 19, 2012 06:27, Robert Haas wrote:
On Sat, Feb 18, 2012 at 11:58 AM, Erik Rijkers e...@xs4all.nl wrote:
pg_restore ignores environment variable PGDATABASE.
What exactly do you mean by ignores? pg_restore prints results to
standard output unless a database name is specified
2 0 16 1562 1562
_null_ _null_ _null_ _null_ bitge _null_ _null_ _null_ ));
I'd like to try this out a bit; could you see if you can fix it?
thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
', 'Type',
'Description') would not be 3 columns of the same width, like they seem to be
now: the 'Type'
column take fully one third of page-width, for short words like 'text' and
'bigint'. The
'Column' values too are almost always more narrow than 1/3 of the page.
Erik Rijkers
--
Sent via
ecpg.sgml: the the - the--- doc/src/sgml/ecpg.sgml.orig 2012-03-11 10:15:20.0 +0100
+++ doc/src/sgml/ecpg.sgml 2012-03-11 10:15:37.0 +0100
@@ -4038,7 +4038,7 @@
termliteralsqlname//term
listitem
para
-The the name of the field.
+
]: *** [pg_backup_archiver.o] Error 1
make[2]: *** [all-pg_dump-recurse] Error 2
make[2]: *** Waiting for unfinished jobs
make[1]: *** [all-bin-recurse] Error 2
make: *** [all-src-recurse] Error 2
-- make returned 2 - abort
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
] Error 2
make: *** [all-src-recurse] Error 2
-- make returned 2 - abort
I should add: Centos 5.8, gcc 4.6.3
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
, installs and runs OK.
(obviously I haven't
tested anything yet)
Linux Centos 5.4
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, December 20, 2010 22:55, Erik Rijkers wrote:
On Mon, December 20, 2010 22:35, Dimitri Fontaine wrote:
During configure I spotted this:
[...]
checking for bison... /usr/bin/bison
configure: using bison (GNU Bison) 2.3
gawk: { if ($4 1.875-extension) exit 0; else exit 1;}
gawk
On Mon, December 20, 2010 22:35, Dimitri Fontaine wrote:
I might be mistaken but it looks like a doc/src/sgml/ref/alter_extension.sgml
is missing?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Tue, December 21, 2010 09:57, Dimitri Fontaine wrote:
Erik Rijkers e...@xs4all.nl writes:
I might be mistaken but it looks like a
doc/src/sgml/ref/alter_extension.sgml is missing?
Mmm, it seems that git was agreeing with you, so here's it:
git ls-files doc/src/sgml/ref
];
==
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
I realize that
... WHERE ir @ range(5);
fixes the problem, but it would be
really nice to have it work on integers)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
() = infinite lower bound, inclusive upper bound
I still want to do Performance review and Coding review.
FWIW, I would like to repeat that my impression is that the patch is very
stable, especially with
regard to the intranges (tested extensively).
regards,
Erik Rijkers
--
Sent via pgsql
cleanly.
Erik Rijkers
As always, my repo is here:
http://git.postgresql.org/gitweb?p=users/jdavis/postgres.git;a=log;h=refs/heads/rangetypes
Regards,
Jeff Davis
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
pg_archivecleanup deleting files, it
would seem that some
bug exists but I haven't followed changes regarding WAL too closely.
(My apologies if it's a config mistake on my part after all; but in that case:
I cannot find it
and would be thankful for a hint)
Thanks,
Erik Rijkers
--
Sent via
]: *** [trgm_regexp.o] Error 1
make: *** [all-pg_trgm-recurse] Error 2
trgm_regexp.c:73:2: error: unknown type name TrgmStateKey
make[1]: *** [trgm_regexp.o] Error 1
make: *** [install-pg_trgm-recurse] Error 2
Did I forget something?
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing
versions 0.6,
and 0.7.
Erik Rijkers
trgm_compare.txt.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
'generalise' them, but for now I'll
send them as they are.
Erik Rijkers
create_data.sh
Description: application/shellscript
trgm_regex_test.pl
Description: Perl program
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
and then part 2 does not.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
backup completed
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sat, December 15, 2012 14:10, Magnus Hagander wrote:
On Sat, Dec 15, 2012 at 11:39 AM, Erik Rijkers e...@xs4all.nl wrote:
from 9.3devel (this morning):
The truncated name in parentheses only shows up during the filling of the
new PGDATA; when 100%
is
reached that part of the displayed
between HEAD,
versions 6, 7, 8. (BTW, is v6 still interesting?)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Mon, December 17, 2012 09:54, Pavel Stehule wrote:
Helllo
I try to search simple solution and I didn't find anything. It is possible?
Perhaps not strictly 1 commandline but I often use this:
echo '\timing on \\ select 1+2' | psql
Erik Rijkers
--
Sent via pgsql-hackers mailing list
to diversify the test program; it
is now too simple.
Thanks,
Erik Rijkers
trgmre_6_7_9.txt.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
am also
trying to get your patch to fall over ;-))
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
that uses
these new options. I
can hack something together myself, but I just thought I'd ask.
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Connections
/tmp:6000 - No Response
which looks unusual to me, could we please make it all lower-case?
TYhanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Sun, January 13, 2013 22:09, Tom Lane wrote:
BTW, although Erik claimed this behaved more sanely in 9.2, a closer
look at the commit logs says that the bogus commit shipped in 9.2,
so AFAICS it's broken there too. But earlier releases would have
rejected the SET as expected. I think we
On Wed, January 23, 2013 08:36, Alexander Korotkov wrote:
Hi!
Some quick answers to the part of notes/issues. I will provide rest of
answers soon.
[...]
trgm-regexp-0.10.patch.gz27 k
Trying to build this I get, after 'make install' in contrib/ :
/usr/bin/install: cannot stat
\\ \echo :y
1
2
testdb=# select 1,2 \gset x,y \\ \echo :x
\gset: syntax error
testdb=#
It'd be nice if it could be made to work
Thanks
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On Fri, October 19, 2012 11:00, Kohei KaiGai wrote:
I confirmed I could apply the latest patch cleanly.
FWIW, I spent a few sessions (amounting to a few hours) trying to break, or get
past SET ROW LEVEL
SECURITY and have not yet succeeded. So far so good.
(I haven't looked at code)
Erik
VERSION
integer_value|
character_value | 09.02.
comments |
I would expect 9.2.1 to contain '09.02.0001' (not '09.02.').
Unless, of course, I have overlooked some step in the upgrade...
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list
keystrokes and errors.
Tab-completion is great and this search_path-annoyance happens to me all the
time; my fingers
can't seem to learn this exception.
(pgsql 9.2devel, problem also in latest 9.1.3)
Thanks,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers
are somewhat arbitrary, it does show some of the
good, the bad and
the ugly of the patch(es). (Also: I've limited the tests to a range of
'workable' regexps, i.e.
avoiding unbounded regexps)
hth (and thanks, great work!),
Erik Rijkers
trgm_regex_test.out.20120429_1300.txt.gz
Description: GNU Zip
)
And perhaps (same paragraph):
The previous query values are preserved, allowing for enhanced analysis.
would be clearer as:
The last query values are preserved, allowing for enhanced analysis.
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
not a likely scenario, but surely such a deviating rowcount on a sync
replica should not
be possible?
thank you,
Erik Rijkers
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
: synchronous_commit = on
Thanks,
Erik Rijkers
- Original Message -
AMD FX 8120 / centos 6.2 / latest source (git head)
It seems to be quite easy to force a 'sync' replica to not be equal
to master by
recreating+loading a table in a while loop.
For this test I compiled+checked+installed three
On Thu, May 17, 2012 16:10, Ants Aasma wrote:
On Thu, May 17, 2012 at 4:53 PM, Erik Rijkers e...@xs4all.nl wrote:
The count(*) was done in the way that I showed, i.e. *after* psql had
exited. My understanding
is
that, with synchronous replication 'on' and configured properly, psql could
was disabled), and how the crash came
quickly when I
switched it on (to add the select count(*) statements).
Erik Rijkers
logfile.head2
Description: Binary data
logfile.head1
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
1 - 100 of 353 matches
Mail list logo
