Re: [PERFORM] Index not used with or condition

I ran analyze; several times. rgds Antony Paul On Mon, 07 Feb 2005 12:53:30 +0100, Jan Poslusny wrote: > It depends on many circumstances, but, at first, simple question: Did > you run vacuum analyze? > I am satisfied with functional indexes - it works in my pg 7.4.x. > > An

Re: [PERFORM] Index not used with or condition

Sorry I forgot to mention it. I am using 7.3.3. I will try it in 8.0.0 rgds Antony Paul On Mon, 7 Feb 2005 12:46:05 +0100, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote: > On Mon, Feb 07, 2005 at 04:44:07PM +0530, Antony Paul wrote: > > On more investigation I found that in

Re: [PERFORM] Index not used with or condition

On more investigation I found that index scan is not used if the query have a function in it like lower() and an index exist for lower() column. rgds Antony Paul On Mon, 7 Feb 2005 14:37:15 +0530, Antony Paul <[EMAIL PROTECTED]> wrote: > Hi all, > I am facing a strange proble

[PERFORM] Index not used with or condition

. rgds Antony Paul. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[PERFORM] PostgreSQL not utilising available memory

467 Swap: 501 0 501 rgds Antony Paul ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get thro

Re: [PERFORM] How to boost performance of ilike queries ?

Actually the query is created like this. User enters the query in a user interface. User can type any character in the query criteria. ie. % and _ can be at any place. User have the freedom to choose query columns as well. The query is agianst a single table . rgds Antony Paul On Tue, 25 Jan

Re: [PERFORM] How to boost performance of ilike queries ?

://archives.postgresql.org/pgsql-sql/2004-11/msg00285.php It says that index is not used if the search string begins with a % symbol. rgds Antony Paul On Mon, 24 Jan 2005 20:58:54 +1100, Russell Smith <[EMAIL PROTECTED]> wrote: > On Mon, 24 Jan 2005 08:18 pm, Antony Paul wrote: > > Hi, &

Re: [PERFORM] How to boost performance of ilike queries ?

I used PreparedStatements to avoid SQL injection attack and it is the best way to do in JDBC. rgds Antony Paul On Mon, 24 Jan 2005 09:01:49 -0500, Merlin Moncure <[EMAIL PROTECTED]> wrote: > Russell wrote: > > I am not sure what the effect of it being prepared will be, however

[PERFORM] How to boost performance of ilike queries ?

performance ?. If creating index can help then how the index should be created on lower case or uppercase ?. rgds Antony Paul ---(end of broadcast)--- TIP 8: explain analyze is your friend

[PERFORM] Checking = with timestamp field is slow

Hi all, I have a table which have more than 20 records. I need to get the records which matches like this where today::date = '2004-11-05'; This is the only condition in the query. There is a btree index on the column today. Is there any way to optimise it. rgds A