Please forgive me if this is silly, but if you wanted XML from the server,
couldn't you just write a PL/Perl untrusted function that takes a SELECT
statement as its parameter, and returns a single scalar containing the XML?
- The XML:: modules in Perl help with the XML formatting
- DBD::PgSPI
-Original Message-
From: Greg Stark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 12:17 AM
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal
[...snip...]
I might suggest again RT. It's open source and has serious commercial
traction.
My apologies, then! I was operating off of the statements
of others, and the
fact that the only RT impelementations I've used were running
on MySQL. So,
questions:
1) can you compare/contrast RT vs. BZ vs. Simplified
bug-tracking, like
GForge?
I've used Bugzilla for
Janos,
So far, all of the solutions that are being seriously considered seem to be
free, open-source software. I can't find any indication on your site that
this is software the PostgreSQL community can hack to bits as needed over
the years. Even if it's free now, there's the possibility that it
Ordering the pg_dump output by name within classes instead of OID sounds
good to me, too.
Also, something that might be easier for comparing schemata between
databases: rather than dumping the database, have you tried using PostgreSQL
Autodoc (http://www.rbt.ca/autodoc/) which just outputs the
From: Gaetano Mendola [mailto:[EMAIL PROTECTED]
I think I have to discard also the addresses with last octet
equal to 256.
Any comments ?
Any octet that contains a number less than 0 or greater than 255 should be
suspect.
Assuming you really meant 255:
It would be perfectly legal
Andreas wrote:
AFAICS, we have some alternatives:
- try to grab the currently created files/syslog/eventlog.
Seems hard to
do, because we'd depend on additional external tools.
- redirect stderr to a postgresql.conf known file.
Disadvantage: breaks
piping.
- maintain a sharedMem for
Tom Lane wisely wrote:
While we clearly want this functionality, I tend to agree with Barry
that COMMIT IGNORE ABORT (and the other variants that have
been floated)
is a horrid, confusing name for it. I would suggest using
END with some
modifier, instead. Perhaps
END [ WORK |
Title: RE: [HACKERS] psql \e broken again
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Is there a Windows port of the command-line cvs tool? That
would be a
good thing to compare with.
The one that I see most often ( and use here ) is CVSGUI ( http://www.wincvs.org/ ), which
Title: RE: [HACKERS] psql \e broken again
From: Zeugswetter Andreas DAZ SD [mailto:[EMAIL PROTECTED]]
I am not sure the test is valid, since %EDITOR% was used on
the command line,
which does it's own magic on quotes. Is there a command that
would use the
envvar EDITOR without
Title: RE: [Testperf-general] Re: [HACKERS] ExclusiveLock
The impression I had was that disk drives no longer pay the slightest
attention to interleave specs, because the logical model
implied by the
concept is too far removed from modern reality (on-disk buffering,
variable numbers of
Title: RE: [Testperf-general] Re: [HACKERS] ExclusiveLock
From: Doug McNaught [mailto:[EMAIL PROTECTED]]
Bort, Paul [EMAIL PROTECTED] writes:
One other thought: How does static RAM compare to disk
speed nowadays?
A 1Gb flash drive might be reasonable for the WAL if it
can keep
Title: RE: [Testperf-general] Re: [HACKERS] ExclusiveLock
From: Kenneth Marshall [mailto:[EMAIL PROTECTED]]
[snip]
The simplest idea I had was to pre-layout the WAL logs in a
contiguous fashion
on the disk. Solaris has this ability given appropriate FS
parameters and we
should be able
Title: RE: [HACKERS] Call for port reports
Port report for Gentoo (www.gentoo.org) Linux: No errors.
uname -a:
Linux imgvmhost 2.4.26-gentoo-r3 #1 Tue Sep 7 14:20:02 EDT 2004 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz GenuineIntel GNU/Linux
gcc -v:
gcc version 3.3.4 20040623 (Gentoo Linux
Title: RE: [HACKERS] [PATCHES] Merge pg_shadow pg_group -- UNTESTED
a) start from the user:
Search for useroid in pg_auth_members.member
For each returned role, search for that role in member column
Repeat until all roles the useroid is in have been found
[Note: This could possibly be
Title: RE: [HACKERS] Escaping the ARC patent
Just an idle thought, but each connection to the DB could add a fixed
amount to some queueing parameter. The amount added to be set
per backend,
and the client could use a SET variable to adjust the
standard amount for
it's own
Title: RE: [HACKERS] New form of index persistent reference
If that ID is the only thing you use to access that data, why not just store it in a flat file with fixed-length records? seek() (or your language's equivalent) is usually fast.
If you need to drive that from within PostgreSQL, you
Title: RE: [HACKERS] We are not following the spec for HAVING without GROUP BY
Would those of you with access to other DBMSes try this:
snip
Results for Microsoft SQL Server 2000 - 8.00.944 (Intel X86):
---
(0 row(s) affected)
---
1
(1 row(s) affected)
Title: RE: [HACKERS] Raw size
990 * 2072 = 2,051,280 Bytes
BUT after clustering triples according to an index on att1:
snip
142 * 8 * 1024 = 1,163,264 Bytes
Is there any compression or what?
varchar means 'character varying'. What varies is the length. So a varchar(1000)
Title: RE: [HACKERS] RFC: built-in historical query time profiling
I see your point. The ugliness of log-parsing beckons.
Maybe it would make sense to use a separate log server machine, where they could be written to a database without impacting production?
I'll second autodoc. Been using it with Docbook and Dia for over a year
with good results.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Dunstan
Sent: Thursday, February 23, 2006 12:00 PM
To: Markus Schaber
Cc: Ron Peacetree;
I wonder if Oracle ever recommended disabling PL/SQL (not to
mention MS Transact-SQL)...
Don't know abiout Oracle, but you can't disable Transact-SQL in SQL
Server 7.0 or 2000 (don't know about 2003^h5) because Enterprise Manager
and sp_help* require it.
And +1 for not installing plpgsql
Some of the SysInternals tools might be a start.
ProcessExplorer provides information about processes:
http://www.sysinternals.com/Utilities/ProcessExplorer.html
DebugView shows Debugging output (not sure if PG uses this):
http://www.sysinternals.com/Utilities/DebugView.html
Also, I haven't
Personally I would much rather see a tuning advisor tool in
more general
use than just provide small/medium/large config setting files.
True dat.
Maybe the SoC project here is just such a tuning advisor tool? Something
that can run pgbench repeatedly, try different settings, and compare
Compressed-filesystem extension (like e2compr, and I think either
Fat or NTFS) can do that.
Windows (NT/2000/XP) can compress individual directories and files under
NTFS; new files in a compressed directory are compressed by default.
So if the 'spill-to-disk' all happened in its own
BTW, I think the writer would actually need to bump the
counter twice,
once before and once after it modifies its stats area.
Else there's
no way to detect that you've copied a partially-updated stats entry.
Actually, neither of these ideas works: it's possible that
the reader
* reader's read starts before and ends after writer's update: reader
will certainly note a change in update counter.
* reader's read starts before and ends within writer's update: reader
will note a change in update counter.
* reader's read starts within and ends after writer's update:
so presumably this is only needed for old Cygwin versions. Can anyone
say how old 1001 is and whether we still ought to care about it?
IIRC, I've been on 1.5.x for at least three years. 1.0/1.1 seems to be
around 2000/2001, based on a quick Google. So it's definitely older than
PG 7.3.
Tom Lane said:
To make use of a TruncatedTuple, we'd set up a temporary HeapTupleData
struct with its t_data field pointing 16 bytes before the start of the
TruncatedTuple. As long as the code using it never tries to
access any
of the missing fields (t_xmin through t_ctid), this would
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Peter Eisentraut
Taking a step back here, I see two points in favor of
including PL/Java or
something like it into the main CVS:
1. Build farm support
It seems that eventually one would like to have build farm
On UNIX systems uname may work pretty well. But I guess each
system may
have slightly different options. What'll probably happen is that you
end up with a big if() statement testing $Config{osname} wtih
each case
having specific code to determine the specifics. But for that you need
How do you do this from a program though. Under UNIX uname() is a
function call as well as a program. It returns the os name, version,
hostname and system type.
Multiple methods (TIMTOWTDI) depending on what you want:
my $verstring = `cmd.exe /c ver`;
# or
use Win32;
my ($string,
Andrew Dunstan [EMAIL PROTECTED] writes:
Well, we have a result, courtesy of a special run from Stefan:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=seahorsedt=
2006-07-19%2017:52:41
has:
Command was:
C:/msys/1.0/home/pgbuild/pgfarmbuild/HEAD/pgsql.804/src/test
-hackers,
With help from Andrew Dunstan, I'm adding the ability to do a pgbench
run after all of the other tests during a buildfarm run.
Andrew said I should solicit opinions as to what parameters to use. A
cursory search through the archives led me to pick a scaling factor of
10, 5 users, and
100 transactions seems barely enough to get through startup
transients.
Maybe 1000 would be good.
OK.
I think the hard part of this is the reporting process. How
do we track how performance varies over time? It doesn't
seem very useful to compare different buildfarm members, but
a
Andrew Dunstan wrote:
We are really not going to go in this direction. If you want ideal
performance tests then a heterogenous distributed collection of
autonomous systems like buildfarm is not what you want.
You are going to have to live with the fatc that there will be
occasional,
Greg Stark asked:
I know Oracle calls this online index builds. In fact it
works similarly
with a single keyword online tacked on near the end of the
create index
statement.
Anyone know what MSSQL or DB2 call it?
I have to live with MSSQL at work, and I didn't remember anything like
Tom Lane wrote:
psql could actually tell these apart if it worked just a bit harder.
CLUSTER with no arguments is the one case, CLUSTER with
anything after it is the other. Not sure why we couldn't be
bothered to get that right in psql the first time :-(.
Should this go on the to-do
Jim Nasby wrote:
Why is it being hard-coded? I think it makes a lot more sense to allow
pg_bench options to be specified in the buildfarm config. Even better
yet would be specifying them on the command line, which would allow
members to run a more rigorous test once a day/week (I'm thinking
Peter Eisentraut wrote:
Memory units are kB, MB, GB. The factor is 1024.
Then shouldn't the factor be 1000? If the factor is 1024, then the units
should be KiB, MiB, GiB per IEEE 1541
(http://en.wikipedia.org/wiki/IEEE_1541) and others.
I'm not trying to be pedantic, but the general
Gregory Start wrote:
Fwiw a few data points:
MSSQL uses (WITH ONLINE=ON) much like we and Oracle use ONLINE tacked
on to the
end of the create index command.
Where did you find this? I thought my MSDN-foo was pretty good, and I
didn't find this when searched a couple days ago.
Peter Eisentraut wrote:
I'd imagine that one of the first things someone will want to try is
something like SET work_mem TO '10MB', which will fail or misbehave
because 1000 bytes do not divide up into chunks of 1024
bytes. Who
wants to explain to users that they have to write
Peter Eisentraut politely corrected:
For your entertainment, here are the usage numbers from the
linux-2.6.17
kernel:
kilobyte (-i) 82
kibibyte (-i) 2
megabyte (-i) 98
mebibyte (-i) 0
gigabyte (-i) 32
gibibyte (-i) 0
KB1151
kB407
KiB 181
MB
Martijn van Oosterhout wrote:
How about this:
INFO: Your setting was converted to IEC standard binary
units. Use KiB,
MiB, and GiB to avoid this warning.
That's silly. If you're going to treat KB as 1024 bytes anyway,
complaining about it is just being pedantic.
But after a
Peter Eisentraut wrote:
I have committed it using the 1024 multiplier, but if you want to
propose changing all uses of kB, MB, and GB in PostgreSQL to
the other
system, now would be the time to do it.
I think it would be a good idea. I know I don't have time to do it for
8.2.
I get
Peter Eisentraut wrote:
This consideration would become much more interesting if
*any* software
product actually made use of this newer proposed convention,
but so far
I haven't seen one yet.
So we'll look at it when Oracle does it?
I think we should be leading this charge, rather
Peter Eisentraut wrote:
I didn't say Oracle, I said anyone. It could be Microsoft or
Samba or
Red Hat or NetBSD or my VoIP phone.
OK, I did some further digging, and
(http://members.optus.net/alexey/prefBin.xhtml) has a list at the end of
the page of software that the author claims use
Kenneth Marshall wrote:
RT is easy to setup/configure/use and works well with PostgreSQL as
the backend.
RT works with Postgres, but I wouldn't say well. All queries
in RT are generated by a query generator due to a naive
obsession with database independance. They've achieved
Am Freitag, 25. August 2006 16:31 schrieb Reinhard Max:
But shouldn't mountpoints always have 000 permissions to prevent
writing into the directory as long as nothing is mounted to it?
That's an interesting point, but in practice nobody does
that. And we're
trying to defend exactly
Gregory Stark writes:
Tom Lane [EMAIL PROTECTED] writes:
There isn't if you want the type to also handle long strings.
But what if we restrict it to short strings? See my
message just now.
Then it seems like it imposes a pretty hefty burden on the user.
But there are a lot of
I don't think so...the columns of update_test are visible to the
scalar subquery...that way you can use fields from 'a'
to filter the
subquery...
select a, (select y from supdate_test where x = a) from
update_test;
Yes this is fine, but in select
Tom Lane wrote:
I think that the easiest fix might be to not remove no-longer-used
segment files during a truncate, but simply reduce them to zero size
rather than delete them. Then any open file pointers aren't
invalidated. The only alternative I can see is to invent some new
signaling
52 matches
Mail list logo