From: | "carter ck" <carterck32(at)hotmail(dot)com> |
---|---|
To: | chad(dot)wagner(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Improve Postgres Query Speed |
Date: | 2007-01-16 01:08:19 |
Message-ID: | BAY101-F24AC888471255FA46BF547D5B40@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Thanks for reminding me. And the actual number of records is 100,000.
The table is as following:
Table my_messages
----------------------------------------------------------------------------
midx | integer | not null
default nextval('public.my_messages_midx_seq'::text)
msg_from | character varying(150) |
msg_to | character varying(150) |
msg_content | text |
msg_status | character(1) | default 'N'::bpchar
created_dtm | timestamp without time zone | not null default now()
processed_dtm | timestamp without time zone |
rpt_generated | character(1) | default 'N'::bpchar
Indexes:
"msgstat_pkey" PRIMARY KEY, btree (midx)
"my_messages_msgstatus_index" btree (msg_status)
Thanks for help.
>From: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>
>To: "carter ck" <carterck32(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Improve Postgres Query Speed
>Date: Mon, 15 Jan 2007 19:54:51 -0500
>
>On 1/15/07, carter ck <carterck32(at)hotmail(dot)com> wrote:
>>
>>I am having slow performance issue when querying a table that contains
>>more
>>than 10000 records.
>>
>>Everything just slow down when executing a query though I have created
>>Index
>>on it.
>>
>
>You didn't really provide much information for anyone to help you. I would
>suggest posting the table definition (columns & indexes), the queries you
>are running, and the output of "EXPLAIN ANALYZE <your query here>;".
>
>--
>Chad
>http://www.postgresqlforums.com/
_________________________________________________________________
Receive MSN Hotmail alerts over SMS!
http://en-asiasms.mobile.msn.com/ac.aspx?cid=1002
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Godoy | 2007-01-16 01:15:41 | Re: Transaction callback |
Previous Message | Chad Wagner | 2007-01-16 00:54:51 | Re: Improve Postgres Query Speed |