Hi Hackers,
I have a strange problem, or maybe it's not a strange problem but just
something wrong with my understanding i have SIP router which works with
postgresql using libpq, somewhere in the code it inserts a row in the
database and then when the insert is finished it invokes another module
On Jan 7, 2008 2:40 PM, Michael Akinde <[EMAIL PROTECTED]> wrote:
> As suggested, I tested a VACUUM FULL ANALYZE with 128MB shared_buffers
> and 512 MB reserved for maintenance_work_mem (on a 32 bit machine with 4
> GB RAM).
My Apologies if my question seems redundant and something you have alr
Doug Knight wrote:
We are running the binary distribution, version 8.2.5-1, installed on
Windows XP Pro 32 bit with SP2. We typically run postgres on linux,
but have a need to run it under windows as well. Our typical admin
tuning for postgresql.conf doesn't seem to be as applicable for windows
On Jan 3, 2008 8:57 PM, Doug Knight <[EMAIL PROTECTED]> wrote:
> All,
> Is there a place where I can find information about tuning postgresql
> running on a Windows XP Pro 32 bit system? I installed using the binary
> installer. I am seeing a high page fault delta and total page faults for one
>
On Jan 3, 2008 7:39 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Sure, feel free to propose a specific ordering. I think you would need
> to take table size into account too.
Thanks, i thought we were already taking the database size into account
somewhat when we calculate the vacuum thresho
OK, so i was going through the autovacuum code and i noticed that when we
construct the table list to vacuum in a database per run, we don't process
them in a particular order. I mean since we pick the list up from pg_class
so it may be ordered on oid? but when we select a database we have a
priori
On Dec 22, 2007 7:40 PM, Andrew Chernow <[EMAIL PROTECTED]> wrote:
> >Tom Lane wrote:
> >>range-checks are present only where needed for the backend to defend
> itself
>
> Survival is very important, but so is maintaining data integrity. IMHO,
> data
> validation should be as consistent as poss
On Dec 6, 2007 5:26 PM, srinath narra <[EMAIL PROTECTED]> wrote:
> hi,
>
> when i connecting my postgresql which giving
> org.postgresql.util.PSQLException: ERROR: conversion between UNICODE and
> MULE_INTERNAL is not supported.please send solution about this problem.
>
> Srinath
>
postgre
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 Nov 30, 2007 11:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
> > I disagree. For people who want a quick summary of the major
> user-facing
> > things changed we'll have multiple sources: (a) the announcement, (b)
> the
> > press features list, (c) the
On 11/30/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
>
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>
> > If people understand there aren't 13 performance improvements there are
> > at *least* 19+ that is a positive message to help people decide to
> > upgrade.
>
> Frankly I think the release not
Thu, 29 Nov 2007, Gregory Stark wrote:
> > >
> > > > What do you want the resulting bytea to look like?
> > > >
> > > example : id = 9 , bytea = '\000\000\011' IIRC
> >
> > What do you expect to happen when server and clie
Does it matter if you have written an explicit cast for int to bytea?
On Nov 29, 2007 9:00 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> On 11/29/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> > On Thu, 29 Nov 2007, Gregory Stark wrote:
> >
> > > What do you want the resulting bytea to
+1
On Nov 29, 2007 4:09 AM, Andreas 'ads' Scherbaum <[EMAIL PROTECTED]>
wrote:
> On Tue, 27 Nov 2007 15:37:04 -0500 Tom Lane wrote:
>
> > "Andreas 'ads' Scherbaum" <[EMAIL PROTECTED]> writes:
> > > On Tue, 27 Nov 2007 11:08:58 -0800 Joshua D. Drake wrote:
> > >> Release 7.3.21 with and EOL addend
14 matches
Mail list logo
