Re: horizontal partition

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: horizontal partition
Date: 2005-02-03 01:10:15
Message-ID: ctrtln$d0m$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus wrote:
> Gaetano,
>
>
>>I have a big table with ~ 10 Milion rows, and is a very
>>pain administer it, so after years I convinced my self
>>to partition it and replace the table usage ( only for reading )
>>with a view.
>>
>>Now my user_logs table is splitted in 4:
>>
>>user_logs
>>user_logs_2002
>>user_logs_2003
>>user_logs_2004
>
>
> Any reason you didn't use inheritance?

I did in that way just to not use postgresql specific feature.
I can give it a try and I let you know, however the question remain,
why the index usage is lost if used in that way ?

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-02-03 03:16:08 Re: horizontal partition
Previous Message Tom Lane 2005-02-02 23:49:13 Re: Bad query optimizer misestimation because of TOAST