er vendors'
database products due to their parallel feature set (make -j 9 is nice
too), but behaves like the boat-anchor it is w.r.t. PostgreSQL.
Mike Mascari
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
aborts after step 3,
but newer transactions commit?
Mike Mascari
---(end of broadcast)---
TIP 6: explain analyze is your friend
Andrew Dunstan wrote:
Mike Mascari wrote:
but the side effect function will only run (unless you set it with
security definer) with the privileges of the caller - it won't grant
visibility to things that user can't otherwise see.
If the visibility is determined by view definition
Neil Conway wrote:
Mike Mascari wrote:
People who use views to achieve row security, which is a rather common
paradigm, cannot allow users to create functions with side effects.
Can you elaborate? I'm not sure I follow you.
(I'll note anyway that (1) SQL functions can have side effec
gm, cannot allow users to create functions with side effects.
Mike Mascari
---(end of broadcast)---
TIP 8: explain analyze is your friend
BEN-US%3BQ241733
My code expects to find an shfolder.dll on < Windows 2000 systems and a
shell32.dll on >= Windows 2000 systems. As I said, I *believe* you can
guarantee success by just shipping shfolder.dll with the application.
Hope that helps,
Mike Mascari
---(end
data is composed entirely
of NULL in 8.0?
http://archives.postgresql.org/pgsql-performance/2004-11/msg00363.php
Mike Mascari
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
image onto the next page, discover it is too large to
fit on the next page, generate a page break, and the process continues
ad infinitum.
Maybe a recent large image was added to the docs?
FWIW,
Mike Mascari
---(end of broadcast)---
TIP 7: don'
ackers Emeritus section?
Eh?
Mike Mascari
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
7;8.13 inches'
And of course, the various types would be constrained appropriately.
One couldn't have a negative LENGTH or a TEMPERATURE under absolute
zero, as examples. I think it would be neat to have an external
library supporting a large set of types like these.
Tom Lane wrote:
Mahmoud Taghizadeh <[EMAIL PROTECTED]> writes:
a dirty method to fix this bug is to replace following
Are you aware that the monetary type is deprecated and is going to be
dropped entirely pretty soon?
What's taking so long? ;-)
Mike Mascari
---
which determined the major
contributors to open source software and it read something like:
1. UC Berkeley
2. MIT
3. Tom Lane
4. Carnegie Mellon
5. IBM
I wish I had the link...
Mike Mascari
---(end of broadcast)---
TIP 7: don't forget to increase
ates
some complexities that are akin to science-fiction stories about time
travel and parallel universes."
Is it science-fiction, or just relativity?
Mike Mascari
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unr
aggregate functions, I agree
with your analysis, so long as the fact that an ffunc may be invoked
more than once is well documented, (i.e. an SGML section
might be nice.)
Mike Mascari
---(end of broadcast)---
TIP 7: don't forget to inc
&ie=UTF-8&selm=40B74B73.6080702%40mascari.com
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Simon Riggs wrote:
On Mon, 2004-07-05 at 23:40, Mike Mascari wrote:
hmmm...not sure I know what you mean.
It is very-very-close-to-impossible to edit the transaction logs
manually, unless some form of special-format editor were written for the
purpose.
Is it clear that the PITR features are
IMHO,
Mike Mascari
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
he possibility as a
solution in the enterprise if they think they'll look like a fool
pronouncing the name aloud. I remember back in '94 being "corrected"
when talking about Linux in the enterprise - and I was corrected in
the wrong direction.
Someone needs to poke the propaga
WORK ] [ AND[ NO ] CHAIN ]
[ ]
::=
TO SAVEPOINT
Mike Mascari
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get th
Inheritance: No
I think it'd be a fair statement that Date & Darwen would have the
relvar inheritance ripped out of PostgreSQL as an experiment gone bad...
Mike Mascari
P.S.: D is the language of the future:
http://www.digitalmars.com/d
Ha!
---(end of
L
Later versions of one of the Access components (jet, mdac,
access.exe - who knows where) changed its behavior and never
performed similarly...
Mike Mascari
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ly. I think it's Bill Gates leading a secret life...
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
nerability:
http://www.us-cert.gov/cas/techalerts/TA04-147A.html
For what it's worth,
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Marc G. Fournier wrote:
On Mon, 17 May 2004, Mike Mascari wrote:
A quick google of "7.4 Win32 release" will reveal that the above was
precisely what was said about 7.4: it would be released to not hold
up important features like the IN optimization and a quick 7.5 would
have Win32 and
eased to not hold
up important features like the IN optimization and a quick 7.5 would
have Win32 and PITR. It's almost as if a cron job reposts this
thread every 6 - 12 months. For those of us that are desirous of
PITR, it's a 6 month reposting that is becoming p
it does
become data. Has the advocacy group performed any polling in this
area that might shed some light as to what users and potential users
might want?
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensiv
nctions to read
the image file from disk?
PostgreSQL really needs a maintained type library as a single
project where people can contribute types, functions, operators, and
aggregates, such as the recently discussed email type.
Mike Mascari
Just be sure not to actually compress/decompress t
ped 20% of the bits in the postgres binary you'd
not find it to be more buggy than the Postgres95/early 6.x series...
Mike Mascari
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ciated with the comment. Example:
COMMIT WORK COMMENT 'A complex distributed Tx';
Perhaps there is some common ground between the 2PC implementation
and PITR?
Mike Mascari
---(end of broadcast)---
TIP 2: you can get off all lists at once wi
way queries on Oracle is only a necessity
if the DBA hasn't made use of resource limits - PROFILEs. ;-)
Mike Mascari
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
rom eleven to twelve. With your new fuzzy comparison
patch is twelve still the appropriate number? Or does the fuzzy
comparison scale all planning time down and therefore the default
threshold should remain where it is?
Mike Mascari
---(end of broadcast)-
't know if Rod has plans to change attempts to COMMENT ON
non-local databases to an ERROR in 7.5 or not. It was my fault from
the beginning - but once I'd implemented COMMENT ON for tables and
columns I just couldn't stop... :-)
Mike Mascari
Mike Mascari wrote:
..
The comments are s
TED] select count(*) from pg_description;
count
---
1542
(1 row)
[EMAIL PROTECTED] select count(*) from pg_description;
count
---
1541
(1 row)
Mike Mascari
---(end of broadcast)---
TIP 6: Have you searched our list arc
ql
This is SQL*Server syntax:
==
...
select * from foo where bar = 1
...
This is Oracle syntax:
==
SQL> select * from foo where bar = 1;
...
mysql> select * from foo where bar = 1;
Mike Mascari
-
x27;t assuming 32-bit quantities that will break once ~4.2 billion
is reached and I get index scans without quoting or casting free.
But IIRC there's a change in the development tree to jettison the
requirement for quoting/casting...
Mike Mascari
---(end of
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/storage/smgr/smgr.c?rev=1.58&content-type=text/x-cvsweb-markup
Actually, that was an Aug 6, 2002 commit, not 2003 which would make
it 7.3, right? So Simon, my I humbly ask from where you culled this
change in CVS tip?
Mik
pgsql-server/src/backend/storage/smgr/smgr.c?rev=1.58&content-type=text/x-cvsweb-markup
Mike Mascari
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Simon Riggs wrote:
- All operations on TEMP relations are no longer logged in WAL, nor are
they involved in checkpoints, thus improving performance. (Tom)
That is great news!
Looking forward to 7.5 already,
Mike Mascari
---(end of broadcast
er installing PostgreSQL, a message should be output to
read it:
http://conferences.oreillynet.com/presentations/os2002/lane_tom.tar.gz
Mike Mascari
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
last time this subject was dicussed, I believe it was Mike Mascari
who proposed and implemented another solution which is more client-side
oriented.
I humbly confess it wasn't me. We use CORBA....
Mike Mascari
---(end of broadcast)---
problem is in adding OIDs to rows that
initially did not have 'em when returned from the SELECT DISTINCT plan.
Okay.
So your best immediate workaround is to create the first temp table with
oids, or create the second one without.
Thanks!
Mike Mascari
--
rsing?
Mike Mascari
[EMAIL PROTECTED]
Tom Lane wrote:
It occurred to me today that it would not be difficult to implement a
direct check on the physical size of the execution stack.
---(end of broadcast)---
TIP 8: explain analyze is your friend
://www.ecommercetax.com/official_docs/SSTP%20-%20Rounding.pdf
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
eads along
>>>it.
>>
>>How about changing the names of those directories?
>
>
> I thought about that, but what would we call them? We could change xlog
> to wal, I guess. That might actually be clearer. xlog could become
> xstatus or xactstatus or just x
of the disk, you will
get 500 times more bandwidth—you can read or write the disk in a day.
So programmers have to start thinking of the disk as a sequential
device rather than a random access device."
Isn't a TID-List-Fetch implementation a crucial first step in the
right direction?
ww.acm.org/sigmod/record/issues/0309/4.JHdbcourseS03.pdf
How about extra credit for PITR?
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
viewed as window
dressing...
Could be wrong, though...
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
; internals.
>
> Darren
I've learned that a feed into the postgresql-hackers mailing list from
comp.databases.postgresql.hackers can be easily spotted by its
astonishing lack of civility and intelligent discourse... :-(
Mike Mascari
[EMAIL PROTECTED]
---(en
al traffic. er, yeah, that's the ticket. Except who ever
> heard of having express lanes for local traffic. Hm.
All I know is that Jan Wieck would have each car filled to the brim
with spikes
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
PostgreSQL?
1) XA-compatibility/interoperability
or
2) Robustness in the face of network failure
The implementation choosen depends upon the answer, does it not? Is
there an implementation (e.g. 3PC) that can simulate 2PC behavior for
interoperability purposes and satisfy both requirem
y), and how
> one should treat them as such, especially for large data volumes.
Too bad PostgreSQL is misspelled ("Postgress") and MySQL dominates the
open source discussion. And the MySQL questions are coming from:
"David Patterson, who holds the Pardee Chair of Computer Science
inheritance, which of course, are in PostgreSQL.
It's a very provocative read. At a minimum, one can learn what to
avoid with SQL. The language looks neat on paper. Perhaps one day
someone will provide an open source implementation. One could envision
a "D" project along
abase or a BEA Tuxedo TPM acting as the
coordinator. So PostgreSQL won't have an opportunity to modify the
protocol in any meaningful way if it wishes to interoperate with
XA-based transaction managers.
If it is being used only amongst other PostgreSQL backends for
replication, then why
consistent."
So it seems, for Oracle 8 at least, PITR is the method of recovery for
cohorts after unrecoverable coordinator failure.
Ugly and yet probably a prerequisite.
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
, etc.
Just because Oracle and MS do something doesn't necessary make it
wrong. :-)
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
we still time out after a minute's total delay.
>
> Comments?
Should there be any correlation between the manner by which the
backoff occurs and the number of active backends?
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
is can be directly
> atttributed to your work. Thank you. And thank you for the personal help
> back when I was working on the PostgreSQL trigger documentation.
It's hard to imagine PostgreSQL with out MVCC, WAL, subselects, etc.
You know, maybe on the Developer's page there should
his is actually an issue though. Row-level shared locks would be
> really nice to have for foreign-key handling. Right now we have to
> use X locks for those, and that leads to deadlocking problems for
> applications.
Yes! Yes! It's the last big hurdle for an otherwise excellent RI
imple
Jenny - wrote:
http://www.expita.com/nomime.html
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
6 months ago, that the 2PC work
being done by Satoshi Nagayasu was going to be allowed to die on the vine.
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
itting the database changes associated with the
> COMMIT-VOTE response it supplied to the coordinator's PREPARE. It
> seems this would require REDO? And yet there are thousands of
> installed distributed databases running enterprises every day.
Please ignore the REDO remark. It&
ort will block waiting for the coordinator. We're not talking
asynchronous multi-master replication of 4 databases distributed over
low-speed communication lines across the country. We're talking about
the sales dept. database having a few linked tables to the accounting
dept. database, where i
The Hermit Hacker wrote:
> On Sun, 22 Jun 2003, Bruce Momjian wrote:
>
>>Mike Mascari wrote:
>>
>>>I was disappointed that Satoshi Nagayasu's two-phase commit
>>>patches seemed to be implicitly rejected by lack of an
>>>enthusiastic response by
lack of an
enthusiastic response by any of the core members. Distributed
query (not replication) would have been a very nice feature.
It's what separates, in part, Oracle Enterprise Edition from the
Standard Edition, and it appeared someone (Satoshi Nagayasu) was
more than willing to get the ball
r to a question and
it is likely that only a developer will know the answer, you may
re-post that question here. You must try elsewhere first!"
HTH,
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Use
RIALIZABLE
Whoops. Sorry. I though this was confusion regarding phantom rowsand
READ COMMITTED vs. SERIALIZABLE. Nevertheless, I cannot repeat the
above...
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Use
ook 5 minutes. I
then disabled GEQO and the queries ran in around a second. I noticed
that the explicit join syntax will no longer confine planning choices
in 7.4, but is it possible the GEQO threshold, as a default, is too low?
Mike Mascari
[EMAIL PROTECTED]
---(end of broa
etc. A far-reaching, wild suggestion would be to
replace the postmaster with a CORBA-based server process with a
well defined interface. At a minimum, if a binary protocol is
the ultimate destination, perhaps some of the mapping of various
types could be borrowed from the specs.
Mike
Tom Lane wrote:
"Mike Mascari" <[EMAIL PROTECTED]> writes:
Hello. I have some code which generates subselects in the target
list of a query and then aggregates the results. The code allows
the user to determine the attributes of the aggregation. If the
user chooses to aggre
is
PostgreSQL version 7.2.1.
Any help or instruction would be greatly appreciated.
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
..
>A few other changes, like allowing ownership of an object to be a group
>(role) rather than strictly a user.
Also, at least in Oracle, one can grant ROLEs to other ROLEs. I don't know if that is
what the SQL standard says though:
GRANT role1 TO role2;
Mike Mascari
[EMAIL PROTECTE
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
> "Mike Mascari" <[EMAIL PROTECTED]> writes:
> > From: "Tom Lane" <[EMAIL PROTECTED]>
> >> That's a rowtype variable, though, not a record variable. I belie
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
> "Mike Mascari" <[EMAIL PROTECTED]> writes:
> >> Does Oracle's PL/SQL have a concept of record variables? If so, what
> >> do they do in this situation?
>
> >
SQL> insert into employees values (1, 'Mike');
1 row created.
SQL> select foo(1) from dual;
FOO(1)
--
1
SQL> select foo(2) from dual;
FOO(2)
--
SQL> select nvl(foo(2), 0) from dual;
NVL(FOO(2),0)
-
0
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
eeded by a custom C function.
>
> Hmm. Is GUC really the best place for something like that? (not that there
> is any other place :-)).
>
> Gavin
Maybe GUC should be stored in a Berkeley DB? ;-)
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
sybase.com/onlinebooks/group-xs/xsge/xatuxedo/@ebt-link;pt=61?target=%25N%13_446_START_RESTART_N%25
The standard is 2PC based.
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
> Mike Mascari wrote:
> > Okay. But please keep in mind that a 2-phase commit implementation
> > is used for more than just replication.
>
> This is a good point. I don't want to
Tom referenced earlier, but I'd guess there might be an assumption of 2PC
support in the implementation. In other words, I think we still need 2PC, regardless
of the method of replication. And if Satoshi Nagayasu has an implementation ready,
why not investigate its possibilities?
Mike Ma
&lr=&ie=UTF-8&oe=UTF-8&threadm=20021106111554.69ae1dcd.pgsql%40snaga.org&rnum=2&prev=/groups%3Fq%3DNAGAYASU%2BSatoshi%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
imits.
I'm not sure how remote administration is supposed to work under
such a scenario though...
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "u
Tom Lane wrote:
Mike Mascari <[EMAIL PROTECTED]> writes:
I curious if any of the rewriting of EXISTS and NOT EXISTS would
address the problem described by Date:
That should read "I'm curious"...
http://www.firstsql.com/iexist.htm
We are not here to redefine
he problem described by Date:
http://www.firstsql.com/iexist.htm
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
in order at some point in the future though...
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Neil Conway wrote:
Mike Mascari <[EMAIL PROTECTED]> writes:
Is there any thought about changing the protocol to support
two-phase commit? Not that 2PC and distributed transactions would be
implemented in 7.4, but to prevent another protocol change in the
future?
My understanding is th
thing or if there is something you think we should
add, please let me know.
Is there any thought about changing the protocol to support
two-phase commit? Not that 2PC and distributed transactions
would be implemented in 7.4, but to prevent another protocol
change in the future?
Mike Mascari
[
Karel Zak wrote:
On Fri, Oct 25, 2002 at 03:31:22PM -0400, Mike Mascari wrote:
Bruce Momjian wrote:
Added to TODO:
* Allow limits on per-db/user connections
Could I suggest that such a feature falls under the category of
resource limits, and that the TODO should read something like
ever a new
resource limitation issue arrises, such as PL/SQL recursion
depth, a new attribute would be added to pg_profile to handle
the limitation...
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
.
Even though TRUNCATE was modeled after Oracle's TRUNCATE and
Oracle's TRUNCATE commits the running tx, truncates the
relation, and starts a new tx, regardless of whether or not
TRUNCATE is the first statement of the tx?
Mike Mascari
[EMAIL PROTECTED]
---(end of
eSQL
>>>marketing dept. (wink wink) should come up with a press release.
>>
>
> Anybody have a link where I can find the /. or the Oracle statement?
Here's the Oracle statement:
http://forum.icann.org/org-eval/gartner-report/msg0.html
Hope that helps,
Mike Mascari
nsactions without a full implementation of a two-phase commit
protocol? What happens when the remote server issues the COMMIT
and then the local server crashes?
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
? ;-)
(for the humor impaired, that's a joke...)
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
doc/server.901/a90125/functions2.htm#80856
Mike Mascari
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
M bar, bar, bar, bar, bar, bar, bar, bar;
14 SELECT SYSDATE
15 INTO time2
16 FROM DUAL;
17 RETURN (time2 - time1);
18 END;
19 /
Function created.
SQL> select mydiff FROM dual;
MYDIFF
--
.34722
I can't test the use of CURRENT_TIMESTAMP because I have
Bruce Momjian wrote:
> Mike Mascari wrote:
>>
>>Oracle isn't processing those statements interactively. SQL*Plus
>>is waiting on the "/" to send the PL/SQL block to the database.
>>I suspect its not going to take Oracle more than a second to
>>i
r_foo select sysdate from dual;
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> select * from rbr_foo;
Oracle isn't processing those statements interactively. SQL*Plus
is waiting on the "/" to send the PL/SQL block to the database.
I suspect its not going to take
E PROCEDURE vs. PL/SQL code created with CREATE
FUNCTION. It may be that UDFs return a single CURRENT_TIMESTAMP
for the life of the invocation, while stored procedures don't.
It is PostgreSQL, after all, that has merged the two concepts
into one.
Maybe someone could test version 9 with a FU
und is implementation
dependent. Therefore PostgreSQL is in compliance, but its
compliance is not very popular.
Mike Mascari
[EMAIL PROTECTED]
> Dan Langille wrote:
>>
>>
>>DECLARE
>> time1 TIMESTAMP;
>> time2 TIMESTAMP;
>> sleeptime NUMBER;
>>BEGIN
&
Tom Lane wrote:
> Mike Mascari <[EMAIL PROTECTED]> writes:
>
>>Bruce wrote:
>>"Yes, someone from India has a project to test LRU-K and MRU for
>>large table scans and report back the results. He will
>>implement whichever is best."
>>Did
) causes by the fact that
the SQL standard defines temporary relations as surviving across
transactions? If so, I'd bet those of us who use
transaction-local temporary tables could get few drops more of
performance from an ON COMMIT drop patch w/o fsync.
Any thoughts?
;
Process 3: Error - File does not exist
Process 4: "BAR"
Its interesting in that it allows for Unix-style rename() and
unlink() behavior, but with a race condition. Without Stephan's
two MoveFile() trick and the FILE_SHARE_DELETE flag, however,
the result would be Access Denied.
1 - 100 of 149 matches
Mail list logo
