Re: need suggestion on querying big tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 05/12/2022 12:14, Bo Guo wrote:
Partitioning the table if possible should also help.

This really only helps if the partitioning is relevant to the query. Otherwise it can slow things down.

Eg, if you partition on date, and search on date, the partitioning will probably help, but if you partition on date, and search on name, it'll be no quicker, and will possibly be slower.


Paul


--


Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53

Sign up for news & updates at http://www.pscs.co.uk/go/subscribe





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux