On 10/13/2011 05:30 AM, Bob Hatfield wrote:
Is it possible to do a full file system level backup of the data
directory, say once a week, and differentials or incrementals daily?
I'd love to be able to do this, but you can't do it usefully at a
file-system level. There's too much churn in the d
On 10/15/11 1:59 PM, Chris Travers wrote:
Are you saying that Windows XP is the ultimate server OS for high
performance PostgreSQL installations? Are there optimizations that
this platform can take advantage of, perhaps extending Pg timelines
into actual time travel that are not available on o
On Sat, Oct 15, 2011 at 1:33 PM, Grzegorz Jaskiewicz wrote:
>
> On 15 Oct 2011, at 21:20, Thomas Kellerer wrote:
> >
> > Total runtime: -2.368 ms << this is amazing ;)
> >
> wow :)
>
> > This is with 9.1.1 on a Windows XP machine
> That explains it ;)
>
>
> Are you saying that Windows XP is
On 15 Oct 2011, at 21:20, Thomas Kellerer wrote:
>
> Total runtime: -2.368 ms << this is amazing ;)
>
wow :)
> This is with 9.1.1 on a Windows XP machine
That explains it ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
I have to share this, a statement that is finished before I even run it ;)
Limit (cost=0.00..527.34 rows=20 width=4) (actual time=0.046..-2.436 rows=20
loops=1)
Output: id, (count(*))
Buffers: shared hit=191
-> GroupAggregate (cost=0.00..12403455.78 rows=470416 width=4) (actual
time=0
On Fri, Oct 14, 2011 at 6:20 AM, Willy-Bas Loos wrote:
> 1. I think that there is no such information in the system tables. is
> that correct?
Yes. It's been discussed before but some people (particularly, Tom,
IIRC) are not convinced that it's useful enough to justify its
existence.
> 2. i wou
On 13.10.2011 22:47, Mark Keisler wrote:
> It is possible. See
http://www.postgresql.org/docs/9.0/interactive/high-availability.html
[3]
>
> On Wed, Oct 12, 2011 at 3:31 AM, Condor wrote:
>
>> Hello
everyone,
>> from a few days I want to ask how to make replica server of
my database and whe
