Re: Increasing pattern index query speed

От: Andrus
Тема: Re: Increasing pattern index query speed
Дата: ,
Msg-id: 534B7B28155C4275BD2B9AA8F3B656DD@andrusnotebook
(см: обсуждение, исходный текст)
Ответ на: Re: Increasing pattern index query speed  (Richard Huxton)
Ответы: Re: Increasing pattern index query speed  (Richard Huxton)
Список: pgsql-performance

Скрыть дерево обсуждения

Increasing pattern index query speed  ("Andrus", )
 Re: Increasing pattern index query speed  (Richard Huxton, )
  Re: Increasing pattern index query speed  ("Andrus", )
   Re: Increasing pattern index query speed  (Scott Carey, )
    Re: Increasing pattern index query speed  ("Andrus", )
     Re: Increasing pattern index query speed  (Scott Carey, )
      Re: Increasing pattern index query speed  ("Andrus", )
   Re: Increasing pattern index query speed  (Richard Huxton, )
    Re: Increasing pattern index query speed  ("Andrus", )
     Re: Increasing pattern index query speed  (Richard Huxton, )
      Re: Increasing pattern index query speed  ("Andrus", )
       Re: Increasing pattern index query speed  (Richard Huxton, )
       Re: Increasing pattern index query speed  ("Andrus", )
      Re: Increasing pattern index query speed  ("Andrus", )
       Re: Increasing pattern index query speed  (Richard Huxton, )
   Re: Increasing pattern index query speed  (Mario Weilguni, )

Richard,

>> Results are provided in bottom of the message to which you replied.
>
> No - the explains there were contrasting a date test BETWEEN versus =.

I changed rid.toode statitics target to 100:

ALTER TABLE firma2.rid ALTER COLUMN toode SET STATISTICS 100;
analyze firma2.rid;

Analyze takes 3 seconds and testcase rans fast.
I'm planning to monitor results by looking log file for queries which take
longer than 10 seconds.

Do you still need results ?
If yes, which query and how many times should I run?

> Ah, I think I understand. The test case was *missing* this clause.

I added  this clause to testcase. Also added char(70) colums containing
padding characters to all three tables. Cannot still reproduce this issue
in testcase in fast devel 8.3 notebook.
In testcase order_products contains product_id values in a very regular
order, maybe this affects the results. No idea how to use random() to
generate random
products for every order.

Andrus.



В списке pgsql-performance по дате сообщения:

От: Gregory Stark
Дата:
Сообщение: Re: Partition table query performance
От: Kevin Kempter
Дата:
Сообщение: performance tuning queries