[GENERAL] Bad performace of a query

I have this query: SELECT DISTINCT isbn, CURRENT_TIMESTAMP, 1 FROM librosdisponibilidadtemp WHERE proceso = ai_proceso AND gen_isbn_pais(isbn) IN (SELECT pais FROM raizpaises) AND NOT EXISTS ( SELECT isbn

[GENERAL] Esay question, about the numeric format

Hi every body I have this query SELECT 20.00::numeric(38,2) and postgre gives me 20, i need that postgre gives me 20.00 What can i do? i suppose this must be easy, but i dont find how to do ir thanks every body

[GENERAL] Having performance problems with TSearch2

I have problems with queries over tsearch index. I have a table of books, with 120 registers. I have created an GIST index over the title and subtitle, CREATE INDEX "idxts2_titsub_idx" ON "public"."libros" USING gist ("idxts2_titsub"); My problems started when i execute my queries. For examp

[GENERAL] Having performance problems with TSearch2

I have problems with queries over tsearch index. I have a table of books, with 120 registers. I have created an GIST index over the title and subtitle, CREATE INDEX "idxts2_titsub_idx" ON "public"."libros" USING gist ("idxts2_titsub"); My problems started when i execute my queries. For examp

[GENERAL] problems: slow queries with tsearch2

Hi from Spain, I have a problem with TSearch2, I have a table with more than a million registers (a table of books, for example), I made a tsearch2 index for one of my fields (the title of the books, for example), I make queries from that table, over the tsearch2 index. Then some of my queries