Re: [HACKERS] review: More frame options in window functions

2010-01-15 Thread Erik Rijkers
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

Re: [HACKERS] review: More frame options in window functions

2010-01-16 Thread Erik Rijkers
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

[HACKERS] testing cvs HEAD - HS/SR - missing file

2010-01-26 Thread Erik Rijkers
/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

Re: [HACKERS] testing cvs HEAD - HS/SR - missing file

2010-01-27 Thread Erik Rijkers
: 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

[HACKERS] testing cvs HEAD - HS/SR - cannot stat

2010-02-03 Thread Erik Rijkers
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

Re: [HACKERS] testing cvs HEAD - HS/SR - cannot stat

2010-02-04 Thread Erik Rijkers
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

[HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread 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

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-18 Thread Erik Rijkers
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

Re: [HACKERS] testing cvs HEAD - HS/SR - PANIC: cannot make new WAL entries during recovery

2010-02-19 Thread Erik Rijkers
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

[HACKERS] testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset

2010-02-24 Thread Erik Rijkers
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

Re: [HACKERS] testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset

2010-02-24 Thread Erik Rijkers
-- 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

Re: [HACKERS] testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset

2010-02-24 Thread Erik Rijkers
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

Re: [HACKERS] Streaming replication and pg_xlogfile_name()

2010-02-25 Thread Erik Rijkers
(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

[HACKERS] Assertion failure twophase.c (testing HS/SR)

2010-02-26 Thread Erik Rijkers
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

[HACKERS] one-off error in to_char formatting

2010-03-04 Thread Erik Rijkers
) 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

[HACKERS] Assertion failure twophase.c (2) (testing HS/SR)

2010-03-04 Thread 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

Re: [HACKERS] Streaming replication and pg_xlogfile_name()

2010-03-04 Thread Erik Rijkers
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

Re: [HACKERS] Assertion failure twophase.c (3) (testing HS/SR)

2010-03-14 Thread Erik Rijkers
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

[HACKERS] Release Notes 9.0: substring() changes?

2010-04-04 Thread Erik Rijkers
--- 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

Re: [HACKERS] Remaining Streaming Replication Open Items

2010-04-06 Thread Erik Rijkers
, 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

[HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-09 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-12 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-12 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-12 Thread Erik Rijkers
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

[HACKERS] testing HS/SR - invalid magic number

2010-04-13 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - invalid magic number

2010-04-13 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - invalid magic number

2010-04-15 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-22 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-22 Thread Erik Rijkers
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

Re: [HACKERS] Assertion failure twophase.c (3) (testing HS/SR)

2010-04-22 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-23 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-25 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-25 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-26 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-26 Thread Erik Rijkers
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

Re: [HACKERS] Reg: SQL Query for Postgres 8.4.3

2010-05-04 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-05-04 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-05-04 Thread Erik Rijkers
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

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-05-04 Thread Erik Rijkers
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

[HACKERS] underscore split to alias

2010-05-14 Thread Erik Rijkers
, 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

Re: [HACKERS] initdb: The password file was not generated.

2009-09-02 Thread Erik Rijkers
, 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

[HACKERS] initdb: The password file was not generated.

2009-09-02 Thread Erik Rijkers
, 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

Re: [HACKERS] [PATCH] Add XMLEXISTS function from the SQL/XML standard (was: Add xpath_exists Function)

2010-05-25 Thread Erik Rijkers
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

Re: [HACKERS] patch (for 9.1) string functions

2010-07-10 Thread Erik Rijkers
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

Re: [HACKERS] patch (for 9.1) string functions

2010-07-29 Thread Erik Rijkers
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

Re: [HACKERS] patch (for 9.1) string functions ( correct patch attached )

2010-07-29 Thread Erik Rijkers
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

Re: [HACKERS] pg_restore should accept multiple -t switches?

2010-08-10 Thread Erik Rijkers
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

Re: [HACKERS] Progress indication prototype

2010-08-17 Thread Erik Rijkers
/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

Re: [HACKERS] Progress indication prototype

2010-08-17 Thread Erik Rijkers
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

[HACKERS] pg_archivecleanup debug message consistency

2010-08-21 Thread Erik Rijkers
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

Re: [HACKERS] pg_archivecleanup debug message consistency

2010-08-22 Thread Erik Rijkers
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

Re: [HACKERS] patch (for 9.1) string functions

2010-08-24 Thread Erik Rijkers
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

[HACKERS] pg_restore --clean text

2008-12-26 Thread Erik Rijkers
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

[HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-08 Thread Erik Rijkers
. 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

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-09 Thread Erik Rijkers
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

[HACKERS] 8.4 release notes Recursive Joins

2009-06-14 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-01-19 Thread Erik Rijkers
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

Re: [HACKERS] Online base backup from the hot-standby

2012-01-20 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-01-20 Thread Erik Rijkers
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

[HACKERS] pg_restore ignores PGDATABASE

2012-02-18 Thread Erik Rijkers
: 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

Re: [HACKERS] pg_restore ignores PGDATABASE

2012-02-18 Thread Erik Rijkers
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

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

2012-02-21 Thread Erik Rijkers
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

Re: [HACKERS] pgstat documentation tables (pdf OK on centos)

2012-02-27 Thread Erik Rijkers
', '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

[HACKERS] ecpg.sgml: the the - the

2012-03-11 Thread Erik Rijkers
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. +

Re: [HACKERS] patch for parallel pg_dump

2012-03-19 Thread Erik Rijkers
]: *** [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

Re: [HACKERS] patch for parallel pg_dump

2012-03-19 Thread Erik Rijkers
] 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

Re: [HACKERS] Extensions, patch 22 (cleanup, review, cleanup)

2010-12-20 Thread Erik Rijkers
, 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

Re: [HACKERS] Extensions, patch 22 (cleanup, review, cleanup)

2010-12-20 Thread Erik Rijkers
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

Re: [HACKERS] Extensions, patch 22 (cleanup, review, cleanup)

2010-12-20 Thread Erik Rijkers
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:

Re: [HACKERS] Extensions, patch 22 (cleanup, review, cleanup)

2010-12-21 Thread Erik Rijkers
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

Re: [HACKERS] MULTISET patch

2011-01-06 Thread Erik Rijkers
]; == 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

Re: [HACKERS] Range Types - cache lookup failed for function

2011-02-06 Thread Erik Rijkers
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

Re: [HACKERS] REVIEW Range Types

2011-02-08 Thread Erik Rijkers
() = 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

Re: [HACKERS] Range Types (catversion.h)

2011-02-10 Thread Erik Rijkers
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

[HACKERS] 9.3 pg_archivecleanup broken?

2012-11-18 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-11-19 Thread Erik Rijkers
]: *** [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

Re: [HACKERS] WIP: index support for regexp search

2012-12-01 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-12-02 Thread Erik Rijkers
'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

Re: [HACKERS] [v9.3] writable foreign tables

2012-12-12 Thread Erik Rijkers
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

[HACKERS] small pg_basebackup display bug

2012-12-15 Thread Erik Rijkers
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

Re: [HACKERS] small pg_basebackup display bug

2012-12-15 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-12-17 Thread Erik Rijkers
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

Re: [HACKERS] is possible enforce \timing on from command line

2012-12-17 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-12-17 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2012-12-18 Thread Erik Rijkers
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

Re: [HACKERS] foreign key locks

2012-12-22 Thread Erik Rijkers
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

Re: [HACKERS] [WIP] pg_ping utility

2012-12-23 Thread Erik Rijkers
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

[HACKERS] erroneous restore into pg_catalog schema

2013-01-13 Thread Erik Rijkers
, 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

Re: [HACKERS] erroneous restore into pg_catalog schema

2013-01-13 Thread Erik Rijkers
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

Re: [HACKERS] WIP: index support for regexp search

2013-01-24 Thread Erik Rijkers
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

Re: [HACKERS] proposal - assign result of query to psql variable

2012-10-13 Thread Erik Rijkers
\\ \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

Re: [HACKERS] [v9.3] Row-Level Security

2012-10-19 Thread Erik Rijkers
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

[HACKERS] sql_implementation_info still contains old value

2012-10-25 Thread Erik Rijkers
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

[HACKERS] psql: tab-completion fails SET var=

2012-03-30 Thread Erik Rijkers
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

Re: [HACKERS] Patch: add conversion from pg_wchar to multibyte

2012-04-29 Thread Erik Rijkers
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

Re: [HACKERS] Draft release notes complete

2012-05-09 Thread Erik Rijkers
) 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

[HACKERS] master and sync-replica diverging

2012-05-17 Thread Erik Rijkers
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

Re: [HACKERS] master and sync-replica diverging

2012-05-17 Thread Erik Rijkers
: 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

Re: [HACKERS] master and sync-replica diverging

2012-05-17 Thread Erik Rijkers
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

[HACKERS] FailedAssertion(!(PrivateRefCount[i] == 0), File: bufmgr.c, Line: 1741

2012-05-26 Thread Erik Rijkers
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   2   3   4   >