[BUGS] BUG #7610: planner get wrong rows estimate with LIKE operator

2012-10-16 Thread sam
The following bug has been logged on the website: Bug reference: 7610 Logged by: Sam Wong Email address: s...@hellosam.net PostgreSQL version: 9.2.1 Operating system: Windows 7 64-bit Description: Repro SQL: CREATE TABLE a (id text, primary key (id)); INSERT INTO a

Re: [BUGS] BUG #7578: Not able to drop user if S/he has permission on tablespace

2012-10-16 Thread Alvaro Herrera
Nikolay escribió: > Where can I found this path? http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=412a4295b5390cfe4fd5b9fc84a25c6e2d1aa0ad You can also download the 9.1 snapshot from ftp.postgresql.org/pub/snapshot/9.1, which should already contain this patch. -- Álvaro Herrera

Re: [BUGS] EnterpriseDB Advanced Server 8.2 Supported Platforms

2012-10-16 Thread Christopher Browne
On Tue, Oct 16, 2012 at 2:24 AM, Ricky Wong wrote: > EnterpriseDB team, > > ** ** > > I was wondering which Linux OS (i.e. CentOS) the Advanced Server 8.2 > supports. > > ** ** > > I was able to found Documentation for 8.3 (but not 8.2): > > http://www.enterprisedb.com/docs/en/8.3/ser

Re: [BUGS] BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.

2012-10-16 Thread Hedén Daniel
I had never changed `join_collapse_limit` it is still out commented is this not default. When I try to run EXPLAIN ANALYZE on my query in PostgreSQL 9.2.1 it runs for 6 hours (21724001 ms) and then gives this error: ERROR: could not load library "C:/Program Files/PostgreSQL/9.2/lib/postgis-2.

[BUGS] EnterpriseDB Advanced Server 8.2 Supported Platforms

2012-10-16 Thread Ricky Wong
EnterpriseDB team, I was wondering which Linux OS (i.e. CentOS) the Advanced Server 8.2 supports. I was able to found Documentation for 8.3 (but not 8.2): http://www.enterprisedb.com/docs/en/8.3/server/supported-platforms.html Wonder if you can provide reference for 8.2 (similar to the

Re: [BUGS] BUG #7598: Loss of view performance after dump/restore of the view definition

2012-10-16 Thread Vaclav Juza
And if it helps, see below results of my explain(analyze, buffers) where it is worse on 9.2.1 than on 9.1.4 (both on the same hardware): Original view: pg 9.1.4: Nested Loop (cost=237.46..289.36 rows=1 width=254) (actual time=3998.609..5870.697 rows=1848 loops=1) Buffers: shared hit=1044261 re

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-10-16 Thread Heikki Linnakangas
On 15.10.2012 19:31, Fujii Masao wrote: On Mon, Oct 15, 2012 at 11:27 PM, Heikki Linnakangas wrote: On 15.10.2012 13:13, Heikki Linnakangas wrote: Oh, I didn't remember that we've documented the specific structs that we pass around. It's quite bogus anyway to explain the messages the way we

Re: [Spam] Re: [BUGS] BUG #7577: JDBC Driver - Compiled with Java 7

2012-10-16 Thread Craig Ringer
On 10/16/2012 08:10 PM, Sean Hogan wrote: On 12-10-16 12:08 AM, Craig Ringer wrote: On 10/15/2012 11:10 PM, seancompusult wrote: Does anyone have a solution for people like me who must use Java 5? I had no problems building current git head of the JDBC driver with Java SE 5, nor the REL_9_2_S

Re: [Spam] Re: [BUGS] BUG #7577: JDBC Driver - Compiled with Java 7

2012-10-16 Thread Sean Hogan
On 12-10-16 12:08 AM, Craig Ringer wrote: On 10/15/2012 11:10 PM, seancompusult wrote: Does anyone have a solution for people like me who must use Java 5? I had no problems building current git head of the JDBC driver with Java SE 5, nor the REL_9_2_STABLE branch. Ah, quite right. I was

Re: [BUGS] BUG #7598: Loss of view performance after dump/restore of the view definition

2012-10-16 Thread Vaclav Juza
I was doing the test on the released 9.2.1 (without the patch). The times of the query with the original view were floating around those values, so it's maybe just a luck that it was slightly slower on 9.2.1. The big difference was after the view was restored with the explicit cast. The purpose of

Re: [BUGS] BUG #7606: service restart failed

2012-10-16 Thread Magnus Hagander
On Tue, Oct 16, 2012 at 4:33 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7606 > Logged by: James > Email address: jameshun...@163.com > PostgreSQL version: 9.2.1 > Operating system: CentOS 6.2 > Description: > > When I modify the "listen_