[BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

2013-02-05 Thread luberti
The following bug has been logged on the website: Bug reference: 7851 Logged by: ivano luberti Email address: lube...@archicoop.it PostgreSQL version: 8.4.15 Operating system: Windows 7 Home Premium 64 bits Description: I know this is probalby a duplicate of bug BUG #

[BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly

2013-02-05 Thread nvardar
The following bug has been logged on the website: Bug reference: 7850 Logged by: Nadir Vardar Email address: nvar...@carrieriq.com PostgreSQL version: 9.0.10 Operating system: linux-gridsql Description: I am trying to run below query; SELECT tbl.id, tbl.day,

Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly

2013-02-05 Thread Pavel Stehule
Hello this is not a bug report. please, send your query to pg_general mailing list probably better - ask on gridsql mailing list Regards Pavel Stehule 2013/2/5 : > The following bug has been logged on the website: > > Bug reference: 7850 > Logged by: Nadir Vardar > Email addres

Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

2013-02-05 Thread Dave Page
On Tue, Feb 5, 2013 at 10:45 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7851 > Logged by: ivano luberti > Email address: lube...@archicoop.it > PostgreSQL version: 8.4.15 > Operating system: Windows 7 Home Premium 64 bits > Description:

Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly

2013-02-05 Thread Amit Kapila
Tuesday, February 05, 2013 12:40 PM nvardar wrote: > I am trying to run below query; > > SELECT > tbl.id, > tbl.day, > tbl.week, > tbl.appfailure, > tbl.appname, > tbl.deviceid, > ext6.DIM_NAME, > ext7.DIM_NAME, > ext8.DIM_NAME, > ext9.DIM_NAME, > tbl.st

Re: [GENERAL] [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly

2013-02-05 Thread Alban Hertroys
On 5 February 2013 17:06, Amit Kapila wrote: > Tuesday, February 05, 2013 12:40 PM nvardar wrote: > > throws; > > > > >[Error] Script lines: 1-20 - > > ERROR: Node 2 has aborted execution, cause is: > > com.edb.gridsql.exception.XDBServerException : > > java.lang.NullPoin

[BUGS] BUG #7852: TeamPostgresql is giving error

2013-02-05 Thread yogesh . khandelwal
The following bug has been logged on the website: Bug reference: 7852 Logged by: Yogesh Khandelwal Email address: yogesh.khandel...@emc.com PostgreSQL version: 9.0.8 Operating system: Linux Description: hi, I've deployed TeamPostgreSQL on my server and trying to acce

Re: [BUGS] BUG #7852: TeamPostgresql is giving error

2013-02-05 Thread Magnus Hagander
On Feb 5, 2013 6:20 PM, wrote: > > The following bug has been logged on the website: > > Bug reference: 7852 > Logged by: Yogesh Khandelwal > Email address: yogesh.khandel...@emc.com > PostgreSQL version: 9.0.8 > Operating system: Linux > Description: > > hi, > > I've deployed

[BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-05 Thread jimbob
The following bug has been logged on the website: Bug reference: 7853 Logged by: James Skaggs Email address: jim...@seagate.com PostgreSQL version: 8.4.14 Operating system: RHEL6 Description: After "analyze verbose", the table shows 158 million rows. A select count(1)

Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

2013-02-05 Thread Ivano Luberti
Thanks Dave for your quick answer Il 05/02/2013 16:19, Dave Page ha scritto: If this is a new installation, you should really use 9.2. 8.4 will go out of support in about a year. It is a new installation on my machine, but I use for development and I have to support customers that will still

Re: [BUGS] BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

2013-02-05 Thread Ivano Luberti
Thanks Dave for your quick answer Il 05/02/2013 16:19, Dave Page ha scritto: If this is a new installation, you should really use 9.2. 8.4 will go out of support in about a year. It is a new installation on my machine, but I use for development and I have to support customers that will still

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-05 Thread Kevin Grittner
"jim...@seagate.com" wrote: > INFO:  analyzing "public.stream_file" > INFO:  "stream_file": scanned 3 of 2123642 pages, containing > 184517 live rows and 2115512 dead rows; 3 rows in sample, > 158702435 estimated total rows 184517 live rows in 3 randomly sampled pages out of 2123642

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-05 Thread James R Skaggs
Kevin - Agreed, we shouldn't have so many dead rows. Our autovacuum is set on but has default parameters. We are clustering today. This, of course, means downtime and inconvenience to the users. Here is the troublesome query: select sum(case when t1.cdlc < 0 then 0 else t1.cdlc end) as

Re: [BUGS] BUG #7853: Incorrect statistics in table with many dead rows.

2013-02-05 Thread Kevin Grittner
James R Skaggs wrote: > Agreed, we shouldn't have so many dead rows.  Our autovacuum is > set on but has default parameters.   We are clustering today. > This, of course, means downtime and inconvenience to the users. Right, which is why it's important to figure out why the bloat happened.  Som