No, these messages are not confuse; I just wanted to show output
2016-03-04 15:58 GMT-06:00 David G. Johnston <david.g.johns...@gmail.com>:
> On Fri, Mar 4, 2016 at 2:56 PM, Felipe de Jesús Molina Bravo <
> fjmolinabr...@gmail.com> wrote:
>
>> when i run wit
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
=# 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 <david.g.johns...@gmail.com>:
> On Fri, Mar 4, 2016 at 2:16 PM,
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 <david.g.johns...@gmail.com>:
> On Fri, Mar 4, 2016 at 1:52 PM, Felipe de Jesús
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 <melvin6...@gmail.com>:
>
>
> On Fri, Mar 4, 2016 at 3:52 PM, Felipe de Jesús Molina Bravo <
&
>
>> 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
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 |
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
El 2 de agosto de 2010 19:14, John R Pierce pie...@hogranch.com 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 700Mhz processors
...
Also I have installed
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
- when i
El 26 de junio de 2010 16:56, Felipe de Jesús Molina Bravo
fjmolinabr...@gmail.com escribió:
2010/6/25 John R Pierce pie...@hogranch.com
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
2010/6/25 John R Pierce pie...@hogranch.com
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?
where did this 64bit
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
2010/6/25 John R Pierce pie...@hogranch.com
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 of
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 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 obtAscendencia('(11099,15685)','(6808,9621)');
I
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:
Racional* obtPadre( Racional *li, Racional *ld
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 was an
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 anyone
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
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