[PERFORM] Reason of Slowness of query

2011-03-22 Thread Adarsh Sharma
Dear all, I have 2 tables in my database name clause2( 4900 MB) & page_content(1582 MB). My table definations are as : *page_content :- *CREATE TABLE page_content ( content_id integer, wkb_geometry geometry, link_level integer, isprocessable integer, isvalid integer, isanalyzed integer

Re: [PERFORM] good old VACUUM FULL

2011-03-22 Thread Scott Marlowe
On Tue, Mar 22, 2011 at 6:52 PM, felix wrote: > I posted many weeks ago about a severe problem with a table that was > obviously bloated and was stunningly slow. Up to 70 seconds just to get a > row count on 300k rows. > I removed the text column, so it really was just a few columns of fixed > dat

Re: [PERFORM] ANTI-JOIN needs table, index scan not possible?

2011-03-22 Thread Robert Haas
On Fri, Mar 11, 2011 at 10:32 AM, hans wulf wrote: > I need an ANTI-JOIN (not exists SELECT something from table.../ left join > table WHERE table.id IS NULL) on the same table. Acutally I have an index to > serve the not exists question, but the query planner chooses to to a bitmap > heap scan

Re: [PERFORM] good old VACUUM FULL

2011-03-22 Thread Chris
On 23/03/11 11:52, felix wrote: I posted many weeks ago about a severe problem with a table that was obviously bloated and was stunningly slow. Up to 70 seconds just to get a row count on 300k rows. I removed the text column, so it really was just a few columns of fixed data. Still very bloated.

[PERFORM] good old VACUUM FULL

2011-03-22 Thread felix
I posted many weeks ago about a severe problem with a table that was obviously bloated and was stunningly slow. Up to 70 seconds just to get a row count on 300k rows. I removed the text column, so it really was just a few columns of fixed data. Still very bloated. Table size was 450M The advice

Re: [PERFORM] Analyze on temp table taking very long

2011-03-22 Thread Tom Lane
"Mahadevan, Mridula" writes: > This has been running fine for a while on multiple setups, large and small > volumes. The setups all have the same hardware configuration. > On one particular setup with about 200k records and this analyze runs for > 45min and then times out(statement timeout is s

Re: [PERFORM] Performance on AIX

2011-03-22 Thread Josh Berkus
Phillippe, > At Bull company, we want to answer a call for tender from a large > company. And we are asked for information about PostgreSQL performance > under AIX on Power 7 servers. Afilias runs PostgreSQL on AIX. I don't know the architecture, though. Or what they think of it as a platform.

[PERFORM] Analyze on temp table taking very long

2011-03-22 Thread Mahadevan, Mridula
I have a function where in In a cursor loop I 1. create a temp table (on commit drop) 2. insert data into it 3. Run Analyze on the table Select/update outside the loop. This has been running fine for a while on multiple setups, large and small volumes. The setups all have

Re: [PERFORM] Help: massive parallel update to the same table

2011-03-22 Thread Red Maple
Hi, I have found the bug in my code that made the update to the same row in the table instead of two different row. Now I have all cores up and running 100%. Thank you for all your help. On Fri, Mar 18, 2011 at 3:21 PM, Kevin Grittner wrote: > Red Maple wrote: > > > Here is my function. If I

Re: [PERFORM] Request for feedback on hardware for a new database server

2011-03-22 Thread Merlin Moncure
On Thu, Mar 17, 2011 at 7:51 PM, Oliver Charles wrote: > Hello, > > At MusicBrainz we're looking to get a new database server, and are > hoping to buy this in the next couple of days. I'm mostly a software > guy, but I'm posting this on behalf of Rob, who's actually going to be > buying the hardwa