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)-
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
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
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
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
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
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
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
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]
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
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
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
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
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
&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
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
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
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
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
---
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.
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
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
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
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
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]
; 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
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])
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 [
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?
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
://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]
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
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
--
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)---
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
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
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]
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
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
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
-
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
'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
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
ackers Emeritus section?
Eh?
Mike Mascari
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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'
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]
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
101 - 149 of 149 matches
Mail list logo