Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Slow queries on very big (and partitioned) table - Mailing list pgsql-general

From Jaime Soler
Subject Re: [GENERAL] Slow queries on very big (and partitioned) table
Date
Msg-id CAKVUGgTD4CSXG1+HToh9hkvnG7Phn_9Bvk3a3PSdqgUKPuBtuQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Slow queries on very big (and partitioned) table  (Job <Job@colliniconsulting.it>)
Responses R: [GENERAL] Slow queries on very big (and partitioned) table  (Job <Job@colliniconsulting.it>)
List pgsql-general
Tree view
Please share us an explain analyze of your query and \d+ of your table 

2017-02-20 13:33 GMT+01:00 Job <Job@colliniconsulting.it>:
Hu guys,

we have a test machine with Postgresql 9.6.1 an about 800.000.000 record in a table.
Table is partitioned by day, with indexes on partitioned table.

Also a simple query (for example i want to search log occurred in a specific day), is immediate in tha partitioned table (table_2017_02_15) but *extremely* slow in global table.

Where am i wrong?
Shall i create global index?

Thank you!
/F

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Job
Date:
Subject: [GENERAL] Slow queries on very big (and partitioned) table
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] Slow queries on very big (and partitioned) table