Hi,
On Fri, Jun 12, 2009 at 11:18 PM, Kevin
Grittner wrote:
> Dave Page wrote:
>
>> Please try now.
>
> It now works for me.
So do I. Thanks!
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hack
This errdetail doesn't seem quite right in the following situation:
rhaas=# select distinct proacl from pg_proc;
ERROR: could not implement DISTINCT
DETAIL: Some of the datatypes only support hashing, while others only
support sorting.
...Robert
--
Sent via pgsql-hackers mailing list (pgsql-h
On Friday 12 June 2009 08:15:17 Robert Haas wrote:
> Here we go, XML and JSON output.
Could you post some examples of how some plans would look in either format?
That would help us judge the particulars.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to y
On Fri, Jun 12, 2009 at 5:13 PM, Andrew Dunstan wrote:
> Josh Berkus wrote:
>>
>>> How would you go about extracting the XML/JSON bits from the rest of
>>> what is in the log file? (apologies if this is a question I should
>>> already know the answer to)
>>
>> If you do CSV output, it's in a field
Dimitri Fontaine writes:
> Le 12 juin 09 à 21:49, Tom Lane a écrit :
>> It seems to me it could still do
>> with a lot more detail to specify what API the functions are really
>> expected to implement.
> I'm sorry I'm not following... I guess you're talking about a better
> high-level view of t
Josh Berkus wrote:
How would you go about extracting the XML/JSON bits from the rest of
what is in the log file? (apologies if this is a question I should
already know the answer to)
If you do CSV output, it's in a field.
And even if it's not, a well formed XML document would be fairly
Hi,
Le 12 juin 09 à 21:49, Tom Lane a écrit :
Applied with some editorialization.
Thanks a lot :)
It seems to me it could still do
with a lot more detail to specify what API the functions are really
expected to implement.
I'm sorry I'm not following... I guess you're talking about a bette
Dimitri Fontaine writes:
> I've been working some more on this documentation:
Applied with some editorialization. It seems to me it could still do
with a lot more detail to specify what API the functions are really
expected to implement.
regards, tom lane
--
Sent via p
How would you go about extracting the XML/JSON bits from the rest of
what is in the log file? (apologies if this is a question I should
already know the answer to)
If you do CSV output, it's in a field.
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
Sent via pgsql-hackers maili
On Fri, Jun 12, 2009 at 11:47 AM, Josh Berkus wrote:
> On 6/11/09 10:15 PM, Robert Haas wrote:
>>
>> Here we go, XML and JSON output.
>>
>> You will need to apply explain_refactor-v4.patch and
>> explain_options-v2.patch first, then apply the two patches attached to
>> this message.
>
> Wow, cool.
"Albe Laurenz" writes:
> The attached patch states that we support 4.3.3 to 6.1, removes the
> comment for version 4.3.2 and adds a table of minimum recommended fix
> levels for AIX.
Applied with a bit of additional wordsmithing. Thanks!
regards, tom lane
--
Sent via p
On 6/11/09 10:15 PM, Robert Haas wrote:
Here we go, XML and JSON output.
You will need to apply explain_refactor-v4.patch and
explain_options-v2.patch first, then apply the two patches attached to
this message.
Wow, cool. Can this work with auto_explain? That's where I see
machine-readable
Shadar wrote:
>>> There have been several suggestions already.
>
> Yes, but other have commented that these (e.g. dropping TOAST table)
> might not work and even lose data, so I was left confused as to what
> would work...
Well, dropping the TOAST table once you have data in it will lose
data
Tom Lane wrote:
> The code change is already made for RC1, but if you want to send in a
> patch to improve the docs, feel free. I left it with just a vague
> recommendation to update to the latest fixpack:
> http://developer.postgresql.org/pgdocs/postgres/installation-platform-notes.html#INSTALLAT
> I am from Cambodia. I want to use PostgreSQL. But I am poor of knowledge to
> install could you please help me give some guide to install PostgreSQL on
> Solaris 10,
(+ to pgsql-general)
Try to use the general list for these cases, you could obtain better
results ;)
The documentation for Sola
> 2. How can I disable TOAST? Only by changing TOAST_TUPLE_THRESHOLD
> and TOAST_TUPLE_TARGET in the include file and compiling a private
> version?
>> There have been several suggestions already.
Yes, but other have commented that these (e.g. dropping TOAST table) might
not work and even lose
"Albe Laurenz" writes:
> After we have word from Merlin, I'd write a patch that changes
> src/backend/libpq/ip.c and src/frontend/libpq/ip.c to undo the AIX hack
> and adds documentation to section 15.8.1 that states the recommended
> fix levels per AIX version.
> I won't get to do that before Mon
Shadar wrote:
> 1. Am I correct in assuming that in my case the TOAST mechanism
> probably results in a performance hit, not boost,
Possibly, but you didn't give enough information to be sure. One
important factor would be how often the table in question has updates
or deletes. If those are
Dave Page wrote:
> Please try now.
It now works for me.
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Fri, Jun 12, 2009 at 9:45 AM, Fujii Masao wrote:
> Hi,
>
> $ cvs update
>
> cvs update: Updating src/backend/commands
> cvs update: [08:32:37] waiting for anoncvs's lock in
> /projects/cvsroot/pgsql/src/backend/commands
> cvs update: [08:33:07] waiting for anoncvs's lock in
> /projects/cvsr
Tom Lane wrote:
> Bruce Momjian writes:
> > Fujii Masao wrote:
> >> The cvs's lock remains held? Why?
>
> > Seems OK from my computer.
>
> Were you checking anoncvs or the master?
Oh, sorry, I was checking master.
--
Bruce Momjian http://momjian.us
EnterpriseDB
Bruce Momjian writes:
> Fujii Masao wrote:
>> The cvs's lock remains held? Why?
> Seems OK from my computer.
Were you checking anoncvs or the master?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscri
Bruce Momjian wrote:
> Fujii Masao wrote:
>> $ cvs update
>>
>> cvs update: Updating src/backend/commands
>> cvs update: [08:32:37] waiting for anoncvs's lock in
> Seems OK from my computer.
I'm having the problem. Same directory.
-Kevin
--
Sent via pgsql-hackers mailing list (pgs
Fujii Masao wrote:
> Hi,
>
> $ cvs update
>
> cvs update: Updating src/backend/commands
> cvs update: [08:32:37] waiting for anoncvs's lock in
> /projects/cvsroot/pgsql/src/backend/commands
> cvs update: [08:33:07] waiting for anoncvs's lock in
> /projects/cvsroot/pgsql/src/backend/commands
>
Hi,
We trying to port PostgreSQL to Windows x64.
It based on Windows 64bit patch which are posted before.
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00440.php
Is there someone working in progress about it ?
This patch works if total activity memory is less than 2GB,
but when memor
On Fri, Jun 12, 2009 at 7:42 AM, Albe Laurenz wrote:
> Which raises a final question for me:
> The documentation mentions support from 4.3 on, and there are specific
> comments for 4.3.2.
> We can't say anything for versions before 4.3.3, can we?
> Should we drop versions < 4.3.3 even if Merlin rep
Tom Lane wrote:
>> On Thu, Jun 11, 2009 at 9:50 AM, Tom Lane wrote:
>>> Where are we on this?
>
>> waiting on a patch? Albe? (or should I do it myself?)
>
> I thought the proposed patch was just "remove the special case for AIX
> in src/backend/libpq/ip.c".
Yes.
The only bugs at IBM that are l
Guys,
I appreciate your intentions to treat this more flexibly in a future
release. But I'm not sure I got a reply to my original questions, about the
existing 8.3 version:
1. Am I correct in assuming that in my case the TOAST mechanism probably
results in a performance hit, not boost, and is th
Hi,
$ cvs update
cvs update: Updating src/backend/commands
cvs update: [08:32:37] waiting for anoncvs's lock in
/projects/cvsroot/pgsql/src/backend/commands
cvs update: [08:33:07] waiting for anoncvs's lock in
/projects/cvsroot/pgsql/src/backend/commands
cvs update: [08:33:37] waiting for ano
Dear sir/madam,
I am from Cambodia. I want to use PostgreSQL. But I am poor of knowledge to
install could you please help me give some guide to install PostgreSQL on
Solaris 10,
Thanks for your respond and value times.
Brs,
Lyvar
Cambodia
30 matches
Mail list logo
