Re: [BUGS] BUG #8450: pg_basebackup blocks until WAL archiving successful

2013-09-25 Thread Stuart Bishop
On Mon, Sep 23, 2013 at 3:33 PM, Heikki Linnakangas > I can see why you'd want that, but it seems equally problematic to let > pg_basebackup return, when the WAL files haven't been archived yet and you > therefore don't in fact have valid, restorable backup yet. Have you > considered using the --x

Re: [BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-09-25 Thread Alvaro Herrera
o...@ohmu.fi wrote: > The following code performs a lot slower on PostgreSQL 9.3.0 than on > PostgreSQL 9.2.4: > > DROP TABLE IF EXISTS tmp; > CREATE TABLE tmp (id BIGSERIAL, vals BIGINT[]); > DO $$ > DECLARE > r_id BIGINT; > n BIGINT; > BEGIN > FOR n IN 1..1000 LOOP > BEGIN

[BUGS] BUG #8470: 9.3 locking/subtransaction performance regression

2013-09-25 Thread os
The following bug has been logged on the website: Bug reference: 8470 Logged by: Oskari Saarenmaa Email address: o...@ohmu.fi PostgreSQL version: 9.3.0 Operating system: Linux Description: The following code performs a lot slower on PostgreSQL 9.3.0 than on PostgreSQL

Re: [BUGS] BUG #8468: Create index on type tstzrange fail

2013-09-25 Thread Heikki Linnakangas
On 24.09.2013 14:42, marian.kruc...@gmail.com wrote: CREATE INDEX ON tstzrange fail on 9.3.0 and 9.2.4 - default postgres configuration. It ate whole memory and was killed by oom. Example: postgres=# CREATE TABLE range_test AS SELECT tstzrange(t, t+'1min') tr FROM generate_series('2000-1-1'::TI

Re: [BUGS] Errors during PostgreSQL 9.2 and 9.3 installation

2013-09-25 Thread Sandeep Thakkar
Hi Please send the installation log (install-postgresql.log) from the temp. That will help us to know what went wrong. On Wed, Sep 25, 2013 at 2:44 AM, Volberg, Ovsei < ovsei.volb...@scientificgames.com> wrote: > The error message is attached. The computer was Windows 7, 32-bit > machine. Ple