Re: [PERFORM] Insert are going slower ...

Josh, Le mardi 13 Juillet 2004 19:10, Josh Berkus a écrit : > > > What can I do to get better results ?? (configuration option, and/or > > hardware update ?) > > What can I give you to get more important informations to help me ? > > 1) What PostgreSQL version are you using? v7.4.3 > 2) What's y

Re: [PERFORM] Swapping in 7.4.3

Jim Ewert wrote: When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements are that it doesn't initially take much memory (have 512M) and didn't swap. I ran a full vaccum and a cluster before installation, however speed degaded to 1 *second* / update of one row in 150 rows of data, within a

Re: [PERFORM] Inverted-list databases (was: Working on huge RAM based datasets)

""Andy Ballingall"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On another thread, (not in this mailing list), someone mentioned that there > are a class of databases which, rather than caching bits of database file > (be it in the OS buffer cache or the postmaster workspace), co

Re: [PERFORM] Working on huge RAM based datasets

Oops - sorry - I confused my numbers. The opteron machine in mind *only* has up to 64GB of RAM (e.g. HP DL585) - here's the datapage: http://h18004.www1.hp.com/products/servers/proliantdl585/index.html Still - with *just* 64GB of RAM, that would comfortably provide for the type of scenario I env

[PERFORM] Swapping in 7.4.3

When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements are that it doesn't initially take much memory (have 512M) and didn't swap. I ran a full vaccum and a cluster before installation, however speed degaded to 1 *second* / update of one row in 150 rows of data, within a day! pg_autovac

Re: [PERFORM] Insert are going slower ...

Herve, > What can I do to get better results ?? (configuration option, and/or > hardware update ?) > What can I give you to get more important informations to help me ? 1) What PostgreSQL version are you using? 2) What's your VACUUM, ANALYZE, VACUUM FULL, REINDEX schedule? 3) Can you list the n

[PERFORM] Insert are going slower ...

Hi, I have a database with 10 tables having about 50 000 000 records ... Every day I have to delete about 20 000 records, inserting about the same in one of this table. Then I make some agregations inside the other tables to get some week results, and globals result by users. That mean about 18

Re: [PERFORM] How to create an index for type timestamp column using rtree?

Thanks, Chris and Tom. I had read *incorrectly* that rtrees are better for <= and >= comparisons. Chris On Tue, 13 Jul 2004 14:33:48 +0800, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > I'm storing some timestamps as integers (UTF) in a table and I want to > > query by <= and >= for tim