Partitioning V schema

From: Dave Potts <dave(dot)potts(at)pinan(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Partitioning V schema
Date: 2013-09-19 07:02:38
Message-ID: 523AA18E.5030404@pinan.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List

I am looking for some general advice about the best was of splitting a
large data table,I have 2 different choices, partitioning or different
schemas.

The data table refers to the number of houses that can be include in a
city, as such there are large number of records.

I am wondering if decided to partition the table if the update
speed/access might be faster that just declaring a different schema per
city.

Under the partition the data table would appear to be smaller, so I
should get an increase in speed, but the database still have to do some
sort of indexing.

If I used different schemas, it resolves data protection issues, but
doing a backup might become a nightmare

In general which is the fast access method?

regards

Dave.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2013-09-19 08:56:51 Re: Using ODBC and VBA to pull data from a large object
Previous Message Jayadevan 2013-09-19 06:33:16 Re: Query - CPU issue