""Ahmad Fajar"" <[EMAIL PROTECTED]> wrote
> Hi Qingqing,
>
> I don't know whether the statistic got is bad or good, this is the
> statistic:
Please do it in this way:
1. Start postmaster with "stats_start_collector=true" and
"stats_block_level=true".
2. Use psql connect it, do something like t
5 8:43
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Query seem to slow if table have more than 200
million rows
""Ahmad Fajar"" <[EMAIL PROTECTED]> wrote
>
> Select ids, keywords from dict where keywords='blabla' ('blabla' is a
""Ahmad Fajar"" <[EMAIL PROTECTED]> wrote
>
> Select ids, keywords from dict where keywords='blabla' ('blabla' is a
> single
> word);
>
> The table have 200 million rows, I have index the keywords field. On the
> first time my query seem to slow to get the result, about 15-60 sec to get
> the res
If I do a simple query like:
Select ids, keywords from dict where
keywords='blabla' ('blabla' is a single word);
The table have 200 million rows, I have index the
keywords field. On the first time my query seem to slow to get the result,
about 15-60 sec to get the result. But if I repeat