On Mon, 2007-01-15 at 23:26, Tom Lane wrote:
> "carter ck" <[EMAIL PROTECTED]> writes:
> > And you are definitely right when updating the table. The time it takes is
> > getting longer and longer. When I do a select statement, the speed has also
> > degraded.
>
> Seems like you need a VACUUM in
"carter ck" <[EMAIL PROTECTED]> writes:
> And you are definitely right when updating the table. The time it takes is
> getting longer and longer. When I do a select statement, the speed has also
> degraded.
Seems like you need a VACUUM in there somewhere...
regards, tom
carter ck wrote:
Hi, the rpt_generated is a boolean value.
And you are definitely right when updating the table. The time it takes
is getting longer and longer. When I do a select statement, the speed
has also degraded.
If you send us the query that is slow, then I'm sure you'll get some
s
"carter ck" <[EMAIL PROTECTED]> writes:
> Hi, the rpt_generated is a boolean value.
Is there any special reason, then, for not using a boolean type?
> And you are definitely right when updating the table. The time it takes is
> getting longer and longer. When I do a select statement, the speed
MAIL PROTECTED]>
CC: [EMAIL PROTECTED], pgsql-general@postgresql.org
Subject: Re: [GENERAL] Improve Postgres Query Speed
Date: Mon, 15 Jan 2007 23:19:13 -0200
"carter ck" <[EMAIL PROTECTED]> writes:
> Hi,
>
> Thanks for reminding me. And the actual number of records
"carter ck" <[EMAIL PROTECTED]> writes:
> Hi,
>
> Thanks for reminding me. And the actual number of records is 100,000.
>
> The table is as following:
You forgot the EXPLAIN ANALYZE output...
> Table my_messages
>
> mid
carter ck wrote:
>
> Hi,
>
> Thanks for reminding me. And the actual number of records is 100,000.
>
> The table is as following:
And the query?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
" btree (msg_status)
Thanks for help.
From: "Chad Wagner" <[EMAIL PROTECTED]>
To: "carter ck" <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Improve Postgres Query Speed
Date: Mon, 15 Jan 2007 19:54:51 -0500
On 1/15/07, carter ck <
On 1/15/07, carter ck <[EMAIL PROTECTED]> wrote:
I am having slow performance issue when querying a table that contains
more
than 1 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 y
