Re: horizontal partition

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: horizontal partition
Date: 2005-02-02 20:09:06
Message-ID: 200502021209.06878.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cosimo Streppone 2005-02-02 21:10:00 Re: High end server and storage for a PostgreSQL OLTP system
Previous Message Merlin Moncure 2005-02-02 18:50:59 Re: High end server and storage for a PostgreSQL OLTP system