On Monday 14 July 2003 01:21, Balazs Wellisch wrote:
> Unfortunatelly, compiling from source is not really an option for us. We
> use RPMs only to ease the installation and upgrade process. We have over a
> hundred servers to maintaine and having to compile and recompile software
> everytime a new
Chris,
Oops - it's changed !
Here's the link's you need:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
Cheers
Rudi.
Chris_Wu wrote:
>Hello all!
> I'm a new to Postgresql , I have never used it be
Hi Chris,
I suggest you read this tech. document:
http://www.varlena.com/GeneralBits/
I think you'll it's the best place to start.
Cheers
Rudi.
Chris_Wu wrote:
>Hello all!
> I'm a new to Postgresql , I have never used it before.
> I am having an issue with configure the pos
Hello all!
I'm a new to Postgresql , I have never used it before.
I am having an issue with configure the postgresql.conf file.
The machine itself is a
CPU= 2.66GHz P4 w/
Memory= 2G
Maybe you can tell me how to configure these parameters.
At 11:31 PM 7/13/03 -0300, Chris Bowlby wrote:
Woops, this might not go through via the address I used :> (not
subscribed with that address)..
At 01:46 PM 7/13/03 -0700, Steve Wampler wrote:
The following left join should work if I've done my select right, you
might want to play with a left
At 01:46 PM 7/13/03 -0700, Steve Wampler wrote:
The following left join should work if I've done my select right, you
might want to play with a left versus right to see which will give you a
better result, but this query should help:
SELECT * FROM attributes_table att LEFT JOIN attributes at
> > Could you not rewrite this as a simple join though?
>
> Hmmm, I don't see how. Then again, I'm pretty much the village
> idiot w.r.t. SQL...
>
> The inner select is locating a set of (2049) ids (actually from
> the same table, since 'attributes' is just a view into
> 'attributes_table'). Th
Steve Wampler kirjutas P, 13.07.2003 kell 23:46:
> On Sun, Jul 13, 2003 at 08:09:17PM +0100, Richard Huxton wrote:
> > > I'm not an SQL or PostgreSQL expert.
> > >
> > > I'm getting abysmal performance on a nested query and
> > > need some help on finding ways to improve the performance:
> > [snip]
On Sun, Jul 13, 2003 at 12:51:02PM -0700, Balazs Wellisch wrote:
> > Alternatively, you simply compile 7.3.3 from source. I've upgraded most my
> > machines that way.
> >
>
> Unfortunatelly, compiling from source is not really an option for us. We use
> RPMs only to ease the installation and upgra
On Sun, Jul 13, 2003 at 08:09:17PM +0100, Richard Huxton wrote:
> > I'm not an SQL or PostgreSQL expert.
> >
> > I'm getting abysmal performance on a nested query and
> > need some help on finding ways to improve the performance:
> [snip]
> > select * from attributes_table where id in (select id f
Balazs Wellisch wrote:
I would *not* use the default version of Postgres shipped with any
particular distribution. Use 7.3.3 because that is the latest released
version. Or, as Shridhar mentioned in his post, the are a number of
pretty significant performance improvements in 7.4 (which is in featur
> There are many Linux and other OS distributions that will work just
> fine. You may need to tweak a few kernel configuration parameters, but
> that's not too difficult; see:
>
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=kernel-resources.html
>
Yes, I looked at the online doc
> select * from attributes_table where id in (select id from
> attributes where (name='obsid') and (value='oid00066'));
Can you convert it into a join? 'where in' clauses tend to slow pgsql
down.
--
Mike Nolan
---(end of broadcast)---
TIP
> The most important thing seems to be to increase shared_buffers. On my
> RH7.3 machine here, Linux is configured with shmmax = 32MB which allows me
> a value of just under 4000 for shared_buffers (3900 works, 3950 doesn't).
> If your selects return large amounts of data, you'll probably also nee
> On Sun, 2003-07-13 at 01:35, Balazs Wellisch wrote:
> > Hi all,
> >
> >
> >
> > I’m in the process of initiating a movement in our company to move
> > towards open source software use. As part of this movement I will be
> > recommending PostgreSQL as an alternative to the currently used MSSQL.
>
> On Sunday 13 July 2003 12:05, Balazs Wellisch wrote:
> > Hi all,
> > However, to be able to justify the move I will have to demonstrate that
> > PostgreSQL is up to par with MSSQL and MySQL when it comes to
> > performance. After having read through the docs and the lists it seems
> > obvious th
> I'm not an SQL or PostgreSQL expert.
>
> I'm getting abysmal performance on a nested query and
> need some help on finding ways to improve the performance:
[snip]
> select * from attributes_table where id in (select id from
> attributes where (name='obsid') and (value='oid00066'));
This i
I'm not an SQL or PostgreSQL expert.
I'm getting abysmal performance on a nested query and
need some help on finding ways to improve the performance:
Background:
RH 8.0 dual-CPU machine (1.2GHz athlon)
Postgresql 7.2
1GB ram
(Machine is dedi
Balazs Wellisch wrote:
I don't have months to learn the ins and outs of PostgreSQL
performance tuning so I looked around to see if there are any
preconfigured solutions out there.
I don't know of a preconfigured solution. Generally speaking, the best
configuration will be highly dependent on your
Hi all! I'm new to Postgresql and I'm trying solve a problem: is there a way to know
how many disk-pages are read during a query? Because I found out only how many
disk-pages a relation has and I'd like to know if there is a system
catalog or something else that stores this information
thanks,
On Sunday 13 July 2003 12:05, Balazs Wellisch wrote:
> Hi all,
> However, to be able to justify the move I will have to demonstrate that
> PostgreSQL is up to par with MSSQL and MySQL when it comes to
> performance. After having read through the docs and the lists it seems
> obvious that PostgreSQL
On Sunday 13 July 2003 10:23, Ron Johnson wrote:
> On Fri, 2003-07-04 at 09:49, Shridhar Daithankar wrote:
> > On 4 Jul 2003 at 16:35, Michael Mattox wrote:
>
> [snip]
>
> > On a positive note, me and Josh are finishing a bare bone performance
> > article that would answer lot of your questions. I
22 matches
Mail list logo
