I have to say I've been really impressed with the quality and diversity
of tools here to increase performance for PostgreSQL. But I keep seeing
a lot of the same basic things repeated again and again. Has anyone
looked into a "smart" or auto-adjusting resource manager for postgres?
Conside
Hello All,
I've inherited a postgresql database that I would like to refactor. It
was origionally designed for Postgres 7.0 on a PIII 500Mhz and some
design decisions were made that don't make sense any more. Here's the
problem:
1) The database is very large, the largest table has 40 mil
On Wed, 2004-02-04 at 21:27, Josh Berkus wrote:
Orion,
> I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
> slower than 7.3.4. Is this common knowledge or am I just unlucky with
> my query/data selection?
No, it's not common knowledge. It should be the other way aroun
On Fri, 2004-02-06 at 02:44, Hannu Krosing wrote:
> Christopher Browne kirjutas N, 05.02.2004 kell 07:32:
> > Oops! [EMAIL PROTECTED] (Orion Henry) was seen spray-painting on a wall:
> > > Oh... as a side note I'm happy to announce that the 2.6 Linux kernel
> > > ha
On Fri, 2004-02-06 at 02:43, Hannu Krosing wrote:
> Orion Henry kirjutas N, 05.02.2004 kell 07:16:
> > I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30%
> > slower than 7.3.4. Is this common knowledge or am I just unlucky with
> > my query/data sel
>
> One question though... It sounds like your 7.3 binaries are 64-bit and
> your 7.4 binaries are 32-bit. Have you tried grabbing the SRPM for 7.4
> and recompiling it for X86_64?
No, they were all 64 bit.
I'm going to run explains on all my queries and see if I can find
anything of interes
4 was from the Fedora
distro and the 7.4.1 was the PGDG package. The database is 3.5 Gigs
with 10 millions rows and the machine had 1 Gig or ram.
Oh... as a side note I'm happy to announce that the 2.6 Linux kernel has
more than DOUBLED the speed of all my Postgres queries over the 2.4. =)
Quick Question,
The full query listed in pg_stat_activity is getting truncated. Does
anyone know how I can see the full query in progress?
--
Orion Henry <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
Thanks Tom! You're a life-saver.
On Fri, 2004-01-23 at 17:08, Tom Lane wrote:
> Orion Henry <[EMAIL PROTECTED]> writes:
> > The queries usually are in the form of, where "user_id = something and
> > event_time between something and something".
>
> >
Also, would it make sense for me to raise my ANALYZE value and how would
I go about doing this?
Thanks for the help.
--
Orion Henry <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
10 matches
Mail list logo
