[PERFORM] PostgreSQL 8.0 occasionally slow down

Hi, I am new for postgresql server. And now i work on a projects which requires postgreSQL 8.0 and Java. I don't know why the server occasionally slow down a bit for every 3 minutes. I have changed the log configuration so that it logs all statement transaction > 1000 ms and the result shown be

Re: [PERFORM] update query taking too long

Richard Huxton wrote: Chris wrote: Tom Lane wrote: Any foreign keys leading to or from that table? Nope :( 3.5 million row updates are not exactly gonna be instantaneous anyway, but only FK checks or really slow user-written triggers would make it take upwards of an hour ... No triggers,

Re: [PERFORM] update query taking too long

Chris wrote: Tom Lane wrote: Any foreign keys leading to or from that table? Nope :( 3.5 million row updates are not exactly gonna be instantaneous anyway, but only FK checks or really slow user-written triggers would make it take upwards of an hour ... No triggers, functions. Of course

Re: [PERFORM] update query taking too long

A. Kretschmer wrote: am Thu, dem 28.06.2007, um 16:16:50 +1000 mailte Chris folgendes: Is there a better way to write the update? I thought about something like this (but couldn't get it working - guess I don't have the right syntax): update t1 set domainname=(select id, SUBSTRING(emailaddre

Re: [PERFORM] update query taking too long

am Thu, dem 28.06.2007, um 16:16:50 +1000 mailte Chris folgendes: > Is there a better way to write the update? I thought about something > like this (but couldn't get it working - guess I don't have the right > syntax): > > update t1 set domainname=(select id, SUBSTRING(emailaddress FROM > POS

Re: [PERFORM] update query taking too long

A. Kretschmer wrote: am Thu, dem 28.06.2007, um 15:03:32 +1000 mailte Chris folgendes: Hi all, I'm trying to do an update of a reasonably large table and it's taking way too long so I'm trying to work out why and if I need to tweak any settings to speed it up. The table is around 3.5 milli

Re: [PERFORM] update query taking too long

Tom Lane wrote: Chris <[EMAIL PROTECTED]> writes: I'm trying to do an update of a reasonably large table and it's taking way too long so I'm trying to work out why and if I need to tweak any settings to speed it up. Any foreign keys leading to or from that table? Nope :( 3.5 million row u

Re: [PERFORM] update query taking too long

Chris <[EMAIL PROTECTED]> writes: > I'm trying to do an update of a reasonably large table and it's taking > way too long so I'm trying to work out why and if I need to tweak any > settings to speed it up. Any foreign keys leading to or from that table? 3.5 million row updates are not exactly g

Re: [PERFORM] update query taking too long

am Thu, dem 28.06.2007, um 15:03:32 +1000 mailte Chris folgendes: > Hi all, > > I'm trying to do an update of a reasonably large table and it's taking > way too long so I'm trying to work out why and if I need to tweak any > settings to speed it up. > > The table is around 3.5 million records.

[PERFORM] update query taking too long

Hi all, I'm trying to do an update of a reasonably large table and it's taking way too long so I'm trying to work out why and if I need to tweak any settings to speed it up. The table is around 3.5 million records. The query is update table set domainname=substring(emailaddress from positio

[PERFORM] High IOWAIT times, low iops? Need Help with configuration

I was wondering if you guys have some suggested settings for our server, i think we are not hardware limited but the configureation is set up incorrectly. For some reason our database seems to have trouble handling 10+ inserts per second which seems to be a pretty trivial load for this hardware,

Re: [PERFORM] Volunteer to build a configuration tool

Lance, > I have a PostgreSQL database that runs on a dedicated server. The > server has 24Gig of memory. What would be the max size I would ever > want to set the shared_buffers to if I where to relying on the OS for > disk caching approach? It seems that no matter how big your dedicated > serv

Re: [PERFORM] PostgreSQL Configuration Tool for Dummies

Greg, > I'd like to see people have a really simple set of questions to get them > past the completely undersized initial configuration phase, then ship them > toward resources to help educate about the parts that could be problematic > for them based on what they do or don't know. I don't see an

[PERFORM] rtree/gist index taking enormous amount of space in 8.2.3

Hi, In version 8.1.5, I have an rtree index on a 1.5 GB table. The size of this index is 500 MB. After migrating to 8.2.3, the size of this index has increased to 35GB. I've dropped are recreated the index and got the same result. In 8.2.3 the index type is gist, does this have something to