No, these messages are not confuse; I just wanted to show output
2016-03-04 15:58 GMT-06:00 David G. Johnston :
> On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
> fjmolinabr...@gmail.com> wrote:
>
>> when i run without the ANALIZE the output is:
>>
when i run without the ANALIZE the output is:
pba=# EXPLAIN ( TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb a LEFT
join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );
ERROR: la opción BUFFERS de EXPLAIN requiere ANALYZE
pba=# EXPLAIN ( TIMING) SELECT idprodxintegrar FROM _gc_t
=# EXPLAIN (ANALYZE, TIMING, BUFFERS) SELECT idprodxintegrar FROM _gc_tb
a LEFT join _gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama )
;
Terminado (killed)
:(
2016-03-04 15:30 GMT-06:00 David G. Johnston :
> On Fri, Mar 4, 2016 at 2:16 PM, Felipe de Jesús Molina Bravo <
rows=0 loops=1)
-> Seq Scan on _gc_cat b (cost=0.00..0.00 rows=1 width=70) (never
executed)
Planning time: 0.206 ms
Execution time: 0.074 ms
(6 filas)
2016-03-04 15:01 GMT-06:00 David G. Johnston :
> On Fri, Mar 4, 2016 at 1:52 PM, Felipe de Jesús Molina Bravo <
> fjm
estimadasANALYZEpba=# SELECT idprodxintegrar FROM _gc_tb a LEFT join
_gc_cat b on ( b.arama <@ a.arama and a.arama <@ b.arama );Terminado
(killed)*
2016-03-04 15:00 GMT-06:00 Melvin Davidson :
>
>
> On Fri, Mar 4, 2016 at 3:52 PM, Felipe de Jesús Molina Bravo <
> fjmolinabr...@gmail.com>
>
>> Now i execute the same in pgsql 9.4.5 and all is fine!!!
>>
>> The EXPLAINs are:
>>
>> - pgsql 9.5.1:
>>
>>Nested Loop Left Join (cost=0.03..492944.81 rows=276095 width=4)
>> -> Seq Scan on _gc_tb a (cost=0.00..3321.30 rows=120130 width=66)
>>-> Bitmap Heap Scan on _gc_cat
Hi!!!
I try to explain my problem...sorry for my english :(
In pgsql 9.5.1 I have a two tables with the next structure:
1. Tabla unlogged «public._gc_cat»
Columna | Tipo | Modificadores
-+--+---
idppicat| integer |
El 2 de agosto de 2010 19:14, John R Pierce escribió:
> On 08/02/10 7:35 AM, Felipe de Jesús Molina Bravo wrote:
>
>> Hi
>>
>>
>> I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems
>> sun4u Sun Fire 880 with:
>>
>> - 4 700M
Hi
I have installed postgres 8.4.4 (libxml and plperl)on a Sun Microsystems
sun4u Sun Fire 880 with:
- 4 700Mhz processors
- 8 Gb Ram
- System 9 operSolaris
- 64-bit sparcv9 Applications
- 32-bit sparc Applications
- SCSI-3. Discs do not have any arrangement
It was compiled with the sun-studio
well after many problems i can install sunstudio 11; but now my
problem is:
>
>
> - environment:
> bash-2.05# echo $CC
> /opt/SunStudio/bin/cc
>
> bash-2.05# echo $CFLAGS
> -xarch=v9 -O
>
> - my configure was:
>
> ./configure --with-CC=/opt/SunStudio/bin/cc --with-perl --without-readline
El 26 de junio de 2010 16:56, Felipe de Jesús Molina Bravo <
fjmolinabr...@gmail.com> escribió:
>
>
> 2010/6/25 John R Pierce
>
>> On 06/25/10 9:28 PM, Felipe de Jesús Molina Bravo wrote:
>>
>> original perl is 5.6. so i installed perl 5.8.9 for 64 bit an
2010/6/25 John R Pierce
> On 06/25/10 9:28 PM, Felipe de Jesús Molina Bravo wrote:
>
>> original perl is 5.6. so i installed perl 5.8.9 for 64 bit and the
>> error is the same... maybe my error is with the compiler, it is "gcc"
>> (3.4.6). is it possible?
2010/6/25 John R Pierce
> On 06/25/10 2:21 PM, MOLINA BRAVO FELIPE DE JESUS wrote:
>
>> Hi
>>
>> I don't have experience with solaris. I know it is a 64 bits:
>>
>> bash-2.05# isainfo -v
>> 64-bit sparcv9 applications
>> 32-bit sparc applications
>>
>>
>>
>> I tried to compile postgres (Version o
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The options for the configure are:
/configure --with-CC=/usr/local/bi
tsearch can help you; i have a system with it ... and its ok.
El mar, 05-08-2008 a las 18:03 +0400, Vyacheslav Kalinin escribió:
> Hello,
>
> In our application we need a pattern based text search, that is if
> user supplies 'foo bar' he receives only documents containing words
> that begin with
El mié, 02-07-2008 a las 10:39 -0400, Alvaro Herrera escribió:
> Felipe de Jesús Molina Bravo wrote:
>
> > I suspect that my error is:
> >
> > r = obtPadre( &intF->izq, &intF->der );
>
> You didn't show obtPadre().
>
ok it is:
El mié, 02-07-2008 a las 08:02 +0200, Martijn van Oosterhout escribió:
> On Tue, Jul 01, 2008 at 10:02:39AM -0500, Felipe de Jesús Molina Bravo wrote:
> > Hi
> >
> > what can i do for a SRF written in C, can called as follow:
> >
> > select * from obtAscend
Hi
what can i do for a SRF written in C, can called as follow:
select * from obtAscendencia('(11099,15685)','(6808,9621)');
I can call the function:
select obtAscendencia('(11099,15685)','(6808,9621)');
the code of function is:
PG_FUNCTION_INFO_V1(obtAscendencia);
if you create its in a template1
regards...
El jue, 27-03-2008 a las 23:10 -0400, David T escribió:
> Hi all,
>
> I am using Ubuntu 7.10 with PostgreSQL 8.2. I have just finished creating
> two C functions and have successfully loaded them using "CREATE OR REPLACE
> FUNCTION" ... This wa
May be can help you \timing in psql
El vie, 05-10-2007 a las 21:32 +0400, John Wells escribió:
> Guys,
>
> In the book PostgreSQL (2nd ed) the author mentions a timer script he wrote
> to analyze various performance bits about PostgreSQL. I've looked everywhere
> and can't find it. Does anyon
Hi
You are rigth, the output of "show lc_ctype;" is C.
Then I did is:
prueba1=# show lc_ctype;
lc_ctype
-
es_MX.ISO8859-1
(1 row)
and do it
% initdb -D /YOUR/PATH -E LATIN1 --locale es_ES.ISO8859-1
(how you do say)
and "createdb -E iso8859-1 prueba1" and finally ts
Hi
I had installed postgresql-8.2.4 and tsearch2 with dictionary spanish.
My problem is:
prueba=# select to_tsvector('espanol','melón');
ERROR: Affix parse error at 506 line
And if execute:
prueba=# select lexize('sp','melón');
lexize
-
Hi
I had installed postgresql-8.2.4. After some problems with tsearch2
installation i had the next problem:
prueba=# select to_tsvector('espanol','melón');
ERROR: Affix parse error at 506 line
If execute:
prueba=# select lexize('sp','melón');
lexize
-
23 matches
Mail list logo
