[GENERAL] Re: Reply: Reply: [GENERAL] 回复: [GENERAL] Can't create plpython language

2013-07-19 Thread Raghavendra
Foremost, its interesting, why your replies populate as distinct thread rather than of continuing one. (I may be incorrect, are you choosing "forward" option while replying, no ?). Request to hold the continuity of the post instead of different chunks for each reply. :) On Thu, Jul 18, 2013 at 12:

Re: [GENERAL] Re: Reply: Reply: [GENERAL] 回复: [GENERAL] Can't create plpython language

2013-07-19 Thread John R Pierce
On 7/19/2013 12:12 AM, Raghavendra wrote: ... its interesting, why your replies populate as distinct thread rather than of continuing one the mailer they are using isn't generating 'In-Reply-To' and/or 'References' headers. -- john r pierce 37N 122W some

[GENERAL] Re: [GENERAL] Re: Reply: Reply: [GENERAL] 回复: [GENERAL] Can't create plpython language

2013-07-19 Thread Raghavendra
On Fri, Jul 19, 2013 at 1:30 PM, John R Pierce wrote: > On 7/19/2013 12:12 AM, Raghavendra wrote: > >> ... its interesting, why your replies populate as distinct thread rather >> than of continuing one >> > > the mailer they are using isn't generating 'In-Reply-To' and/or > 'References' headers.

Re: [GENERAL] Best Postgresql books

2013-07-19 Thread Pedro Costa
Thanks Steven Em 18-07-2013 23:20, Steven Schlansker escreveu: PostgreSQL 9.0 High Performance: http://www.amazon.com/books/dp/184951030X On Jul 18, 2013, at 3:11 PM, Pedro Costa wrote: Hi guys, Can anyone tell me the best books about postgresql? Specialy about tunning and querys performa

Re: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure

2013-07-19 Thread George Weaver
From: Stephen Brearley To: pgsql-general@postgresql.org Sent: Wednesday, July 17, 2013 5:41 AM Subject: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure The Problem On re-installing Postgres, I have not been able to get it to work. During re-installa

Re: [GENERAL] Hot Standby and Foreign Tables

2013-07-19 Thread Tim Kane
Brilliant. Thanks Michael. That looks great. On Thu, Jul 18, 2013 at 11:54 PM, Michael Paquier wrote: > > > On Thu, Jul 18, 2013 at 11:15 PM, Tim Kane wrote: > > Hi all, > > > > I'm currently playing a few ideas out in my head and wanted to see if > this > > was feasible. There may be some

Re: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

2013-07-19 Thread guxiaobo1982
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 PostgreS

Re: Reply: [GENERAL] Can we specify transaction level when connectting toexternal postgresql server via postgres_fdw

2013-07-19 Thread bricklen
On Fri, Jul 19, 2013 at 7:47 AM, guxiaobo1982 wrote: > 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 secon

[GENERAL] Insert result does not match record count

2013-07-19 Thread Natalie Wenz
Hi all, I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario: insert into newtable select data from oldtable where proc_date >= x and proc_date < y; INSERT 0 78551642 select count(*) from newtable where proc_date >= x and proc_date < y; count -

Re: [GENERAL] Insert result does not match record count

2013-07-19 Thread Tom Lane
Natalie Wenz writes: > I am moving some data from one table to another in 9.2.4, and keep seeing > this strange scenario: > ... > So, my counts from the old and new tables match, but the result returned from > the insert statement is sometimes a completely different number. (But not > always.)

Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread guxiaobo1982
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 wrote: There is another situation, We have a demo table with about 1700 rows, the "select count(1) from demotabl

Re: Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread bricklen
On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982 wrote: > > 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 wrote: > > There is another situation, > > > We have a de

Reply: [GENERAL] Can we specify transaction level

2013-07-19 Thread guxiaobo1982
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 "bricklen" 写道: On Fri, Jul 19, 2013 at 5:08 PM, guxiaobo1982 wrote: what does