| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, John Gardner <john(dot)gardner(at)tagish(dot)co(dot)uk> |
| Subject: | Re: Tablespaces |
| Date: | 2007-06-05 23:04:57 |
| Message-ID: | 200706051904.58700.xzilla@users.sourceforge.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday 04 June 2007 04:53, Richard Huxton wrote:
> John Gardner wrote:
> > I've been testing one of our apps on PostgreSQL for the last few months
> > and I'm about ready to put it on the production server, but I need
> > advice on where to locate the tablespace. I've been so concerned
> > getting the app working, I haven't even considered this yet.
> >
> > I'm using a RPM install of Postgres, so the data directory is located at
> > /var/lib/pgsql/data/. Shall I just create a directory under here and
> > point the tablespace to there? Any advice would be appreciated.
>
> If you're not going to be spreading your installation over multiple
> disks (well, mount-points), there's no need to play with tablespaces at
> all.
Well, one could use them as part of a disk quota utilization scheme... granted
doesn't sound like the OP needs them... just saying is all.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gardner | 2007-06-05 23:14:52 | Re: pl/pgsql debuging, was Re: debugging C functions |
| Previous Message | Diego Sanchez | 2007-06-05 22:12:33 | Record Types Structure in PL/pgSQL |