On Fri, Mar 26, 2004 at 11:53:47 -0600,
Guy Rouillier <[EMAIL PROTECTED]> wrote:
>
> I saw in the referenced sequence of posts that PostgreSQL will close a
> file for a table once it reaches 1 GB, and start a new file. So I'm
> concluding PostgreSQL has the ability to span multiple files for a
Bruno Wolff III wrote:
> On Fri, Mar 26, 2004 at 11:53:47 -0600,
> Guy Rouillier <[EMAIL PROTECTED]> wrote:
>>
>> I saw in the referenced sequence of posts that PostgreSQL will close
>> a file for a table once it reaches 1 GB, and start a new file. So
>> I'm concluding PostgreSQL has the abilit
On Fri, 26 Mar 2004, Guy Rouillier wrote:
> (Resurrecting a subject I found searching the archives...)
>
> Newbie. We're investigating replacing our Oracle databases with
> PostgreSQL. Our largest database is currently 25 GB and growing. It
> contains time sequenced data. Under Oracle, we use
(Resurrecting a subject I found searching the archives...)
Newbie. We're investigating replacing our Oracle databases with
PostgreSQL. Our largest database is currently 25 GB and growing. It
contains time sequenced data. Under Oracle, we use a partitioned
tablespace for the busiest table, so t
On Wednesday 25 June 2003 21:21, Jonathan Bartlett wrote:
> My solution did not involve tablespaces, but was more of a quick solution
> to make it easier for admins to do _some_ sort of physical configuration.
>
> The idea is that the developer could do something like
>
> 'create alternate location
I know the current method for specifying alternate drives for PG tables is
by using symlinks. I had some ideas for simple ways to do this in PG
code, but wanted to know if anyone was working on this right now. I'd
hate to take the time to start messing with this if others were already on
it.
Jon
