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 5435
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
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
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:
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 that be
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 scoped
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:
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
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
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
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
On Aug 31, 2006, at 12:04 , Tom Lane wrote:
The two major complaints that I've seen are
snip
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
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).
snip
-- The
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?
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
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
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 performance
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
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 profiling support
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 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 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 weeks
subqueries in COPY to disambiguate the syntax:
COPY (SELECT * FROM table WHERE i=1) TO stdout;
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROTECTED]
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
---(end of broadcast)---
TIP
so peripheral that we've already wasted
more time on it than it's worth. IMHO anyway.
regards, tom lane
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
AgentM
[EMAIL PROTECTED]
|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-
---(end of broadcast
at the moment 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 PROTECTED
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
mutexes: zero to deadlock in 6.9 milliseconds!
---(end of
broadcast)---
TIP 1: subscribe and unsubscribe commands go to
[EMAIL PROTECTED]
AgentM
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2
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) 1998.
(perhaps a little outdated)
AgentM
[EMAIL PROTECTED]
---(end of broadcast
29 matches
Mail list logo