Hello,
Here is my exp. regarding VIEW (create VIEW view_name AS SELECT )
optimization.
I have found strange (or at least not very intelligent) behavior of query
planner (v.7.3.4).
Given task is to take data from 14 tables, join, group, sort, etc. I
currently use about ten views referencing ea
On Thu, 2003-08-21 at 14:16, Bill Moran wrote:
> >>>What test are interesting? Plese give us tips and ideas. The guy has time
> >>>for other test.
> >>
> >>It's a shame you didn't test ufs+softupdates. I'd be curious to see how
> >>it stacked up against the others.
> >
> > Shame? I smell here a h
2003-08-22 ragyogó napján Robert Treat ezt üzente:
> On Thu, 2003-08-21 at 14:16, Bill Moran wrote:
> > >>>What test are interesting? Plese give us tips and ideas. The guy has time
> > >>>for other test.
> > >>
> > >>It's a shame you didn't test ufs+softupdates. I'd be curious to see how
> > >>it
Tomka Gergely wrote:
2003-08-22 ragyogó napján Robert Treat ezt üzente:
On Thu, 2003-08-21 at 14:16, Bill Moran wrote:
What test are interesting? Plese give us tips and ideas. The guy has time
for other test.
It's a shame you didn't test ufs+softupdates. I'd be curious to see how
it stacked up a
Tomka,
Did you get my test suggestion? It never hit the lists, so I wonder if you
got it
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, 2003-08-22 at 16:54, Tomka Gergely wrote:
> 2003-08-22 ragyogó napján Robert Treat ezt üzente:
>
> > On Thu, 2003-08-21 at 14:16, Bill Moran wrote:
> > > >>>What test are interesting? Plese give us tips and ideas. The guy has time
> > > >>>for other test.
> > > >>
> > > >>It's a shame you
On 22/08/2003 22:00 Bill Moran wrote:
[snip] Well, as much as I _am_ a die-hard BSD geek, I'm far more
interested in
knowing what platform is really best when I need a top-notch PostgreSQL
server.
I'm going to try to force some time this weekend to do some tests ...
we'll see if I succeed ...
I,
Paul Thomas wrote:
On 22/08/2003 22:00 Bill Moran wrote:
[snip] Well, as much as I _am_ a die-hard BSD geek, I'm far more
interested in
knowing what platform is really best when I need a top-notch PostgreSQL
server.
I'm going to try to force some time this weekend to do some tests ...
we'll see
Tomka,
Since this didn't post last time:
Another good test to do would be one that measures simultaenous steaming
read-write. For example:
create table_a, with at least 10,000 records, where field1 is the PK and
field2 is a text field.
create table_b, with 500,000 or more records, where f
2003-08-22 ragyogó napján Josh Berkus ezt üzente:
> Tomka,
>
> Did you get my test suggestion? It never hit the lists, so I wonder if you
> got it
Yes, we got it, and we use your ideas. Thanks.
--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak
10 matches
Mail list logo