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
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
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
"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
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
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
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
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
Hi Folks,
is it possible to make a Replication between several
PostgresSQL-Databases ?
Regards
Jan Waiz
