[BUGS] BUG #3179: crash when canceling avacuum

2007-03-21 Thread
The following bug has been logged online: Bug reference: 3179 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: FreeBSD 6.2 Description:crash when canceling avacuum Details: I started a vacuumdb -a -v -z then changed my mind to

[BUGS] BUG #3180: Postmaster Services

2007-03-21 Thread Sudarshan V Tantry
The following bug has been logged online: Bug reference: 3180 Logged by: Sudarshan V Tantry Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.8.2 Operating system: windows Description:Postmaster Services Details: The Postmaster service(postgres login) install

Re: [BUGS] BUG #3180: Postmaster Services

2007-03-21 Thread Magnus Hagander
On Wed, Mar 21, 2007 at 08:02:49AM +, Sudarshan V Tantry wrote: > > The following bug has been logged online: > > Bug reference: 3180 > Logged by: Sudarshan V Tantry > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.3.8.2 > Operating system: windows > Description

Re: [BUGS] BUG #3179: crash when canceling avacuum

2007-03-21 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > > The following bug has been logged online: > > Bug reference: 3179 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.0 > Operating system: FreeBSD 6.2 > Description:crash when canceling avacuum > Details: > > I st

[EMAIL PROTECTED]: Re: [BUGS] BUG #3179: crash when canceling avacuum]

2007-03-21 Thread Alvaro Herrera
- Forwarded message from Cstdenis <[EMAIL PROTECTED]> - From: Cstdenis <[EMAIL PROTECTED]> To: Alvaro Herrera <[EMAIL PROTECTED]> Date: Wed, 21 Mar 2007 10:44:49 -0700 (PDT) Subject: Re: [BUGS] BUG #3179: crash when canceling avacuum X-Bogosity: Ham, tests=bogofilter, spamicity=0.00, v

[BUGS] Very slow bytea extraction

2007-03-21 Thread [EMAIL PROTECTED]
Hi, before writing to this list I've tried to solve the problem discussing it in the pgsql-performance mailing list but I wasn't able to solve it. The problem is as follows. My test db only contains a single table with some varying-text field and a bytea field. When inserting data into this t

Re: [EMAIL PROTECTED]: Re: [BUGS] BUG #3179: crash when canceling avacuum]

2007-03-21 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > - Forwarded message from Cstdenis <[EMAIL PROTECTED]> - > Mar 20 22:29:48 ayu postgres[60274]: [1-1] ERROR: canceling statement due > to user request > Mar 20 22:29:48 ayu postgres[60274]: [1-2] STATEMENT: VACUUM FULL VERBOSE > ANALYZE; > Mar 2

Re: [BUGS] Very slow bytea extraction

2007-03-21 Thread Tom Lane
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > The test table has 36 records and each bytea field > contains a 250KB object. A (SELECT byteafield FROM table) takes more > than 1 minute to execute. Hm, it takes about 4 seconds here, on a fairly old and slow machine: $ time psql -A -c "select

[BUGS] "Relation not found" error but table exits.

2007-03-21 Thread TANIDA Yutaka
Hi, My customer found a problem about PL/pgsql functions and TRUNCATE command. If you execute PL/pgsql function includeing TRUNCATE command concurrently, causes "relation ... does not exist." or "relation with OID X does not exist" against exists table. Here's a testcase to reproduce this.

Re: [BUGS] "Relation not found" error but table exits.

2007-03-21 Thread Heikki Linnakangas
TANIDA Yutaka wrote: Hi, My customer found a problem about PL/pgsql functions and TRUNCATE command. If you execute PL/pgsql function includeing TRUNCATE command concurrently, causes "relation ... does not exist." or "relation with OID X does not exist" against exists table. ... In my test