Re: [GENERAL] pgcluu

2014-08-12 Thread David Carpio
make make: *** No targets specified and no makefile found. Stop. -bash-4.1$ make test make: *** No rule to make target `test'. Stop. -bash-4.1$ let me know any help..? On Mon, Aug 11, 2014 at 9:07 PM, David Carpio mailto:dav...@consistentstate.com>> wrote:

Re: [GENERAL] pgcluu

2014-08-11 Thread David Carpio
Hello You must install the harness.pm module You may do it via yum yum install perl-Test-Harness or downloaded the tar package and install it http://search.cpan.org/~leont/Test-Harness-3.32/lib/Test/Harness.pm I hope this help you. David On 08/11/2014 08:52 AM, Ramesh T wrote: Hello ,

Re: [GENERAL] decrease my query duration

2013-07-05 Thread David Carpio
On Thu 04 Jul 2013 08:10:45 PM PET, Michael Paquier wrote: On Fri, Jul 5, 2013 at 10:04 AM, bricklen wrote: On Thu, Jul 4, 2013 at 5:26 PM, David Carpio wrote: Also, can you supply the EXPLAIN (ANALYZE, BUFFERS) plan instead of the simple EXPLAIN plan? Then it might be interesting that you

[GENERAL] decrease my query duration

2013-07-04 Thread David Carpio
t=0.00..6.27 rows=1 width=4) Index Cond: (id = s2.my_table_1_id) -> Index Scan using my_table_2_pk on my_table_2 o (cost=0.00..8.38 rows=1 width=27) Index Cond: (id = fd.typeid) SubPlan 2 -> Index Scan using my_table_2_pk on my_table_2 o (cost=0.00..8.38 rows=1 width=23) Index Cond: (id = s3.id) SubPlan 3 -> Nested Loop (cost=0.00..14.66 rows=1 width=23) -> Index Scan using my_table_1_pk on my_table_1 fd (cost=0.00..6.27 rows=1 width=4) Index Cond: (id = s6.my_table_1_id) -> Index Scan using my_table_2_pk on my_table_2 o (cost=0.00..8.38 rows=1 width=27) Index Cond: (id = fd.typeid) (120 rows) Is there another way to do this query faster? Thank you for the tips, David Carpio

[GENERAL] decrease my query duration

2013-07-04 Thread David Carpio
cost=0.00..8.38 rows=1 width=27) Index Cond: (id = fd.typeid) SubPlan 2 -> Index Scan using my_table_2_pk on my_table_2 o (cost=0.00..8.38 rows=1 width=23) Index Cond: (id = s3.id) SubPlan 3 -> Nested Loop (cost=0.00..14.66 rows=1 width=23) -> Index Scan using my_table_1_pk on my_table_1 fd (cost=0.00..6.27 rows=1 width=4) Index Cond: (id = s6.my_table_1_id) -> Index Scan using my_table_2_pk on my_table_2 o (cost=0.00..8.38 rows=1 width=27) Index Cond: (id = fd.typeid) (120 rows) Is there another way to do this query faster? Thank you for the tips, David Carpio