[GENERAL] four template0 databases after vacuum

2016-02-06 Thread Kazuaki Fujikura
Hi there, Version: 9.1.6 running since Dec, 2014 We have 3 different databases. [problem history/background] Jan 10th, 2016: The first problem was autovacuum issue. - autovacuum could not finish successfully. - I set autovacuum_freeze_max_age to 2 hundreds million. - autovacuum immediately finis

Re: [GENERAL] Cannot install Extention plperl in 9.5

2016-02-06 Thread Adrian Klaver
On 02/06/2016 02:21 PM, Alex Magnum wrote: Hi, I installed 9.5 as described in http://tecadmin.net/install-postgresql-9-5-on-centos/ on centos7. Is there a problem with the Repo or do I miss something? [local]:template1=# \dx List of installed extensions

[GENERAL] Cannot install Extention plperl in 9.5

2016-02-06 Thread Alex Magnum
Hi, I installed 9.5 as described in http://tecadmin.net/install-postgresql-9-5-on-centos/ on centos7. Is there a problem with the Repo or do I miss something? [local]:template1=# \dx List of installed extensions Name | Version | Schema |

Re: [GENERAL] Asp.net 5 and EF6

2016-02-06 Thread Arjen Nienhuis
On Thu, Feb 4, 2016 at 5:46 PM, FarjadFarid(ChkNet) wrote: > > > Hi I am trying to use certain features of Asp.net 5 using postgresql using > EF6. > I think you can use EF6, but not with .NET Core. It's possible to use Aap.net 5 without .NET Core. > > > I have downloaded the latest unstable vers

Re: [GENERAL] strange sql behavior

2016-02-06 Thread Peter J. Holzer
On 2016-02-01 12:35:35 -0600, Yu Nie wrote: > Recently I am working with a large amount of taxis GIS data and had > encountered > some weird performance issues.  I am hoping someone in this community can help > me figure it out. > > The taxi data were loaded in 5 minute block into a table.  I hav