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 already
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
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
of the
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 threshold
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
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 possible. If
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
postgresql jdbc
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 test
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 notes are already
+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 addendum :). E.g; this
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 look like?
= '\000\000\011' IIRC
What do you expect to happen when server and client are
differently-endian?
-Doug
Usama Dar írta:
Does it matter if you have written an explicit cast for int to bytea?
You don't know what't endianness is, do you?
Say, you have a number: 0x12345678
14 matches
Mail list logo