create the new partitions.
>
> Anyone have any thoughts on how to debug this? were running postgres 8.4.4
> on
> CentOS 5.5
If you're doing the partitions on demand, you could be getting
deadlocks. Any reason not to pre-create a big bunch of them in
advance?
Cheer
On Tue, Sep 08, 2009 at 10:32:53AM -0700, David Fetter wrote:
> On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> > Folks,
> >
> > For those of you who can't attend in person, we'll be streaming audio
> > and video and having a chat for tonight&#
On Tue, Sep 08, 2009 at 10:30:21AM -0700, David Fetter wrote:
> Folks,
>
> For those of you who can't attend in person, we'll be streaming audio
> and video and having a chat for tonight's SFPUG meeting on how the
> planner uses statistics.
>
> Video:
&g
Folks,
For those of you who can't attend in person, we'll be streaming audio
and video and having a chat for tonight's SFPUG meeting on how the
planner uses statistics.
Video:
http://media.postgresql.org/sfpug/streaming
Chat:
irc://irc.freenode.net/sfpug
Cheers,
David.
--
Dav
; However, it still doesn't answer my question about the EV model
> (where each attribute is given its own table).
The answer to EAV modeling, is, "DON'T!"
Cheers,
David (who, if he were greedy, would be encouraging EAV modeling
because it would cause guaranteed large consulting
On Sun, Aug 19, 2007 at 08:26:58PM +0200, Steinar H. Gunderson wrote:
> On Sun, Aug 19, 2007 at 11:12:16AM -0700, David Fetter wrote:
> > There's your mistake. EAV is not performant, and won't become so.
>
> It sort of depends. I put all the EXIF information for my im
what your database will and won't do, and design your schema
around that. I know it takes a little extra helping of courage, but
it's worth it in the long run.
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
B/s), what other observations do you have to
hand? Any ideas about what things are not performing here? Parts of
the code that could bear extra scrutiny? Ideas on how to fix same in
a cross-platform way?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1
