There is another situation,
We have a demo table with about 1700 rows, the select count(1) from
demotable statement finishes with-in 3 seconds when executed directlly
against the Greenplum database,but it takes about 230 seconds to finish when
executed via postgres_fdw inside
what does a wrapper function mean, count is a standard function in Greenplum,
or how to creat the wrapper function.
regards
On Fri, Jul 19, 2013 at 7:47 AM, guxiaobo1982 guxiaobo1...@qq.com wrote:
There is another situation,
We have a demo table with about 1700 rows, the select count
I wil test next week, but the document of postgres_fdw says it is smart enough
to push executing into the external server, I wander is this a bug or a version
compability problem.
---原始邮件---
在 2013年07月20日 10:05:02
bricklenbrick...@gmail.com 写道:
On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982
@postgresql.org; Asif
Naeemasif.na...@enterprisedb.com;
Subject: Re: Reply: [GENERAL] ?? [GENERAL] Can't create plpython language
On Mon, Jul 15, 2013 at 7:10 PM, guxiaobo1982 guxiaobo1...@qq.com wrote:
It works with ActivePython 3.2.2.3,
Thanks for notifying.
but not ActivePython 2.7.2.5
Greeplum is based on 8.2.15, so we can only use the read-only option.
-- Original --
Sender: Tom Lanet...@sss.pgh.pa.us;
Send time: Tuesday, Jul 16, 2013 1:57 PM
To: guxiaobo1982guxiaobo1...@qq.com;
Cc: Jovam...@amutu.com;
modify the code to add READ COMMIT level.but be
carefull the code comment.
Jov
blog: http:amutu.com/blog
2013/7/11 guxiaobo1982 guxiaobo1...@qq.com
Hi,
We are try to connect to Greenplum database from PostgreSQL 9.3 beta2 via
postgres_fdw, but the Greenplum Database does not support
;
pgsql-generalpgsql-general@postgresql.org; Asif
Naeemasif.na...@enterprisedb.com;
Subject: Re: Reply: [GENERAL] ?? [GENERAL] Can't create plpython language
On Wed, Jul 10, 2013 at 7:36 AM, guxiaobo1982 guxiaobo1...@qq.com wrote:
I am using PostgreSQL 9.3 beta 2
[postgres@lix Multicorn
Hi,
We are try to connect to Greenplum database from PostgreSQL 9.3 beta2 via
postgres_fdw, but the Greenplum Database does not support REPEATABLE READ
transactions, can we specify other isolation leves?
Regards,
Xiaobo Gu
/blog
2013/7/5 Michael Paquier michael.paqu...@gmail.com
On Thu, Jul 4, 2013 at 6:26 PM, guxiaobo1982 guxiaobo1...@qq.com wrote:
Hi,
I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64
server, I got the following errors when trying to create the python language
2013/7/5 Michael Paquier michael.paqu...@gmail.com
On Thu, Jul 4, 2013 at 6:26 PM, guxiaobo1982 guxiaobo1...@qq.com wrote:
Hi,
I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64
server, I got the following errors when trying to create the python language
handler, can you
Hi,
I installed postgreSQL 9.3 beta 2 from
http://yum.postgresql.org/repopackages.php#pg92 following
http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html
But I cann't find pg_config, is this a bug?
Xiaobo Gu
Hi,
I use the following commands to build PostgreSQL9.3 from source, but plpython3u
and postgres_fdw are missed in the result, can you help with this.
./configure PYTHON='/opt/python32/bin/python3' --prefix=/opt/PostgreSQL/93b2src
--with-python
make
make install
export
...@gmail.com;
Date: Jul 5, 2013
To: guxiaobo1982guxiaobo1...@qq.com;
Cc: pgsql-generalpgsql-general@postgresql.org;
Subject: Re: [GENERAL] How to build postgresql 9.3 beta2 from source
withplpython3u handler and postgres_fdw extensions.
On 07/05/2013 03:31 AM, guxiaobo1982 wrote:
Hi,
I use
source
withplpython3u handler and postgres_fdw extensions.
On 07/05/2013 03:31 AM, guxiaobo1982 wrote:
Hi,
I use the following commands to build PostgreSQL9.3 from source, but
plpython3u and postgres_fdw are missed in the result, can you help with
this.
http://www.postgresql.org/docs/9.3
Hi,
I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64 server, I
got the following errors when trying to create the python language handler, can
you help with this, thanks in advance.
[postgres@lix ~]$ psql
Password:
psql.bin (9.2.4)
Type help for help.
No entry for
, Jul 4, 2013 at 6:26 PM, guxiaobo1982 guxiaobo1...@qq.com wrote:
Hi,
I am running PostgreSQL 9.2.4.1 (from EnterpriseDB) on CENTOS 5.9 X64
server, I got the following errors when trying to create the python language
handler, can you help with this, thanks in advance.
If this is PPAS
16 matches
Mail list logo