Tomasz Ostrowski wrote:
On 2008-06-06 07:25, Brent Wood wrote:
Would "real" tables in a tablespace defined on a ramdisk meet this
need?
Bad idea. This would mean an unusable database after a restart.
Funnily, I was thinking the same this night, somehow defining a
tablespace on tmpfs or som
On 2008-06-06 07:25, Brent Wood wrote:
> Would "real" tables in a tablespace defined on a ramdisk meet this
> need?
Bad idea. This would mean an unusable database after a restart.
> You could also mount a tablespace on a physical disk with a
> filesystem which has delayed/deferred writes to disk
Hi Tim,
Off the top of my head, from somewhat left field, using filesystems to manage
this sort of effect.
Would "real" tables in a tablespace defined on a ramdisk meet this need? So the
functionality/accessibility of a
physical table is provided, along with the performance of a filesystem act
On Thu, Jun 5, 2008 at 5:36 PM, Tim Tassonis <[EMAIL PROTECTED]> wrote:
> Is there a way to create temporary tables in another way, so they are
> visible between sessions, or do I need to create real tables for my purpose?
> And is the perfomance penalty big for real tables, as they have been writ
Tino Wildenhain wrote:
Hi,
Tim Tassonis wrote:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now build
In response to Tim Tassonis <[EMAIL PROTECTED]>:
>
> Bill Moran wrote:
> > In response to Tim Tassonis <[EMAIL PROTECTED]>:
> >
> >>
> >> Now, with apache/php in a mpm environment, I have no guarantee that a
> >> user will get the same postgresql session for a subsequent request, thus
> >> he w
Hi,
Tim Tassonis wrote:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now building a web
application u
In response to Tim Tassonis <[EMAIL PROTECTED]>:
> Hi all
>
> I assume this is not an uncommon problem, but so far, I haven't been
> able to find a good answer to it.
>
> I've got a table that holds log entries and fills up very fast during
> the day, it gets approx. 25 million rows per day. I
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now building a web
application using apache/mod_php where