Re: max time in a table query takes ages - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: max time in a table query takes ages
Date
Msg-id 2f4958ff0810230448j4359d2ffif127f8855ad81c66@mail.gmail.com
Whole thread Raw
In response to Re: max time in a table query takes ages  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general

if reindex will help (which I will run overnight, and will let you know Tomorrow) - I find it quite worrying, cos it is 8.3, and I was hoping - with HOT in place, and all these features - that reindexing of that table wouldn't be needed. it is 'only' 375M rows now, but I can definetively feel pain ppl with much bigger dbs/tables have, if they have to reindex once in a while. 

I also have to think about maybe partitioning that table by quarters, or months even, but that's a subject for different set of questions - if I run into any problems here.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Shopping cart
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Explain's estimation differs from real count enormously