[PERFORM] Auto performance tuning?

background, or that query plans keep screwing up on a particular table so it knows to up the amount of stastics it keeps on that table. Is this a crazy idea or something someone's already working on? Orion ---(end of broadcast)--- TIP 2:

Re: [PERFORM] Large Database Design Help

I just wanted to thank everyone for your input on my question. You've given me a lot of tools to solve my problem here. Orion ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[PERFORM] Large Database Design Help

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

Re: [PERFORM] 7.3 vs 7.4 performance

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 shou

Re: [PERFORM] 7.3 vs 7.4 performance

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

Re: [PERFORM] 7.3 vs 7.4 performance

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

Re: [PERFORM] 7.3 vs 7.4 performance

> > 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

[PERFORM] 7.3 vs 7.4 performance

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. =)

[PERFORM] pg_stat_activity

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

Re: [PERFORM] help with dual indexing

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". > > >

[PERFORM] help with dual indexing

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