Hi Folks,
is it possible to make a Replication between several
PostgresSQL-Databases ?
Regards
Jan Waiz
Hi,
If I ask detailed information about statements in log file, I got
something like:
...
2005-08-29 10:19:15 CEST ...(...)DETAIL: ! system usage stats:
! 101.659118 elapsed 0.64 user 0.95 system sec
! [0.67 user 0.97 sys total]
...
What does "elap
Hello,
I have a question to the usage of locale.
In the PostgreSQL 8.0.3 Documentation is written:
"The drawback of using locales other than C or
POSIX in PostgreSQL is its
performance impact. It slows character handling and prevents ordinary indexes
from being used by LIKE. For this reas
Jeff Frost <[EMAIL PROTECTED]> writes:
> Since we're on the vacuum kick these days, what's the best way to tell if my
> autovacuum settings are working well? I'm sure I can query some info out of
> the pg_stats tables, no?
If the database isn't bloating (ie, physical storage growing faster than
On Wed, Aug 31, 2005 at 09:47:35AM -0400, Tom Lane wrote:
> Jeff Frost <[EMAIL PROTECTED]> writes:
> > Since we're on the vacuum kick these days, what's the best way to tell if
> > my
> > autovacuum settings are working well? I'm sure I can query some info out
> > of
> > the pg_stats tables, n
"MG" <[EMAIL PROTECTED]> writes:
> In the PostgreSQL 8.0.3 Documentation is written:
> "The drawback of using locales other than C or POSIX in PostgreSQL is =
> its performance impact. It slows character handling and prevents =
> ordinary indexes from being used by LIKE. For this reason use locales
Jan Waiz wrote:
Hi Folks,
is it possible to make a Replication between several
PostgresSQL-Databases ?
Short answer: Yes (for most cases). Long answer will depend on what
your requirements are.
What do you have in mind?
Best Wishes,
Chris Travers
Metatron Technology Consulting
Thanks Tom!
Now what does the relpages column mean? I.e. how should I interpret that
entry for my tables?
On Wed, 31 Aug 2005, Tom Lane wrote:
If the database isn't bloating (ie, physical storage growing faster than
valid data volume) then it's getting the job done. Keep an eye on
"du $PGD
On Wed, Aug 31, 2005 at 10:59:49AM -0700, Jeff Frost wrote:
> Thanks Tom!
>
> Now what does the relpages column mean? I.e. how should I interpret that
> entry for my tables?
relpages is the number of "pages" of the table. A page is 8kb (unless
you changed a compile-time setting -- you can chec
