Hi.
I propose to add in pg_env.sh line
export LD_LIBRARY_PATH=:$LD_LIBRARY_PATH
Postgres not need it but PgAdmin yes.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I am using PostgreSQL 9.2 and while trying to vacuum db named mcfdb3, i am
getting below error.
DETAIL: 0 index row versions were removed.
110 index pages have been deleted, 110 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "i1409226645953" now contains 374682
Hi
Why is there limit on the number of cube dimensions?
It is bit strange because ARRAY has no such limit which is similar to cube.
Does it relate to Rtree?
Can I use 1 dimensional cube without R-tree?
---
sato
Shida Sato wrote
> Hi
>
> Why is there limit on the number of cube dimensions?
> It is bit strange because ARRAY has no such limit which is similar to
> cube.
> Does it relate to Rtree?
> Can I use 1 dimensional cube without R-tree?
>From the docs: http://www.postgresql.org/docs/9.4/static/cu
David G Johnston writes:
> Shida Sato wrote
>> Why is there limit on the number of cube dimensions?
>> From the docs: http://www.postgresql.org/docs/9.4/static/cube.html
> "To make it harder for people to break things, there is a limit of 100 on
> the number of dimensions of cubes. This is set in
On 01/09/14 09:05, Shida Sato wrote:
Hi
Why is there limit on the number of cube dimensions?
It is bit strange because ARRAY has no such limit which is similar to
cube.
Does it relate to Rtree?
Can I use 1 dimensional cube without R-tree?
---
sato
Have you calculated how much disc space y
On Sun, Aug 31, 2014 at 11:22 PM, pasma...@gmail.com
wrote:
> I propose to add in pg_env.sh line
> export LD_LIBRARY_PATH=:$LD_LIBRARY_PATH
> Postgres not need it but PgAdmin yes.
There is no such file in the Postgres source code. The version of Postgres
you are using may have been modified and
Thank you for reply.
The time return by SYSDATE depends on the OS timezone setting while in
PostgreSQL we can set the timezone using 'set time zone..' statement so here
timezone setting depends on DBMS but I think there are not so many systems
that use different timezone settings between DBMS and
Le 29 août 2014 18:13, "Emmanuel Medernach" a
écrit :
>
> Hello,
>
> I use Postgres version 9.3.5 and spot a performance issue
> with postgres_fdw.
>
> I have a table object_003_xyz with 275000 lines and is
> exported to the master node as master_object_003_xyz.
>
> ( The following query
