>
> 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 "se
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
> signal
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
>
> 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
>
> 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 achiev
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
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, ra
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
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.
Bu
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
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 '
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.
R
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 ap
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 think
> 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
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 an
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
> occasio
> 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, b
-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 1
> >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=seahorse&dt=
> 2006-07-19%2017:52:41
> has:
>
> Command was:
> ""C:/msys/1.0/home/pgbuild/pgfarmbuild/HEAD/pgsql.804/src/te
>
> 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,
>
> 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 nee
> 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 fa
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 woul
>
> 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
>
> * 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 u
>
> > 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
>
>
> 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 spe
> > 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 co
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 use
>
> 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 plpgs
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; pgs
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?
Title: RE: [HACKERS] Raw size
>
> 990 * 2072 = 2,051,280 Bytes
>
> BUT after clustering triples according to an index on att1:
>
>
> 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(1
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:
Results for "Microsoft SQL Server 2000 - 8.00.944 (Intel X86)":
---
(0 row(s) affected)
---
1
(1
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, yo
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 b
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 c
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 3.3.4
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
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
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
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: [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/ ), wh
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 [ WO
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 shared
> 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 l
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 sc
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
>
> 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
> -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
> tr
> Interesting, when I went to copy my data directory out of the way, I
> received this from cp:
>
> cp: data/base/16976/17840: Result too large
>
> might be a clue
I don't think it's PostgreSQL. I would suggest unmounting the volume and
running fsck (or the equivalent for your environment.)
I
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 could
53 matches
Mail list logo
