[GENERAL] Cost of max

t=43.00 rows=1000 width=4) -- Dott. Stefano Bargioni Biblioteca della Pontificia Universita' della Santa Croce - Roma <mailto:[EMAIL PROTECTED]> <http://www.usc.urbe.it> Personal web page:<http://www.usc.urbe.it/html/php.script?bargioni> --- "Si apud b

[GENERAL] Re: Very slow select

> Stefano Bargioni writes: > > SELECT FROM t WHERE a='my string'; works very fast. The same select > > made on b is very slow (2 or 3 seconds), as if no index exists for > > column b. > > What does EXPLAIN say about the two queries? > >

[GENERAL] Very slow select

hy. Note that b contains very long strings, more than 500 chars. Is there a limit in indexing? Thanks. Stefano -- Dott. Stefano Bargioni Biblioteca della Pontificia Universita' della Santa Croce - Roma <mailto:[EMAIL PROTECTED]> <http://www.usc.urbe.it> Personal web page:

[GENERAL] Indexing arrays

| var | +--+--+---+ How can I create an index for schedule? I need to index every occurrence of this array. Thanks. Stefano -- Dott. Stefano Bargioni Biblioteca della Pontificia Universita' della Santa Croce - Roma <mailto:

Re: [GENERAL] Alternate location

Peter Eisentraut wrote: > On Wed, 22 Mar 2000, Stefano Bargioni wrote: > > > $ PGDATA2=/data > > $ initlocation $PGDATA2 > > initlocation PGDATA2 > > > We are initializing the database area with username postgres (uid=40). > > This user will own all the fil

[GENERAL] Alternate location

t. Stefano -- Dott. Stefano Bargioni Biblioteca della Pontificia Universita' della Santa Croce - Roma <mailto:[EMAIL PROTECTED]> <http://www.usc.urbe.it> Personal web page:<http://www.usc.urbe.it/html/php.script?bargioni> --- "Si apud bibliothecam hortulum habes, nihil deerit" (Cicerone) ---

Re: [GENERAL] Problem with LIKE operator

gt; is '(4)'. > > I have tried to escape the brackets with '\\(4\\)' or with ' \(4\)' but > it doesn't work. > > How can i do it ? > > Gabi :-) Try select code from codes where code ~ '(4)' ; HTH. Stefano -- Dott.