nally, I would prefer not to have so
many options but this listing should help folks so they don't paint
themselves into a corner while coding on the tablespaces.
All examples courtesy of "Oracle 8: Advanced Tuning and
Administration", Aronoff, Eyal, et al. ASIN: 0078822416 (c
, Philip.
I can just see the ad for 7.3's pthreads impementation
"Fast mutexes: zero to deadlock in 6.9 milliseconds!"
---(end of
broadcast)---
TIP 1: subscribe and unsubscribe commands go to
[EMAIL PROTECTED]
><&g
On Aug 8, 2006, at 17:47 , Josh Berkus wrote:
What happens now is:
A starts working on X.
3 months pass
B comes to hackers, spends hours reading the archives, doesn't find
X (because they know it by a different name), comes to -hackers and
asks "Is anyone working on X?"
B waits for 2 week
On Aug 12, 2006, at 6:01 , Tzahi Fadida wrote:
On Saturday 12 August 2006 07:22, Bruce Momjian wrote:
I am still waiting for someone to tell us that they would use this
capability for a real-world problem.
Notice that if you google "full disjunction" that the first link is
this project.
On Aug 15, 2006, at 10:40 , Jim C. Nasby wrote:
Yeah, unless someone comes up with some kind of 'magic', I think
trying
to handle every cross-column possibility is a non-starter. IIRC, that
argument is what's stalled cross-column stats every time in the
past. It
makes a lot more sense to a
On Aug 15, 2006, at 12:26 , Peter Eisentraut wrote:
AgentM wrote:
I've always found it odd that database didn't determine which
statistics are the most interesting from the queries themselves.
The overhead of doing that on the fly is probably prohibitive. More
explicit profili
On Aug 15, 2006, at 13:55 , Peter Eisentraut wrote:
Jim C. Nasby wrote:
Meet EXPLAIN ANALYZE.
Which does no good for apps that you don't control the code on. Even
if you do control the code, you have to find a way to stick EXPLAIN
ANALYZE in front of every query, and figure out how to deal
On Aug 21, 2006, at 10:30 , Joshua D. Drake wrote:
Fujii Masao wrote:
Stefan Kaltenbrunner wrote:
It is however async replication so you can loose data commited on
the
master but not yet replicated to the slaves in case you loose the
master
completely.
Yes, here is an insufficient point
On Aug 21, 2006, at 15:00 , D'Arcy J.M. Cain wrote:
On Mon, 21 Aug 2006 14:46:05 -0400
"Gregory Maxwell" <[EMAIL PROTECTED]> wrote:
On 8/21/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
But the confirmation that needs to come is that the WAL changes have
been applied (fsync'ed), so the perfor
On Aug 22, 2006, at 17:01 , Tom Lane wrote:
[EMAIL PROTECTED] writes:
I've been set right. Seems hstore was never in contrib. Sorry for the
noise.
BTW: any reason it isn't? It is very cool...
AFAIR the authors have never proposed it for inclusion.
According to http://www.sai.msu.su/~meg
On Aug 24, 2006, at 12:58 , Andrew J. Kopciuch wrote:
On Thursday 24 August 2006 10:34, Stefan Kaltenbrunner wrote:
We just had a complaint on IRC that:
devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector;
?column?
--
f
(1 row)
This could be an endianess issue?
T
Sorry, but I don't get it. Why offer a closed forum for an open project?
-M
On Aug 27, 2006, at 24:48 , Joshua D. Drake wrote:
Hello,
The community jabber server is now up. We are using the Wildfire
server from Jive Software, backed to a PostgreSQL database (of
course).
-- The idea
On Aug 31, 2006, at 8:52 , Csaba Nagy wrote:
This of course would need a lot more preparation time than just
prepare
one plan, but that's why you want to do it upfront and then cache the
results. A central plan repository mentioned in other posts would fit
nicely here... and you could use p
On Aug 31, 2006, at 11:18 , [EMAIL PROTECTED] wrote:
I'm attempting to understand why prepared statements would be used for
long enough for tables to change to a point that a given plan will
change from 'optimal' to 'disastrous'.
Wouldn't this require that the tables are completely re-written,
On Aug 31, 2006, at 12:04 , Tom Lane wrote:
The two major complaints that I've seen are
Neither of these problems have anything to do with statistics getting
stale.
Not stats-- plans. Plan invalidation has been discussed before, no?
-M
---(end of broadcast)-
On Sep 13, 2006, at 14:44 , Gregory Stark wrote:
I think we need a serious statistics jock to pipe up with some
standard
metrics that do what we need. Otherwise we'll never have a solid
footing for
the predictions we make and will never know how much we can trust
them.
That said I'm no
On Sep 14, 2006, at 14:04 , D'Arcy J.M. Cain wrote:
On Thu, 14 Sep 2006 10:33:19 -0700
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
By the way, I removed the currency symbol from the output. Would
removing the commas also make sense? These are the sorts of things
that can be added by applica
On Sep 22, 2006, at 11:26 , Merlin Moncure wrote:
On 9/22/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Stephen Frost <[EMAIL PROTECTED]> writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> An admin who is concerned about this can revoke public access
on the
>> functions for himself ... but should
On Sep 22, 2006, at 12:46 , Merlin Moncure wrote:
On 9/22/06, AgentM <[EMAIL PROTECTED]> wrote:
I would be more worried about accidental collisions between
applications. The lock ranges will now need to be in their respective
i dont think this argument has merit because the lock is
On Sep 22, 2006, at 14:11 , Jim C. Nasby wrote:
On Fri, Sep 22, 2006 at 01:21:57PM -0400, Merlin Moncure wrote:
On 9/22/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Fri, Sep 22, 2006 at 12:56:37PM -0400, Merlin Moncure wrote:
the whole point about advisory locks is that the provided lock
On Sep 22, 2006, at 15:00 , [EMAIL PROTECTED] wrote:
On Fri, Sep 22, 2006 at 01:52:02PM -0400, Jim Nasby wrote:
I thought folks might be interested in this... note in particular the
comment about linux.
...
From: Greg 'groggy' Lehey <[EMAIL PROTECTED]>
Date: June 26, 2006 11:34:12 PM EDT
To:
The regular dlfcn family of functions are now properly implemented on
Darwin (10.4+).
Re: Zeroconf- Avahi is API+ABI compatible with the Apple API, so its
use would be preferable on Linux (for cross-platform considerations).
http://avahi.org/browser/trunk/avahi-compat-libdns_sd
[Warning: Av
On Oct 2, 2006, at 18:15 , Markus Schaber wrote:
Hi,
I'm happy that the rather verbose "timestamp with time zone" has the
much nicer alias "timestamptz", however it seems that this alias is
not
documented, neither at
http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
nor
On Oct 3, 2006, at 10:49 , Oleg Bartunov wrote:
On Tue, 3 Oct 2006, Magnus Hagander wrote:
BTW, try
# select plainto_tsquery('foo bar');
plainto_tsquery
-
'foo' & 'bar'
(1 row)
It parses plain text and makes tsquery. Function exists only in 8.2
- some later we add docs ab
On Oct 5, 2006, at 11:56 , Mark Woodward wrote:
I am using the netflix database:
Table "public.ratings"
Column | Type | Modifiers
+--+---
item | integer |
client | integer |
day| smallint |
rating | smallint |
The query was executed as:
psql -p 543
On Oct 5, 2006, at 15:46 , Mark Woodward wrote:
Not to cause any arguments, but this is sort a standard discussion
that
gets brought up periodically and I was wondering if there has been any
"softening" of the attitudes against an "in place" upgrade, or
movement to
not having to dump and r
pe strings, correct? That is, there
is no escape mechanism that works correctly for both "old" and "new"
servers?
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROTECTED]
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
---(end o
On Sunday, Nov 2, 2003, at 18:16 Europe/Berlin, Tom Lane wrote:
Manfred Spraul <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
I don't see that this proposal adds any security.
It's not about security:
The proposal would be more salable if it addressed the security problem
too. As is, you are proposi
oment whether Apple publishes all of Darwin
under a straight BSD license, but that would surely be a good place to
look first. ]
regards, tom lane
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROT
gres' purpose, we might feel like doing
extra work on it; but it's so peripheral that we've already wasted
more time on it than it's worth. IMHO anyway.
regards, tom lane
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROTECTED]
|-|-|-|-|-|
just allow subqueries in COPY to disambiguate the syntax:
COPY (SELECT * FROM table WHERE i=1) TO stdout;
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROTECTED]
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
---(end of broadcast)-
31 matches
Mail list logo