/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
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
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
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
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
,
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, 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
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 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 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
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 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
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 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
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
, 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
---
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
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
)
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
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
(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
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
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
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
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
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
: 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
/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
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
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
, 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
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
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
. 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
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
301 - 353 of 353 matches
Mail list logo