On Jan 5, 2008 5:38 AM, Ed L. <[EMAIL PROTECTED]> wrote:
> We need some advice on how to handle some large table autovacuum
> issues. One of our 8.1.2 autovacuums is launching a DB-wide
> vacuum on our 270GB database to prevent xid wrap-around, but is
> getting hung-up and/or bogged down for hour
On Jan 3, 2008 2:27 AM, Martin Langhoff <[EMAIL PROTECTED]> wrote:
> Is it possible to segregate the PITR data by database at any stage? We are
i don't think so.
My guess is that at snapshot time, I could use oid2name to focus on the
> database I'm interested in plus core Pg data structures,
On Dec 22, 2007 12:10 AM, Marc <[EMAIL PROTECTED]> wrote:
> Hey Folks,
>
> This query is running really slowly. Sometimes much slower then others.
> I have a feeling that there may be contention on one of the indices it is
> using.
>
> Query and explain plan are below. Seems like it spend the mo
On Dec 21, 2007 8:53 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi
>
> I am trying to upgrade my database from 8.0 to 8.1 and am looking for a
> little info/advice.
>
> This is a production database that we are migrating and it is in CONSTANT
> use, so the maintenance window must be small
On Dec 22, 2007 12:10 AM, Marc <[EMAIL PROTECTED]> wrote:
> Hey Folks,
>
> This query is running really slowly. Sometimes much slower then others.
> I have a feeling that there may be contention on one of the indices it is
> using.
>
> Query and explain plan are below. Seems like it spend the mo
On Dec 5, 2007 9:19 AM, pc <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to redirect the output of an sql command to a file?
> Thanks in advance
if you are using psql
postgres=# \o ~/sql.out
postgres=# select * from foo;
the output will be directed to a file, when you need to stop doing it
postgre
On Dec 6, 2007 8:03 AM, Efraín López <[EMAIL PROTECTED]> wrote:
> Thank you for your reply
>
> but I got the error 'LC_MESSAGES' : undeclared identifier
>
> locale.h only defines LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC,
> LC_TIME
>
> I tried to set a system variable LC_MESSAGES, but didn't w
On Dec 2, 2007 6:35 PM, rokj <[EMAIL PROTECTED]> wrote:
> Hi.
>
> For an example let me say that I have a big (over 1 million) user
> "base". Then every user does a lot of inserting/updating of data.
> Would it be better to create different tables for insert/updating for
> every user or would it
On Dec 2, 2007 7:40 AM, Dragan Zubac <[EMAIL PROTECTED]> wrote:
> Hello
>
> I have a stored procedure which does the billing stuff
> in our system,it works ok,but if I put in
> production,where there is some 5-10 billing events per
> second,the whole database slows down. It won't even
> drop some
On 11/30/07, Glyn Astill <[EMAIL PROTECTED]> wrote:
>
> Hi People,
>
> I've setup a postgres 8.2 server and have a database setup with UTF8
> encoding. I intend to read some of our legacy data into the table,
> this legacy data is in ASCII format, and as far as I know is 8 bit
> ASCII.
>
> We have
On 11/29/07, Ragnar Heil <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> our customer has got the following requirements:
>
> Req1) Master master replication supported, not only master / slave
> replication with only the master being writable. If you do have multiple
> slave systems they are only useful from
On 11/30/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
> Guillaume Pungeot wrote:
> > Hi,
> > I have a problem when a lot of connexions are opened on postgresql.
> >
> > When 243 threads have been created by postmaster, the next CreateThread
> > fails and the following error is written in pglogs
On 11/28/07, della <[EMAIL PROTECTED]> wrote:
>
> hi, I describe my steps:
>
> 1. installed postgresql 8.2 via apt-get (ubuntu gutsy)
> 2. # sudo -u postgres psql template1
> 3. template1=# CREATE ROLE kokomo WITH LOGIN CREATEDB PASSWORD
> 'kokomo';
> 4. template1=# \q
> 5. # createdb kokomo_dev -U
Or you can try using a simple packet sniffer, maybe ,ethereal , to see if
name resolution is going on, i had similar problems with MySQL name
resolution in the past and they generally went away after disabling its name
resolution and just use IPs
On Nov 29, 2007 1:23 PM, Shane Ambler <[EMAIL PROTE
On Nov 29, 2007 6:27 PM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
> I'll take that as a "no".
> What i mean is to actually run exactly one cluster (no replicated copy) on
> more than one server. Of course, if that were possible, why would people
> bother with replication..
>
> I guess it is irrat
As far as automatic archiving is concerned the easiest would be to provide
something similar to "archive_command" , however i can't imagine how the
second suggestion could be useful, that sounds like pretty dangerous to me.
On Nov 29, 2007 9:20 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> On T
There is no direct system information function like pg_get_indexdef etc, but
you can find the enum labels in pg_enum catalog table, and there are some
enum support functions
See if they help you
http://www.postgresql.org/docs/8.3/static/functions-enum.html
On Nov 29, 2007 1:53 PM, Richard Broersm
what i do is setup a cron job which runs daily or every second day, creates
a tar.gz and copies them to a seperate location, and then another cron job
which clears up archives more than one month old. That seems to be the way
to go, i don't think you will find a postgresql.conf parameter which does
i has exactly the same discussion with a bunch of java developers over the
use of Hibernate with Postgres, and most of them feel that it gives them the
ability to write code and not worry about which backend will be plugged in
Oracle or postgres or Mysql and any other, if you are using it with
some
i have experience with Hibernate and postggresql, what information are you
exactly looking for?
On Nov 29, 2007 1:52 PM, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Hello,
>
> any exprerience with Hibernate + PostgreSQL ? How does this combination
> is flexible and smart ? Is't possible to tune se
20 matches
Mail list logo
