| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Dick Kniep <dick(at)kniep(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Schema's versus tablespace |
| Date: | 2006-03-28 07:48:04 |
| Message-ID: | 20060328074804.GA12995@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Mar 28, 2006 at 09:41:46AM +0200, Dick Kniep wrote:
> Hi list,
>
> We have developed a system that is running as an ASP application, currently we
> are using Postgresql 7.4. For every customer we have a separate schema, and
> this works OK. Now in version 8, tablespaces were introduced. This summer we
> are planning to migrate to version 8.1. Question is if there are advantages
> to use tablespaces instead of schema's?
Schemas related to how your tables are logically divided up.
Tablespaces are about where the tables are actually stored on disk. As
such they have nothing to do with eachother. You can mix and match as
you please.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-03-28 07:52:25 | Re: Recovery in PostgreSql |
| Previous Message | Paolo Sala | 2006-03-28 07:45:55 | Re: Inheritance |